Oracle Sql Developer Data Modeler

1 - About

Oracle SQL Developer Data Modeling is the latest product offering to join the Oracle Database Tools. SQL Developer Data Modeling offers a full spectrum of data and database modeling tools and utilities, including Entity Relationship modeling, Relational (Database Design), Data Type and Multidimensional modeling, full forward and reverse engineering and code generation. It includes importing from and exporting 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 Demo, Flash, Tutorial, User Guide, see the Start Page from Oracle OTN

3 - How to

3.1 - Install

Download it, click on datamodeling.exe and if you are asked to enter the full pathname for java.exe, click Browse and find java.exe. For example, on a Windows system the path might have a name similar to C:\Program Files\Java\jdk1.6.0_06\bin\java.exe.

3.1.1 - 64 bit

You must modify the path of your 64 bit JDK in the datamodeler_home\bin\datamodeler64.conf file. Oracle doesn't provide one.

Set your path as follow:

SetJavaHome C:\Program Files\Java\jdk1.6.0_32

in place of

SetJavaHome ../../jdk

Otherwise you will get this error:

Unable to launch the jvm

3.2 - Add SQL Server as data source

  • Download the JDBC Driver
  • Copy the file sqljdbc4.jar in the jdbc directory of Data Modeler of in your library directory
  • Add the jar to the preferences (Menu > Tools > Preferences) sqljdbc4.jar as first in the list

  • When importing from a data dictionary, fill the parameters in.

oracle_sql_developer_data_modeler/oracle_sql_developer_data_modeler.txt ยท Last modified: 2013/07/13 16:03 by gerardnico