Chat now with support
Chat mit Support

Toad Data Modeler 7.3 - 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 Microsoft SQL Server 2019 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 Oracle 19c PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 PostgreSQL 10 PostgreSQL 11 PostgreSQL 12 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

Manage Templates

To create a user template

  1. In Template Editor, select Object Category (e.g. Triggers).
  2. Click and write the code in the Template body for template window.
  1. Confirm the changes Commit or Commit and Save.

To change properties of a user template (e.g. location, visibility etc.)

  1. Select a template.
  2. Click to open the Template Properties dialog.
  3. Check properties of the template.

    Option Description
    General Tab  
    Name Write a name of your template.
    Property Selection Select for which database, object type and property the template should be used.
    Active Template Select this checkbox to display the template in the Templates box in the object Properties dialog.
    Default Template Select this checkbox to set this template as default in particular object Properties dialog.
    Generate SQL Only

    Select this checkbox to set the property Generate SQL Only enabled in the object Properties dialog.

    Available Pre-defined Templates

    Package

    Select a package where you want to save the template. By default, user packages are saved to My Package.txg.

    Where Templates Are Stored

    Lock Package Sets the ReadOnly property of the .txg file on the disk.
    Visibility Tab Select databases and database versions for which the template should be valid and available.
  4. Confirm OK
  5. Confirm Commit and Save.

To set a template as Default

  1. Select a template in Template Editor.
  2. Select the Default checkbox for the template.
  3. Confirm Commit and Save.

To disable a template

(not to display it in the combo-box in the object Properties dialog)

  1. In Template Editor, find the template that you want to disable and uncheck the Active checkbox.
  2. Confirm Commit and Save.

To delete a template

  1. In Template Editor, select the template that you want to delete.
  2. Click .
  3. Confirm Commit and Save. Now it is not possible to edit the template.

Note: After you reopen the Template Editor, the deleted item will be removed. The template has been deleted from the .txg package.

Toad for Oracle Templates

Toad Data Modeler allows you to import the templates you created in Toad for Oracle and refresh them at any time you need.

We do NOT recommend to modify these templates in Toad Data Modeler as export of the templates to Toad for Oracle is not possible.

Toad Data Modeler imports Toad for Oracle templates of the following objects:

  • Stored Procedures
  • Functions
  • Entity Triggers
  • Packages (object in Oracle)

To import Toad for Oracle template to Toad Data Modeler

  1. Open Template Editor - Select Settings | Template Editor.
  2. Click .

    Note: This option is available only if you have Toad for Oracle installed on your computer.

  3. Confirm OK and take notice of new templates in Template Editor (e.g. "Default" templates). 

Note: The Toad for Oracle templates are stored in TOAD.txg file at: C:\Documents and Settings\user name\My Documents\Toad Data Modeler\Installation name\Packages\{GUI}

To refresh your existing Toad for Oracle templates in Toad Data Modeler

Click .

 

Toad for Oracle Auto Replacement Words

Toad Data Modeler allows you to use Application Variables in your templates.

Toad for Oracle templates can have Auto Replacement Words.

During import of Toad for Oracle templates, the Toad for Oracle Auto Replacement Words are replaced by Toad Data Modeler Application Variables. See how:

Toad for Oracle Auto Replacement Word Toad Data Modeler Application Variable
%YourObjectName% <%FullName%>
%Date% <%Date%>
%SysDate% <%Date%>
%DateTime% <%DateTime%>
%Time% <%Time%>
%TableName% <%TableFullName%>
%UserName%' <%Author%>

Note: Not all Toad for Oracle Auto Replacement Words are supported.

Tips and Tricks

Rename

To rename your model

Right-click the model name in Model Explorer (or Application View) and select Rename.

To rename objects on Workspace

  1. Select the object (entity, view etc.) and press F2.
  2. Enter new name.
  3. Click anywhere else on Workspace to apply changes.

To rename object in Model Explorer

Select an object and press F2 or right-click an object and select Rename.

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen