Meta Integration® Model Bridge (MIMB)
"Metadata Integration" Solution

MIMB Bridge Documentation

MIMB Import Bridge from SAS Library

Bridge Specifications

Vendor SAS
Tool Name Library
Tool Version 9.3
Tool Web Site https://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a001294104.htm
Supported Methodology [Relational Database] Data Store (Physical Data Model) via SPK File

SPECIFICATIONS
Tool: SAS / Library version 9.3 via SPK File
See https://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a001294104.htm
Metadata: [Relational Database] Data Store (Physical Data Model)
Component: SasDb version 11.0.0

OVERVIEW
This bridge imports SAS Database metadata.

REQUIREMENTS
The bridge reads the definition of Libraries and Tables from an SPK package file.
The file may contain multiple libraries of different engine types, implemented on multiple servers.
Thus you must specify the Library Engine to use and which server you wish to import from.

Please work with your SAS administrator to generate the required SPK file which must contain the proper Libraries, Servers, and Tables you wish to import.

FREQUENTLY ASKED QUESTIONS
n/a

LIMITATIONS
Refer to the current general known limitations at http://metaintegration.com/Products/MIMB/MIMBKnownLimitations.html or bundled in Documentation/ReadMe/MIMBKnownLimitations.html

SUPPORT
Provide a trouble shooting package with:
- the debug log (can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6)
- the metadata backup if available (can be set in the Miscellaneous parameter with option -backup)


Bridge Parameters

Parameter Name Description Type Values Default Scope
File The spk file to import from.

To create a SAS Package file in SAS Management Console:
1. Connect to the metadata server.
2. Select the Folders tab.
3. Right-click the SAS Folders node, and click 'Export SAS Package'.
4. Enable the option 'Include dependent objects when retrieving initial collection of objects'.
5. Follow the wizard screens to select folders and objects of interest and create the SPK file.

Make sure to include the following objects required by your selection:
- Libraries
- Servers
- Connections

You can also use the ExportPackage command line utility to generate the SPK file.
See this page for details:
http://documentation.sas.com/?docsetId=bisag&docsetTarget=n008xsxs34mvcwn1qrgcmugpzu6i.htm&docsetVersion=9.4&locale=en
FILE *.spk   Mandatory
Library Engine Specify the library engine to import.

The supported engine types are:
'SAS BASE'
BASE engine

'SAS LASR"
Analytic engine (SASIOLA in-memory engine for input-output with LASR)

For other types of engines (ORACLE, TERADATA), connecting to the source database directly is recommended.
ENUMERATED
SAS BASE
SAS LASR
BASE  
Server The SPK package file may contain multiple libraries of different engine types, implemented on multiple servers.
Specify the server where the libraries you wish to import from are deployed.
The value should match a 'ServerContext' or 'SASClientConnection' in the SPK file.
You can browse this parameter to select a server available in the SPK file.
REPOSITORY_MODEL     Mandatory

 

Bridge Mapping

Mapping information is not available

Last updated on Fri, 25 Sep 2020 17:37:51

Copyright © Meta Integration Technology, Inc. 1997-2020 All Rights Reserved.

Meta Integration® is a registered trademark of Meta Integration Technology, Inc.
All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.