Bridge Requirements
This bridge:is only supported on Microsoft Windows.
Bridge Specifications
| Vendor | Object Management Group |
| Tool Name | Common Warehouse Metamodel (CWM) XMI |
| Tool Version | 1.0 to 1.1 |
| Tool Web Site | http://www.omg.org/cwm/ |
| Supported Methodology | [Metadata Management] Metadata Repository, Data Store (Object Model UML Class Diagrams, Physical Data Model, Logical Data Model) via CWM XMI File |
| Data Profiling |  |
| Incremental Harvesting | |
| Multi-Model Harvesting | |
| Remote Repository Browsing for Model Selection | |
SPECIFICATIONS
Tool: Object Management Group / Common Warehouse Metamodel (CWM) XMI version 1.0 to 1.1 via CWM XMI File
See http://www.omg.org/cwm/
Metadata: [Metadata Management] Metadata Repository, Data Store (Object Model UML Class Diagrams, Physical Data Model, Logical Data Model)
Component: OmgCwmXmi version 11.2.0
OVERVIEW
Imports an XML file compliant with the Object Management Group (OMG) Common Warehouse Metamodel (CWM) XML Metadata Interchange (XMI) file format. There are multiple versions of the CWM metamodel and XMI format, therefore make sure you identify the exact OMG CWM XMI version produced by your source tool.
REQUIREMENTS
For instructions on how to create a proper UML XMI file, please select the exact bridge (with the tool name) from the list of bridges rather than using this generic bridge.
FREQUENTLY ASKED QUESTIONS
Q: Which version of CWM file is supported by my tool?
A: Contact the vendor to obtain the exact version of their supported CWM metamodel and XMI format. You can also check out the OMG website for more details of their valid combinations for metamodels and XMI formats.
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 | 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) |
"OMG CWM 1.x XMI 1.x" 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 |