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

MIMB Bridge Documentation

MIMB Export Bridge to IBM InfoSphere DataStage

Bridge Specifications

Vendor IBM
Tool Name InfoSphere DataStage
Tool Version 7.5 to 11.x
Tool Web Site http://www.ibm.com/software/data/infosphere/datastage/
Supported Methodology [Data Integration] ETL (Source and Target Data Stores, Transformation Lineage, Expression Conversion) via XML and DSX File

Export tool: IBM InfoSphere DataStage 7.5 to 11.x (http://www.ibm.com/software/data/infosphere/datastage/)
Export interface: [Data Integration] ETL (Source and Target Data Stores, Transformation Lineage, Expression Conversion) via XML and DSX File to IBM InfoSphere DataStage Export bridge: 'AscentialDataStage' 10.1.0

To import the resulting XML into DataStage, first launch DataStage Designer Client and then go to the Import->DataStage Components... menu item.

Once imported, the mappings will be placed in the previously opened folder structure of the project. The folder structure is defined based upon the names in the .XML fie. To determine the folder structure, open the .XML file and refer to the 'Category' Property of the 'ROOT' Record.


Bridge Parameters

Parameter Name Description Type Values Default Scope
File This export bridge only supports XML format. The XML file defines CharacterSet: ENGLISH.

FILE *.xml   Mandatory

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"IBM InfoSphere DataStage"
Metamodel
AscentialDataStage
Mapping Comments
     
Association   The foreign key information is exported
AssociationRole   The foreign key information is exported
AssociationRoleNameMap ForeignKey  
DesignLevel   No equivalent for Logical Only objects.
Attribute Column  
Description Description  
DesignLevel   No equivalent for Logical Only objects.
Name Name Attribute Name. Computed if not set
Optional Nullable  
BaseType Column  
DataType SQL Type See datatype 'DataType Mapping' worksheet
DesignLevel   No equivalent for Logical Only objects.
CandidateKey Column  
DesignLevel   No equivalent for Logical Only objects.
Class Table Definition  
Description Description  
DesignLevel   No equivalent for Logical Only objects.
Name Name Class Name. Computed if not set
PhysicalName   Class Physical Name.Computed from the 'name' if not set
DatabaseSchema Table Definition  
DesignLevel   No equivalent for Logical Only objects.
Name Owner in record identifier
DerivedType Column  
DataType SQL Type See datatype 'DataType Mapping' worksheet
DesignLevel   No equivalent for Logical Only objects.
Length Precision  
Scale Scale  
ForeignKey ForeignKey  
DesignLevel   No equivalent for Logical Only objects.
SQLViewAttribute Column  
Description Description  
DesignLevel   No equivalent for Logical Only objects.
Name Name View Attribute Name. Computed if not set
SQLViewEntity Table Definition  
Description Description  
DesignLevel   No equivalent for Logical Only objects.
Name Name View Name. Computed if not set
StoreModel Header  
DesignLevel   No equivalent for Logical Only objects.

Last updated on Fri, 31 May 2019 17:36:37

Copyright © Meta Integration Technology, Inc. 1997-2019 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.