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
NOTE: Exist in Model field has four states:
Manage External Objects
External Dependencies Explorer Actions
|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
There are three types of models in Toad Data Modeler:
Select Model | Properties.
|General||General information on the model (project, model, author, company, version etc.)|
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.|
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.
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.
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.
In Toad Data Modeler, you can create multiple graphical representatives of an object - Shortcuts.
You can create shortcuts of these objects:
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.
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.
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
Create a shortcut of the Customer entity on one WS - Borrowing WS:
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
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.
- 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)
- 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.