Chat now with support
Chat with Support

Toad Data Modeler 6.2 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
About Physical Data Modeling Benefits of Physical Data Model Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects Model Properties Model Statistics
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Projects Reports Reverse Engineering Scripting and Customization SQL Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Supported Databases Connection Types by Database DB2 UDB v. 8 (LUW) DB2 v. 9 (LUW) DB2 v. 9.5 (LUW) DB2 v. 9.7 (LUW) DB2 v. 10.1 (LUW) DB2 v. 10.5 (LUW) DB2 z/OS v. 9 DB2 z/OS v.10 DB2 z/OS v. 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 Microsoft Access 2000/2002/2003 Microsoft Access 2007/2010 Microsoft Azure SQL Database Microsoft Azure SQL Database V12 Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 Oracle 9i Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 PostgreSQL 8.1 PostgreSQL 8.2 PostgreSQL 8.3 PostgreSQL 8.4 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 SQLite 3.7 Sybase ASE 12.5 Sybase ASE 15 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
Legal Information

Introduction

About Toad Data Modeler

Introduction > About Toad Data Modeler

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 Databases).
  • 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.

Benefits

Toad Data Modeler allows you to:

  • Reduce faults 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 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
  • 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 2012 (64-bit)
Microsoft Windows Server 2008 R2 (64-bit)
Microsoft Windows Server 2008 (32-bit or 64-bit)*
Microsoft Windows 7 (32-bit or 64-bit) *
Microsoft Windows Vista (32-bit or 64-bit) *

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

About Us

Introduction > About Us

We are more than just a name

We are on a quest to make your information technology work harder for you. That is why we build community-driven software solutions that help you spend less time on IT administration and more time on business innovation. We help you modernize your data center, get you to the cloud quicker and provide the expertise, security and accessibility you need to grow your data-driven business. Combined with Quest’s invitation to the global community to be a part of its innovation, and our firm commitment to ensuring customer satisfaction, we continue to deliver solutions that have a real impact on our customers today and leave a legacy we are proud of. We are challenging the status quo by transforming into a new software company. And as your partner, we work tirelessly to make sure your information technology is designed for you and by you. This is our mission, and we are in this together. Welcome to a new Quest. You are invited to Join the Innovation.

Our brand, our vision. Together.

Our logo reflects our story: innovation, community and support. An important part of this story begins with the letter Q. It is a perfect circle, representing our commitment to technological precision and strength. The space in the Q itself symbolizes our need to add the missing piece — you — to the community, to the new Quest.

Technical Support Resources

For sales or other inquiries, visit www.quest.com/company/contact-us.aspx or call +1 949 754-8000.

Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com.

The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:

  • Submit and manage a Service Request
  • View Knowledge Base articles
  • Sign up for product notifications
  • Download software and technical documentation
  • View how-to-videos
  • Engage in community discussions
  • Chat with support engineers online
  • View services to assist you with your product

New in this Release

Introduction > New in this Release

General features

Support for Git

  • Configure Toad Data Modeler to work with Git in Options | Application | Version Control System
  • Set paths to your Git client and working directory for your repository
  • Clone a remote repository easily after setting path to the remote repository, user name and password
  • The values set here will be your default values for setting up new repositories in Toad Data Modeler
  • The Git commands are displayed in Application View toolbar when you work with a model that is tracked
Button Description
Version Control System Settings Opens Options page where you can set the Version Control System preferences
Refresh Refreshes file status in Toad Data Modeler
Add to Index Adds the file to the list of tracked files
Remove from Index Remove the file from the list of tracked files
Commit Commits the changes
Push Pushes the committed changes into the remote repository
Pull Pulls the current state from the remote repository
Fetch Fetches information about the current state of the remote repository
Information Displays information about the commit and its author
History Browser Allows you to browse different versions of the file, merge and compare them and create change script

External Objects

  • External objects are objects dynamically linked from another model
  • Right-click a model in Model Explorer or Application View and select External Sources to import external objects
  • Select the source model to import from and check objects you want to use in your destination model
  • Select Window | External Dependencies Explorer to manage imported and exported objects
  • Click Update to update the imported objects if they had been modified in the source model

Syntax Validity

  • SQL Preview tab now highlights errors in SQL script syntax
  • Select Model | Verify Model in the main Toad Data Modeler toolbar and then the Verification Settings
  • Check Syntax Validity to perform syntax checks in SQL Preview for the following objects:
    • Procedure, Function, View, Materialized View
    • User Data Type, Package (Oracle only)
  • Options are available in Options | Model | Physical Model | Verification | SQL Syntax Options
  • Syntax validity check may be disabled in Settings | Options | Model | Physical Model | <database> | Syntax Validity checkbox

Database features

Support for Oracle 12c Release 2

  • The latest Oracle 12c Release 2 is now supported as a physical model, during report generation and DDL script generation

Support for SAP SQL Anywhere 17

  • The latest SAP SQL Anywhere 17 is now supported as a physical model, during report generation and DDL script generation

Support for MySQL 5.7

  • Change Script Generation now supports the following MySQL 5.7 changes:
    • Support for generated columns for ALTER TABLE
    • Support for multiple TRIGGERS

Support for SQL Server 2016

  • Support for Stretch Database (REMOTE_DATA_ARCHIVE) in SQL Server 2016
  • To create a Table for remote data archive see Entity Properties | Stretch Database Properties

NOTE: REMOTE_DATA_ARCHIVE is not supported for Memory Optimized Tables.

  • Enhanced support for history tables:
    • Set System Versioning in Entity Properties | Temporal Table Properties tab

Support for PostgreSQL 9.5

  • Change Script Generation now supports the following PostgreSQL 9.5 changes:
DDL New Syntax
CREATE SEQUENCE IF NOT EXISTS
CREATE MATERIALIZED VIEW

IF NOT EXISTS

Support for SET and RESET of storage parameters log_autovacuum_min_duration, toast.log_autovacuum_min_duration (integer)

CREATE TABLE

Support for SET and RESET of storage parameters log_autovacuum_min_duration, toast.log_autovacuum_min_duration (integer)

CREATE INDEX

IF NOT EXISTS

BRIN method

Support for SET and RESET of pages_per_range parameter in WITH section

Support for SET and RESET of new GIN method parameter gin_pending_list_limit in WITH section

CREATE FOREIGN TABLE INHERITS

Support for Vertica Database

  • You now can work with models of Vertica Database 8.0

Support for Microsoft Azure SQL Database

  • Azure SQL Database V12 is now supported
  • Performance of Script Generation and Alter Script Generation is now much quicker
  Duration in Toad Data Modeler 6.2 Duration in Toad Data Modeler 6.1 Improvement
Small model* 1 second 31 seconds 31 times
Large model* 3 seconds 43 seconds 14 times

*Small/large model: 135/540 entities, 544/2176 attributes, 26/104 relationships, 55/220 views

Enhancements

Naming Convention Enhancements

  • You now can turn case sensitivity off (by default it is on) for Word Replacement
  • To set Case Sensitivity check or uncheck Tools | Naming Convention | Settings | Glossary | Word Replacement
  • You can now select delimiters for Naming Convention

Exporting Views to Excel

  • Support for exporting Views to Excel has been implemented
  • The following table illustrates the modified properties:
Modification Property type

Properties

Unlocked String

Alias

Where

Having

SQL

Comment

Note

BeforeS

AfterS

Boolean GenerateSQLOnly

SelectViewsInText

Locked List

Attributes

From

Order

Group

  • Aliases of entities and attributes are in columns “From” or “Attributes” in a format: “Object AS alias” in an exported file

Model Actions Enhancements

  • You now can sort Model Actions alphabetically or by default (Nature Order)
  • You now can Filter in Model Actions to quickly find what you are looking for

Model Conversion Enhancements

  • You now can enable disabled databases directly from Model Conversion Wizard

Splitting Files in DDL Generator

  • It is now possible to output to several files in Toad Data Modeler DDL Generator
  • To enable check Split Output File in Model | DDL Script Generation | Run or Edit Default Setings

Mapping Attributes and Entities

  • Now you can easily map entities and their attributes in Change Script Generation and Merge Model wizards
  • Click the () button and set the object in the target model you want to map the source object into

Deprecated Features

  • Support of Microsoft Azure SQL Database V2 has been deprecated
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