Toad Data Modeler 6.5 - User Guide

List of Projects, Files, Versions

The List displays information on items in Version Manager - projects, files and versions. Here, you can sort the items by different conditions (by name, version number, date of creation etc.), however you are not able to edit them.

The List opens together with Version Manager. You can dock it wherever you want. If you close it, you can find it later in appropriate pop-up menus of items in Version Manager. E.g. Right-click the server and select List of Projects

Click a column to sort the data by:

• Name -  in alphabetical order
• Owner
• Created - chronologically by date of creation
• Changed - chronologically by date of a change
• Locked - locked items will be moved at the beginning or at the end of the list
• Lock Time - chronologically by time of locking an item  
• Description - items with description will be moved at the beginning or at the end of the list

Options and Configuration

The Options contain most of the settings available in Toad Data Modeler. This topic divides all settings into categories and describes what each individual option controls.

There are two kinds of Options:

• Default Options (most of the Model related settings) - these apply to newly created Models only, they do not influence existing Models
• Other Options (most of the general settings) - these are changeable at any time, the changes are applied immediately

The main Options Categories are:

• Application Options - affect the application behavior and user interface
• Model Options - affect every existing or created Model

The Options categories are:

• General
• Graphics
• Dialog Boxes
• Paths
• Reverse Engineering
• Reports
• Scripting
• TOAD for Oracle Integration
• Version Control System
• Print
• Expert Mode
• Physical Model
• Specific Databases
• Logical Model

The Import and Export of Settings is discussed at the end of the topic.

Application

General

Graphics

General tab

Colors tab

• Colors used in Toad Data Modeler can be set here.

Autolayout tab

Page Setup tab

• This tab contains options for default page setup configuration for printing.

Dialog Boxes

Hidden Dialog Boxes tab

• Most dialog prompts have a Do Not Show Next Time checkbox. When you check it, the specific dialog won't be shown anymore. It will also appear in this tab, so if you change your mind, you can allow it again by unchecking it.

Other tab

• You can configure Delete in Designer dialog here. It determines what action will be performed by default when you delete an object on workspace.

Paths

• This section contains default paths where Toad Data Modeler looks for objects and where objects are saved.

Reverse Engineering

Reports

• You can set default file name and preferred language of generated reports here.

Scripting

Toad for Oracle Integration

Version Control System

Print

Expert Mode

Expert Mode | Version Manager

• Paths to Version Control server and client files and projects can be set here.

Expert Mode | Editable Forms

Design Mode tab

• You can choose which windows should be visible when in Design Mode.

Component Palette tab

• Shows small/large buttons in Component Palette when in Design Mode.

Object Inspector tab

• Contains options to configure Object Inspector when in Design Mode.

Form Explorer tab

• Has several options to configure Form Explorer when in Design Mode.

Expert Mode | Eclipse

Model

Logical Model

General Tab

Shape tab

Note Line tab

Entity tab

Verification tab

• This tab contains Model Verification criteria. You can enable/disable them and Model Verification will/won't use them.

Physical Model

General Tab

Generation SQL Script tab

Verification

Workspace Tab

Shape tab

Note Line tab

Entity tab

Specific Databases

• Specific databases have their own settings, for more information see chapter Databases.

Import and Export of Settings

Export

You can export your customized settings at any time by clicking the Export button.

Choose a destination folder and Toad Data Modeler exports several .txc files to it. These are configuration files, one file matches one category in Options. The more categories settings you change, the more files will be exported.

Import

To load your exported customized settings, click the Import button.

You can either import settings from a folder or from an existing Toad Data Modeler installation.

Import from Folder

Select the Import from Folder option and in the following dialog navigate to your folder where your .txc files are stored. Toad Data Modeler will then import the configuration.

Import from Other Installation

Import Settings dialog is displayed. You can choose from which Toad Data Modeler installation should the settings be imported. If your installation directory is not shown, you can add it manually by clicking Add Location.

Default Values

Toad Data Modeler allows you to define and change default values of objects in your models.

Examples:

• You want to define default values for referential integrity type in your model.
• You want to define Not Null property for all new attributes that you create in your model.
• You want to define a name for your relationships in the following format: 'parent table - child table'.

TIP: You can use application variables in default values. Application Variables and Default Values

To open the Default Values dialog

Select Settings | Default Values...
or
Open the Properties dialog of specific object (e.g. Relationship Properties form) | right-click the form and select Default Values for Class.

Note: The second option is available only in Expert Mode.

To define a default value e.g. for relationships in your Oracle 10g model

1. Open your Oracle 10g model.
2. Select Settings | Default Values.
3. Select the Relationships item in the list.
4. Select the default value you want to modify.
5. Press F2 in the Default Value column.
6. Define the value and click anywhere else in the dialog.
7. Confirm OK.
8. Restart Toad Data Modeler.

Note: When you change the default values, you make modifications in package (by default in My Package.txg file). So, to apply the changes, you need to save the package.

9. Create a new relationship. - All newly created relationships will have the new default value.

To restore the original default values

1. Open the Default Values dialog.
2. Select the default value that you want to change back to original. (For multiple selection use CTRL or SHIFT.)
3. Click Delete to restore the original default values.  
4. Confirm OK.
5. Restart Toad Data Modeler.

Default Values Dialog

See the dialog for the Entities item and after the Show Details button has been clicked.

Dictionaries

Dictionary allows you to add and translate new terms in your current dictionary from other dictionaries, import web-based dictionaries and export dictionaries to the web (in CSV file format).

To open Dictionaries

Select Settings | Dictionaries.

Localized HTML, RTF and PDF Reports

To generate localized HTML, RTF or PDF reports

1. Download dictionaries from community website.
2. In Toad Data Modeler select Settings | Dictionaries. New Dictionaries tab opens.
3. On tab Dictionaries click the Dictionary Items sub-tab.
   
4. Click Import Dictionary .
5. Select the downloaded .csv file and click Import. All the imported words will be displayed.
   
6. Make changes if necessary. Otherwise close the Dictionaries tab and generate .
7. In the Report Wizard, page Select Report, select a report type and the newly added language.
   
8. Go through other steps in the Report Wizard.