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

Graphics

Autolayout

There are three autolayout methods available in Toad Data Modeler.

  1. Top to Bottom
  2. Left to Right
  3. Alphabetic

To re-arrange objects on your Workspace automatically

Click any of the autolayout icons on the Layout Toolbar (these options are also available in Layout Menu).

Autolayout is especially handy when you:

  • Reverse engineer a database with a large number of items
  • Add a large number of model objects to a new Workspace

To configure properties of Autolayout

Go to Settings Menu | Options | Graphics | Autolayout.
You can configure horizontal and vertical distance coefficients (the distance between objects) and Alphabetic Autolayout sorting property.

 

Arrange Objects in Layers

Toad Data Modeler allows you to rearrange/order objects on the Workspace in different layers.

To re-arrange the selected object on the Workspace

Right-click the object | Arrange and select any of the following options:

  • Bring to Front – Brings the object on the top layer.
  • Bring Forward – Brings the object one layer up.
  • Send Backward – Sends the object one layer down.
  • Send to Back – Sends the object to the lowest layer.

Z-Order Box

To specify exact layer for an object on Workspace:

  1. Right-click the object and select Arrange | Settings.
  2. In the Object Format dialog, change the Z-Order value. Object with greater Z-Order value are placed on top of objects with lower Z-Order value.

Arrange Relationship Lines

Relationship lines consist of:

  • Lines
  • Anchor points - End points directly connected to entity boxes. You can move them.
  • Handle points - Other points that can be added to relationship lines via CTRL key. Handle points allow you to select a part of relationship line to move or delete.

Move Lines, Anchor Points and Handle Points

To move Line or Handle point

  1. Select a relationship line.
  2. Place mouse cursor over a part of the line or over a Handle point.
  3. Drag and drop to change the position of the line/handle point.

To move single anchor point and break a line

  1. Select a relationship line.
  2. Place mouse cursor over an anchor point.
  3. Use drag and drop technique to change position of the break point.

Column to Column Alignment

Lines can be rearranged manually to clearly express a link between columns in entities.

Add Handle Points

To break a horizontal line using one Handle point:

  1. Select a relationship line.
  2. Press CTRL and click the line in any place. A red cross icon appears. Release CTRL key.
  3. Move your mouse cursor left or right of the cross icon and move the highlighted part of the line up or down.


Result:

To break horizontal line using two handle points:

  1. Select a relationship line.
  2. Press CTRL and click the line. A red cross icon appears.
  3. Click the line somewhere else. A second red cross appears.
  4. Move the highlighted part between the two crosses up or down.

Result:

Add Horizontal or Vertical Lines Only

To create horizontally or vertically straight lines

(Assuming it is possible to link two entities using only horizontal/vertical line)

  1. Click the identifying or non-identifying relationship icon on Model Objects Toolbar.
  2. Click parent entity and hold SHIFT key. As long as you hold it, you can only create vertically/horizontally straight line.
  3. Move your mouse cursor over the desired position (child entity)
  4. Click the target entity and release SHIFT key.

TIP: Relationship lines between entities are created automatically once you click the parent and the child entity. The line created may not be ideal and you may have to edit it so it looks as you wish. But you can also create your own custom relationship line from scratch:

  1. Click the identifying or non-identifying relationship icon on Model Objects Toolbar.
  2. Click the parent entity and hold SHIFT key. As long as you hold it, you can only create vertically/horizontally straight line.
  3. Lead the line to the child entity. Click on Workspace to create a break point. By using break points, you can create any path you want.
  4. Finally, click the target entity and release SHIFT key.

Unhide Line

To display relationship line hidden behind objects on Workspace

Select the relationship and click button on Layout Toolbar or right-click the line | Line Style | Unhide Line.

Move, Hide, Find Relationship Names

To move relationship name

Right-click the selected relationship in particular place and select Move Caption Here or Move Caption to Parent or Move Caption to Child.

To hide relationship names on the Workspace

Click Hide Captions button on Layout Toolbar.

Note: You can also right-click the Workspace | Workspace Format | General tab | Hide Line Captions.

To find a relationship line by its caption on Workspace

Click the relationship caption. The appropriate relationship line will be highlighted on the Workspace.

To find a relationship caption by its line on Workspace

Click the relationship line, its caption will be highlighted in a frame.

Format Relationship Lines

To change format of all relationship lines on Workspace

Right-click the WS and select Workspace Format.

To change format of selected relationship(s)

Right-click the relationship and select Format.

Related Documents