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

External Objects

External objects are objects dynamically linked from another model. This feature can help you to divide a large model into several smaller elements.

External objects are read-only, and therefore it is not possible to insert any objects that would have effect on dependencies such as relations. However, it is possible to add entities, procedures, domains and others.

External objects are synchronized with their source objects only when prompted. Both models need to be available during the synchronization process.

Add External Objects to a Model

  • Right-click the root of a model in Model Explorer or Application View and select External Sources to import external objects
  • Both models must be opened in Toad Data Modeler in order to use external sources
  • Select the source model to import from and check objects you want to use in your destination model
  • If an object with the same name as the imported object already exists in the model you will be asked about overwriting it:
    • Click Yes to overwrite the original object with the external object
    • Click No to insert the external object and keep the name
  • If asked about inserting linked objects:
    • Click OK to insert external objects and the objects that are linked to it
    • Click Cancel to cancel import. The external object will not be inserted into the model
    • For linked objects that are named identically to already existing objects:
      • Check Overwrite to replace the original target object with the imported linked objects
      • Leave Overwrite unchecked to keep the names of both objects

NOTE: Exist in Model field has four states:

  • No - There is no object with the same name as the imported object
  • Yes - There is a non-external object with the same name as the imported object
  • Mapped External - There is a external object with the same name as the imported object, which comes from the same source as the currently imported object
  • External - There is a external object with the same name as the imported object, which comes from a different source than the currently imported object

Manage External Objects

  • Right-click a model and select External Objects | Update All to easily update all external objects
  • Select Window | External Dependencies Explorer to manage imported and exported objects
  • Imported Objects shows a list of objects from an external source and Exported Objects shows a list of objects inserted into other models
  • Click Update to update the imported objects if they had been modified in the source model
  • External objects are marked by an icon () in Designer and in Model Explorer

External Dependencies Explorer Actions

Button Description
Refresh Refreshes the list of external objects
Check Item Performs a validity check against the external source model
Check All Performs a validity check for all external objects against the external source models
Delete Object Deletes the object in the target model
Create Reference in Source Model Creates a dependency reference in the source model in order to indicate that the object has been linked from other models
Delete Reference Deletes the reference to the target model from this model
View Object/Item Displays properties of the object
Open Model Opens the model that contains the external object
Update from External Source Updates the model with changes from the external source
Propagate to External Source

Updates the source model with changes from this model

NOTE: There is one exception when the external source is not read-only. Create an object in the source model and synchronize it with your target model. Then create a relation to the object in the target model and an attributed is created in consequence. This attribute will be propagated to the source model when synchronized.

Shortcuts of Objects

There are three types of models in Toad Data Modeler:

Model Properties

Select Model | Properties.

Tab Description
General General information on the model (project, model, author, company, version etc.)
Before Script

Whatever you write on the Before Script tab, it will be generated before the generated SQL code.

After Script Whatever you write on the After Script tab, it will be generated after the generated SQL code.
Description Notes on the model
Naming Convention Here you can select a naming convention for the model.
Database Parameters

The value in the Length Semantics box shows which default length semantics (BYTE or CHAR) was set in the database for reverse engineering of Oracle database.

Note: This tab is available only in Oracle models.

Naming Convention

Here you can link or unlink a naming convention to/from your model.

Manage Naming Conventions - Opens the Naming Convention dialog (available also from the Tools menu)

Edit Naming Convention - Opens the Naming Convention Properties dialog.

Model Statistics

To display details on your model, its Workspaces, objects etc.

Select Model | Statistic....

To change some of the General Information (e.g. model name, author or company)

Select Model | Properties....

TIP: You can also change it via the shortcut of Stamp on the Workspace - just double-click the Stamp.

About Shortcuts

In Toad Data Modeler, you can create multiple graphical representatives of an object - Shortcuts.

  • A shortcut is a graphical representative of an object in the Workspace (WS). It is not a copy of an object.
  • A shortcut has the same name as its object + a number indicator.
  • A shortcut has the same data properties as its object. You can edit any shortcut and all changes will be applied to its object. Also, changes made to an object will be reflected on its shortcuts.
  • An object can have none or many shortcuts. Their number is not limited.
  • You can set individual graphical format for each single shortcut of the same object.

You can create shortcuts of these objects:

  • Entity
  • Relationship
  • Inheritance
  • View (Materialized View)
  • Note
  • Stamp
  • Category (caption of Category)
  • Image

Shortcuts help you to organize your large models. Let's say you have a model, where an entity is related to a large number of other entities. You can break the model down into multiple workspaces and create a shortcut of the entity for each workspace. The structure of model is not affected, but you get to see the important things more clearly.

For further distinction of model objects using colors, see Categories.

Scenario

You have a Student entity, which is related to many other entities across the entire model. You want to divide the model into two blocks and you also want the Student entity to be contained in both of these blocks.

Solution: A shortcut of the Student entity has been created and used in another part of the model. This way, the model has been logically divided into two blocks and became much clearer and better arranged.

Create Shortcuts

Toad Data Modeler allows you to create shortcuts of objects on Workspaces in many ways.

To add a shortcut within a Workspace

Drag&Drop techniques and CTRL+SHIFT

Example:

Create a shortcut of the Customer entity on one WS - Borrowing WS:

  1. Click the Customer entity on the Borrowing WS and hold the mouse key down.
  2. Press CTRL+SHIFT keys and hold them down.
  3. Drag the Customer entity to any place on the work area (the mouse cursor will change its appearance).
  4. Release the mouse button and the keys.

Note: This method cannot be used for creating shortcuts of relationship and inheritance objects.

To add a shortcut from Model Explorer to Workspace

Drag&Drop techniques from Model Explorer to particular WS

Example:

  1. Activate the Workspace where you want to add a shortcut of the Customer entity.
  2. In Model Explorer, find the Customer entity.
  3. Click the Customer entity and hold the mouse key down.
  4. Drag the Customer entity to the WS (the mouse cursor will change its appearance).
  5. Release the mouse button.

To add a shortcut of selected object(s) from one Workspace to another Workspace

Right-click the selected object(s) (e.g. entity) on the WS and select:

  • Add into Workspace to select the particular WS.

or

  • Add into New Workspace to create a new WS and add the shortcut there. The layout and format of the shortcuts remain preserved when you use this option.

To add a shortcut of objects related to an entity on Workspace (including relationships)

Right-click the entity and select from the following options:

  • Fill Parent Objects to add shortcuts of parent objects of the selected entity to the WS.
  • Fill Child Objects to add shortcuts of child objects of the selected entity to the WS.
  • Fill Parent and Child Objects to add shortcuts of parent and child objects of the selected entity to the WS.

To add a shortcut of object(s) to the selected Workspace

Right-click the selected Workspace and select Add All Model Objects to Workspace to add shortcuts of all objects that exist in your model.

Related Documents