Toad Data Modeler offers these basic ways how to work in it and control all its features and functions:
Introduction
New in this Release
Product Improvement Program
Toad World Community
Supported Databases
Connection Types by Database
Toad Data Modeler Freeware
About Us
User Interface
Interface Layout
Models and Model Objects
Application View
Application Window
Designer and Workspace
Docking
Hot Keys
Inplace Editor
Message Explorer
Model Explorer
Object Navigator Box
Object Types and Properties
Object Viewer
Status of Items in Grids
Menus
File Menu
Edit Menu
View Menu
Objects Menu
Layout Menu
Model Menu
Tools Menu
Macros Menu
Expert Mode Menu
Settings Menu
Window Menu
Help Menu
Search Bar
Toolbars
Main Toolbar
Window Toolbar
Views Toolbar
Model Toolbar
Display Toolbar
Users Toolbar
Naming Conventions Toolbar
Grid Toolbar
Undo/Redo Toolbar
Model Objects Toolbar
Graphics Objects Toolbar
Zoom Toolbar
Colors and Alignment Toolbar
Layout Toolbar
Expert Mode Toolbar
Scripting_Window
Alignment Toolbar
Help Search
Intelligence Central Toolbar
Style
Physical Data Model
Features and Tools
Entity Relationship Diagram Objects
Universal Data Model
Logical Data Model
Entities
Attributes
Basic Database Design
Create Attributes
Edit Attributes
Display Attributes in Model
Order Attributes
Copy Attributes
Move Attributes
Delete Attributes
Parent Attributes
Keys
Display Keys in Model
Create Keys
Edit Keys
Delete Keys
Select Parent Key for Relationship
Unique Attributes
Foreign Keys in Toad Data Modeler
FK Mapping
Indexes
Check Constraints
Triggers
Permissions
Data Types and Dictionary
Relationships
Notation and Cardinality
Relationship Types
Create Relationships
Edit Relationships
Referential Integrity
Edit Relationship Lines
Format Relationship Lines
Relationship Right-Click Options
Views
Materialized Views
Procedures
Functions
Defaults
Check Constraint Rules
Schemas
Synonyms
Users
User Groups
Select Target Database
Create Entities
Create Attributes
Create Primary Key
Create Relationship
Notation and Cardinality
Mandatory/Optional Parent/Child
Set up Referential Integrity Rules
Connect Parent and Child Entities
Understanding Foreign Keys
Parent Attributes
Advanced Database Design
Objects in Logical Model
Entities
Attributes
Unique Identifiers
Relationships
Inheritance
Conversion to Physical Model
Working with Model Objects
Convert Logical Model to Physical Model
Data Type Conversion
M:N Relationships
Migration of Keys
Inheritance
Defaults
Rules
Application Variables
Export/Import
DDL Script Generation
Graphics
Options and Configuration
Databases
Autolayout
Arrange Objects in Layers
Arrange Relationship Lines
Categories
Change Notation
Data Warehouse Types
Display Modes
Display Level for Entities
Format Workspaces and Objects
Line Autolayout
Set Colors for Attributes and Keys
Grid and Grid Size
Zoom, Loupe, Overview
Model Actions
Model Actions
Generate Change Script
Merge Models
Model Conversion
Print
Create New Project
Reports
Reverse Engineering
Scripting and Customization
Data Type Conversion Settings
PER - PER Conversion Information
PER - LER Conversion Information
Convert Model
Simple Model Conversion
Compare Models, Generate Change Report
Model Update
Synchronization
Scripting Window
Script Explorer
Script Editor
Automation - Calling TDM From Other Applications
Package Explorer
Scripting in Script Editor
Internal Scripting
How to Create Custom Properties
Scripting and Customization Samples
About Templates
Tips and Tricks
Toad for Oracle Integration
Create New Package
Add New Properties in Metamodel
Creating New Objects
Modify Form
Set Default Values
Add Events
Samples for Message Dialogs
Access Property Values via Scripting
File System Scripts
Create Script
Getting Settings Information
Iterate Entity And Attributes
Call Existing Script from Model Properties Form
Modify HTML Reports
Customize Forms and Frames
Macros
About Metamodel
Toad® for Oracle® Connections
Import Toad® for Oracle ER Diagrams
Open Toad® for Oracle® Projects
Toad® for Oracle® as Default Editor
Toad® for Oracle® Icons
Toad Intelligence Central (TIC) Integration
Tools
About Naming Conventions
To Do List
Quick Search
About Gallery
Model Verification
Data Generation for SQL Server
Refactoring Utility
Schema/Owner/Database Assignment
Infer Relationships
Version Control
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
User Interface
User Interface
Interface Layout
Simple and Minimalist Layout
Layout of Toad Data Modeler can be both simple and complex. Various panes can be docked on the left side, the right side or at the bottom of the application and some of the areas can be collapsed using tiny buttons in the middle of window splitters. The default layout for basic operations and tasks can be similar to this:
Expanded Area
Application View
All currently opened projects, models and their workspaces are listed in the Application View (AV). There, you can:
- Manage your models (activate, save, close, etc.)
- Edit model names (F2 or Rename)
- Work with Workspaces and Designers
Application View is by default docked on the bottom left side, next to the Message Explorer. You can close it at any time and open it later.
To open the Application View
Click 
|
|
TIP:
|
Application View Right-Click Options
Right-click a Model to see the following options:
| Option | Description | ||
|---|---|---|---|
|
Activate Model |
Highlights the selected model and enables menu and toolbar options for the model. | ||
|
Adds a new workspace (WS) to the selected model. You can define the workspace name, description and objects in the automatically opened Workspace Properties dialog.
| |||
|
Model Properties |
Opens the Model Properties dialog. | ||
|
Save |
Saves the model. | ||
|
Save as |
Allows you to save the selected model in another file format or to another location. | ||
|
Object Viewer |
Displays a complete list of model objects, e.g. attributes, triggers, check constraints, views, etc. | ||
| Add to Project |
Adds the model to a chosen Project. | ||
|
Rename |
Renames the model. | ||
|
Close Model |
Closes the selected model. If any changes have been made in the model, a confirmation dialog is displayed. | ||
|
Create Indexes to All Foreign Keys |
Creates Indexes for all foreign keys that don't already have one.
| ||
| Infer Indexes of Foreign Keys |
Binds suitable Indexes of foreign keys to an entity relationship.
| ||
|
In Expert Mode, additional options are available: | |||
|
Add to Version Manager |
Allows you to add the model to Version Manager. | ||
|
Test Model |
Runs internal test of model consistency. | ||
|
Repair Model |
Tries to fix errors found during Test Model. Fixes roughly 60 % of problems.
| ||
Right-click the Workspaces node to see the following options:
| Option | Description |
|---|---|
|
Add Workspace |
Creates a new workspace (WS) in the model. |
|
Open All Designers |
Opens Designers for all existing Workspaces in the model. |
Right-click a specific Workspace to see the following options:
| Option | Description |
|---|---|
|
Activate Designer |
Activates already opened Designer of the selected WS, or opens Designer for this WS in the Application Window. |
|
Open Designer |
Opens another Designer for the selected WS. |
|
Opens the Workspace Properties dialog where you can define the name of the WS and description. | |
| Model Properties | Opens the Model Properties dialog. |
|
Workspace Format |
Opens the Workspace Format dialog. |
| Copy Workspace Layout to | Copies this layout to another Workspace |
|
Add All Model Objects to Workspace |
Adds shortcuts of Model objects to the selected workspace. |
|
Fill Relationships to Workspace |
Adds shortcuts of relationships to the selected WS. Note that this function only adds shortcuts of existing relationships between objects in case they are not present on the selected workspace. |
|
Optimal Style for All Lines |
Seeks an optimal relationship line arrangement and adjusts them accordingly. |
|
Straighten All Lines |
Straightens all relationship lines wherever it is possible. |
| Copy Workspace | Creates a copy of the selected WS. |
| Rename | Renames the Workspace name. |
|
Delete Workspace |
Deletes the selected WS from model. |
Application Window
Application Window (AW) represents a work area where you design your models, work with scripts etc.
Toad Data Modeler allows you to work with several models of the same or different databases simultaneously. The opened models, their workspaces and even Script Editor or Scripting Window are organized using the system of tabs.
The system of tabs used by the Application Window can be divided into two levels:
- Top level tabs - Models, Script Editor, Scripting
- Sub level tabs - Designers (for Models), Scripts (for Script Editor, Scripting)
Closing a top level tab will close all of its sub level tabs (e.g. closing a model tab will close all its designer tabs)