Chat now with support
Chat with Support

Toad Data Modeler 6.3 - 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

Create New Model from DDL/SQL Script

Features and Tools > Reverse Engineering > Create New Model from DDL/SQL Script

Toad Data Modeler allows you to create models from DDL/SQL scripts. This feature is not supported in all database platforms and versions.

Creating models from DDL/SQL Scripts is very similar to creating models from physically existing databases. You need to define "Connection" to your SQL file and then you can either reverse engineer the database structure or open Object Explorer and add objects to existing model using the Drag and Drop technique (Live Reverse Engineering).

To manage database connections

  • Click on the toolbar.

or

  • Select File | Reverse Engineering | Connections.

To create a new SQL file Connection

  1. In the Connections dialog, click New Connection and define a new Connection Name.

  2. Select your database from the DDL Script RE section. In our example, it will be Microsoft SQL Server 2012

  3. Since this is DDL/SQL script file, there is only one available data provider. Continue by clicking Next.

  4. Enter the path to your DDL script. A preview of the script will be shown. You also have to define the terminator. The default one is usually correct, unless you modified the terminator in the script. When you're done, click Next.

  5. Check the items you would like to reverse engineer when creating a new model from this script.

  6. The final dialog contains several settings that can be configured, if you need to do so. When you're done, click Finish.

  7. The connection to the DDL script is saved and you can now create a new model from the connection.

To create a new model from saved DDL script Connection

  1. In the Connections dialog, click the Create New Model from Database button.

  2. Now choose the objects you would like to reverse engineer from the DDL script. If you want to create the entire model from the script, check all items. Then, click Execute.


    Note: You may not see all object types, depending on your Connection settings. This can be changed by editing the Connection in Connections dialog and then checking appropriate objects in the What to Reverse dialog.

  3. The model will be created from the script.


 

Universal DB/ANSI Model

Features and Tools > Reverse Engineering > Universal DB/ANSI Model

Toad Data Modeler allows you to reverse engineer a database structure of unsupported database platforms. Tables, columns, primary keys, indexes, relationships, procedures and views are loaded (depends on the database). Then it is necessary to convert the reversed model to a model of any supported databases.

To reverse an ANSI model

Follow the steps defined in topic Connections and in step Select Data Source, select Universal DB.

Scripting and Customization

About Scripting and Customization

Features and Tools > Scripting and Customization > About Scripting and Customization

Toad Data Modeler and its behavior can be easily customized in several ways to better fit your needs and requirements. You can also leverage the power of scripting and automation to improve your workflow.

To start scripting/customizing, you need to enable Expert Mode first.

To enable Expert Mode

Go to Settings Menu | Options | General and check Expert Mode.

The scripting and customization capabilities include:

  • Scripts/Macros
  • Packages
  • Metamodel
  • Form customization

Note: Useful information about available classes, methods, functions and properties accessible in Toad Data Modeler can be found in the Reference Guide.

This document is available in the Expert Mode Menu| Reference Guide (with Expert Mode enabled).

Scripts/Macros

Code written in JScript, VBScript or Internal script may be used to access and modify various model objects or even perform model actions such as model renaming, merging, DDL script customization, etc.

Note: Macros are similar to scripts except they can be configured to appear in custom Macro menu or context menu of selected objects.

Scripts/Macros can be accessed via Expert Mode Menu | Customization | Script Explorer.
To create and immediately execute scripts, take advantage of Scripting Window located in Expert Mode Menu.

  

Packages

A package contains various means of customization such as scripts, macros, customized form definitions, data type conversion rules, etc. Packages affect models of various database platforms and versions depending on their Visibility and relations with other packages (Extension, Dependency).

Packages can be accessed via Expert Mode Menu | Customization | Package Explorer.

   

Metamodel

Graphical representation of objects (classes, properties, methods...) that belong to the selected package. In metamodels, you can create new classes, properties, methods, associations, generalizations... It is very similar to UML Class Diagram.

Form Customization

It is also possible to modify certain application forms (mostly Properties dialogs) and either change existing elements or add custom ones.

Other Notes

Toad Data Modeler Priority Rules

1. Scripts and definitions stored in My Package.txg file have the highest priority.

2. Scripts and definitions stored in other user defined packages (distributed as add-ons, add-on packages) have higher priority than scripts and definitions stored in system packages.

3. Scripts and definitions stored in system packages have the lowest priority.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating