Oracle SQL Developer Data Modeler Changelog

What's new in Oracle SQL Developer Data Modeler 18.1.0.082.1035

Mar 30, 2018

ENHANCEMENTS:
Diagrams:
export diagrams to database
import diagrams from database (including missing objects);
Identity column:
support for related properties in compare/merge functionality
alter statement generation for Oracle Database 12c
BUGS FIXED:
27260192 - CUSTOM TRANSFORMATION SCRIPTS NOT SHOWING RED FOR MISSING ENGINE
27497837 - NOT POSSIBLE TO EDIT PL/SQL CODE - PROCEDURES, PACKAGES AND FUNCTIONS
27421388 - STORAGE TEMPLATE OF PHYSICAL MODEL LIMITS INITIAL STORAGE TO LESS THAN 2GB
27294969 - ENGINEERING TO RELATIONAL MODEL DIALOG DOESN'T SHOW UP
27360435 - COPY/PASTE OF TABLE BETWEEN MODELS PUT TABLE TOO FAR FROM VISIBLE PART OF DIAGRAM
27571216 - COPYING COLUMNS BETWEEN DESIGNS - DOMAINS ARE NOT CORRECT IN UI
27258556 - REVERSED ENGINEERED VIEW DOES NOT SEE CHAR SEMANTIC COLUMNS
27658598 - LOGICAL TYPE INTEGER CANNOT BE MAPPED TO MS SQL SERVER INT DATA TYPE
27040412 - HIVE:DATATYPE FOR VARCHAR/NVARCHAR COLUMN IN MODEL IS AS UNKNOWN
27683818 - DDL FOR NONE TRANSFERABLE TRIGGER DOESN'T INCLUDE THE SCHEMA OF THE TABLE
27743130 - NO SUPPORT FOR SEVERAL LOCATION SPECIFIERS FOR EXTERNAL TABLES

New in Oracle SQL Developer Data Modeler 17.4.0.355.2121 (Dec 23, 2017)

New in Oracle SQL Developer Data Modeler 17.3.0.261.1529 (Oct 2, 2017)

New in Oracle SQL Developer Data Modeler 4.2.0.932 (Apr 14, 2017)

New in Oracle SQL Developer Data Modeler 4.1.3.901 (Dec 22, 2015)

New in Oracle SQL Developer Data Modeler 4.1.2.1.899 (Dec 3, 2015)

New in Oracle SQL Developer Data Modeler 4.1.2.895 (Oct 24, 2015)

New in Oracle SQL Developer Data Modeler 4.1.1.888 (Aug 19, 2015)

New in Oracle SQL Developer Data Modeler 4.1.0.881 (May 4, 2015)

New in Oracle SQL Developer Data Modeler 4.0.3.853 (Apr 6, 2015)

Bugs fixed:
18440949 - passwords on Oracle User Objects not saved
18990812 - logging clause should not be generated for external tables
18990862 - there is no option similar to database parameter max_string_size
18994508 - DDL generation for redaction policy doesn't consider include schema flag
18678023 - NPE when dropping a table-level check constraint in compare/merge DDL preview
18872679 - mouse cursor doesn't change when passing over resizing points
19071523 - abbreviation property of table is not visible in data modeler table report
19077793 - redaction policy without schema when user is set on table only in phys. model
19048961 - data modeler svn needs a comment field
18901557 - no support for lock on domains when use svn
18902129 - issue with Data Modeler script rhino "oracle.xml.parser.v2.xmlparseexception"
19013074 - abbreviation name and preferred abbreviation when imported from other data model
18892137 - no objects for search/report functionality for transformation tasks
19046577 - navigator window does not display whole diagram
19170356 - want to not apply fk column template during engineering to relational model
19169755 - no location clause rule when accessing hive in Oracle Database 12.1.0.2
19176915 - need variable with script name available in transformation script
13683049 - support for {table abbr} and {table} in table scripts;{schema}, {long name}, {pk name}
19205899 - "custom design rules" window to not be modal
19206591 - exit application asks to save for only one design leaving other not saved
19172342 - common design level settings for set of designs
18892180 - generate DDL in files without directories for design,relational model, physical model
19273240 - import fails on tables with thousands of partitions and subpartitions
19133342 - need option to use preferred logical types in domain administration
19220217 - click team > resolve conflicts, there is a NPE pop up
19415704 - custom libraries window should be non modal
19313110 - sync does not identify imported tables that have been dropped from the model
19438446 - updated status of remote(linked) table is not saved

New in Oracle SQL Developer Data Modeler 4.0.1.836 (Feb 27, 2014)

Enhancements:
Subviews:
dialog to add/remove objects from subview
option to create an SubView based on the selected View and all of its related objects
Diagrams:
option to show/hide Foreign Keys on tables on diagram
execute Zoom-In/Zoom-out actions using CTRL + Mouse Wheel
execute Actual Size action using CTRL + Mouse Wheel click
Search and Custom reports
improvements in building of expressions in advanced search mode
dynamic properties can be included in custom report templates and generated report
Engineering to Relational Model
option to not add column prefix for columns generated out of entity hierarchy
Import from Oracle Database:
options to skip import of partitions, triggers and additional processing for used structured types
New Features:
DDL Generation:
Support for Code folding in DDL file editor
"Generate Valid Value Constraints" option to generate DDL without List of Values and Range of Values constraints
Option to split generated DDL in separate files
Option to include SQL*Plus Prompt command in generated DDL
Diagrams:
Option to show/hide classification types on diagrams in logical and relational models
Logical model - "Resize to visible" works on hierarchical entities; auto layout functionality for diagrams in logical model
Display "Comments in RDBMS" for Tables, Columns, Entities and Attributes on the diagram
"Show page grid" option is added
Engineering between Logical and Relational:
Added support for table_template during engineering to relational model
Subview can be used as selector of objects to be engineered from relational to logical model
General:
Design level preferences are moved to design dialog
Additional classification types can be set on entities and tables
Option to show external log file - View>External Log
Logical Model:
Sorting of attributes in entities – can be applied on Logical model, a group of selected entities and in entity dialog
Entities and attributes can be set as deprecated
Masking:
Mask templates can be defined and used in definition of columns with sensitive information.
Support for REDACTION policy definition on table and column level.
Support for Transparent Sensitive Data Protection (TSDP) policies:
- Sensitive types can be created and associated with domains, columns and attributes TSDP policies can be created and associated with sensitive types
Physical Model Oracle:
Support sub-partitioning for Hash partitions (Oracle 11g)
Added “Propagate Properties” functionality for users and roles
“Propagate Properties” functionality for table now also covers partitions
Propagate Properties option for Views, Procedures, Functions, Packages, Primary and Unique Keys
Physical Model Oracle 12c Database:
Support for IDENTITY Columns - with option to be implemented using sequence and trigger or new syntax for identity column
Option to generate DDL for an auto-increment column using a DEFAULT clause referring to the NEXTVAL of a Sequence
DEFAULT ON NULL clause for columns for explicit NULL insertion
Increased size limit for VARCHAR2, NVARCHAR2 and RAW data types
Session sequences
Invisible columns
Import of Redaction and TSDP policy definitions form database
Redaction and TSDP policy definitions can be included in generated DDL
Printing:
"Print to PDF file" is added in "Print to Printer" functionality
Query Builder:
Added option to disable/enable auto join on FKs/Relationships in Query Builder
Relational Model:
View columns – added support for notes and comments
Tables and Columns can be set as deprecated
“Clear Source Stamp” can be applied on a group of selected objects – removes source information (database or DDL file) logged for selected objects
"Split relational model by schema name" wizard – to split large models into smaller models and transforming source model in read-only mode
Table - added support of Valid Time dimensions introduced in Oracle 12c Database - can be added, imported from Oracle 12c Database and generated in DDL
Reports:
Added SQL script for granting read only access to reporting repository
Standard reports – already created diagrams can be reused in next reports
Custom reports: Reports with two levels of details can be created for Entity, Table (relational model), Table (physical model Oracle), Structured type, Cube and Dimension (in multidimensional model); Custom reports are available in functionality for standard reports (File>Reports)
Search:
Advanced mode: Negation clause can be added to search expression; Search for empty value is supported
Versioning:
SVN 1.7 client is included
Bug fixes:
Import DDL script "comment on table" doesn't work in Data Modeler
Grants on materialized view not imported from data dictionary
Save DDL selection configuration gives wrong results for package bodies
Synchronize data dictionary can't detect existing FKs
Option to not generate new name for PK/UK with sys_xx name during import from DB
Problem when engineer identifying relationship on more than one column
Engineer to relational model fails with NPE if attribute datatype undefined
Set tablespace for auto-generated indexes from oracle index template
Name substitution for roles
SVN - modified table in repository do not appear in incoming changes
Constraints are not generated if existing attribute is used as discriminator
MS SQL Server - comment in rdbms are not extracted on sync operation
Logical data types - default for precision should accept * as value
Support Oracle DDL import of ALTER TABLE MODIFY Column statements
Automatic renaming on primary key columns
Adding relationship using Import/Data Modeler design adds extra entity attribute
Print diagram problem with multi-byte language

New in Oracle SQL Developer Data Modeler 3.1.0.687 EA 2 (Dec 13, 2011)

New in Oracle SQL Developer Data Modeler 3.0.0.665 (Dec 13, 2011)

Browser Navigator:
The browser navigator supports the ability to have multiple open designs. Existing physical models automatically appear in the browser.
Custom Design Rules:
Create user-defined Design Rules. Group collections of rules in Design Rule sets. Create user defined transformations Build user libraries using script languages (JavaScript, JRuby etc) For supported engines see https://scripting.dev.java.net/ Create user defined transformations and design rules using user created script libraries. Manage custom design rules and transformation scripts through version control.
Diagrams:
Settings are available at the diagram level Show labels (for relationships) Add diagram legend Straighten all lines
 Show grid: Resize objects to visible size. (This is useful if you change the View Details settings) The "Diagram color" option has been moved from the general preferences dialog to each diagram. To access this, select the right click menu  Background and foreground color can be set at the object view thus allowing an object to be represented with different colors on same diagram (using synonyms) or on other diagrams (display, subview) Drawing the line for foreign keys has changed when the Unique/PK constraint is defined over FK columns only. The "crows foot" at the child table end is replaced with single crossing line Partial support for Information Engineering notation. PK/UK constraint and index columns can be shown on diagram. Foreign key lines– additional symbols to represent delete rule and transferability. Change in drawing a Process the name is positioned at top of the shape, foot note (changed to “Short definition” ) is displayed at the middle of shape
Domains :
Added “Default value” property at domain level. The default value can be changed at column/attribute level. List of values defined at domain, column or attribute level is used to pick-up default value.
Domains can be used in definitions in Data types model. Forward Engineering There is a change in the way the engineering to the relational model works. The default status for new candidate key is "selected" now
Unique index is created for One-to-one relationships defined in the Logical model if there is no PK/UK constraint or unique index defined over foreign key columns. Glossary Create a glossary based on an existing design. Select Logical model > Create Glossary from Logical Model.
Support for plurals added to the glossary. These are used in the name transformation and validation for entities and tables Import
Importing CA Erwin Data Modeler files has been extended to include the import of Erwin 7.x files. Import from Erwin supports the import of Functions, Packages and Stored Procedures to the Physical Model. Data Dictionary Import supports the import of Functions and Packages. Importing for Designer: You can select the checked in branch. Incremental import of used domains in Designer Sorting available when importing from data Dictionary, (or when generating DDL). Click on column header to sort objects. Import from dictionary wizard – “Import to” settings are moved to step 2 of the wizard. Objects that exist in the selected relational model are selected for import automatically in list of tables and views.  Use "Data Type Kind", Use "Schema" and Case Sensitive Names preferences are duplicated in the Compare/Merge dialog under Compare Options. There is an additional option Use "Generate in DDL "flag to allow objects that are not marked for DDL generation to be excluded from the compare tree. The compare tree can be rebuilt after change of options.
Physical Model:
Support for the import and DDL generation of packages and functions. Changed "snapshot" support to "materialized view" support. Full support for Oracle 11g partitioning (table and materialized view).
Preferences:
The settings.xml file used to store preferences is no longer used. Preferences still can be imported from the existing settings.xml file
Relational Model Added support for auto increment and identity columns in the Relational model. This is supported with sequences and triggers in the Oracle physical model.
Support for dynamic properties – can be created and modified using UI and/or transformation scripts. Reporting. Reporting provided through either:
Reporting Repository. Users export designs to a reporting repository and use SQL Developer to run reports.
Local Reports: Run reports from the tool itself. Reports are word xml documents and can be opened in MS Word 2003 (or later). These reports include entities tables, domains and glossary. Reporting Repository Support extended to include data types and process models.
Note: If you export to the reporting schema in Data Modeler 3.0, either create a new schema or apply the upgrade script to the schema repository created by Data Modeler 2.0. (See Reporting Repository section in the release notes.) Subversion Integration
Integrated version control using Subversion for complete design. Allows you to compare and merge objects. Designs added to versioned folders are placed under version control. Users can see pending incoming and outgoing changes. Data Modeler recognizes versioned designs. Changes made to a versioned design and saved, are revealed in the pending changes dialog. Collaborative access and support is provided through tight integration with Subversion. Custom rules and transformation scripts are stored in a single file. This file can be managed under version control.
Wizards:
Table to View wizard creates views based on tables in a selected relational model. View to Table wizard creates tables based on view definitions a selected relational model. Foreign Key discovery helps find possible foreign keys in a relational model, based on selected criteria.