Tchater maintenant avec le support
Tchattez avec un ingénieur du support

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

Object Explorer

Use Object Explorer to easily drag and drop objects from your connections.

To use Drag and Drop method

  1. Click File | Reverse Engineering | Connections, select a connection and click Open Object Explorer to launch it for the selected connection.

  2. Drag and drop any objects to your model. The model needs to be of the same type as the database connection or the DDL script file. You may drag and drop objects directly to Designer or into Physical Model Explorer by dragging them onto the root or into the correct folder. Some objects such as synonyms may only be dragged to Physical Model Explorer.

Import Toad ERD

NOTE: For more info on Toad for Oracle integration see Toad for Oracle® Connections and other related help topics.

To create a model by importing a diagram created in Toad for Oracle

  1. Click File | Reverse Engineering | Connections, click Import Toad ERD and select a file to import. You can use a selected connection or the connection saved in the imported file. Click “No” to use your own saved connection. If you click “Yes” an alias for a connection will be temporarily saved. The alias is removed after having refreshed Connections or restarting Toad Data Modeler.

  2. A new model is created from the imported Toad for Oracle file.

Universal DB/ANSI Model

Toad Data Modeler allows you to reverse engineer a database structure of unsupported database platforms. Tables, columns, primary keys, indexes, relationships, procedures and views are loaded (depends on the database). It is necessary to convert the reversed model to a model of any supported databases.

To reverse an ANSI model

  • Follow the steps defined in Connections and select Universal DB in Select Data Source step.

Scripting and Customization

Toad Data Modeler and its behavior can be easily customized in several ways to better fit your needs and requirements. You can also leverage the power of scripting and automation to improve your workflow.

To start scripting/customizing, you need to enable Expert Mode first.

To enable Expert Mode

Check Expert Mode in Settings | Options | General

Expert Mode menu and Options section Expert Mode will appear.

Right-click a model name in Model Explorer or Application View and select Test Model to run an internal test of model consistency.

Right-click a model name in Model Explorer or Application View and select Repair Model to repair broken models.

The scripting and customization capabilities include:

  • Scripts and macros
  • Packages
  • Metamodel
  • Form customization

Note: Useful information about available classes, methods, functions and properties accessible in Toad Data Modeler can be found in the Reference Guide.

This document is available in the Expert Mode | Reference Guide (with Expert Mode enabled).

Scripts/Macros

Code written in JScript, VBScript or Internal script may be used to access and modify various model objects or even perform model actions such as model renaming, merging, DDL script customization, etc.

Note: Macros are similar to scripts except they can be configured to appear in custom Macro menu or context menu of selected objects.

Scripts/Macros can be accessed via Expert Mode Menu | Customization | Script Explorer.
To create and immediately execute scripts, take advantage of Scripting Window located in Expert Mode Menu.

  

Packages

A package contains various means of customization such as scripts, macros, customized form definitions, data type conversion rules, etc. Packages affect models of various database platforms and versions depending on their Visibility and relations with other packages (Extension, Dependency).

Packages can be accessed via Expert Mode Menu | Customization | Package Explorer.

   

Metamodel

Metamodel is a graphical representation of objects (classes, properties, methods, etc.) that belong to a selected package. In metamodels, you can create new classes, properties, methods, associations, generalizations, and others in a way similar to UML Class Diagram.

Form Customization

It is also possible to modify certain application forms (mostly Properties dialogs) and either change existing elements or add custom ones.

Other Notes

Toad Data Modeler Order of Priority

1. Scripts and definitions stored in My Package.txg file have the highest priority.

2. Scripts and definitions stored in other user defined packages (distributed as add-ons, add-on packages) have higher priority than scripts and definitions stored in system packages.

3. Scripts and definitions stored in system packages have the lowest priority.

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation