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

Grid and Grid Size

The Grid options are available directly from the toolbar or from the View menu.

To show grid and set a grid size

  1. Click to show grid.
  2. To change a grid size, click .
  3. To snap objects of your ERD to grid, click .

Zoom, Loupe, Overview

Toad Data Modeler allows you to move around your large models quickly and views various parts of a model in various zoom levels.

For this purpose, the following functions can be used:

  • Zoom (Zoom In, Zoom Out, Zoom Box)
  • Loupe (magnifier glass)
  • Overview (navigator)
  • Move

All these functions are available on Zoom Toolbar or in View and Windows menus.

 

Navigation Tips on Workspace

  • CTRL + scroll mouse to zoom in/zoom out
  • CTRL + Page Up/Page Down to zoom in/out
  • Scroll mouse to move up/down on the Workspace
  • SHIFT + scroll mouse to move right/left on the Workspace
  • Holding down the middle mouse button to move around the entire page/Workspace
  • Page Down, CTRL + down to move down
  • Page Up, CTRL + up to move up
  • CTRL + left to move left
  • CTRL + right to move right
  • Click on Zoom Toolbar to adjust the zoom level so the entire ER diagram fits on screen.

Objects on Workspace and keyboard arrows

  • Move objects on Workspace using keyboard arrows.

TIP: To set the move distance of one keypress, see Settings Menu | Options | Graphics | Move Objects by (mm/10) (in tenths of milimeters).

  • Select a shape on Workspace, hold down SHIFT and use the keyboard arrows to change size of the shape.

Model Actions

Model Actions

Basic Information

Model Actions can be opened by clicking Window | Model Actions or Model | Manage Model Actions.

This tool contains following Model features:

  • Compare and Generate Report
  • Generate Change Script
  • Merge Models
  • Convert Model
  • Generate SQL
  • Report

Using Model Actions helps you work more effectively. You can:

  • Find the most used Model features all in one place
  • Save Action Definitions for future use, even to a file
  • Load Action Definitions to reduce time spent configuring Actions, even from a file
  • Reduce the number of dialogs using Run Promptly button

Note: Action Definition is a custom configuration of an Action (e.g. Convert Model). Instead of configuring Action every time from scratch, you are now able to save its Definition for later use (e.g. Convert Model from DB2 10.5 to DB2 10.1). In the future you can simply execute the Action Definition without worrying about its settings.

If you clicked through Action dialogs and forgot to save the Action Definition in progress, worry not. Every executed Action creates an Action Definition called Last *Action*. It contains the settings of the last Action you ran.

Also please note that all saved Action Definitions are part of the model. You can transfer Action Definitions from one Model to another by saving them to a file in original Model and loading them from the file in target Model.

Model Actions Options

Option Description
Run Action Definition Promptly Allows you to execute Action Definition with minimum of dialogs shown.
Run Action Definition Executes the selected Action/Action Definition. You can save the configuration as a new Action Definition in progress.
New Action Definition Executes the selected Action/Action Definition. An extra dialog displays asking you to enter name and comment for new Action Definition.
Edit Action Definition Allows you to go through the dialogs of an Action Definition and edit any options.
Delete Action Definition Removes Action Definition from list.
Save Action Definition to file Allows you to save selected Action Definition to a .txad file.
Load Action Definition from file Allows you to load an Action Definition from .txad file.

Saving Action Definition

Action Definition can be saved by clicking the Save Action button which is located in the Review dialog (the last dialog every Action has).

Fill in the new Action Definition name and an optional description. Click Save.

The newly saved Action Definition will now show up in the list.

Related Documents