New Release of Oracle SQL Developer Data Modeler Supports Collaborative Development

In an effort to further assist data modelers, developers and IT architects to quickly and easily design data models for Oracle® Database (www.oracle.com/database) and other databases, Oracle today announced the availability of Oracle SQL Developer Data Modeler (tinyurl.com/pyqt5x) Release 3.0.

This latest release supports collaborative development through integration with the popular Subversion open-source version control software, as well as the incorporation of user-defined design rules and transformation scripts.

A lightweight, simple-to-install tool, Oracle SQL Developer Data Modeler Release 3.0 is available for download today from the Oracle Technology Network (bit.ly/g4rr4U) (OTN).

Oracle SQL Developer Data Modeler supports logical, relational, multi-dimensional and data type modeling while featuring multi-layered design and generation capabilities to produce conceptual entity relationship diagrams (ERDs) and transform them to relational models. Data modelers, developers, architects and others can build, extend and modify a model as well as compare to existing designs.

Integration with Subversion enables Oracle SQL Developer Data Modeler users to maintain current and historical versions of designs, support multi-user access to allow teams to develop the same model, and notify users of changes to models as well as allow users to accept and merge changes.

This latest release offers greater flexibility by enabling users to write rules based on corporate standards or design-specific criteria. Oracle SQL Developer Data Modeler includes a large set of pre-defined design rules for use during the development process to help identify any errors on inconsistencies in the design.

New support for user-defined transformation scripts enables developers to make global changes or updates to a design such as adding a set of standard columns to all tables or adding or removing prefixes to tables or columns in a model.

The tool integrates with Oracle SQL Developer – the popular graphical tool for database development – enabling developers to open and view and now, update, previously developed designs as well as query, run and write reports against the reporting repository.

Oracle SQL Developer Data Modeler 3.0 enables users to design and develop for Oracle Database 11g, IBM DB2 for Linux, UNIX and Windows (V7 and V8), IBM DB2 for OS/390 and z/OS, and Microsoft SQL Server 2000 and 2005. The tool also imports data models from Oracle and non-Oracle products such as Oracle Designer and CA Erwin (Data Modeler 4.x and 7.x).

Oracle SQL Developer Data Modeler is a feature of the Oracle Database and is supported through My Oracle Support with any Oracle Database license and runs on Windows, Linux and Mac OS X.

“Following a recent demonstration of Oracle SQL Developer Data Modeler 3.0, I downloaded the product and pointed it at our Designer repository,” said Andrew Davies, Data Architect, BAE Systems. “I was delighted to see how easily I could extract an existing model and work with it in Oracle SQL Developer Data Modeler. I have also used it for some top-down design, and find it intuitive and user-friendly. Oracle SQL Data Modeler 3.0 has matured into a capable and powerful tool that I now consider an essential part of my database design and development toolkit.”

“Oracle SQL Developer Data Modeler 3.0 truly returns my data analysis investment,” said Marc de Oliveira, Business Analyst, Architect, Teacher at Simplify Systems. “Specifically, the new transformation feature enables me to reuse all my metadata in new and powerful ways, allowing me to support both business managers with reporting such as natural language translations of my logical models and system developers with code generation such as table APIs managing surrogate keys and auditing.”