Chat now with support
Chat with Support

Toad Data Modeler 6.3 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
About Physical Data Modeling Benefits of Physical Data Model Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects Model Properties Model Statistics
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Projects Reports Reverse Engineering Scripting and Customization SQL Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Supported Databases Connection Types by Database DB2 UDB v. 8 (LUW) DB2 v. 9 (LUW) DB2 v. 9.5 (LUW) DB2 v. 9.7 (LUW) DB2 v. 10.1 (LUW) DB2 v. 10.5 (LUW) DB2 z/OS v. 9 DB2 z/OS v.10 DB2 z/OS v. 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 Microsoft Access 2000/2002/2003 Microsoft Access 2007/2010 Microsoft Azure SQL Database Microsoft Azure SQL Database V12 Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 Oracle 9i Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 PostgreSQL 8.1 PostgreSQL 8.2 PostgreSQL 8.3 PostgreSQL 8.4 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 SQLite 3.7 Sybase ASE 12.5 Sybase ASE 15 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
Legal Information

Other Quick Tips

Features and Tools > Tips and Tricks > 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

About Integration Options

Features and Tools > Toad for Oracle Integration > About Integration Options

Toad Data Modelerand 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

Features and Tools > Toad for Oracle Integration > 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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating