Chat now with support
Chat with Support

Toad Data Modeler 7.2 - 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 Microsoft SQL Server 2019 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 Oracle 19c PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 PostgreSQL 10 PostgreSQL 11 PostgreSQL 12 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

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

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

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

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