Dec/083
Developer Toolbox: Oracle SQL Developer Data Modeling
I’ve been a big fan of Oracle’s SQL Developer for quite awhile. When I first started using Oracle everyone at work was using TOAD but I just couldn’t get used to TOAD’s sometimes overwhelming interface. Digging around I went looking for a free tool and stumbled across an early version of SQL Developer. While a bit buggy it did what I needed and has since matured into a very robust tool. The only thing it was lacking was a good diagram tool when I needed to generate an ERD.
That is now about to change as Oracle has released an Early Adopter Release of SQL Developer Data Modeling. This is currently a standalone product but Oracle has said at some point it will be integrated with SQL Developer.
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.
Oracle SQL Developer Data Modeling
- Browse, edit, create database models using a Graphical User Interface
- Import from a script file or Oracle, IBM mainframe DB2, IBM DB2/UDB, Microsoft SQL Server and ODBC/JDBC database catalogs
- Import multidimensional Cube Views metadata and XMLA
- Import existing models from other modeling tools like CA ERwin® Data Modeler, Oracle Designer
- Printing facilities
- Synchronized forward and reverse engineering between Logical and Relational models
- Model compare and merge facilities
- Extensive formatting options and support for subviews
- Run on Linux, Mac OS X and Windows
Oracle already has a lot of documentation, tutorials and a FAQ online at the Data Modeling site. If you are currently using SQL Developer I’d give it a try – even as an early release I’ve had good luck creating basic ERDs so far.
Possibly Related:
The Developer Toolbox: Oracle SQL Developer Data Modeling by Jim , unless otherwise expressly stated, is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.
Sorry, the comment form is closed at this time.
Upcoming
