Oracle Designer - Export - 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 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

SPECIFICATIONS
Tool: Oracle / Oracle Designer version 6i to 10g via DAT File
See http://www.oracle.com/technology/products/designer/index.html
Metadata: [Data Modeling] Data Store (Physical Data Model, Logical Data Model)
Component: OracleDesigner version 11.0.0

OVERVIEW
This bridge generates a .DAT file containing either:
- an E/R Model with entities, attributes, domains, relationships and graphical layout (diagrams)
- a Server Model with tables, columns, data types, PK/FK and graphical layout (diagrams)

REQUIREMENTS
n/a

FREQUENTLY ASKED QUESTIONS
n/a

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 The path name of the generated Oracle Designer file.

In order to load the converted model, start Oracle Designer and:

1. Start the Oracle Designer tool.
2. Start the Repository Object Navigator tool by clicking on the Navigator icon.
3. Select the root object of the tree and choose "Create Child..." in the "Edit" menu.
4. Select "Application Systems" and click "OK".
5. Enter the name of the application you want to create.
6. Right-click on this newly created object and select "Import".
7. Select "Import from a text based export file" and click on "Next".
8. Enter the name of the file you want to import from or browse to select it and click on "Next" and click on "Finish".
FILE *.dat   Mandatory
Design level Design level of the model to export:

'Logical only'
Generates an E/R Model.

'Physical only'
Generates a Server Model.
ENUMERATED
Logical only
Physical only
Physical only  
Commit frequency How many commit instructions should be written in the file.

'Standard'
Standard commit frequency.

'High'
One commit instruction per object created. Useful to investigate why a particular DAT file would not load into Oracle Designer. Setting to 'High' allows an easier understanding of messages written in the Oracle Designer log file 'errlog.log' located in the BIN directory of Oracle Designer installation. However, forcing Oracle Designer to commit changes frequently takes 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