Toad Data Modeler Packages

Instructions here

Instructions here

Target database: DB2 LUW v 10.5
Author: Petr Sklar

This package contains macro for adding Extended Properties to all objects of selected object type. The package is valid for SQL Server 2005 – 2014 models.

Blog article:  

• adding extended properties to all objects sql server models

Instructions here

Example that shows how to modify generation of DDL for Microsoft SQL Server 2008, 2012 and 2014.

This package fixes problem reported here:

"Hello,

I am using version 5.2.4.45 of TOAD.  I am trying to produce a report of various pieces of my Logical Data Model that contains more limited information, as the reports are 1,500+ pages long containing information about all the objects. However, when I un-check the 'Generate All Model Objects' checkbox in the Report Wizard, I get a MS JScript Runtime error that says the following:

Script:  BasicRTFLERReport
Description: Object Expected
Row: 3024
Column: 9

If I can only produce these huge reports, I don't think they'll be very useful to our business people or our developers.  I can see that I have a 'Reports/XSL Transformation…' object when printing out the Physical Data Model, but some of our key documentation (especially textual information around business rules and processes) is likely to be stored in the Logical Data Model. Can anyone tell me how to limit my output while printing out the Logical Data Model? 

Thank you!"

Instructions: Unzip the archive and replace both original application files in the folder where you installed Toad Data Modeler.

Default path to TBG file: C:\Program Files (x86)\Quest Software\Toad Data Modeler 5.2\Packages\System
Default path to TXM file: C:\Program Files (x86)\Quest Software\Toad Data Modeler 5.2\Packages\System\Metamodels

Instructions: Unzip the archive and replace original application file in the folder where you installed Toad Data Modeler. 

Default path: C:\Program Files (x86)\Quest Software\Toad Data Modeler 5.2\Packages\System

This small macro allows you to rename FK attributes. In case you use e.g. ID attribute as a primary key in all tables in your model and need to name FK columns with parent table names, e.g. CUSTOMER_ID, ORDER_ID and so on, use this macro and change names of existing FK attributes at once.

More information here

The package Object Phase contains the following features:

• New combo box available on Entity and Attribute forms
• In the combo box there are five Phases predefined
• Selected value are stored with model
• New macros for entities and attributes: Write Phase to Message Explorer, Delete all objects except objects in defined Phase, Set generate for objects in defined phase (only entities), Set phase

Database: MS SQL 2008
Size: 32 KB
Date: 26 May 2010
Author: Vaclav

This package is based on script written by Mario. It adds new menu item Order Entities Alphabetically to Macros menu.  After execution all entities will be sorted alphabetically (Click Model | Order of Generated Objects to see current settings.)

Additional Information:

• Original script

This package allows you to change identity type for selected entities on workspace or attributes in physical model explorer. Import the package to TDM.

After you import the package, you can:

1. Select entities on workspace and click Macros | Selected Objects | Change Identity Type. Or, you can:
2. Select any attribute in physical model explorer, right click on it and choose the item from Macros item from popup menu. Or you can also:
3. Search objects via Objects Viewer (Objects | Objects viewer) and then select attributes in result list, right click any of them and choose Macros item from popup menu.

This small macro allows you to generate DDL script for selected entity to a file. For every entity new Save Dialog will open.

This small macro will help you to find empty SimpleText graphics on your workspace. It also outputs statistics to Message Explorer/Log.

After you import the macro, new menu item will appear in TDM. Click Macros | Search graphics in menu.

When you reverse engineer database system used by Ruby on Rails, you may want to infer relationships. This add-in will help you.

Import the custom package, open your model and click Macros | Infer Relationships (Ruby).

Here's a sample model as specified in rails for the "medicine" model:

create_table "medicine", :force => true do |t|
t.string “sku”, :limit => 50
t.string “lic_number”, :limit => 50
t.string “name”, :limit => 50
t.datetime “lic_startdate”
t.datetime “lic_enddate”
t.integer “medicine_manufacturer_id”, :limit => 8
t.boolean “active”, :default => true
t.datetime “created_at”
t.datetime “updated_at”
end

And here's the model for "medicine_manufacturer"

create_table "medicine_manufacturer", :force => true do |t|
t.string “lic_number”, :limit => 50
t.string “name”, :limit => 50
t.string “addr1”, :limit => 50
t.string “addr2”, :limit => 50
t.string “town”, :limit => 50
t.string “postcode”, :limit => 50
end

In both cases you may be wondering "where's the ID?!?" — Rails creates an id column in each table by convention so the medicine_manufacturer_id can be assumed to refer to the ID column of the medicine_manufacturer model.

Use this macro to iterate through selected entities and create graphical notes with entity comments. If you wish to create graphical notes for all entities, use CTRL+A to select all objects on workspace and then click Macros | Display Entity Comments to run the macro.

This macro allows you to remove collation from all attributes from selected or all tables. Install the macro, open model for SQL Server and select tables on your Workspace. Then click menu Macros | Remove Collation. You can also right click any entity and choose Macros | Remove Collation to remove collation from all attributes in the selected entity. Information about removed collations will be written to Log.

This macro copies PK attribute descriptions to FK attribute descriptions. When FK attribute has a description nothing will be copied or overwritten. 

Install this macro and then click the Macros menu, select Copy Key Attributes Descriptions and then see Log. Of course, backup the model before you run the macro. (Note that each attribute should have its own description).

This macro allows you to change existing domain for selected attributes in Physical Model Explorer or Object Viewer or in selected entities on Workspace, Physical Model Explorer or Object Viewer.

If you wish to divide a large model into several workspaces (WS), first create a new workspace and then select objects that should be displayed in the WS. This macro offers you an alternative method. Select various objects (Entities, Views, Materialized Views) in the Model Explorer or Object Viewer, right-click any of them and select Add To New Workspace option. New WS is crated and objects are added in there.

Additional Information:

• How to quickly divide large database models

Run this macro if you wish to quickly add relationship lines to entities on your workspace.

Additional Information:

• How to add missing relationships to a Workspace

This macro allows you to add objects selected in the Physical Model Explorer, Object Viewer, or in a Workspace to an existing category, or quickly create a new category for the selected objects.

Objects that can be added to a category: Entities, Views, Relationships, Materialized Views, View Relationships.

Objects in a category are colored automatically, which should help you to get oriented in large models better.

This package adds new item to Entity properties form. At bottom right corner you will find DM Table Type combobox with values Not specified, Dimension, Fact.

Additional Information:

• Fact and Dimension tables in Toad Data Modeler

mport this package to Toad Data Modeler, open two models, compare them and generate standard HTML comparison report. Toad Data Modeler will generate to the output folder one additional file – XMLReport.xml. Open it in XML editor or your browser to see XML structure.

This package contains a macro that puts attributes Created and LastUpdated to second and third position in a table. After import the macro will add new menu item: Macros | Change Order of Predefined Columns.

To change this behavior or attribute names, edit the macro code via Script Explorer.

Notes:  In addition, you might find useful the following tip: Create the two attributes in one entity. Then navigate to the entity in Physical Model Explorer, right click the Created column and choose Macros | Copy Attribute to All Entities. Then click the Macros menu in toolbar and choose item Change Order of Predefined Attributes. It can't be faster 

Autogenerate the columns is not recommended.

This package adds Tablespace Assignment feature to Toad Data Modeler.

Additional Information:

• How to quickly assign tablespace to various objects

Instructions here

This macro adds possibility co copy Entity and Attribute Comments to Notes and vice versa.

Advantages:

• Notes can be displayed in diagram in form of a hint (move mouse cursor over entity or attribute in diagram to see Notes).
• If convert logical model to physical, descriptions will be converted to Notes. If you wish to use Comments, use the macro to copy Notes to Comments. (In section Scripts you can find short java script that transfers the Notes to Comments and deletes the Notes from Physical model).

How to use the package:

Select entities in your diagram, right click any of the entity and choose item Macros – Comments and Notes. If you do not select any entity, the macro will show confirmation dialog and offer possibility to change all entities in your model.

This package contains sample macro for custom verification of Oracle models.