OMG CWM 1.x XMI 1.x - Import - 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
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection
Data Profiling

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

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

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.


Bridge Parameters

Parameter Name Description Type Values Default Scope
File This bridge 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. Set up the bridge options accordingly, or select another import bridge version if necessary. FILE
*.xml
*.xmi
  Mandatory
Target Tool Specify which tool was used to generate the model you want to import. This parameter allows the bridge to fine tune the its behavior to match the way the source tool saved the model.

'Auto Detect' - The 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
OMG CWM
IBM DB2 Warehouse Manager
Oracle Warehouse Builder
SAS ETL Studio
Auto Detect  
Auto Correct The CWM file produced by some source tools may contain a slightly incomplete or incorrect model. This option allows you to specify whether the bridge should attempt to fix the model or not.

'True' - Attempt to fix the model. This may involve deleting some model elements. The bridge will log warnings informing you about the changes.

'False' - Do not modify the model. If the model is invalid the bridge will reject it.
BOOLEAN   True  
Top Package This option is used for two purposes. First, the repository metamodel requires that all model elements (lasses, Associations...) belong to a Package. So whenever an object is not explicitly associated to a Package it is stored in a special Package and this option specifies the name of the Package. Second, if there is a single top-level Package by that name in the model, the bridge will mark the Package as 'optional' so that it will not appear in the destination model if the destination tool does not require all objects to be in a Package. STRING   Logical View  
Import UUIDs The CWM file may contain UUIDs. This option allows you to specify whether the bridge should import them:

'True' - The attribute xmi.uuid is saved in the NativeId property. This is the default.
'False' - The attribute xmi.uuid is ignored.
BOOLEAN   True  
Data model Tables design level This option controls the design level of the imported tables.

It is particularly 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.
Please set the option to:

'Logical and physical' - If you would like the tables to appear both in the logical view and in the physical view of the model.

'Physical' - If you would like tables to appear only in the physical view of the model (default).
ENUMERATED
Physical
Logical and physical
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:ForeignLey 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 is 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