Oracle Data Modeler (ODM) 4.x - Import
Availability-note
AWS
AWS-only features are available at any of the following URLs: us.cloud.talend.com, eu.cloud.talend.com, ap.cloud.talend.com
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 |
| Data Profiling |  |
| Incremental Harvesting | |
| Multi-Model Harvesting |  |
| Remote Repository Browsing for Model Selection | |
SPECIFICATIONS
Tool: Oracle / Oracle Data Modeler (ODM) version 4.x via DMD File
See http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html
Metadata: [Data Modeling] Multi-Model, Data Store (Physical Data Model, Logical Data Model, Stored Procedure Expression Parsing), Graphical Layout
Component: OracleDataModeler4 version 11.2.0
OVERVIEW
This bridge imports an Oracle SQL Developer Data Modeler .DMD file.
REQUIREMENTS
n/a
FREQUENTLY ASKED QUESTIONS
n/a
LIMITATIONS
Refer to the current general known limitations at https://metaintegration.com/Products/MIMB/Help/#!Documents/mimbknownlimitations.html
SUPPORT
Provide a troubleshooting package with:
- the debug log (can be set in the UI or in conf/conf.properties with MIR_LOG_LEVEL=6)
- the metadata backup if available (can be set in the Miscellaneous parameter with -backup option, although this common option is not implemented on all bridges for technical reasons).
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. '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 |
|
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 |