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

Model Menu

User Interface > Menus > Model Menu

The options in the Model menu are model dependent. From here, key features such as Verify model, generate SQL script, generate report, synchronize model etc. can be accessed.

Option Description
Workspace | New Workspace Creates a new Workspace, prompting you to name it and select objects it should contain.
Workspace | Edit Workspace Allows you to edit active Workspace properties such as name and description. You can also select objects that will be shown or hidden in the Workspace.
Workspace | Delete Workspace Deletes Workspace selected from list of currently opened Workspaces.
Workspace | Workspace Format Contains mostly graphical settings that can be changed to your liking.
Verify Model Displays Model Verification dialog which allows you to quickly check for errors in your model and fix them.
Generate DDL Script Allows you to generate SQL code which can be run to create a database identical to your Toad Data Modeler model.
Generate Report | Report Wizard Opens Report Wizard, allowing you to generate customizable HTML, RTF or PDF reports
Generate Report | Reports / XSL Transformation Allows you to generate reports using customized XSL templates.
Order of Generated Objects The generation order of objects during DDL script generation can be changed here.
Compare and Generate Report Opens Model Compare Wizard, showing you the differences between two selected models. You can generate a report by clicking Report button in Compare Tree dialog.
Generate Change Script Opens Generate Change Script Wizard which compares two different models (or a model and a database) and generates a SQL script reflecting all the changes you made in the first model to your target.

Update Model From Database

Compares local model with target database and changes the model to match the database.
Merge Models | Run Opens Merge Model Wizard which is able to merge two selected models into one.
Merge Models | Simple Merge Merges two selected models, bypassing a lot of options in Merge Model Wizard.
Convert Model | Run Opens Convert Model Wizard which converts selected model to another database platform or version.
Convert Model | Simple Conversion Converts selected model to another database platform or version, bypassing a lot of options in the Convert Model Wizard.
Manage Model Actions Opens Model Actions tool which contains key model functions.
Model Items Allows you to see all objects in selected object group in and add, edit or delete.
To Do You can create your own tasks and assign them priority and deadline. These are only for organizing your work and they do not have impact on the model itself.
Categories This option allows you to create, edit and delete categories, which are used to graphically organize objects in your model. Each category has a certain color and objects which are part of a category will share its color (e.g. entity headers).
Export Dictionary Exports dictionary types, user data types and domains into .txl file.
Import Dictionary Imports dictionary types, user data types and domains from .txl file.
Statistic Displays information and various statistics about your model and workspaces.
Properties Opens the Model Properties dialog which contains information about the model itself, its description and statistics.

Tools Menu

User Interface > Menus > Tools Menu

Tools Menu is not shown in Logical Models since it only contains options applicable to Universal and Physical Models.

Option Description
Refactoring Utility

If you rename object in your model, the Refactoring Utility can be used for changing the old object name in SQL properties of other objects.

Example: Rename an attribute and use the Refactoring Utility to replace the old name with new name in SQL properties of database views, triggers, stored procedures etc.

Schema/Owner Assignment Allows you to assign multiple objects to a Schema/Owner/Database at once.
Naming Conventions Manage rules and naming standards for object groups. Also contains an option to verify current names.
Infer Relationships Creates relationships between identically named Primary or Alternate Key attributes, if they don't exist already.

Macros Menu

User Interface > Menus > Macros Menu

The Macros menu contains items that can be customized by users or new features developed by users.

Option Description

Displays sample macros that you can use for your currently active model.

The selected macro will be applied to all objects on all Workspaces of the model.

Sample macros:

  • Convert Names to Lower Case
  • Convert Names to Upper Case
  • Alphabetic AutolayoutAutolayout
Selected Objects

Displays sample macros that you can use for your currently active model.

The selected macro will be applied only to selected objects on the currently active Workspace.

Sample macros:

  • Remove Spaces from Names
  • Display Entities Note on Workspace

Displays macros which allow you to do multiple actions at once, enhancing your productivity.

  • Add Entities— This macro allows you to add multiple entities in your model at the time.
  • Add Attribute to Selected or All Entities— Fast and easy way to add new attributes to entities.

Displays macros which serve to rename multiple objects at once.

Expert Mode Menu

User Interface > Menus > Expert Mode Menu

The Expert Mode Menu appears only if you enabled Expert Mode in Settings| Options | General.

Option Description
Customization | New Custom Package Allows you to create a new custom Package.
Customization | Import Custom Package Imports Packages or Metamodels saved as .txg and .txm files.
Customization | Package Explorer Opens an instance of Package Explorer window.
Customization | Script Explorer Opens an instance of Script Explorer window.
Customization | Find in Scripts Allows you to quickly search through all system and user scripts.
Scripting Window Opens an instance of Scripting Window.
Reference Guide Opens the Reference Guide.
Version Manager | Internal Version Manager Allows you to use TDM integrated Version Manager.
Version Manager | Add to Version Manager Adds currently active model to TDM integrated Version Manager project.
Expert Mode Settings | Data Type Conversion Settings Here you can affect how Toad Data Modeler converts various data types during Model Conversion to another database platform or version.
Expert Mode Settings | Available OTPs

Advanced settings that can be set for:

  • Model Definition - specify model structure depending on database platform
  • Other Model Features - define structure of selection trees in certain dialogs
Generate XSD File Generates an XSD file which contains the structure definition of Toad Data Modeler XML model files(*.txp, *.txl).
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating