Chat now with support
Chat with Support

Toad Data Modeler 6.2 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
About Physical Data Modeling Benefits of Physical Data Model Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects Model Properties Model Statistics
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Projects Reports Reverse Engineering Scripting and Customization SQL Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Supported Databases Connection Types by Database DB2 UDB v. 8 (LUW) DB2 v. 9 (LUW) DB2 v. 9.5 (LUW) DB2 v. 9.7 (LUW) DB2 v. 10.1 (LUW) DB2 v. 10.5 (LUW) DB2 z/OS v. 9 DB2 z/OS v.10 DB2 z/OS v. 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 Microsoft Access 2000/2002/2003 Microsoft Access 2007/2010 Microsoft Azure SQL Database Microsoft Azure SQL Database V12 Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 Oracle 9i Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 PostgreSQL 8.1 PostgreSQL 8.2 PostgreSQL 8.3 PostgreSQL 8.4 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 SQLite 3.7 Sybase ASE 12.5 Sybase ASE 15 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
Legal Information

Create New Project

Features and Tools > Projects > Create New Project

Projects are used to group multiple models, files and other items.

To create a new project

  • Select File | New | Project

  • Check Create TDM Directory Structure to create a project with a predefined directory structure
  • Check Use Version Control to create a version controlled project. In the following steps you will need to configure it in order to create a new project. You can set up Version Control system for your projects anytime later

To select a version control system

  • Select a type of version control system:
  • Git - Enter the path to the Git client executable (e.g git.exe)
  • Subversion - Enter the path to the Git client executable (e.g svn.exe)
    • Check Use Read Only Locking Mechanism to enable locking files (set read-ony attributes to them)
    • Check Non Interactive to disable all interactive prompting
    • Check No Authentication Cache to not save authentication tokens into cache
  • Click Next to enter details of your repository

To setup your repository

  • Subversion - Enter the path (server address) to your subversion repository
    • Enter your User Name and Password
    • Check Checkout an existing repository into the working directory to checkout the files into your project folder

  • Git - Check Initialize Local Repository to initialize your local Git repository
    • Check Configure Remote Repository to enter details of your remote Git repository, click Next
    • Enter the path to your local Git repository and check Clone an Existing Repository to the Working Directory if you want to pull the latest files from your remote repository

NOTE: The working directory for your SVN/Git repository is the root folder of your new project.

Add Existing Models to Project

Features and Tools > Projects > 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.





 

 

Reports

XSL Transformation

Features and Tools > 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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating