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

Command Line Parameters

You can start Toad Data Modeler from command line and add additional parameters to make it perform various tasks on startup:

  • Open files
  • Create a new model
  • Script execution
  • Start logging
  • Import Toad for Oracle Diagram or Model
Open files

Definition:

Open-File -File:"Name=*Path to file*"[,Name=<string>]*

Open-File -File:Name=”*Path to file*

TIP: You can include more than one parameters. Use comma (,) to separate multiple parameters. See examples for more information.

Example:

The following command opens a model called Videorental.txp:

TDM.exe Open-File -File:Name="C:\Models\Videorental.txp"

The following command opens two models at once:

TDM.exe Open-File -File:Name="C:\Models\Videorental.txp", Name="C:\Program Files (x86)\Quest Software \Toad Data Modeler - Beta\Samples\Employee.txl"

Create a new model

Definition:

New-Model -ModelType:"*model type*"[ -ModelName:"*model name*"]

Examples:

Creates a new logical model with default name:

TDM.exe New-Model -ModelType:"Logical Model"

Creates Oracle 10g model with the specified name:

TDM.exe New-Model -ModelType:"Oracle 10g" -ModelName:"My Physical Model"

Script execution

Executes script stored in the application. First parameter is ScriptName (name of the script), second is MethodName(name of the method in script) and the following parameters (Par1Name, Par2Name...) will be passed as parameters to the script method.

Definition:

Execute-Script -Parameter:ScriptName="*script name*",MethodName="*method name in script*"[,Par1Name=Par1Value, Par2Name=Par2Value...] -TDM [-Silent]

Examples:

TDM.exe Execute-Script -Parameter:ScriptName=MyScript,MethodName=MyMethod,Par1Name="ABC",Par2Name="DEF" -TDM -Silent

Switches:

-TDM: The executed script is stored in Toad Data Modeler.

-Silent: Script will be executed in Silent mode and you will be able to work with the application regardless the state of the executed script.

Start logging

Writes messages to log. May be useful for sending reports to TDM developers.

Definition:

Start-Log

Import Toad for Oracle ER Diagram or Toad for Oracle Project

TDM.exe Import-ToadForOracleERD -file:"NopathMovERD.erd"

TDM.exe Import-ToadForOracleERD -file:NopatMovERD.erd -Connection:"SERVER=OstDbServer:1521/ORCL, USER=movies,PROTOCOL=TNS,CONNECTAS=NORMAL,SAVEPASSWORD=1,ORACLEHOME=c:\oracle\product\10.2.0\db_1,HOST=OstDbServer,SErVICENAME=ORCL, PORT=1521,LDAP=,METHOD=1"

Other Quick Tips

Objects on the Workspace and Keyboard Arrows

  • Move entities on the Workspace via keyboard arrows.

Note: To set the size of a step to move, select Settings | Options | Graphics | Move Objects by (mm/10) (in tenths of millimeters).

  • Select an entity, press SHIFT, hold it down and use the keyboard arrows to change size of the entity box.

Navigation on Workspace

  • CTRL + scroll mouse to zoom in/zoom out
  • CTRL +, CTRL + Page Up to zoom in
  • CTRL-, CTRL+ Page Down to zoom out
  • Scroll mouse to move up/down on the Workspace
  • SHIFT + scroll mouse to move to the right/left on the Workspace
  • Holding down the middle button to move on entire page/Workspace
  • Page Down, CTRL + down to move to next page
  • Page Up, CTRL + up to move to previous page
  • CTRL + left to move to the left page
  • CTRL + right to move to the right page
  • Click to fit your entire ERD to screen.
  • Press F11 to display the application in full screen mode.

Make a Copy of Multiple Objects on the Workspace (CTRL+A, CTRL+C, CTRL+V)

  • Before you press CTRL + V to paste the objects, close the Model Explorer dialog to accomplish the operation much faster.

(The larger your model is, the more significant difference in speed you will notice.)

Print Models

  • In Settings | Options | General, clear the Print Gradients checkbox for much faster print performance. (It is disabled by default.)

HTML Report Layout

  • For large models, Frames - top menu or Frames - left menu options are recommended.

(Frameless report layout is not recommended as it uses Java script that goes through all objects, which takes too much time if your model is large.)

Toad for Oracle Integration

Toad Data Modeler and Toad for Oracle products have started the integration process.

Toad for Oracle - Basic Information on Product

Toad for Oracle® is a powerful application development tool built around an advanced SQL - PL/SQL editor. Using Toad, you can build and test scripts, PL/SQL packages, procedures, triggers, and functions. You can create and edit database tables, views, indexes, constraints, and users. The Schema Browser and Project Manager provide quick access to database objects.

Toad’s Editor provides an easy and efficient way to write and test scripts and queries, and its powerful data grids provide an easy way to view and edit Oracle data. With the optional DB Admin module you can manage space, compare schemas, monitor database performance, create new databases, maintain redo logs, perform health checks, and much more.

Toad for Oracle Integration in Toad Data Modeler

  • Loading of Toad for Oracle® aliases
  • Opening Toad for Oracle® projects
  • Importing Toad for Oracle® ER diagrams
  • Possibility to define Toad for Oracle® as a default editor for generated SQL scripts
  • Possibility to use Toad for Oracle® icons in Toad Data Modeler
  • Import of Toad for Oracle® templates. Toad for Oracle Templates
 

Default Settings for Toad for Oracle Integration

Select Settings | Options | Toad for Oracle Integration.

Note:

  1. Since Toad for Oracle® 10.0, the list of installed programs is not saved to registry but to a special file SettingsLocations.ini. What it means in reality: During start-up Toad Data Modeler searches for all Toad for Oracle® versions that you have on your computer. By default Toad Data Modeler pairs with the last installed Toad for Oracle® version. Once the Toad for Oracle® version is found, it is written in Config file of Toad Data Modeler.
    If you want Toad Data Modeler to pair with another Toad for Oracle® version, you have to define it manually in Toad Data Modeler: Settings | Options | Toad for Oracle Integration.
  2. Toad for Oracle® cannot auto-detect Toad Data Modeler. To detect Toad Data Modeler via Toad for Oracle®, check the Detect this Toad Data Modeler... checkbox at the bottom in this window.

Toad® for Oracle® Connections

Toad Data Modeler recognizes Toad for Oracle connections and displays them in the:

  • Connections dialog - click on Main Toolbar.
  • Reverse Engineering Wizard - click on Main Toolbar.

Note:

  • Both options are available from the File Menu | Reverse Engineering.
  • Toad Data Modeler allows you to use Toad for Oracle aliases but it doesn't allow you to save changes to these aliases.

Related Documents