Toad Data Modeler 6.5 - User Guide

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.

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.

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.