Chat now with support
Chat with Support

Toad Data Modeler 7.2 - 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

XSL Transformation

This feature allows you to create user outputs for your physical models very fast. The output can be in any format that supports XSL language - e.g. HTML, PDF, CSV, text or XML.

You select among various XSL templates. Each template generates a different output (HTML, CSV etc.) Advanced users can customize the templates and modify their content to generate an output that will fit their needs.

You can generate the following reports or outputs:

  • Comments (HTML)
  • Complete XML (XML)
  • Entities (CSV)
  • Notes (HTML)
  • Tablespaces (HTML)
  • To Do Report (HTML)

To generate any of the outputs

Select Model | Generate Report | Reports / XSL Transformation.

Option Description

XSL Template Name

Shows types of various XSL templates that you can select.

Output File

Path where the output file will be saved. It corresponds with the path defined in Settings | Options | Paths | Reports.

Template Description

Gives information on the selected template.

More>>

Shows/hides options for advanced users interested in customization of the templates.

XSL File Location

Path where appropriate system template is stored. System templates shouldn't be modified. Via the button on the right, you can add other templates you created and that are missing in the box XSL Template Name.

Input Values

In this area, templates with parameters are displayed. You can edit them directly here.

Save XSD File As Allows you to save the XSD file without the necessity to open it in associated application.

Show XSD File

Shows the XSD file. The XSD file describes structure of source XML that is an input for XSL transformation.

Transform

Starts the process of transformation.

View

Shows the result.

Customize XSLT Templates

XSLT is an XML based language used for transformation of XML source documents into other documents. Output files can be XML, HTML, TXT, CSV, SVG, XSD and so on.

In general, for transformation of XML files it is necessary to specify:

  1. Source (XML)
  2. Template with instructions on how to convert a source to ouput (XSLT file)
  3. Output file (where to store the output)

Toad Data Modeler allows you to transform simplified XML structure to the selected output. The simplified XML contains less XML data than standard TXP files (TXP is a standard file suffix for Toad Data Modeler models, however, its structure is also XML.)

Where to Find the Simplified XML File?

You will not find it. You have to generate it. Every database system contains different items (sequences...), that's why also simplified XML structures for MySQL and Oracle may differ.

To generate XML file

  1. Click Model | Generate Report | XSL Transformation and from the XSL Template Name box select Complete XML (XML).

  1. Click Transform and View to open the generated simplified XML file for your database model. You will see a structure of XML file and a content of your model, including entity names, attribute names, information about relationships, comments etc.

For creation of new XSL templates, it is useful to work with XSD files. XSD files describe structure of XML source file and helps you to understand the XML structure, what nodes may appear in XML and so on. You can click Show XSD File or Save XSD File As to display or save XSD file for your simplified XML structure.

Predefined XSL Templates

By default, the following reports or outputs can be generated:

  • Comments (HTML)
  • Complete XML (XML)
  • Entities (CSV)
  • Notes (HTML)
  • Tablespaces (HTML)
  • ToDo Report (HTML)

Using these predefined items you can generate report of all ToDo items, create CSV files with information about entity names, captions and descriptions etc.

Path to XSLT files

There are two folders where XSLT files are stored.

  1. System folder: C:\Program Files\Quest Software\Toad Data Modeler 3\XSL
  2. User-defined files: C:\Documents and Settings\<user name>\My Documents\Toad Data Modeler\<installation name>\XSL

Sample XSLT File

Special instructions, parameters

In all XSLT files there must be the following special instructions:

If you want to create a template only for selected target databases, use the following:

Parameters specified this way:

will display in the Input Values table of the XSL Transformation dialog.

Edit Existing XSLT Templates

  1. Copy the system XSLT template to your user section. Default locations are:

System: C:\Program Files\Quest Software\Toad Data Modeler 5.0\XSL

User: C:\Documents and Settings\<user name>\My Documents\Toad Data Modeler\<installation name>\XSL

  1. Edit the code then.

HTML Reports

HTML report is great for viewing information about your model objects in an interactive matter. HTML report can also contain images of workspaces, as opposed to RTF/PDF reports. It is also the only type of report you can generate for Metamodels.

To generate a HTML report:

  1. Click on Model Toolbar (or go to Model Menu | Generate Report | Run).

  2. In Select Format section, choose HTML format.

  3. In the next section, select the type of the HTML report.


  4. In Select File section, select the report location. You can either save the report to a folder, or you can publish it to a Toad Intelligence Central (TIC) server (see Basic TIC Actions for more information).

    Tip: You can generate localized reports. Download the appropriate language package from the community website and import it to Toad Data Modeler. See Dictionaries for more information.

  5. In the next section, you can choose the Report Layout. If you generate report for a large model, you should choose Frames - Top/Left menu. Generating Frameless reports consumes more RAM and viewing the report might feel sluggish on lower-spec PCs. Other than that, the layout choice is a purely cosmetic one.

  6. The What to Report section allows you to select specific object types that should be included in the report.

  7. Select Workspaces section allows to you specify for which workspaces the report should be generated.

    Note: The report will be generated for model objects based on the following rules:

    • When you check a specific workspace, all of its objects and an image of the workspace will be included in the report.
    • When you check Generate All Model Objects, all model objects will be included in the report.
    • Both rules respect the selection made in What to Report section.

  8. The final section contains several options allowing you to further customize the generated report. Click on Execute to generate the report. Once the report is generated, you can view it by clicking on Show.

RTF Reports

To generate a RTF report:

  1. Click on Model Toolbar (or go to Model Menu | Generate Report | Run).

  2. In Select Format section, choose RTF format.

  3. In the next section, select the type of the RTF report.

  4. In Select File section, select the report location. You can either save the report to a folder, or you can publish it to a Toad Intelligence Central (TIC) server (see Basic TIC Actions for more information).

    Tip: You can generate localized reports. Download the appropriate language package from the community website and import it to Toad Data Modeler. See Dictionaries for more information.

  5. The next section allows you to customize the look of your report. You can change the report Orientation, Font Settings and add Watermark.

  6. The What to Report section allows you to select specific object types that should be included in the report.

  7. Select Workspaces section allows to you specify for which workspaces the report should be generated.

    Note: The report will be generated for model objects based on the following rules:

    • When you check a specific workspace, all of its objects and an image of the workspace will be included in the report.
    • When you check Generate All Model Objects, all model objects will be included in the report.
    • Both rules respect the selection made in What to Report section.

  8. The final section contains several options allowing you to further customize the generated report. Click on Execute to generate the report. Once the report is generated, you can view it by clicking on Show.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating