Note:
AWS
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 | 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), BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage) 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 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), BI Design (RDBMS Source, OLAP Source, Dimensional Target, Transformation Lineage)
Component: OmgCwmXmiPre10 version 11.2.0
OVERVIEW
REQUIREMENTS
n/a
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 web site for more details of their valid combinations of 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 | |||
| Auto Correct | The CWM file sometimes contain a slightly incomplete or incorrect model. Specify whether this bridge should attempt to fix them 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 |
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 OmgCwmXmiPre10 |
Mapping Comments |
| 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 | |
| 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 | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| InitialValue | UML:Attribute.initialValue | |
| Name | collationName | |
| Optional | isNullable | |
| PhysicalName | UML:ModelElement.name / name | |
| Position | Order in the file | |
| Stereotype | UML:Stereotype | |
| BaseType | CWMRDB:SQLSiimpleType | |
| 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 | The length and precision are appended if non zero |
| 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 | |
| Name | name | |
| Stereotype | UML:Stereotype | |
| ClassDiagram | A class diagram is created each package that contains elements | |
| DerivedType | CWMRDB:SQLDistinctType | |
| DataType | See the DataType Mapping section | |
| Length | length, precision | This value can also be set from the Column's properties |
| Name | name | The length and precision are appended if non zero |
| Scale | scale | This value can also be set from the Column's properties |
| UserDefined | Set to 'true' | |
| DesignPackage | CWMRDB:Schema | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| ForeignKey | CWMRDB:ForeignKey | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| Index | CWMRDB:SQLIndex | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| IndexMember | CWMRDB:SQLIndexColumn | |
| Description | UML:ModelElement.taggedValue | Tagged values called 'documentation' are put in the description |
| Name | name | |
| PhysicalName | UML:ModelElement.name / name | |
| Position | Order in the file | |
| SortOrder | isAscending | |
| 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 |