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

Reverse Engineering

Connections

Connections displays all connections to databases and to DDL files. You can easily create and edit connections and also launch Reverse Engineering wizard or perform operations with models.

To manage connections

  • Select File | Reverse Engineering | Connections.
Button Description
New Connection Create a new connection to a database or to a DDL script file.
Edit Connection Edit existing database or DDL file connection.
Test Connection Tests a connection.
Copy Connection Clones a connection. Creates a connection based on an existing one.
Delete Connection Deletes a connection.
Reload Connections Refreshes the list of connections. If you manually add a connection to Connections file this list needs to be refreshed. The path to Connections file is defined in Settings | Options | Reverse Engineering | Path to Connections.
Show Favorites Only Only displays your favorite connections. Double-click into Favorite column to mark a connection as favorite.
Create New Model from Database Launches Reverse Engineering wizard.
Open Object Explorer Launches Object Explorer to drag and drop objects into your model from the connection.
Import Toad ERD Creates a new model based on *.erx or *erd file from Toad.
Show Right Bar Displays a right-hand bar with extra buttons.

To create a new database connection

  1. Click New Connection and define a new connection name.
  2. Select data source. Select the desired type of database RE. See the Supported Databases for more info on Toad Data Modeler support for Reverse Engineering. Click Add/Remove Databases to enable or disable databases. Check Show Enabled Databases to only show your enabled database types.

  3. Select the data provider for your connection to a database. See more information on the connection methods available for specific databases in Types of Connections by Databases.
  4. Enter your connection information or edit your connection string directly.
  5. Select what you want to perform Reverse Engineering with. Use Auto Check button to automatically select parent objects when any of their dependent objects are selected.
  6. In Options configure settings used for Reverse Engineering. See Help | Databases | {specific database} | Reverse Engineering for more information on available options. The following options for Reverse Engineering are common for more database types:

    Option Description
    Divide Objects to Workspaces by Schema The resulting model will have a workspace for each schema.
    Infer Relationships Check to automatically generate relationships between entities in the resulting model. If unchecked you will be prompted during Reverse Engineering only when no relationships are found in the resulting model. Default: Unchecked.
    Terminator Select the desired terminator for SQL statements.

  7. Click Finish to save the new connection.

To create a new DDL file connection

  1. Click New Connection and define a new connection name.
  2. Select data source. Select the desired type of DDL Script RE. See the Supported Databases for more info on Toad Data Modeler support for Import from SQL files. Click Add/Remove Databases to enable or disable databases. Check Show Enabled Databases to only show your enabled database types.

  3. Select the data provider for your connection to a DDL script file.

  4. Click Open DDL Script File and select the file that you want to use for connecting. Enter the desired terminator for SQL statements. The DDL script is displayed after opening the file.

  5. Select what you want to perform Reverse Engineering with.
  6. In Options configure settings used for Reverse Engineering. See Help | Databases | {specific database} | Reverse Engineering for more information on available options. The following options for Reverse Engineering are common for more database types:

    Option Description
    Divide Objects to Workspaces by Schema The resulting model will have a workspace for each schema.
    Infer Relationships Check to automatically generate relationships between entities in the resulting model. If unchecked you will be prompted during Reverse Engineering only when no relationships are found in the resulting model. Default: Unchecked.

  7. Click Finish to save the new connection.

Reverse Engineering Wizard

Reverse Engineering Wizard guides you through the process of creating a model from an existing database or a DDL file.

To create a model by Reverse Engineering

  1. Click File | Reverse Engineering | Reverse Engineering Wizard. Select one of your stored connections or select “No connection” to define a new source in the following steps of the wizard. You can also select one of the connections shared with Toad for Oracle or created during import of an ERD file from Toad for Oracle. Select a connection and click Load to proceed to the last step of the wizard or define a new connection. See Connections for more information on how to create a connection to a database or to a DDL file.

  2. Select the objects you want to include in your target model and click Execute to create a new model.

    Feature Description
    Schema Select a specific schema you want to include in the target model, all tables or all selected tables.
    Select All on All Tabs Selects all objects on all tabs.
    Deselect All on All Tabs Deselects all objects on all tabs.
    Filter

    Type to filter objects.

    TIP: Use wildcards - example: "*user" or "?ser".

    * - replaces unlimited number of characters

    ? - replaces any single character

    Select All Selects all object on the current tab.
    Deselect All Deselects all object on the current tab.
    Invert Selection Inverts selection on the current tab.
    Select Parent Tables Selects all parent tables of the currently selected tables.
    Select Child Tables Selects all child tables of the currently selected tables.
    Select Parent and Child Tables Selects all child and all parent tables of the currently selected tables.
    Export Selection Export selection as a *.wsxr file.
    Import Selection Imports a selection from *.wsxr file.

TIP: Select parent and child tables easily using the right-click menu. You can select child and/or parent tables up to 3 levels of depth or all levels (Infinity Depth).

Object Explorer

Use Object Explorer to easily drag and drop objects from your connections.

To use Drag and Drop method

  1. Click File | Reverse Engineering | Connections, select a connection and click Open Object Explorer to launch it for the selected connection.

  2. Drag and drop any objects to your model. The model needs to be of the same type as the database connection or the DDL script file. You may drag and drop objects directly to Designer or into Physical Model Explorer by dragging them onto the root or into the correct folder. Some objects such as synonyms may only be dragged to Physical Model Explorer.

Related Documents