Chat now with support
Chat with Support

Toad Data Modeler 7.2 - 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 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

Naming Convention Valid Characters

Naming Conventions also allow you to define valid and invalid characters.

 

On Naming Convention Rules tab you can define valid characters for physical names and also set how invalid characters should be replaced.

Example: Let’s say you have set a space as invalid character for entity names in your naming convention. See how Toad Data Modeler will behave in the following situation:

Customer Data logical name in the Caption box, will automatically change to CustomerData physical name in the Name box. -> The space will be ignored.

You edit the naming convention and define that every space should be replaced with '_'.

Customer Data logical name in the Caption box, will change to Customer_Data physical name in the Name box.

Once you manually edit the physical name, the automatic synchronization will turn off.

Valid Characters and Character/Word Replacement

Character Replacement

Use Character Replacement to replace diacritical characters. Do not use Character Replacement to replace a space with another character.

Word Replacement

Use Word Replacement to replace one word with another word or more words. Word Replacement launches after characters are replaced.

Valid Characters + Replacement

Use this combination to define valid characters. Also, it is possible to replace invalid characters with an alternative character. Check of valid characters launches as last. See the example below.

Example:

Character Replacement:

ñ -> n

Word Replacement:

espanoles -> esp

residentes -> res

Valid Characters:

Space -> _

Toad Data Modeler proceeds in the following order:

1) "residentes españoles" -> "residentes espanoles"

2) "residentes espanoles" -> "res esp"

3) "res esp" -> "res_esp"

Valid Characters Definition

Option Description
All Characters
Except Space Character If it is selected, all characters are valid except for a space.
Except

Click this checkbox and manually write out character set that you want to forbid.

For more information, see Character Set Syntax.

User Defined Character Set

Select this option to manually define character set. Incorrect definition will be highlighted in red.

Note: Valid character set is automatically written out in the Valid Chars column.

Selected Characters Select any of the following options to set:
All Standard ASCII Characters (0-127) - all standard ASCII characters valid, others are forbidden.
Space (32)

- only Space (32) character as valid.

Note: Number 32 is an ordinal value of the Space character.

Number '0'-'9' - number 0 – 9 as valid.
Lower Characters - only lower characters as valid.
Underscore (95)

- Underscore 95 as valid.

(Number 95 is an ordinal value of the Underscore character.)

Upper Characters - only upper characters as valid.
Language Specific Chars

- a diacritical character set of the particular language as valid. Click the box on the right to select the language.

TIP: You can create your own table with diacritical character set for your language. See: C:\Program Files\Quest Software\Toad Data Modeler 3\Naming Conventions\CSV. Create your CSV file in this location.

Valid Chars Column

In this column, a complete character set is written out – according to your settings in the Valid Characters area.

Note: You can also define the character set manually to this column – via F2 key. However, to make sure your character set is correct, please use the User Defined Character Set option.

Replacer Column

Define a character that will be used as a replacer.

Example: underscore character.

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

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating