Oracle SQL Developer Data Modeler Changelog

What's new in Oracle SQL Developer Data Modeler 23.1.0.087 Build 0806

Apr 19, 2023

Bugs Fixed:
34423443 - ISSUE WITH IDENTITY AND AUTOINCREMENT WHEN USING DEFAULT VALUE
34565272 - AFTER "SAVE AS" OR "SAVE", "CLOSE" AND "OPEN" DATA MODELER LOSING SYNONYM INFORMATION

New in Oracle SQL Developer Data Modeler 22.2.0.165 Build 1149 (Jun 30, 2022)

New in Oracle SQL Developer Data Modeler 21.4.2.059 Build 0838 (Mar 9, 2022)

New in Oracle SQL Developer Data Modeler 21.4.0.345 Build 2220 (Dec 13, 2021)

New in Oracle SQL Developer Data Modeler 21.1.0.183 Build 1957 (Jul 14, 2021)

New in Oracle SQL Developer Data Modeler 21.1.0.092 Build 1221 (Apr 14, 2021)

New in Oracle SQL Developer Data Modeler 20.4.1.406 Build 0906 (Feb 24, 2021)

New in Oracle SQL Developer Data Modeler 18.4.0.339 Build 339.1532 (Jan 16, 2019)

New in Oracle SQL Developer Data Modeler 18.3.0.268 Build 268.1156 (Oct 11, 2018)

New in Oracle SQL Developer Data Modeler 18.2.0.179 Build 179.0756 (Jul 3, 2018)

New in Oracle SQL Developer Data Modeler 18.1.0.082 Build 082.1035 (Mar 29, 2018)

New in Oracle SQL Developer Data Modeler 4.2.0.932 Build 932 (Apr 13, 2017)

New in Oracle SQL Developer Data Modeler 4.2.0.917 Build 917 Early Adopter (Sep 18, 2016)

New in Oracle SQL Developer Data Modeler 4.1.5.907 Build 907 (Sep 18, 2016)

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

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

New in Oracle SQL Developer Data Modeler 4.1.2.895 Build 895 (Oct 25, 2015)

New in Oracle SQL Developer Data Modeler 4.1.1.888 Build 888 (Jul 22, 2015)

COMPARE/MERGE:
Extended support for objects in Oracle Physical Models
Tables:
Details of partitions, subpartitions and subpartition templates for Tables
Details of partitions for globally partitioned Indexes
Details of Triggers
Physical Model Properties for the Table and its Columns and Indexes, Primary Key, Unique Key, Foreign Key and Check constraints
Views:
Details of Primary Key, Unique Key and Foreign Key constraints
Details of Triggers
Physical Model Properties for the View
Structured Types:
Details of Structured Type Method Parameters
Physical Model Properties for the Structured Type and its Attributes, Methods and Method Parameters
Collection Types:
Physical Model Properties for the Collection Type
Other Oracle Physical Model objects now supported:
Contexts
Directories
Functions, Stored Procedures and Packages
Synonyms
Dimensions, Levels and Hierarchies
Users, Roles and their Permissions
Tablespaces, Temporary Tablespaces and Undo Tablespaces
Bitmap Join Indexes, Lob Storages of Tables and Materialized Views
DDL GENERATION FOR DB2/390, DB2/UDB AND MS SQL SERVER 2012:
Option to implement identity columns with sequence and trigger
Added support for auto increment columns implemented through sequence and trigger
EXPORT TO REPORTING REPOSITORY:
Support for additional properties on entity, table, relationship and foreign key
GENERAL:
Support for similar data types for PK-FK column pairs
Support for user defined properties (UDP) - in UI and on diagrams
Import of UDP from designer repository and ERwin 7.3 model
UDP can be included in custom reports
Predefined report for UDP in current design
Support for images on diagram
New "files" directory in design structure where customers can put their artifacts
User defined DDL generation using transformation scripts
Support for "preferred" classification types
LOGICAL MODEL:
Creating entity hierarchies on diagram using drag&drop of entitties together with pressed Ctrl key (or Ctrl+Alt keys pressed together)
Support for linked entities from another design
Support for design level domains used in linked objects
NEW TRANSFORMATION SCRIPTS:
Transformation script to remove columns created with table template script and also to remove related attributes from logical model
Design rules - new custom rule of type Warning for optional composite foreign keys with mandatory columns
User defined DDL generation - "After Create table " script to generate journal table and related support trigger - described in SQLDeveloperDataModelerScripting.docx document located in datamodeler\datamodeler\xmlmetadata\doc directory
PERSISTENCE:
Option to store each model in single file
PHYSICAL MODEL:
Support for MS SQL Server 2012 including import and DDL generation
DB2 390/8 - support for index controlled partitioning
DB2 390/8 - import from database dictionary also supports "DB2 11 for z/OS"
RELATIONAL MODEL:
Auto layout functionality works on selected tables or on the whole diagram if there are no selected objects
Support for Primary, Unique and Foreign key constraints on views
Table to view wizard can transfer to created view PK, UK and FK constraints defined on the base table
Composite optional Foreign Key can have mandatory columns
Table can be defined as Materialized view in relational model - support SQL Queries and Query Builder on Relational Table object; also supported in import from Oracle, DB2/zOS and DB2/LUW dictionary and DDL scripts
Oracle REST Data services - related properties can be defined for schema, table and view and included into generated DDL
Arc constraints can be detected during import from database or DDL script;
SEARCH:
Search profiles can be defined and used in global and simple search
Improved UI
User defined properties can be used in search and set common properties functionality
VERSIONING:
Improved performance and stability
Support for customer's artifacts in new "files" directory
Support in the browser of "Use Navigator State Overlay Icons" and "Use Navigator State Overlay Labels" options
Improved tree presentation of objects appearing in Outgoing and Incoming changes - also support for folders with tree conflict and modified properties
Option to clear(resolve) tree conflict on filder in outgoing changes window, resolving conflicts on objects(files) after "update from repository"/"merge from branch" operations
Improved processing of "Update" conflicts - preventing conflicted files to go into non parse able state, resolving of conflicts through "Team>Resolve Conflict" functionality
Design Estimates - creates design structure able to accommodate the number of objects set in the wizard
BUGS FIXED:
20973958 - System-generated columns incorrectly imported as Valid Time Dimensions
20988192 - No DROP CONSTRAINT generated for a dropped Foreign Key
21106404 - SQL DEVELOPER DATA MODELER 4.1 ON MACOSX DOES NOT START
21118219 - Note format does not work on Data Modeler 4.1.0.881
21080065 - Hidden foreign keys reappear after adding a table to a subview
21053323 - NOT NULL constraint name template cannot be applied
21031155 - Name of arc in logical model is ignored when engineering to relational model
16266742 - Ignore partition number when export DB2/UDB 9 DB Partitions IBMCATGROUP
21067179 - Delete relation results in empty index
21147923 - Enabling the check constraint to be generated along with PK, FK, and other constraints
21118743 - Changes in the model do not appear in outgoing changes
21185200 - More tolerant column data type correspondence for FK on view
21031388 - User's own preferences for user defined table DDL transformations
19567646 - Ability to define custom legend in diagrams
21031034 - Need a check box to set usage of preference class types in design settings
21096199 - Add table schema to auto increment sequence/trigger name in DDL if necessary
18824312 - Support reference to Disk Group from Tablespace
21111024 - Self references do not appear when hide/show lines functionality is used
21066943 Cannot change script engine in custom libraries functionality
21176371 Data Modeler addin cannot start in SQLDEV due to problem related to UDP
18364709 Support for singular form of table name in FK column template

New in Oracle SQL Developer Data Modeler 4.1.0.873 Build 873 EA2 (Apr 6, 2015)

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

Fixed bugs:
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 Build 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 4.0.0.820 Build 820 EA 2 (Oct 3, 2013)

Database Performance Monitoring:
SQL Developer now provides a full interface for Oracle Database Enterprise Edition’s Diagnostic pack, including Automatic Database Diagnostic Monitor (ADDM), and Active Session History (ASH). Accessible from the DBA panel, users can also manage their snapshots, baselines, and baseline templates.
Find Database Object - Search:
The database search is completely redesigned. The new tree layout allows for searches on multiple schema, object type, identifier types and usages. A history of your searches will be stored for later access. Search results can be viewed in a separate Editor where multiple search results can be pinned and displayed.
Command Line:
Command Line support has been extended to Reporting and to the Cart. You can run Reports and generate them into HTML format through the command line. The Cart commands offer the ability to export objects and data. A set of predefined DDL generation options and data formats can be applied.
Cart:
The Cart has been greatly enhanced. You can create and work on multiple carts. The deployment of objects has been extended to give you more flexibility in selecting export DDL options and data formats. Export Object configurations can be saved and applied again. Compare Cart objects to another Cart or Connection with the Database Diff. Cart objects can also be copied with the Database Copy feature. Scripts are extended to include Before and After Data Load.
Reports:
Creating reports has never been easier. The create new report dialog has a tree layout for ease of navigation. An Advanced Option is available to instantly create Child and Drill Down type reports. Chart based reports include more chart types and you can test reports from anywhere within the report editor. Charts can be previewed in design mode. An HTML Report can be generated for any report. Enhancements in Database Doc generation include better layout and support for multiple threads to improve performance.
UI Enhancements:
The new UI changes in 4.0 enhances the overall look and feel of SQL Developer. A popular request on the Feature Exchange, a window border color can be dynamically set for a database connection. Useability improvements can be seen with with the new floating Editor and Navigation windows
Data Modeler 4.0:
This version includes the new Data Modeler release 4.0. New features include 12c support for IDENTITY columns and masking of sensitive data with Redaction policy definitions at table and column level, create Transparent Sensitive Data Protection (TSDP) policies and associate it with sensitive types.
JDK 7 Support:
This release supports JDK 7 and above.

New in Oracle SQL Developer Data Modeler 3.3.0.747 Build 747 (Oct 3, 2013)

NEW FEATURES:
Search:
The search capabilities in SQL Developer Data Modeler have been greatly enhanced. Regular expressions can be used to search any information entered into designs and models. Simple and advanced search options are provided for Relational models and down to the physical properties. Search results can be filtered by object type and common properties can be set for objects. Reports can be generated from the search results.
Export and Import to Excel:
Data Architects can now fully leverage SQL Developer Data Modeler's Excel functionality. Information in models can be exported to an Excel file, both XLS and XLSX are supported. Business owners can now make updates to columns, tables or entities in the Excel file and those changes can be imported back into the Data Modeler to update an existing model.
DDL Generation:
You now have more control and flexibility in generating your DDL. Detailed options to generate default values – schema, tablespace, logging, storage as global option, and options for each storage element.
Table and column level check constraints can be excluded from generated DDL. Save current DDL generation settings including selected objects and check constraints, name substitution and other DDL related settings into configuration file. Preserve DDL generation settings when DDL File editor is started and restore them back when it’s closed.
Reports:
Integrated with the new Search functionality, reports can be generated from the search results. Templates can be defined to include column names, sort order and replacement for boolean values. Diagrams where entities and tables are used are included into the report. Reports can be generated for a set of subviews and objects. Report configurations can be saved and used later to generate a report for the same set of objects. The following report formats are supported – HTML, PDF, RTF, XLS and XLSX.
Compare / Merge:
Filtering of properties – can be set which properties per object type should be considered in compare/merge functionality.
Storage properties (defined in storage template) can be compared and alter statement generated.
Filtering on storage properties can be set. DDL configuration can be loaded providing settings for "Generate In DDL" filter.
Tabular view (in addition to tree presentation) for better tracking of changes, filtering by object type and status, regular expressions can be used in filtering. Report for modified, new and deleted objects can be generated. Similar functionality is used also in engineering between logical and relational models.
Diagrams:
Possibility to show/hide foreign keys and relationships in subviews.
Lines for self referencing foreign keys and relationships can be arranged.
Support for hiding Table and Entity elements.
Grid size can be changed in preferences.
Import and export:
Import from Designer Repository - Imported objects have the same ID as in Designer repository.
Export to Data Modeler Design - export configuration can be defined and used allowing easy slicing of the design.
Open Design - select relational models dialog is changed, default physical model can be set to be open, settings are used als in next “open design” operation.
BUG FIXES:
Different Tablespace for Indexes not recognized in Compare Models dialog
Column Sort Order in Indexes on Views not generated in SQL Server 2000 DDL
Synchronize fails when original import connection no longer available
Import from Designer generates wrong 'generate for DDL' for table level constraint
View with with-clause gives parsing error in Query Builder
Declarative view definition malformed after importing from Designer
Object types losing domain definitions, cannot assign new type/domain
Foreign key constraint generates invalid SQL- no action for delete rule
Migration data dictionary from Oracle database missing grants on functions, packages
Compare/merge with database always reports difference on integer data type
Import from MS SQL- wrong size for nchar and nvarchar, max as size not correct
Dependency order of generated DDL - view generated before function is used
Definition of first for min analytical function is not parsed by query builder
Logical many to many relation with delete rule:"no action" creates "cascade" FK
DDL for before create table script has unwanted ";" added following / (execute)
Types to domains wizard wrongly sets precision and scale
Dependent views not generated in correct order for DDL
"Open" status for diagrams is not restored
Enable trigger statement missing semicolon
Discover foreign keys not applying FK naming template properly
Compare/merge from database fail on list of values with single quotes 'y' y
Template for PK not used on object tables
Product lacks semantic analysis to support mviews on prebuilts
Commit of deleted physical model not working properly
Import of design - not possible to import subviews without importing objects
Materialized view body text - no horizontal scrolling
Relationship's labels displayed incorrectly after open design
Commit of deleted physical model not working properly

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.