Chat now with support
Chat with Support

Toad Data Modeler 6.2 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
About Physical Data Modeling Benefits of Physical Data Model Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects Model Properties Model Statistics
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Projects Reports Reverse Engineering Scripting and Customization SQL Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Supported Databases Connection Types by Database DB2 UDB v. 8 (LUW) DB2 v. 9 (LUW) DB2 v. 9.5 (LUW) DB2 v. 9.7 (LUW) DB2 v. 10.1 (LUW) DB2 v. 10.5 (LUW) DB2 z/OS v. 9 DB2 z/OS v.10 DB2 z/OS v. 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 Microsoft Access 2000/2002/2003 Microsoft Access 2007/2010 Microsoft Azure SQL Database Microsoft Azure SQL Database V12 Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 Oracle 9i Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 PostgreSQL 8.1 PostgreSQL 8.2 PostgreSQL 8.3 PostgreSQL 8.4 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 SQLite 3.7 Sybase ASE 12.5 Sybase ASE 15 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
Legal Information

Rules

Features and Tools > Tools > Naming Conventions > Rules

Naming convention rules can be defines in Naming Convention Properties (Tools Menu | Naming Conventions | Settingsor click on Naming Conventions Toolbar.)

Note: Click the particular column and use F2 to turn on the edit mode. Press Enter to confirm every rule you define in the form.

Option Description
Enabled Enables set rule for particular Object Type.
Prefix Defines a prefix for selected Object Type.
Suffix Defines a suffix for selected Object Type.
Case You can define Upper/Lower Case as a rule for object names.
Valid Chars Lists characters that can be used in object name. The list can be configured in Valid Characters section.
Replacer If set, replaces all invalid characters during verification and update.

Valid Characters

You can define a set of characters that can be used in object names. Characters outside the defined set will be considered invalid and will be replaced during verification and update process (either by Replacer, if defined, otherwise by a blank space).

To define valid characters, choose one of the three options.

All characters

All possible characters will be considered valid. You can choose to except space or any other characters. See Character Set Syntax for more information on how to specify a set of characters.

User Defined Character Set

Only characters defined in this set will be considered valid. See Character Set Syntax for more information on how to specify a set of characters.

Selected Characters

You can choose categories of characters that will be considered valid. Language Specific Characters can be also included, simply select one of the option from the menu. If you language is not present, you can create your own CSV file with characters specific to your language, see files in C:\Program Files (x86)\Quest Software\Toad Data Modeler\Naming Conventions\CSV as an example.

Character Set Syntax

Example: Character set for letters a,b,c and numbers 0,1,2:

  • Single character in single quote, divided by comma: 'a', 'b', 'c', '0', '1', '2'
  • Single character’s ordinal value divided by comma: 97,98,99,48,49,50
  • Single character’s ordinal value divided by comma, in hexadecimal format: $61, $62, $63, $30, $31, $32
  • Set of characters in single quote: 'a'-'c', '0'-'2'
  • Set of characters as ordinal value: 97-99, 48-50
  • Set of characters as ordinal value in hexadecimal format: $61-$63, $30-$32
  • Any combination: 'a'-$63, $30-49, '2'

Glossary

Features and Tools > Tools > Naming Conventions > 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

Features and Tools > Tools > 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

Features and Tools > Tools > 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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating