Release Notes

Toad® Data Modeler 6.5.6

Release Notes

Friday, April 5, 2019

These release notes provide information about the Toad® Data Modeler release.

About Toad Data Modeler

Toad Data Modeler helps organizations create, maintain and document their database systems with an easy-to-use graphical interface into new or existing database structures. Toad Data Modeler enables users to reverse engineer database structures, update models, design and generate SQL, compare models and generate alter scripts, create HTML or RTF reports, in addition to versioning of database designs and creation of to-do lists.

Toad Data Modeler 6.5.6 is a patch release. It is a replacement of the previous 6.5 release that contains extra resolved issues and a fixed vulnerability of a third party component. See New in Toad Data Modeler 6.5.6 and Resolved issues for more information.

Toad Data Modeler is released in 32-bit and 64-bit versions. The 64-bit version of the application has a significantly higher memory limit which should resolve several common issues incl. out of memory errors, which occurred when working with complex models.

However, in order to reverse engineer databases that require a client you need a corresponding version of the client, i.e. 32-bit or 64-bit.

New Features

New in Toad Data Modeler 6.5.6

Database features

Support for Oracle 18c

• Oracle 18c is now fully supported
• Database settings are placed in Settings | Options | Model | Physical Model | Oracle | Oracle 18c
• Reverse Engineering, Change Script and DDL Script Generation are supported

Oracle 12c Support

New option NOKEEP is supported

• Check NOKEEP in Attribute Properties | Identity
• Check NOKEEP in Sequence Properties

New access drivers for Oracle 12c R2

• In Entity Properties | External Table Properties you can now use ORACLE_HDFS, and ORACLE_HIVE in addition to existing ORACLE_LOADER, and ORACLE_DATAPUMP

New option Segment Creation for Oracle 12c R2

• In Entity Properties | Physical Properties | Segment Creation you can now select Deferred, Immediate or Not Specified

PostgreSQL Support

• Support for Import DDL has been added for Postgres 9.5 and 10
• You now can perform Reverse Engineering from a connection and from a DDL file

EDB Advanced Postgres Server Support

• Support for stored procedures has been implemented
• Support for directories has been implemented
• Support for Nested table type and Varray type for User Data Type has been added

SQL Server 2017 Support

• Support for Graph Tables has been added for Import DDL functionality

Enhancements

External Objects

• Right-click the root of a model and select External Objects | Update All to easily update all external objects

Ordering of Indexes

• Indexes can now be ordered using buttons in Entity Properties or using Ctrl + Up or Ctrl + Down

Selecting Parent and Child Tables in Reverse Engineering

• Select parent and child tables easily using three new buttons in Reverse Engineering Wizard | Tables
• Use right-click menu to select parent or child tables up to 3 level of depth or to infinity

Text Wrapping in Text and Label Rectangle objects

• Double-click Text or Label Rectangle object and check Word Wrap to wrap the text inside

Default names for primary keys

• Set a default name in Settings | Options | Model | Physical Model | Primary Key Default name

Search bar for main menu

• Find any menu option easily by writing its first letters into Jump To

Resolved Issues

The following is a list of issues addressed in this release.

Known Issues

The following is a list of issues, including those attributed to third-party products, known to exist at the time of release.