Chat now with support
Chat with Support

Toad Data Modeler 7.0 - 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 MySQL 8.0 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

Import Toad ERD

NOTE: For more info on Toad for Oracle integration see Toad for Oracle® Connections and other related help topics.

To create a model by importing a diagram created in Toad for Oracle

  1. Click File | Reverse Engineering | Connections, click Import Toad ERD and select a file to import. You can use a selected connection or the connection saved in the imported file. Click “No” to use your own saved connection. If you click “Yes” an alias for a connection will be temporarily saved. The alias is removed after having refreshed Connections or restarting Toad Data Modeler.

  2. A new model is created from the imported Toad for Oracle file.

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). 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 Connections and select Universal DB in Select Data Source step.

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

Check Expert Mode in Settings | Options | General

Expert Mode menu and Options section Expert Mode will appear.

Right-click a model name in Model Explorer or Application View and select Test Model to run an internal test of model consistency.

Right-click a model name in Model Explorer or Application View and select Repair Model to repair broken models.

The scripting and customization capabilities include:

  • Scripts and 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 | 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

Metamodel is a graphical representation of objects (classes, properties, methods, etc.) that belong to a selected package. In metamodels, you can create new classes, properties, methods, associations, generalizations, and others in a way 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 Order of Priority

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.

Scripting Window

Scripting Window allows you to run simple scripts only. In Scripting Window, you cannot save scripts as they do not relate to any package.

To open Scripting Window

  1. Enable Expert mode: select Settings | Options | General | select the Expert Mode checkbox.
  2. Select Expert Mode | Scripting Window.

In the Application Window, see the new tab Scripting with the Scripting Window open.

Scripting Window toolbar

Option Description
Show Windows Automatically Displays a corresponding side tab. When you are writing a script, Code Explorer is displayed. When a script is being executed, Log is displayed.
Show Log Displays a log window that shows log messages and errors related to Scripting Window.
Show Code Explorer Displays a side tab that lists code segments.
Execute Script Executes a script in Scripting Window.
Stop Script Stops a running script.
Type

Switch between:

  • JScript
  • VBScript
  • Internal Script
Load Script from File Load a script from a file.
Save Script Saves a script.
Save Script as Saves a script under a new name.

To display the Available Objects and the Selected Objects windows in Scripting Window

Select View | Show Registered Objects.

Related Documents