Oracle Data Modeler (ODM) 4.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 Specifications

Vendor Oracle
Tool Name Oracle Data Modeler (ODM)
Tool Version 4.x
Tool Web Site http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html
Supported Methodology [Data Modeling] Multi-Model, Data Store (Physical Data Model, Logical Data Model, Stored Procedure Expression Parsing), Graphical Layout via DMD File
Incremental Harvesting
Multi-Model Harvesting
Remote Repository Browsing for Model Selection
Data Profiling

BRIDGE INFORMATION
Import tool: Oracle Oracle Data Modeler (ODM) 4.x (http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html)
Import interface: [Data Modeling] Multi-Model, Data Store (Physical Data Model, Logical Data Model, Stored Procedure Expression Parsing), Graphical Layout via DMD File from Oracle Data Modeler (ODM) 4.x
Import bridge: 'OracleDataModeler4' 10.1.0

BRIDGE DOCUMENTATION
This bridge imports an Oracle SQL Developer Data Modeler .DMD file.


Bridge Parameters

Parameter Name Description Type Values Default Scope
File Specify here the file path of the Oracle SQL Developer Data Modeler (.dmd) to import. FILE *.dmd   Mandatory
Model selection ODM files are composed of multiple independent models. Select which model the bridge should import:

'All models' - The logical and relational models are imported. (Default)
'Logical model' - The logical model is imported.
'Relational model' - A relational model is imported. Use the parameter 'Relational model name' to select which one.

Note - Selecting 'All models' means that the bridge will create a multi-model construct which is not compatible with many data modeling and design tools. Please only use this option if one intends to load the result in a tool which can consume it.
ENUMERATED
Logical model
Relational model
All models
All models  
Relational model name ODM files are composed of multiple independent models. To choose which relational model should be imported, set the parameter 'Model selection' to 'Relational model', and enter the name of the relational model to import in this parameter. STRING      
Installation directory The full path to the installation directory. The directory is used to search for proper types files used by the bridge.

For version 4.x, it might be
'C:\Program Files\Oracle Data Modeler', or
'C:\Program Files\Oracle SQLDeveloper\sqldeveloper\extensions'.
DIRECTORY     Mandatory

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Oracle Data Modeler (ODM) 4.x"
Metamodel
Oracle Data Modeler (Design)
Mapping Comments
     
DirectoryStructureModel Design  
CreationTime Creation Time  
Description Description  
ImportDate Import Date  
Name Name  
NativeId Native Id  
NativeType Native Type  
Folder Relational Models  
Author Author  
CreationTime Creation Time  
Description Description  
LastModificationTime Last Modification Time  
Modifier Modifier  
Name Name  
NativeId Native Id  
NativeType Native Type  
StoreContent Logical Model, Relational Model  
Author Author  
CreationTime Creation Time  
Description Description  
LastModificationTime Last Modification Time  
Modifier Modifier  
Name Name  
NativeId Native Id  
NativeType Native Type  

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Oracle Data Modeler (ODM) 4.x"
Metamodel
Oracle Data Modeler (Logical Model)
Mapping Comments
     
Association Relation  
Aggregation Identifying  
Comment Comment  
Description Description  
DesignLevel Design Level  
ExtraConstraint Constraint  
Name Name  
NativeId Native Id  
AssociationRole Unnamed RelationEnd, Named RelationEnd  
Multiplicity Cardinality  
Name Name  
OnDelete On Delete  
OnInsert On Insert  
OnUpdate On Update  
Source Source  
Attribute Attribute  
Comment Comment  
Description Definition  
DesignLevel Design Level  
ExtraConstraint Constraint  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Nullable  
PhysicalName Column Name  
Position Position  
CandidateKey Primary Key, Unique Constraint  
Comment Comment  
Description Description  
DesignLevel Design Level  
Name Name  
NativeId Native Id  
PhysicalName Physical Name  
UniqueKey Unique Key  
Class Entity  
Description Description  
DesignLevel Design Level  
Name Name  
NativeId Native Id  
PhysicalName Table Name  
ClassDiagram Display  
Comment Comment  
Description Description  
DesignLevel Design Level  
Name Name  
Notation Notation  
Condition Condition  
Name Name  
DerivedType Domain  
Comment Comment  
DataType Data Type  
Description Description  
DesignLevel Design Level  
InitialValue Initial Value  
Length Length  
LowerBound Lower Bound  
Name Name  
NativeDataType Native Data Type  
NativeId Native Id  
NativeLogicalDataType Native LogicalDataType  
PhysicalName Physical Name  
Scale Scale  
UpperBound Upper Bound  
UserDataType User Data Type  
DesignPackage SubView  
Comment Comment  
Description Description  
DesignLevel Design Level  
Name Name  
NativeId Native Id  
ForeignKey Foreign Key  
Comment Comment  
Description Description  
DesignLevel Design Level  
Generate Generate  
Name Name  
NativeId Native Id  
PhysicalName Physical Name  
Generalization Inheritance  
Comment Comment  
Complete Complete  
Description Description  
DesignLevel Design Level  
Exclusive Exclusive  
Name Name  
NativeId Native Id  
PhysicalName Physical Name  
GeneralizationRole Inheritance Role  
Description Description  
DesignLevel Design Level  
Name Name  
NativeId Native Id  
OnDelete On Delete  
OnInsert On Insert  
OnUpdate On Update  
Note Note  
Name Name  
Position Position  
Value Note  
SQLViewAttribute View Attribute  
Comment Comment  
Description Definition  
DesignLevel Design Level  
Expression Expression  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Nullable  
PhysicalName Column Name  
Position Position  
SQLViewEntity View  
Comment Comment  
Description Description  
DesignLevel Design Level  
DimensionalRole Dimensional Role  
Generate Generate  
GroupByClause Group By Clause  
HavingClause Having Clause  
Name Name  
NativeId Native Id  
OrderByClause Order By Clause  
PhysicalName Physical Name  
SelectType Select Type  
ViewStatement View Statement  
ViewStatementType View Statement Type  
ViewType View Type  
WhereClause Where Clause  
StoreModel Logical Model  
Author Author  
Comment Comment  
CreationTime Creation Time  
Description Description  
DesignLevel Design Level  
ModificationTime Modification Time  
Modifier Modifier  
Name Name  
NativeId Native Id  
PhysicalName Physical Name  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
SystemTypeOld System Type Old  

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Oracle Data Modeler (ODM) 4.x"
Metamodel
Oracle Data Modeler (Relational Model)
Mapping Comments
     
Association Relation  
Aggregation Identifying  
Comment Comment  
Description Description  
DesignLevel Design Level  
ExtraConstraint Constraint  
Name Name  
NativeId Native Id  
AssociationRole Unnamed RelationEnd, Named RelationEnd  
Multiplicity Cardinality  
Name Name  
OnDelete On Delete  
OnInsert On Insert  
OnUpdate On Update  
Source Source  
Attribute Column, Foreign Key Column  
Comment Comment  
Description Definition  
DesignLevel Design Level  
ExtraConstraint Constraint  
Generate Generate  
InitialValue Initial Value  
Name Column Name, Name  
NativeId Native Id  
Optional Nullable  
Position Position  
CandidateKey Primary Key, Unique Constraint  
Comment Comment  
Description Description  
DesignLevel Design Level  
Name Name  
NativeId Native Id  
PhysicalName Physical Name  
UniqueKey Unique Key  
Class Table  
Comment Comment  
Description Description  
DesignLevel Design Level  
DimensionalRole Dimensional Role  
DimensionalType Dimensional Type  
Generate Generate  
Name Name  
NativeId Native Id  
PhysicalName Table Name  
ClassDiagram Display  
Comment Comment  
Description Description  
DesignLevel Design Level  
Name Name  
Notation Notation  
Condition Condition  
Name Name  
DatabaseSchema Schema  
Comment Comment  
Description Description  
DesignLevel Design Level  
Name Name  
NativeId Native Id  
PhysicalName Physical Name  
DerivedType Domain  
Comment Comment  
DataType Data Type  
Description Description  
DesignLevel Design Level  
InitialValue Initial Value  
Length Length  
LowerBound Lower Bound  
Name Name  
NativeDataType Native Data Type  
NativeId Native Id  
NativeLogicalDataType Native LogicalDataType  
PhysicalName Physical Name  
Scale Scale  
UpperBound Upper Bound  
UserDataType User Data Type  
DesignPackage SubView  
Comment Comment  
Description Description  
DesignLevel Design Level  
Name Name  
NativeId Native Id  
ForeignKey Foreign Key  
Comment Comment  
Description Description  
DesignLevel Design Level  
Generate Generate  
Name Name  
NativeId Native Id  
PhysicalName Physical Name  
Index Index  
Clustered Clustered  
Comment Comment  
Description Description  
DesignLevel Design Level  
Generate Generate  
Name Name  
NativeId Native Id  
PhysicalName Physical Name  
Unique Unique  
Note Note  
Name Name  
Position Position  
Value Note  
SQLViewAttribute View Column  
Comment Comment  
Description Definition  
DesignLevel Design Level  
Expression Expression  
InitialValue Initial Value  
Name Name  
NativeId Native Id  
Optional Nullable  
PhysicalName Column Name  
Position Position  
SQLViewEntity View  
Comment Comment  
Description Description  
DesignLevel Design Level  
DimensionalRole Dimensional Role  
Generate Generate  
GroupByClause Group By Clause  
HavingClause Having Clause  
Name Name  
NativeId Native Id  
OrderByClause Order By Clause  
PhysicalName Physical Name  
SelectType Select Type  
ViewStatement View Statement  
ViewStatementType View Statement Type  
ViewType View Type  
WhereClause Where Clause  
StoreModel Relational Model  
Author Author  
Comment Comment  
CreationTime Creation Time  
Description Description  
DesignLevel Design Level  
ModificationTime Modification Time  
Modifier Modifier  
Name Name  
NativeId Native Id  
PhysicalName Physical Name  
StoreType Store Type  
SystemMajorVersion System Major Version  
SystemMinorVersion System Minor Version  
SystemReleaseVersion System Release Version  
SystemType System Type  
SystemTypeOld System Type Old