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 |
SPECIFICATIONS
Tool: IBM / InfoSphere DataStage version 7.5 to 11.x via XML and DSX File
See http://www.ibm.com/software/data/infosphere/datastage/
Metadata: [Data Integration] ETL (Source and Target Data Stores, Transformation Lineage, Expression Conversion)
Component: AscentialDataStage version 11.2.0
OVERVIEW
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.
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 troubleshooting package with debug log. Debug log can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6
Bridge Parameters
| Parameter Name | Description | Type | Values | Default | Scope |
| File | Only supports XML format. | 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. |