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

Component Inspector

Component Inspector is a list of properties of the selected component in the form. Here, you can edit properties.

Option Description

Top combo-box

Select a component to display in this dialog.

Left Column

Displays property names.

Right Column

Displays values. Most of the values can be changed in inplace editors.

Note: If you select components directly in the form you edit, you can select more components using the SHIFT key. Then, only common properties will be displayed in Component Inspector.

Right-click the Component Inspector form and select Properties.

Here you can edit colors of specific parts of the dialog, and select other options.

Component Palette

Component Palette is a list of components that you can add to a form. It is divided into two parts:

  • Data - here you can find components that can follow up with already existing properties
  • Standard -  other components that can be used for change of appearance or better classification of components

To insert a component to a form

  1. Select a component from the Component Palette.
  2. Click to a place where you want to insert it.  

To display components with small buttons

Right-click the Component Palette form and select Properties | Small Buttons.

Form Explorer

Form Explorer displays tree structure of components in a form.

In Form Explorer, you can move components, select them for edit in Component Inspector (via mouse), and delete them (Delete key).

Right-click the Explorer form and select Properties.

Macros

Toad Data Modeler supports macros. You can use sample macros available in the Macros menu or create your own macros. You can create a macro in Package Explorer or Script Explorer and modify its properties to display the macro either in the main menu or pop-up menu (of specific object or on the Workspace etc.). Visual components for creation of macros are also available (User Forms).

Macros menu contains:

  • All - The selected macro will be applied either on all objects on all Workspaces or all objects of the active Workspace.
  • Selected Objects - The selected macro will be applied only on the selected objects on the currently active Workspace.
  • Productivity Pack
  • Rename Objects Pack

Scenario

You want to create a macro Add Attribute to PK and add this macro to pop-up menu of attributes in Model Explorer.

To create your own macro

  1. Open Script Explorer (Tools menu, Expert mode must be enabled).
  2. Right-click the Macros item and select Add New Macro.
  3. Right-click the newly created macro and select Properties.
  4. Define properties of the new macro. Remember to define its caption (macro name that will be displayed), visibility on tab Visibility (if for all databases etc.).
  5. On tab Others, you can define Undo options. It is recommended to keep the default settings.
  6. On tab Menu, you can define where you want to display the macro - in Main menu, pop-up menu or both.
    Select Add to Popup Menuand write the path name.
  7. On tab Object Types, select object types for which the macro will be available in their pop-up menu.
    Select Attribute and confirm OK.

  8. Double-click the new macro to open the Script Editor. Modify the default code at your convenience.

  9. Confirm Commit and Save.
  10. The Macros will be available accordingly.
 
Related Documents