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

Features and Tools

Application Variables

In Toad Data Modeler you can use application variables in:

  • Names/captions in Physical Model Explorer and Designer - use the percent button () to enter the selected variable in the current cursor location
  • DDL Script and Change Script Generators
  • Report Generation - Check Resolve Application Variables in Report Wizard | Options
  • Default Values (e.g. relationship names) - Select Settings | Default Values to adjust default values for objects
  • About Templates
  • Certain properties (most notable ones are SQL, Before Script, After Script)

Note: To see where you can use application variables, see Expert Mode Menu | Reference Guide. If a property has Resolve Application Variables attribute, you can use application variables within it (e.g. PEREntity - BeforeScript).

Application variables are usually resolved during SQL script generation.

Accessing Application Variables

Application variables can be easily accessed via the which can be found in object properties forms. When you click it, the Application Variable dialog opens and displays available variables and in which properties they are supported.

Syntax of Application Variables

  1. <%ApplicationVariableName%> - Example: <%Date%>
  2. <%<% ApplicationVariableName %>%> - Example: <%<%Date%>%>

Syntax 2) is useful in Templates and Default Values. Variables using this syntax will be resolved only during SQL Script/Report generation as opposed to variables with syntax 1) which are resolved immediately after creating an object.

Note: OwnerName, OwnerCaption - Explanation: E.g. For attribute it is an entity, for entity it is a model. It has nothing to do with object Owner/Schema.

Application Variables - Examples

Application Variables and User Template

Application Variables and Default Values

Example: Define a new name and caption for relationships of your model.

Caption: <%ParentTableName%> - <%ChildTableName%>

Name: <%ParentTableName%>_<%ChildTableName%>

Application Variables and Self-Relationships

Possibility to define a name for propagated attributes in self-relationships (e.g. via prefix, suffix etc.)

Select Settings | Options | Physical Model | Self Relation Attribute Name/Caption.

Example: Name: FK_<%ParentAttributeName%>, Caption: Foreign <%ParentAttributeCaption%>

Application Variables and Text Properties

You can use some text properties of particular objects in a similar way as application variables.

Example: You want to see your comments in a pop-up window on the Workspace whenever you point your mouse cursor at the entity name. But comments are not displayed this way, only notes. OR You want to generate notes in SQL script.

Possible solution: In the Entity Properties form,

  1. On tab Notes, write the text, e.g. My Description.
  2. On tab Comments, write: <%Notes%>.
  3. Confirm Apply.
  4. See the SQL Preview tab.
  1. Click to display a quick help bar with application variables that are possible to use in entity.

Example: Name is property of entity. It is of widestring data type, so you can use application variable <%Name%>. Author is not property of entity. However, you can use the application variable <%Author%> in entity. - All the application variables that you can use for entity are available in the list.

Note:

  • Double-click the selected application variable to use it in the box/place where you have your cursor.
  • Press Esc to close the dialog.

Application Variables in Wizards

Sync & Convert Wizard| page Settings and Report Wizard | page Options and the Resolve Application Variables checkbox.

Uncheck the checkbox to compare models/generate report without resolving the application variables.

Check the checkbox to compare models/generate report while resolving the application variables.

Export/Import

Related Documents