Toad Data Modeler 6.5 - User Guide

Model Explorer

In Model Explorer, you can see all objects that exist in your model.
Model Explorer is by docked on the left side of the Application Window by default. You can always undock it and move it somewhere else or close it.

To display Model Explorer

Click on the toolbar or go to Window Menu | Model Explorer.

The contents of Model Explorer depend on type of your model (Physical/Universal/Logical) and used database platform and version.
Example of Physical Model Explorer of Oragle 10g model:

Model Explorer settings

You can access the settings by right-clicking in Model Explorer and selecting Settings.

In settings, you can change the background color of the Explorer or enable the Use Colors of Category to Draw option to color items in the Explorer according to their category.

You can also hide/show specific item categories or make them bold to make the important objects stand out.

Managing Items in Model Explorer

In Model Explorer, you can:

• View objects Properties dialog by double-clicking them
• Place object shortcuts on workspace (or even workspace of another model) using drag and drop
• Create a copy of the object in the Explorer or on workspace using CTRL + drag and drop
• Locate shortcuts of an object on workspace easily (using Find on Workspace context menu option)

Object Navigator Box

Object Navigator Dropdown Menu, together with the modeless dialogs, can ease and speed up your work in Toad Data Modeler significantly.

Object Navigator Dropdown Menu:

• Is available in Object Properties dialogs and forms (entity, attribute, check constraint, view, function, users, user groups etc.).
• Allows you to select items for edit from one (the same) place.

1. Double-click ANY entity on the Workspace to edit it.
2. Click the small black arrow on top right-hand corner.
   
   
3. The form navigator area appears on the form.
   
   
4. From the Object Navigator Dropdown, select the entity you need to edit (Borrowing).
5. Change its properties and confirm Apply. -> The changes will be saved and the Entity Properties form remains opened.
6. Again, from the Object Navigator Dropdown, select another entity you need to edit (Customer). Confirm Apply to save the changes.
7. Take the same steps until you edit all entities you need.
8. For the last entity, you can confirm the changes OK to close the Entity Properties form.

Feel free to take advantage of this box when editing relationships, procedures, views, functions, users etc.

Object Types and Properties

OTPs (Object Types and Properties) enable you to select objects and properties on various forms, define default OTPs selection and store and load them.

Example: See the Sync & Convert Wizard, the Select Object Types page, Detailed Settings button where you can define object types and properties for model compare/merge/conversion. If a particular object is selected (e.g. entities, relationships, functions etc.), it means you want to compare the object between the Left model and Right model. (All objects are selected by default). uncheck the checkboxes at particular objects if you do not want to compare them and therefore ignore the possible changes.

By default, only basic selection of objects and properties is available. Saving, loading and creating default OTPs are options for Experts.

Object Types and Properties are available in:

• Reverse Engineering Wizard and Model Update Wizard - What to Reverse page
• DDL Script Generation dialog - What to Generate tab
• HTML/RTF Report Wizard - What to Report page
• Sync & Convert Wizard - Select Object Types page 
• Model Verification - What to Verify tab

Default (System) Selected OTPs versus User Selected OTPs

In Toad Data Modeler there are:

• Default (System) Selected OTPs

They are stored by default at:

C:\Program Files\Quest Software\Toad Data Modeler\Selected OTPs

They cannot be modified/overwritten.

• User Selected OTPs

They are stored by default at:

C:\Documents and Settings\user name\My Documents\Toad Data Modeler\Installation name \Selected OTPs

They are preserved during update of Toad Data Modeler.

To set/change the path for user OTPs, select Settings | Options  |  Paths | Advanced tab | Selected OTPs.

Define and Save User OTPs

See the differences between the following two dialogs (Expert Mode off versus Expert Mode on).

RE Wizard (Oracle 10g db), What to Reverse page, default OTPs (Expert Mode disabled):

What to Reverse page, OTPs options (Expert Mode enabled):

In this dialog, you can see options for managing OTPs:

Save User OTPs

Each database supported in Toad Data Modeler has its .txo file (Oracle 10g.txo, Microsoft SQL Server 2005.txo etc.).

Default (System) Selected OTPs are stored by default at: C:\Program Files\Quest Software\Toad Data Modeler\Selected OTPs.

As soon as you install Toad Data Modeler, the default .txo files will copy to the user section at: C:\Documents and Settings\user name\My Documents\Toad Data Modeler\Installation name\Selected OTPs. Here, you can store your user OTPs that will be preserved during update of Toad Data Modeler.

New OTPs, which you create, will be saved in .txo file of the particular database.

Example:

You create a new OTP in the DDL Script Generation dialog for your Oracle 10g model and save it. This OTP will be saved to Oracle 10g.txo. This OTP will be available in the Selection box in the DDL Script Generation dialog for all Oracle 10g models for which you need to generate SQL script. (OTPs are saved separately for every dialog, which means that OTPs defined in DDL Script Generation dialog will not be available in Model Verification dialog etc.)

If you want to save this OTP to a particular model, you have to click Save Settings. The OTP, including other settings defined in the DDL Script Generation dialog, will be saved within a model. Next time, when you open the DDL Script Generation for the model, the OTP will be selected automatically. If you didn't click Save Settings, you would have to select the OTP and load it again.

Available OTPs Dialog

To see a list of all OTPs available in your model

Select Expert Mode | Expert Mode Settings menu | Available OTPs.

This option is available for real experts interested in writing their own support for new database systems or for people who need to enhance existing support for the selected database system.

Object Viewer

Toad Data Modeler allows you to display a complete list of selected objects of your model, e.g. attributes, triggers, check constraints, views, etc. with a possibility to open the Properties dialog of the selected object(s), delete them or find on the Workspace.

To open Object Viewer

Click on the toolbar.

or

Select Window | Object Viewer....

Object Viewer is docked by default next to the Model Explorer.

In the list, you can see:

• Icon of an object type
• Physical object name
• Logical object name
• Information about parent object
• Object type (entity, attribute, key, trigger etc.)

Right-click the selected item in the list to display other options (edit, delete, find on Workspace).