Attention all data modellers - we are pleased to announce the release of SQL Developer Data Modeler 3.3. This release includes a new search, reports can be generated from search results, extended Excel import and export capabilities and more control and flexibility in generating your DDL. Here are a few links to get you started:
- For downloads see here: http://www.oracle.com/technetwork/developer-tools/datamodeler/downloads/index.html
- For information about new features see here: http://www.oracle.com/technetwork/developer-tools/datamodeler/datamodeler-33-newfeatures-1869156.html
- The release notes are available here: http://www.oracle.com/technetwork/developer-tools/datamodeler/data-modeler-releasenotes33-1869517.html
- The documentation can be found here: http://www.oracle.com/pls/topic/lookup?ctx=E29463_01&id=homepage
For data warehouse data modellers there are some very important new features around logical models, multi-dimensional models and physical models. For example:
- Support for surrogate keys during engineering to relational model which can be set on each entity.
- More flexible transformation to relational model with mixed engineering strategies based on “engineer” flag and subtypes setting for each entity in the hierarchy
- Export to “Oracle AW” now supports Oracle 11g OLAP
- Support for role playing dimensions in export to Oracle AW.
- Level descriptive attributes can be created without mapping to attribute in logical model.
- Multidimensional model can be bound directly to relational model.
- Support EDITIONING option on views, and support for invisible indexes in Oracle 11g physical model.
Lots of great features that will make life a lot easier for data warehouse teams.