NOTE: For more info on Toad for Oracle integration see Toad for Oracle® Connections and other related help topics.
To create a model by importing a diagram created in Toad for Oracle
Toad Data Modeler allows you to reverse engineer a database structure of unsupported database platforms. Tables, columns, primary keys, indexes, relationships, procedures and views are loaded (depends on the database). It is necessary to convert the reversed model to a model of any supported databases.
To reverse an ANSI model
Toad Data Modeler and its behavior can be easily customized in several ways to better fit your needs and requirements. You can also leverage the power of scripting and automation to improve your workflow.
To start scripting/customizing, you need to enable Expert Mode first.
To enable Expert Mode
Check Expert Mode in Settings | Options | General
Expert Mode menu and Options section Expert Mode will appear.
Right-click a model name in Model Explorer or Application View and select Test Model to run an internal test of model consistency.
Right-click a model name in Model Explorer or Application View and select Repair Model to repair broken models.
The scripting and customization capabilities include:
Note: Useful information about available classes, methods, functions and properties accessible in Toad Data Modeler can be found in the Reference Guide.
This document is available in the Expert Mode | Reference Guide (with Expert Mode enabled).
Code written in JScript, VBScript or Internal script may be used to access and modify various model objects or even perform model actions such as model renaming, merging, DDL script customization, etc.
Note: Macros are similar to scripts except they can be configured to appear in custom Macro menu or context menu of selected objects.
Scripts/Macros can be accessed via Expert Mode Menu | Customization | Script Explorer.
To create and immediately execute scripts, take advantage of Scripting Window located in Expert Mode Menu.
A package contains various means of customization such as scripts, macros, customized form definitions, data type conversion rules, etc. Packages affect models of various database platforms and versions depending on their Visibility and relations with other packages (Extension, Dependency).
Packages can be accessed via Expert Mode Menu | Customization | Package Explorer.
Metamodel is a graphical representation of objects (classes, properties, methods, etc.) that belong to a selected package. In metamodels, you can create new classes, properties, methods, associations, generalizations, and others in a way similar to UML Class Diagram.
It is also possible to modify certain application forms (mostly Properties dialogs) and either change existing elements or add custom ones.
1. Scripts and definitions stored in My Package.txg file have the highest priority.
2. Scripts and definitions stored in other user defined packages (distributed as add-ons, add-on packages) have higher priority than scripts and definitions stored in system packages.
3. Scripts and definitions stored in system packages have the lowest priority.
Scripting Window allows you to run simple scripts only. In Scripting Window, you cannot save scripts as they do not relate to any package.
To open Scripting Window
In the Application Window, see the new tab Scripting with the Scripting Window open.
Scripting Window toolbar
|Show Windows Automatically||Displays a corresponding side tab. When you are writing a script, Code Explorer is displayed. When a script is being executed, Log is displayed.|
|Show Log||Displays a log window that shows log messages and errors related to Scripting Window.|
|Show Code Explorer||Displays a side tab that lists code segments.|
|Execute Script||Executes a script in Scripting Window.|
|Stop Script||Stops a running script.|
|Load Script from File||Load a script from a file.|
|Save Script||Saves a script.|
|Save Script as||Saves a script under a new name.|
To display the Available Objects and the Selected Objects windows in Scripting Window
Select View | Show Registered Objects.