Chat now with support
Chat with Support

Toad Data Modeler 6.5 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Create New Project Reports Reverse Engineering Scripting and Customization About Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Amazon Redshift 1.0 IBM DB2 LUW 9.5 IBM DB2 LUW 9.7 IBM DB2 LUW 10.1 IBM DB2 LUW 10.5 IBM DB2 LUW 11.1 IBM DB2 z/OS 10 IBM DB2 z/OS 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 EDB Postgres Advanced Server 10 Microsoft Access 2007/2010 Microsoft Azure SQL Database V12 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 Microsoft SQL Server 2017 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 Oracle 18c Specifics - Oracle 12c Release 2 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 PostgreSQL 10 SQLite 3.7 Sybase ASE 15.5 Sybase ASE 15.7 SAP ASE 16.0 Sybase IQ 15.2 Sybase SQL Anywhere 11 SAP SQL Anywhere 17 Teradata 13 Vertica Database 8.0
Copyright Legal Notices


Toad Data Modeler helps organizations create, maintain and document their database systems with an easy-to-use graphical interface.

With Toad Data Modeler you can:

  • Create database structures visually (Logical, Universal and Physical Entity Relationship Diagrams - ERD)
  • Create ERD for various target database systems (Oracle Database, SQL Server, DB2, MySQL, PostgreSQL and more, see Supported database platforms)
  • Reverse engineer already existing database structures and see them in a form of a diagram
  • Add logical data to your diagrams and describe existing database structures better
  • Verify model, get a list of Errors, Warnings and Hints and use Quick Fixes to correct issues
  • Automatically generate SQL code for selected target database
  • Generate detailed documentation in HTML, RTF or PDF format
  • Export database structures to Microsoft Excel and edit comments, notes and other model item properties
  • Synchronize models with already existing databases (using Change Script Generation and Update Model features) and much more


Toad Data Modeler allows you to:

  • Reduce errors in development
  • Significantly improve your productivity
  • Visualize your database structures and get better understanding of your existing databases
  • Verify your work automatically
  • Generate very detailed HTML, RTF or PDF reports
  • Work with existing database structures
  • Keep existing database structures up-to-date

Key Features

  • Physical Model, Universal Model (Generic Relational Model) and Logical Model
  • Support for Various Databases
  • Reverse Engineering
  • Version Control System (support for Apache Subversion and Git) and Internal Version Manager
  • Projects for storing models and additional documentation
  • SQL/DDL Script Generation
  • HTML/RTF Reports (including Alter reports)
  • Model Merge, Model Compare
  • Model Verification
  • Autolayout
  • Refactoring Utility
  • Automation
  • Customization and Scripting
  • Templates, Gallery, Default Values, Application Variables, Macros
  • Undo/Redo
  • To-Do List
  • Zoom, Loupe, Model Overview features and many more...

Toad Data Modeler delivers increased level of efficiency, quality and comfort to all database professionals.

System Requirements

  Minimal Requirements Optimal
Memory 1 GB 4 GB
Hard Disk Space 400 MB 1 GB
Operating System

Microsoft Windows 10 (64-bit)
Microsoft Windows 8.1 PRO (64-bit)
Microsoft Windows 8 PRO (64-bit)
Microsoft Windows Server 2016 (64-bit)
Microsoft Windows Server 2012 (64-bit)
Microsoft Windows Server 2008 R2 (64-bit)
Microsoft Windows 7 (32-bit or 64-bit) *

*For Toad Data Modeler 64-bit version, only 64-bit version of the operating system can be used.

Other Requirements .NET 4.0 or later  

New in this Release

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


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

Product Improvement Program

To prioritize enhancements in future releases, Toad Data Modeler collects data about the use of its different features, and periodically, this data is communicated back to us. Initially, this usage data includes an IP address. Upon its receipt at a temporary server in the U.S.A., the IP address is removed, and then the anonymous data is aggregated before it is sent to our servers in California. Our product team analyses the aggregated data to understand our user community’s preferences and common practices. This analysis influences our future releases.

No personal information is collected and you can stop participating at any time.

Freeware users are required to participate in the product improvement program and cannot reject to participate. When you insert you license key the freeware version becomes full and you might modify product improvement program settings.

To view or change your participation in the product improvement program:

  1. Go to Help Menu | Product Improvement Program
  2. Select Yes, I want to participate or No, thank you

You can review the privacy policy at

Toad World Community

Watch instructional flash movies that will guide you through great features of Toad Data Modeler, learn about tips and tricks, read how-to's, tutorials, download sample scripts and user packages, dictionary files and templates for reports, join our discussion forum and much more at:

Submit Your Ideas and Suggestions

If you are already the community member, feel free to post any ideas and suggestions for new features and improvements for Toad Data Modeler.

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating