This document is a list of the main new features in SQL Developer Data Modeler 3.3.
Filtering of properties – can be set which properties per object type should be considered in compare/merge functionality.
|DDL Generation|| |
Options to generate default values (default values normally are not included in DDL) – schema, tablespace, logging, storage as global option, options for each storage element.
Possibility to show/hide foreign keys and relationships in subviews.
|Import and Export|| |
Import from Designer Repository - Imported objects have the same ID as in Designer repository.
|Logical Model|| |
Support for surrogate keys during engineering to relational model – can be set on each entity. Domain or precision for Numeric logical type can be set in preferences and will be used when column is created.
|Multidimensional Model|| |
Export to “Oracle AW” now supports Oracle 11g OLAP, Oracle 10g OLAP is not supported any more.
|Naming Standards|| |
Template for surrogate key and surrogate key column.
|Physical Model|| |
Support for IBM DB2/UDB 9 and MS SQL Server 2008.
Dynamic reports – part of search functionality, search result can be filtered by object type and report can be generated for objects in result set.
Global search – regular expressions (optional) can be used to search any information entered into loaded designs and models including physical models.
|Transformation Scripts||Better text editor with syntax highlight and code folding. |