Oracle Designer - 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 Oracle
Tool Name Oracle Designer
Tool Version 6i to 10g
Tool Web Site http://www.oracle.com/technology/products/designer/index.html
Supported Methodology [Data Modeling] Data Store (Physical Data Model, Logical Data Model) via DAT File

Export tool: Oracle Oracle Designer 6i to 10g (http://www.oracle.com/technology/products/designer/index.html)
Export interface: [Data Modeling] Data Store (Physical Data Model, Logical Data Model) via DAT File to Oracle Designer Export bridge: 'OracleDesigner' 10.1.0

Please enter a description


Bridge Parameters

Parameter Name Description Type Values Default Scope
File Start the Oracle Designer tool and provide the required username, password and connect string in order to connect to the Oracle Designer Repository. Once you are logged in, start the Repository Object Navigator tool by clicking on the Navigator icon.

To import the .dat file generated by MIMB:
1. Select the root object of the tree and choose "Create Child..." in the "Edit" menu,
2. Select "Application Systems" and click "OK".

3. Type the name of the application you want to create and "Enter".

4. Right-click on this newly created object and select "Import...",

5. Select "Import from a text based export file" and click on "Next".
6. Type the name of the file you want to import from or browse to select it and click on "Next". Then click on "Finish".

6. Type the name of the file you want to import from or browse to select it and click on "Next". Then click on "Finish".
FILE *.dat   Mandatory
Design level Specify the design level of the model to export:

'Logical only' - Generates an E/R Model.
'Physical only' - Generates a Server Model (default).
ENUMERATED
Logical only
Physical only
Physical only  
Commit frequency Specify how many commit instructions should be written in the file.
'Standard' - Standard commit frequency (default).
'High' - One commit instruction per object created.
This option is useful to investigate why a particular DAT file would not load into Designer. Setting this value to 'High' will allow an easier understanding of messages written in the Oracle Designer loader log file 'errlog.log' located in the BIN directory of the Oracle Designer installation. However, forcing the Oracle Designer to commit changes frequently makes it longer to load the DAT file into Oracle Designer.
ENUMERATED
Standard
High
Standard  

 

Bridge Mapping

Meta Integration Repository (MIR)
Metamodel
(based on the OMG CWM standard)
"Oracle Designer"
Metamodel
OracleDesigner
Mapping Comments
     
Association Relationship, Relationship Ends, Foreign Key the Association's Foreign Key is exported
Aggregation   Relationship End has to be part of a UIE
AssociationRole Relationship, Relationship Ends, Foreign Key  
ExtraConstraint the foreign key constraints  
Multiplicity Minimum Cardinality, Maximum Cardinality  
Name Relationship End Name Computed if the role name is not set.
AssociationRoleNameMap Foreign Key columns No equivalent in Oracle Designer ER Modeling (Logical level). Name mapping between a foreign key column and its associated primary key column
Attribute Attribute/Column see DerivedType for the attribute's datatype information mapping
Comment Comment  
Description Description  
InitialValue Default Value  
Name Name/Prompt  
Optional Optional  
PhysicalName Name  
Position Sequence Number  
BaseType Domain, Attribute Format  
CandidateKey Unique Identifier/Unique Key, Primary Key  
Description Description  
Name Name  
PhysicalName Name  
UniqueKey Primary UID Flag set to True if the candidate key is the entity's primary key. Non-Unique Candidate Keys are not exported
Class Entity/Table  
Comment Comment  
Description Description  
DimensionalRole DataWarehouse Type  
Name Name/Display Name  
PhysicalName Short Name/Name  
ClassDiagram Entity Relationship Diagram  
DatabaseSchema   No equivalent in Oracle Designer ER Modeling (Logical level)
DerivedType Domain, Attribute Datatype, Allowable Values, Check Constraint  
Comment Comment  
DataType Format / Datatype See datatype conversion array
Description Description  
InitialValue Default Value  
Length Maximum Length  
LowerBound Allowable Values : Low Value  
Name Name  
PhysicalName Name / Datatype  
Scale Decimal Places  
UpperBound Allowable Values : High Value  
DesignPackage Folder  
ForeignKey Foreign Key  
Comment Comment  
Description Description  
Name Name  
PhysicalName Name  
Generalization Subtype/Foreign Key The Generalization's Foreign Key is exported
GeneralizationRole Subtype/Foreign Key  
Index Index  
Comment Comment  
Description Description  
Name Name  
IndexMember Index entries  
Position Usage sequence / Sequence in key  
Note Notes  
PropertyElementTypeScope User Extensions  
PropertyType User Extensions  
PropertyValue User Extensions  
SQLViewAssociation View, Table No equivalent in Oracle Designer ER Modeling (Logical level). Associations between views and tables for the physical level
SQLTableSequence Usage sequence  
SQLViewAttribute View Column  
Comment Comment  
Description Description  
Name Prompt  
PhysicalName Name  
Position Sequence in Table  
SQLViewEntity View  
Comment Comment  
Description Description  
Name Display Title  
PhysicalName Name  
WhereClause Where / Validation condition  
StoreModel Application  
Synonym Table alias  
Trigger Trigger, PL/SQL Definition  
Description Description  
FireOnDelete Delete  
FireOnInsert Insert  
FireOnUpdate Update  
Name Name  
PhysicalName Name  
TriggerType Execution Time  
TypeValue Allowable values  
Name Meaning/Value  
Position RadioSequence  
Value Value