OMG CWM 1.x XMI 1.x - Export - 7.1

Talend Data Catalog Bridges

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Data Catalog

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

Export tool: Object Management Group Common Warehouse Metamodel (CWM) XMI 1.0 to 1.1 (http://www.omg.org/cwm/)
Export interface: [Metadata Management] Metadata Repository, Data Store (Object Model UML Class Diagrams, Physical Data Model, Logical Data Model) via CWM XMI File to OMG CWM 1.x XMI 1.x Export bridge: 'OmgCwmXmi' 10.1.0

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 the bridge options accordingly, or select another export bridge version if necessary.

For instructions on how to Import the generated 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 CMW file is supported by my tool?
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.
Q: Exporting to IBM DB2 Warehouse Manager v8

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.
IBM DB2 Warehouse Manager v8

2. Click on the Selected -> Import MetaData -> Common Warehouse Metamodel menu. A metadata import wizard appears.

3. Specify the path name of the CWM file to be imported

4. Complete the import wizard to import the CWM file.


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 the bridge options accordingly, or select another export bridge version if necessary. FILE
*.xml
*.xmi
  Mandatory
Model Specifies the target model:
'UML' - Export the logical model only as an instance of the metamodel for the CWM Object resource package (e.g. an entity/table is an instance of CWM:Class with the logical/business name as name). Note: the CWM Object Metamodel a subset of the UML Class Diagram Metamodel.
'RDB' - Export the physical model only as an instance of the metamodel for the CWM 'Relational' resource package (e.g. an entity/table is an instance of CWMRDB:Table with the physical table name as name.
'UML and RDB' - Export both logical and physical models as separate instances of the metamodels for CWM Object and Relational resource packages respectively. Note that no dependency relationships are established between both logical and physical models.
'OLAP' - Export your model as OLAP only model. Use when exporting to OLAP objects to Oracle OWB.

The default is to export a physical model as a CWM 'Relational Resource' model.
ENUMERATED
UML
RDB
UML and RDB
OLAP
RDB  
CWM version Specifies the CWM version to write in the header when generating the file. The default is 'CWM 1.0'. ENUMERATED
CWM 1.0
CWM 1.1
CWM 1.0  
Schema mapping Specifies where to export a Table when it is not connected to any MIRSchema:

'Use Packages names' - Create a CWM's RDBMS:Schema for the Package the Table belongs to. This is the default.

'Use default name' - Create only one default RDBMS:Schema and put all the tables that are not connected to a MIRSchema in it. Use the option 'Default Schema name' to specify the name of this the default Schema.
ENUMERATED
Use Packages names
Use default name
Use Packages names  
Default Schema name Specifies the name to use for the default RDBMS:Schema. This option is ignored if 'Schema mapping' is not set to 'Use default name'. STRING      
Export Index of Key Determines whether to export the Index associated to a Primary Key or a Foreign Key.
'True' - Export the Index. This is the default.
'False' - Don't export the associated Index.
BOOLEAN   True  
UUIDs Determines whether to export the object's 'Universally Unique Identifier' when known. Note that the UUIDs of the source model may not be compatible with the target tool.

'True' - Export the UUIDs.
'False' - Don't export the necessary tags. This is the default.
BOOLEAN   False  
xmlns:CWM There is currently no standard for URIs. This option let you change the URI for the CWM namespace if the destination tool expects a special URI that is different from the default URI. STRING   org.omg.CWM1.0  
xmlns:CWMRDB There is currently no standard for the URIs. This option let you change the URI for the CWMRDB namespace if the destination tool expects a special URI that is different from the default URI. STRING   org.omg.CWM1.0/Relational  
xmlns:CWMOLAP There is currently no standard for URIs. This option let you change the URI for the CWM namespace if the destination tool expects a special URI that is different from the default URI. STRING   org.omg.CWM1.0/OLAP  
xmlns:CWMTFM There is currently no standard for the URIs. This option let you change the URI for the CWMRDB namespace if the destination tool expects a special URI that is different from the default URI. STRING   org.omg.CWM1.0/Transformation  
Verbosity This parameter controls the dimensional modeling forward engineering verbosity level.

'False' - Normal verbosity.
'True' - Additional information is printed in the log.
BOOLEAN   True  
XML Indentation (pretty printing) This option controls the pretty printing of the XML, for the purpose of opening the generated file in a text editor.

For example, specify here a tabulation character, or some space characters.

By default, there is no indentation which leads to a more compact file.
STRING      
Print DTD reference By default the bridge include a DTD reference in the XML file.
If you want the bridge to include a DTD reference to 'cwm.dtd' please select the 'True' option.The print DTD reference can be used for XML file validation.
Some XML viewers, like Microsoft IE browser, refuse to display XML file if it includes a reference to a DTD file that is missing. The bridge 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 1.x XMI 1.x"
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 theCWM 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   Ordef 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 is 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