OMG CWM Pre-1.0 XMI 1.1 - Unsupported EOL Bridge - Import - Cloud

Talend Cloud Data Catalog Bridges

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
EnrichPlatform
Talend Data Catalog

Note: This bridge is not available in Talend Cloud Data Catalog by default. You need to set up a remote harvesting agent to import metadata from this source. For more information, see Deploying a remote harvesting agent in Talend Cloud Data Catalog Administration guide.

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
Remote Repository Browsing for Model Selection
Multi-Model Harvesting
Incremental Harvesting

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.0.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 trouble shooting 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
*.xml
*.xmi
  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:ForeignLey 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 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