Oracle SQL Developer Data Modeler 4.0.3.853 Build 853 / 4.1.0.873 Build 873 EA2

A practical and reliable database utility that enables you to import objects from multiple schemas, as well as to design rules and transformation scripts

  Add it to your Download Basket!

 Add it to your Watch List!

0/5

Rate it!

What's new in Oracle SQL Developer Data Modeler 4.1.0.873 Build 873 EA2:

  • Bugs fixed:
  • 20196054 - SQL Server 2012 ddl generation for triggers: schema name missing in on clause
  • 20291862 - Export to reporting schema - ora-12899: value too large for column
  • 20315489 - "straighten lines" greyed out for multiple lines in logical model
Read full changelog
report
malware
send us
an update
LICENSE TYPE:
Freeware 
FILE SIZE:
212 MB
OUR RATING:
5.0/5
DEVELOPED BY:
Oracle
USER RATING:
4.9/5 5
CATEGORY:
C: \ Internet \ Servers \ Database Utils
18 Oracle SQL Developer Data Modeler Screenshots:
Oracle SQL Developer Data Modeler - Oracle SQL Developer Data Modeler provides a model driven approach for database design and generationOracle SQL Developer Data Modeler - From the File menu of the application you are able to import a new DDL or VAR file, as well as to save the current projectOracle SQL Developer Data Modeler - You can navigate to the Team menu if you want to create a new connection, as well as to import new filesOracle SQL Developer Data ModelerOracle SQL Developer Data ModelerOracle SQL Developer Data ModelerOracle SQL Developer Data ModelerOracle SQL Developer Data ModelerOracle SQL Developer Data ModelerOracle SQL Developer Data ModelerOracle SQL Developer Data ModelerOracle SQL Developer Data ModelerOracle SQL Developer Data ModelerOracle SQL Developer Data ModelerOracle SQL Developer Data ModelerOracle SQL Developer Data ModelerOracle SQL Developer Data ModelerOracle SQL Developer Data Modeler
Oracle SQL Developer Data Modeler (referred to as Data Modeler) is a straightforward data modeling and database design tool that comes with a user-friendly environment for capturing, managing and exploiting metadata. It provides a model driven approach for database design and generation and allows you to create various models including relational, logical and data flow diagrams.

Using this application, you have the possibility to create, edit and delete objects in different kinds of models. Many objects including diagrams, tables and classes have similar properties and the methods for performing operations are usually intuitive.

The main window mainly uses the left side for navigation to browse for objects and display them in the right side of the window. The utility comes with well-organized menus that contain standard entries, plus specific features to Data Modeler such as Versioning, Recent Designs, Logical Diagram Notation, DDL File Editor and Engineering Status.

At the core of the utility is the logical model (also known as the entity-relationship diagram or ERD) that provides an implementation-independent view of enterprise information.

After loading the diagram you are interested in, you are able to view graphical representations of entities, inheritances, domains, views (also called virtual tables) and links between classes. However, when you are working with a logical model, you may want to create subviews, each describing only a section of that model. Relations between classes are displayed on the logical model and on logical subviews so you can easily view the dependencies between tables.

When you right-click on the current logical model, you are able to set classification types and apply custom transformation scripts. Also, the utility provides full forward engineering, including engineering from logical models to relational ones. Simply select the ‘Engineer to Relational Model’ option from the context menu, choose the attributes and map the current tables and subviews.

After that, go to the ‘Relational Models’ section from the left panel and view all the generated tables, the created views and the foreign keys. You are able to define the primary key for each table, view all the available dependencies and control the table level constraints. Then, write the scripts for the created tables using Oracle SQL Developer and add new triggers, functions, INSTEAD OF shutters, etc.

Considering all of the above, Oracle SQL Developer Data Modeler proves to be a steady and effective solution specially intended for users who need to develop logical, relational and physical data models. It automatically generates tables and foreign keys from the current logical model and enables you to use all the data when creating new SQL scripts.

Oracle SQL Developer Data Modeler was reviewed by , last updated on April 6th, 2015

Runs on: Windows XP / XP 64 bit / Vista / Vista 64 bit / 7 / 7 64 bit / 8 / 8 64 bit

feature list requirements

#data modeler #SQL modeler #develop data model #data model #modeler #developer #Oracle

Add your review!

SUBMIT