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

Modifying Items

Items in Gallery can be easily modified in a temporary model and the changes can be saved immediately.

  1. In Gallery Explorer, open your Gallery, right-click the item(s) you wish to modify and select Modify....

  2. The item(s) will be placed into a temporary model and you will be able to modify them. The exact way to modify the items varies depending on the number of objects and whether they are shortcuts or not:
    • One object (not shortcut) - the Properties dialog of the objects will be opened right away.
      Example - Entity added to a Gallery by dragging it from Model Explorer.
    • One object (a shortcut) - the object will be shown on workspace, you can view and change its Properties.
      Example - Entity added to a Gallery by dragging it from Workspace.
    • Multiple objects (not shortcuts) - no Properties dialog or Workspace will be shown, you will have to open Properties by locating the object in Model Explorer.
      Example - Two entities added to a Gallery at once by dragging them from Model Explorer.
    • Multiple objects (shortcuts) - the objects will be shown on Workspace, you can view and change their Properties.
      Example - Two entities added to a Gallery at once by dragging them from Model Explorer.
  3. One way or another, you should be able to modify the item(s) as you need. Once you're done, click the Save to Gallery button on File Toolbar.

  4. In the opened dialog, you can choose if you want to save the changes made to the modified item and its related items.

 

 

 

 

Gallery Explorer

This windows is capable of displaying all of your Galleries and their objects and it also allows you to change their structure.

The Explorer toolbar contains several options:

Option Description
New Gallery Creates a new Gallery as described in Basic Actions.
Open Gallery Opens an existing Gallery file (.txgall file format)
Save Gallery Saves recent changes made to Gallery.
Properties Displays Gallery Properties - Name, Decription, Path.
New Folder

Creates a new folder in the Gallery.

Delete Selected Item

Deleted the selected object.

Close Gallery Closes (not deletes) the selected Gallery.

Items in the Explorer also have the following unique right-click options:

Option Description
Save as (Gallery) Allows you to save Gallery as a .txgall file to the selected location.
Item properties (Item) Allows you to modify item properties (Name, Author, Descriptio) and view its objects.
Modify (Item) Allows you to modify the stored item in a separate model and synchronize the changes with the item in the Gallery. See Modifying Items for more information.

Model Verification

Toad Data Modeler allows you to verify your models. You can choose the items you want to verify, find out what errors and flaws your model contains and use quick fixes to resolve any issues.

To verify your model

  1. Select  Model Menu | Verify Model... (also CTRL+F9).
  2. On the Model Objects tab you can mark items for verification. Select either entire object group types or single objects.
  3. On the Verification Settings tab select the rules that should be part of the verification. To save the settings, click Save & Verify.
  4. The result of the Model Verification is shown in Verification Log, which is displayed automatically. To display the log manually, select Windows Menu | Verification Log. Objects that did not pass the verification are also marked by error/warning icons in Model Explorer.

Model Verification Form

Model Objects tab - lists all objects and object group types in your model. Checked object are those that will be verified.

Verification Settings tab - Here you can enable/disable rules that should be considered during verification. Use the buttons on the top of the form to check/uncheck all errors/warnings/hints at once.

Rules are database dependent, the following screenshot shows rules for Microsoft SQL Server 2012.

Verification Log

Verify Model results are displayed in Verification Log.

Toad Data Modeleroffers Quick Fixes - recommended solutions for problems and issues found by Model Verification. Quick Fixes are accessible for problematic objects both in Verification Log and Physical Model Explorer, in right-click menu.

The Verification Log toolbar contains several buttons:

Button Option Description
Tree View Switches Verification Log to tree view where the problem description, affected objects and quick fix suggestion can be all seen. Note that you cannot ignore messages or remove them from ignored in this view.
Show Errors/Warnings/Hints When enabled, Errors/Warnings/Hints are shown in Verification Log.
Ignore Message Marks the selected message as ignored.
Remove Message from Ignored Removes the selected message from ignored list.
Show Ignored Messages

Shows/hides ignored messages.

Verify Form Displays Model Verification dialog.
Verify Verifies model using the last saved settings.
Save Verification Log Saves all verification messages (including the ignored ones) to a CSV file.

On Form Verification

Errors, warning and hints can be displayed directly in the Object Properties form, at the bottom. Every time you make changes to the object and confirm, the object is verified and all issues are displayed at the bottom, similar to the screenshot below. Quick Fixes are not available in this mode.

On Form Verification can be enabled/disabled in Settings Menu | Options | Model . You can also decide what kind of verification messages should be shown - errors/warning/hints.

Syntax Validity

SQL Preview tab now highlights errors in SQL script syntax.

  • Check Syntax Validity to perform syntax checks in SQL Preview for the following objects:
    • Procedure, Function, View, Materialized View
    • User Data Type, Package (Oracle only)
  • Options are available in Options | Model | Physical Model | Verification | SQL Syntax Options
  • Syntax Validity check is supported for the following databases:
    • IBM DB2 LUW, IBM DB2 z/OS, Microsoft Azure SQL Database, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SAP Anywhere, SAP ASE, SAP IQ, Teradata

Settings

Model Verification can be configured for each specific database. Go to Settings Menu | Options | Model | Physical Model | *Target Database*.

In the Verificator frame you can enable/disable verification rules or change their category, e.g. Empty Object can be shown as an error instead of warning.

Syntax validity check may be disabled in Settings | Options | Model | Physical Model | <database> | Syntax Validity checkbox

 

Data Generation for SQL Server

Use Toad Data Modeler random data generation to quickly and easily create data for your databases. Data generation is supported for SQL Server 2005 and onwards

To generate data

  1. Double click any of your entities to open Entity Properties
  2. Setup your Attributes and switch to Data tab to generate your data
  3. Click Add to add one record, click Generate to add a specified number of new records

To work with records

  • Click Delete to remove the selected record and Clear to clear out all your generated data. Cleared data appears grayed out
  • Click Settings to disable/enable attributes and adjust minimum and maximum values for generation of data for each column (attribute) for the current model
  • Click Settings | Options | Model | Physical Model | Microsoft SQL Server | Generating Data to adjust default data generation settings for all MS SQL Server models. When you change any of these default values it will be carried on to all your SQL Server models

TIP: Click <%> to add application variables in Attributes in order to use them in your generated data

Related Documents