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

Add Existing Models to Project

When you create a new project, you might want to add already existing models to it. This can be achieved in two ways:

  • In Application View or Model Explorer right-click a model and select Add to Project | *Project Name*.

    Project Add Model dialog displays and you can decide where to save the model.

or

  • In Application View, right-click your project and select Add Opened Model

  • Project Add Model dialog displays and you can choose from currently opened models and specify their location in the Project structure.





 

 

Generate Project Report

Now you can easily create a report for your Toad Data Modeler projects.

To create a project report

  • Right-click a project in Application View and select Report
  • Select the desired format for your report
  • Select the destination:
    • Intelligence Central
    • A designated folder
  • Choose your layout and style for the report and preview the look below
  • In Options select what you want to include in your report
  • In Models & Actions select which models you want to include and which Model Action you want to perform
  • After clicking Execute the report will be created in Intelligence Central or your local destination folder

Reports

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.

Related Documents