Bridge Specifications
| Vendor | IBM |
| Tool Name | DB2 Warehouse Manager |
| Tool Version | 7.2 to 8.x |
| Tool Web Site | http://www.ibm.com/software/data/db2/datawarehouse/ |
| Supported Methodology | [Data Integration] ETL (Source and Target Data Stores) via CWM XMI File |
SPECIFICATIONS
Tool: IBM / DB2 Warehouse Manager version 7.2 to 8.x via CWM XMI File
See http://www.ibm.com/software/data/db2/datawarehouse/
Metadata: [Data Integration] ETL (Source and Target Data Stores)
Component: OmgCwmXmiImport.IbmDb2WarehouseManager version 12.0.0
OVERVIEW
REQUIREMENTS
To generate an XMI file from IBM DB2 Warehouse Manager:
1. Start the DB2 'Warehouse Center' tool and log on to it.
2. Select the 'Warehouse Schema' to be exported.
3. Click on the Selected > Export MetaData > 'Common Warehouse Metamodel' menu.
4. Specify the path name of the CWM file to be created in the 'Export' file text box.
5. Select the 'Warehouse Targets' or 'Warehouse Sources' to be exported.
6. Complete the export wizard to generate the CWM file.
FREQUENTLY ASKED QUESTIONS
n/a
LIMITATIONS
Refer to the current general known limitations at https://www.metaintegration.com/Products/MIMB/Help/#!Documents/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 | Imports an XML file compliant with the Object Management Group (OMG) Common Warehouse Metamodel (CWM) XML Metadata Interchange (XMI) file format. | FILE |
|
Mandatory | ||||||
| Target Tool | Specify which tool was used to generate the model you want to import. Allows this bridge to fine tune the its behavior to match the way the source tool saved the model. 'Auto Detect' This bridge will auto-detect which tool generated the file. 'OMG CWM' Specifies that the file conforms to the OMG CWM standard DTDs. 'IBM DB2 Warehouse Manager' Specifies that the file was generated by IBM DB2 Warehouse Manager. 'Oracle Warehouse Builder' Specifies that the file was generated by Oracle Warehouse Builder. 'SAS ETL Studio' Specifies that the file was generated by SAS ETLStudio. |
ENUMERATED |
|
Auto Detect | ||||||
| Auto Correct | The CWM file produced by some source tools may contain a slightly incomplete or incorrect model. Allows you to specify whether this bridge should attempt to fix the model or not. 'True' Attempt to fix the model. This may involve deleting some model elements. This bridge will log warnings informing you about the changes. 'False' Do not modify the model. If the model is invalid this bridge will reject it. |
BOOLEAN |
|
True | ||||||
| Top Package | The metamodel requires that all model elements (Classes, Associations...) belong to a package. Whenever any element is not explicitly associated to a package it is stored in a special package. This option specifies the name of that package. If there is a single top level package by that name in the model, package is considered optional so that it will not appear in the destination model if the destination tool does not require all objects to be in the package. | STRING | Logical View | |||||||
| Import UUIDs | The CWM file may contain UUIDs. This option allows you to specify whether this bridge should import them: 'True' The attribute xmi.uuid is saved in the NativeId property. 'False' The attribute xmi.uuid is ignored. |
BOOLEAN |
|
True | ||||||
| Data model table design level | Controls the design level of the imported tables. Relevant when exporting metadata to a target tool which supports two views of the model, a logical view and a physical view. Some Data Modeling tools support this concept, where you can decide if a table appears both as a physical table and as a logical entity. Some Business Intelligence tools also support this concept, where you can decide if a table appears both in the physical model and in the business view of the model. Set the option to: 'Logical and physical' Tables to appear both in the logical view and in the physical view of the model. 'Physical' Tables to appear only in the physical view of the model. |
ENUMERATED |
|
Physical |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"IBM DB2 Warehouse Manager (via CWM XMI)" Metamodel OmgCwmXmi |
Mapping Comments |
| Name | UML:ModelElement.name / name | |
| Argument | UML:Parameter | |
| DefaultValue | defaultValue | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Kind | kind | |
| Name | UML:ModelElement.name / name | |
| PhysicalName | UML:ModelElement.name / name | |
| Position | Order in the CWMRDB file | |
| Association | CWMRDB:ForeignKey | The association is deduced from the foreign key/unique constraint relationship |
| Aggregation | deduced from the unicity of the attributes in the foreign key | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| PhysicalName | UML:ModelElement.name / name | |
| AssociationRole | CWMRDB:ForeignKey | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| ExtraConstraint | deleteRule, updateRule | |
| Multiplicity | 1' for the UniqueConstraint role if all the Attributes in the ForeignKey are mandatory and '0..1' otherwise. '0..*' for the ForeignKey role | |
| PhysicalName | UML:ModelElement.name / name | |
| Source | Set to 'true' for the UniqueConstraint role | |
| Attribute | CWMRDB:Column | |
| CppScope | visibility | |
| CppStatic | ownerScope | |
| InitialValue | UML:Attribute.initialValue | |
| Name | collationName | |
| Optional | isNullable | |
| Position | Order in the file | |
| Stereotype | UML:Stereotype | |
| BaseType | CWMRDB:SQLSimpleType | |
| DataType | See the DataType Mapping section | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Length | length, precision | From the Column's properties |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| Scale | scale | From the Column's properties |
| CandidateKey | CWMRDB:UniqueConstraint,CWMRDB:PrimaryKey | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| UniqueKey | Set to 'true' | |
| Class | CWMRDB:BaseTable | |
| CppAbstract | isAbstract | |
| CppClassType | Set to 'Entity' | |
| CppConcurrency | isActive | |
| CppPersistent | isTemporary | |
| CppScope | visibility | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| Stereotype | UML:Stereotype | |
| ClassDiagram | A class diagram is created each package that contains elements | |
| ClassifierMap | CWMTFM:ClassifierMap | |
| Description | functionDescription | |
| Operation | function | |
| Cube | CWMOLAP:Cube | One CubeRegion per Cube only |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| CubeDimensionAssociation | CWMOLAP:CubeDimensionAssociation | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| PhysicalName | UML:ModelElement.name / name | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| DerivedType | CWMRDB:SQLDistinctType | |
| DataType | See the DataType Mapping section | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Length | length, precision | This value can also be set from the Column's properties |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| Scale | scale | This value can also be set from the Column's properties |
| UserDefined | Set to 'true' | |
| Dimension | CWMOLAP:Dimension | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| Type | isTime or isMeasure | |
| UserDefined | Create the object only if the flag is set to "true" | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| FeatureMap | CWMTFM:FeatureMap | |
| Description | functionDescription | |
| Name | name | |
| Operation | function | |
| ForeignKey | CWMRDB:ForeignKey | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| Hierarchy | CWMOLAP:Hierarchy | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| HierarchyLevelAssociation | CWMOLAP:HierarchyLevelAssociation | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| PhysicalName | UML:ModelElement.name / name | |
| Position | Order in the file | |
| Index | CWMRDB:SQLIndex | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| Level | CWMOLAP:Level | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| LevelAttribute | CWM:Attribute | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| LevelKey | CWM:UniqueKey | |
| Name | name | |
| Measure | CWMOLAP:Measure | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| SQLViewAttribute | CWMRDB:Column | |
| SQLViewEntity | CWMRDB:View | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| WhereClause | CWMRDB:View.queryExpression | |
| StoreModel | CWMRDB:Catalog | If there are several catalogs in the file, they are saved as Packages |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| StoredProcedure | CWMRDB:StoredProcedure | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | UML:ModelElement.name / name | |
| PhysicalName | UML:ModelElement.name / name | |
| Trigger | CWMRDB:Trigger |