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

Glossary

Glossary has two main functions:

  • Character replacement

    Note: This function serves primarily to replace various language-specific characters with standard English ones. A replacement is invalid (red) if:

    • The left or the right side contains more than one character
    • The left side is equal to the right side
    • The left side character is an ASCII character (has ASCII value <= 128, except for space character)

  • Word replacement

In order to replace characters using glossary, you have to define one first. Simply Add a new glossary in Naming Convention Properties | Glossary tab and start defining your custom replacements. Another option is to Import glossary from a CSV file.

Note: Toad Data Modeler includes several existing glossaries used for character replacement. They can be found in:
C:\Users\*username*\Documents\Toad Data Modeler\Standard Installation\Naming Conventions\CSV

To use glossary during name verification, make sure to enable the options Automatic Verification and Use Glossary for Naming Convention Verification are enabled.

To Turn Case-Sensitivity On

  • Allow Case Sensitivity in Tools | Naming Convention | Settings | Glossary | Word Replacement

To Set Delimiters

  • Select from space, underscore, dot, colon or define your own delimiter

To Do List

To-Do List allows you to keep records of tasks and make notes on unfinished actions.

You can assign tasks to:

  • Particular object of your model in its Properties dialog (see the Entity Properties form | To Do tab)
  • Main To Do dialog - see the Model menu | To Do (A complete list of all To Do items can be found here.)

- Hides/shows To Do items that were entered out of the To Do dialog.

In Toad Data Modeler, you can assign tasks to the following objects:

Model, Entity, Relationship, Attributes, Keys, Indexes, Check constraints, Triggers, Users, User groups, Dictionary Types, User Data Types, Domains, Defaults, Rules, Views, Procedures, Schemas, Categories, Metamodels.

Note: Toad Data Modeler allows you to generate a To Do report. XSL Transformation

To add a new To Do item

Select Model | To Do | Add.

To edit a To Do item

Select Model | To Do | double-click the selected item.

General Tab Description

Name

Task name

Priority

Task priority

Category

To logically divide your To Do items, you can define categories for them. Simply write a category name to the Category box.

The existing categories will be available here via a drop-down menu for other To Do items as well.

Date of Creation

Date when the task has been entered to To Do.

Deadline

Date when the task should be accomplished.

Completed

If selected, the task has already been accomplished.

Text

On this tab, you can write a text description on particular task.

Quick Search

To quickly find an object in your model or on your workspace:

  1. Press CTRL + F.
  2. Type an object name or caption, or part of object name or caption.
  3. Click the object or use the arrow down key on your keyboard to select it.
  4. Press Enter to perform suggested action. Select the suggested action via the Arrow button at the bottom of the dialog. Possible actions (depend on the selected item): Edit, Find on Workspace, Format.

Standard Search

When you search for an object, write part of the name or caption to the first field.

Wildcards

Available wildcards are * and ? characters. (The star wildcard at the end of search term is not required).

Word Recognition

If you use underscores in names, you can type just first characters of the words to refine search.

The following example shows search results of string tcr. Results include T_CUSTOMER_RATING.

Underscore characters were used as word delimiter.

Similar functionality is available for search in captions where space is used as word delimiter.

You can partially combine the standard search with the word recognition based search.

Camel Case

In case your objects are defined using CamelCase, type just the characters you expect to be in uppercase.

Example: To find EventLogConfig, search for elc.

Dot Notation

Define object name and type . character to display child items of the object. The dot notation works for schemas as well.

About Gallery

Toad Data Modeler allows you to reuse frequently used parts of your model, no matter if they are entities, single attributes, stored procedures or other objects. This can be done using Gallery where you can simply drag and drop items from your models and use them in your other models.

Some basic Gallery actions include:

  • Creating a new Gallery
  • Adding objects to a Gallery
  • Inserting objects to a Model
Creating a new Gallery
  1. Go to File Menu and select New | Gallery.

  2. Choose the Gallery Name, enter its Description and choose whether you want to comment out code of database specific objects (this option is explained in the Inserting objects... section).

  3. Your Gallery will be opened in the Gallery Explorer.

Adding new objects to a Gallery
  1. To add a new object to a Gallery, simply drag it from Workspace or Model Explorer to and drop it on the Gallery name in Gallery Explorer.

  2. Your object is now part of the Gallery and you can view its properties by expanding it.

Inserting objects to a Model
  1. If you have one or more objects stored in Gallery, you can insert them into a model by simply dragging them to workspace.

Note: If the model database of the object is different from the target model database (e.g. Entity created in Oracle 10g model dragged to SQL Server 2010 model), it will be converted. Note that database-specific properties (mainly SQL code) may be syntactically invalid in the target database. If you have enabled the Comment out code from database specific objects... option, the properties will be commented out and you can fix their syntax later.

Note: You have to drag and drop the main node of the object in the Gallery to actually move the object, not any of its child nodes.

Related Documents