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

Rules

To add a rule

Select Model | Model Items |Rules  and click Add in the Rules dialog.

To edit a rule

Select Model |Model Items | Rules and double-click the selected rule or click Edit.

Note: You can also edit/rename/delete rules in Model Explorer | Rules folder | Right-click the selected rule.

 

To select a rule for attributes

  1. Open the Attribute Properties dialog of the selected attribute | Rules tab.
  2. Select a rule and click the Add arrow button.

Note: You can define rules for domains too.

Working with Model Objects

There are three types of models in Toad Data Modeler:

Model Properties

Select Model | Properties.

Tab Description
General General information on the model (project, model, author, company, version etc.)
Before Script

Whatever you write on the Before Script tab, it will be generated before the generated SQL code.

After Script Whatever you write on the After Script tab, it will be generated after the generated SQL code.
Description Notes on the model
Naming Convention Here you can select a naming convention for the model.
Database Parameters

The value in the Length Semantics box shows which default length semantics (BYTE or CHAR) was set in the database for reverse engineering of Oracle database.

Note: This tab is available only in Oracle models.

Naming Convention

Here you can link or unlink a naming convention to/from your model.

Manage Naming Conventions - Opens the Naming Convention dialog (available also from the Tools menu)

Edit Naming Convention - Opens the Naming Convention Properties dialog.

Model Statistics

To display details on your model, its Workspaces, objects etc.

Select Model | Statistic....

To change some of the General Information (e.g. model name, author or company)

Select Model | Properties....

TIP: You can also change it via the shortcut of Stamp on the Workspace - just double-click the Stamp.

Add Objects

Toad Data Modeler allows you to add objects from multiple places. See the following options:

To add an object on Workspace

  1. Click the object icon on the toolbar, e.g. for entity
  2. Click anywhere on the workspace to add the object.

or

  1. In Objects Menu | Add New select the object you want to add to Workspace
  2. Click anywhere on the workspace to add the object

TIP: You can also use hot keys to add some objects, e.g. CTRL+E for entity, CTRL+I for inheritance. See Hot Keys for more information.

To add multiple objects to Workspace

  1. Press SHIFT and click the object icon on toolbar.
  2. Click on workspace as many times as many objects you need to add.
  3. Right-click the work area (or click the object icon again) to turn this function off.

To add objects to Model Explorer

  1. Find the object group in Model Explorer (e.g. Entities) | right-click and select Add (e.g. Add Entity).  

To add objects from Model menu

  1. Select Model | Model Items | and the object type (e.g. Entities).
  2. In following dialog click the Add button.  

Edit Objects

Toad Data Modeler allows you to edit objects from multiple places. See the following options.

To edit objects on the Workspace

Double-click or Enter the selected object.

To edit objects from Model Explorer

Find the object in tree and double-click it (or right-click | Edit).

Note: Double-clicking in Model Explorer does not highlight the object on the Workspace (WS) but opens the Object Properties dialog instead. To highlight a object on WS, right-click and select Find on Workspace.

To edit objects from Objects menu

  1. Select an object on Workspace or in Model Explorer.
  2. Select Objects Menu | Edit

To edit objects from Model menu

  1. Select Model Menu | Model Items | the object type (e.g. Entities).
  2. In the dialog (Entities), select the object and click Edit.

Buttons in Object Properties dialogs:

- opens the Application Variables form

OK - confirms changes, closes the form/dialog

Cancel - cancels changes

Apply- confirms changes, doesn't close the form/dialog

Help - Help navigation

Note: Objects of your model that have the Generate checkbox disabled in their Properties dialogs are displayed in Model Explorer this way:

Related Documents