Oracle SQL Developer Data Modeler 2.0 (22.214.171.1244)
Patch 1 - Release Notes
Oracle SQL Developer Data Modeler allows you to develop logical, multi-dimensional, user defined data types, relational and physical data models. The tool provides full forward engineering, including engineering from Logical ERD models to Relational models and the reverse, Import from the Data Dictionary and DDL script generation. The Data Modeler imports from and exports to a variety of sources and targets, provides a variety of formatting options and validates the models through a predefined set of design rules. For more detail of the feature see the collateral provided on the Data Modeler home page on the Oracle Technology Network.
Oracle SQL Developer Data Modeler runs on the following operating systems:
The following requirements must be met to install and run correctly:
Note: We provide the download with and without the Java Runtime. Minimum is JRE 1.6. For Linux and Mac install you must download the zip without the JRE. You'll be prompted on startup for the path to the JRE.
Before you Install
Using the Reporting Repository
Providing Full Support for Oracle Database 11g features
Oracle Designer Import
Comparing Logical Models
Comparing Relational Models and Generation Alter DDL scripts
Cloning Physical Models
Oracle SQL Developer Data Modeler imports from:
Oracle does not ship the non-Oracle drivers.To access the non-Oracle databases, you need to download and add the drivers required.
The drivers can be downloaded from the following links:
To add the drivers yourself: Go to Tools - > General Options -> DDL -> Third Party JDBC drivers
After installing, the drivers must be set in the option dialog as follows:
We are aware of the following limitations and issues. This list is not exhaustive, but a list of issues that you may encounter. Please contact Oracle Support through Metalink for further queries about issues, or to log new issues.
Point to be aware of:
You can use the documentation in the Oracle SQL Developer Data Modeler Help or access the online documentation.