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

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
All

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
Productivity

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.
Rename

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

Settings Menu

Option Description
Options Displays the Options dialog, where most of the Toad Data Modeler settings are located.
Add/Remove Databases Opens a dialog where you can enable/disable installed databases.
Reset to Default Layout Resets the application layout to default, requires restart.
Default Values Allows you to set various default properties (e.g. Names, Captions, Values).
Templates Displays the Template Editor where you can add or edit your own templates. These can be used when editing SQL code of some objects.
Dictionaries Contains terms used in generated reports. Feel free to add your own new terms, export/import dictionaries or translate them to another language.
 
Related Documents