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

MIMB Bridge Documentation

MIMB Import Bridge from SAS Data Integration

Bridge Specifications

Vendor SAS
Tool Name Data Integration Studio
Tool Version 9.3
Tool Web Site http://www.sas.com/technologies/dw/etl/etlstudio/
Supported Methodology [Data Integration] Multi-Model, Metadata Repository, ETL (Source and Target Data Stores, Transformation Lineage) via SPK File

SPECIFICATIONS
Tool: SAS / Data Integration Studio version 9.3 via SPK File
See http://www.sas.com/technologies/dw/etl/etlstudio/
Metadata: [Data Integration] Multi-Model, Metadata Repository, ETL (Source and Target Data Stores, Transformation Lineage)
Component: SasDi version 11.0.0

OVERVIEW
This bridge imports SAS Data Integration metadata.

REQUIREMENTS
n/a

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
Miscellaneous Specify miscellaneous options starting with a dash and optionally followed by parameters, e.g.
-connection.cast MyDatabase1="SQL Server"
Some options can be used multiple times if applicable, e.g.
-connection.rename NewConnection1=OldConnection1 -connection.rename NewConnection2=OldConnection2;
As the list of options can become a long string, it is possible to load it from a file which must be located in ${MODEL_BRIDGE_HOME}\data\MIMB\parameters and have the extension .txt. In such case, all options must be defined within that file as the only value of this parameter, e.g.
ETL/Miscellaneous.txt

GENERAL OPTIONS
STRING      

 

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.