Bridge Specifications
| Vendor | Object Management Group |
| Tool Name | Common Warehouse Metamodel (CWM) XMI |
| Tool Version | Adopted Specs Pre-1.0 |
| 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, OLAP Dimensional Model, Stored Procedure Expression Parsing), ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing, Expression Conversion), BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage) via CWM XMI File |
SPECIFICATIONS
Tool: Object Management Group / Common Warehouse Metamodel (CWM) XMI version Adopted Specs Pre-1.0 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, OLAP Dimensional Model, Stored Procedure Expression Parsing), ETL (Source and Target Data Stores, Transformation Lineage, Expression Parsing, Expression Conversion), BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage)
Component: OmgCwmXmiPre10 version 11.2.0
OVERVIEW
Generates an XML file compliant to 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 generate the appropriate OMG CWM XMI version for your target tool.
REQUIREMENTS
n/a
FREQUENTLY ASKED QUESTIONS
Q: Which version of CMW 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 web site for more details of their valid combinations of metamodels and XMI formats.
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 | This bridge generates an XML file compliant to 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 generate the appropriate OMG CWM XMI version for your target tool. Set up this bridge options accordingly, or select another export bridge version if necessary. | FILE |
|
Mandatory | ||||
| Model | Specifies the target Model. 'UML' Export a UML view of the model. 'RDB' Export a Relational view of the model. 'UML and RDB' Exports both a UML view and a Relational view of the model. |
ENUMERATED |
|
RDB | ||||
| XML Indentation (pretty printing) | Controls the pretty printing of XML, for the purpose of opening the generated file in a text editor. E.g. 'space characters' Several space characters as indentation. 'tab key' Tab character as indentation. 'empty' No indentation which leads to a more compact file. |
STRING | ||||||
| Print DTD reference | Some XML viewers, like Microsoft IE, refuse to display an XML file if it includes a reference to a DTD file that is missing. This bridge normally does not provide the 'cwm.dtd' file. If you need the DTD file please find and copy it to the same directory where the XML file is. | BOOLEAN | True |
Bridge Mapping
| Meta Integration Repository (MIR) Metamodel (based on the OMG CWM standard) |
"OMG CWM Pre-1.0 XMI 1.1 - Unsupported EOL Bridge" Metamodel OmgCwmXmi |
Mapping Comments |
| Name | name | If 'physicalName' is not set |
| Argument | UML:Parameter | |
| DefaultValue | defaultValue | |
| Description | 'documentation' tagged value | |
| Kind | kind | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Position | Order in the CWMRDB file | |
| AssociationRole | CWMRDB:ForeignKey | |
| Description | 'documentation' tagged value | |
| ExtraConstraint | deleteRule, updateRule | |
| PhysicalName | name | |
| Source | Source Association roles are not mapped | |
| AssociationRoleNameMap | Order in the CWM RDB file | |
| Attribute | CWMRDB:Column | |
| Description | 'documentation' tagged value | |
| ExtraConstraint | CWMRDB:CheckConstraint | The constraint is associated to the BaseClass |
| InitialValue | UML:Attribute.initialValue | |
| Name | name | If 'physicalName' is not set |
| Optional | isNullable | |
| PhysicalName | name | |
| Position | Order in CWM RDB file | |
| BaseType | CWMRDB:SQLSimpleType | |
| DataType | typeNumber | See the DataType Mapping section. |
| Description | 'documentation' tagged value | |
| Length | characterMaximumLength, numericPrecision, dateTimePrecision | Also saved as a property of the Column |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Scale | numericScale | Also saved as a property of the Column |
| CandidateKey | CWMRDB:UniqueConstraint,CWMRDB:PrimaryKey | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| UniqueKey | Non unique keys are not exported | |
| Class | CWMRDB:BaseTable | |
| CppPersistent | isTemporary | |
| CppScope | visibility | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| ClassifierMap | CWMTFM:ClassifierMap | |
| Description | functionDescription | |
| Operation | function | |
| Cube | CWMOLAP:Cube | One CubeRegion per Cube only |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| CubeDimensionAssociation | CWMOLAP:CubeDimensionAssociation | |
| Description | 'documentation' tagged value | |
| PhysicalName | name | |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| DerivedType | CWMRDB:SimpleType,CWMRDB:DistinctType | The hierarchy of types is not reproduced. See BaseType mapping for the mapping of Derived types to Simple types |
| DataType | typeNumber | See the DataType Mapping section. |
| Description | 'documentation' tagged value | |
| InitialValue | initialValue | Saved as a property of the Column |
| Length | length, precision | Also saved as a property of the Column |
| Name | If 'physicalName' is not set | |
| PhysicalName | name | |
| Scale | scale | Also saved as a property of the Column |
| UserDefined | Generate a DistinctType if the property is set to true. | |
| DesignPackage | CWMRDB:Schema | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Dimension | CWMOLAP:Dimension | |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| Type | isTime or isMeasure | |
| UserDefined | Create the object only if the flag is set to "true" | |
| DimensionAttribute | CWMOLAP:MemberSelection | |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| FeatureMap | CWMTFM:FeatureMap | |
| Description | functionDescription | |
| Name | name | |
| Operation | function | |
| ForeignKey | CWMRDB:ForeignKey | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | 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 | 'documentation' tagged value | |
| PhysicalName | name | |
| Position | Order in the file | |
| Index | CWMRDB:SQLIndex | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Unique | isUnique | If the index is associated to a candidated key |
| IndexMember | CWMRDB:SQLIndexColumn | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Position | Order in the CWM RDB file | |
| SortOrder | isAscending | |
| Level | CWMOLAP:Level | |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| LevelAttribute | CWM:Attribute | |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| LevelKey | CWM:UniqueKey | |
| Name | name | |
| Measure | CWMOLAP:Measure | |
| Description | 'documentation' tagged value | |
| Name | name | |
| PhysicalName | name | |
| SQLViewAttribute | CWMRDB:Column | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Position | Order in CWM RDB file | |
| SQLViewEntity | CWMRDB:View | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| WhereClause | CWMRDB:View.queryExpression | |
| StoreModel | CWMRDB:Catalog | If there are several catalogs in the file, they are saved as Packages |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| StoredProcedure | CWMRDB:StoredProcedure | |
| Description | 'documentation' tagged value | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Semantics | body | |
| Trigger | CWMRDB:Trigger | |
| Description | 'documentation' tagged value | |
| FireOnDelete | eventManipulation | |
| FireOnInsert | eventManipulation | |
| FireOnUpdate | eventManipulation | |
| Name | name | If 'physicalName' is not set |
| PhysicalName | name | |
| Semantics | actionStatement | |
| TriggerType | conditionTiming |