Oracle Designer - Export
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 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.2.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 MIMB Known Limitations or bundled in Documentation/ReadMe/MIMBKnownLimitations.html
SUPPORT
Provide a troubleshooting 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 |
|
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 |
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 |