Toad Data Modeler
Visit shop.quest.com to buy this product online.
Buy online »
Toad World adds value to your Toad experience by providing free education and revealing new functionalities — along with
time-saving tricks and tips.
Visit the community »
Quest Support
  • Global Coverage
  • Highly Skilled Engineers
  • Commitment to Customer Satisfaction
  • Flexible Support Offerings
Learn more »

Toad Data Modeler

Powerful and Cost-Effective Data Modeling and Database Design

Toad™ Data Modeler helps you create high-quality data models and easily deploy accurate changes to data structures — at a fraction of the cost of many other solutions.

With this cross-platform database modeling software, you can:

  • Build high-quality logical and physical data models
  • Compare and synchronize models
  • Generate complex SQL/DDL
  • Create and modify scripts
  • Reverse and forward engineer databases and data warehouse systems

Features

  • Use a product that natively supports multiple databases, including Oracle, DB2, SQL Server, Sybase, MySQL, PostreSQL, Ingres, MS Access, and more
  • Create quality database structures and provide documentation on multiple platforms
  • Generate new database structures or make changes to existing models automatically  
  • Build complex entity relationship models – both logical and physical
  • Reverse and forward engineer databases with ease
  • Import models from SQL scripts
  • Migrate structures across database platforms
  • Generate detailed reports on existing database structures
  • Customize models by adding logical data to your diagrams
  • Synchronize a model with the existing database using “ALTER” script generation (Oracle and SQL Server) and Model Merge features
  • View relationships and work with attributes and columns from linked entities and tables
  • Create project folders to store models, business requirements, specifications, and other files for quick and easy access

Sys Reqs

Before installing Toad Data Modeler, ensure your system meets the following minimum hardware and software requirements:

Platform

Pentium IV

Memory

Minimum 512 MB , 4 GB recommended

Hard Disk Space

Minimum 200 MB, 400 MB recommended

Operating System

Microsoft Windows XP (32-bit or 64-bit, Service Pack 2)
Microsoft Windows Vista (32-bit or 64-bit)
Microsoft Windows Server 2003 (32-bit or 64-bit, Service Pack 2)
Microsoft Windows Server 2008 (32-bit or 64-bit)
Microsoft Windows Server 2008 R2 (64-bit)
Microsoft Windows 7 (32-bit or 64-bit)
Microsoft Windows 8 PRO (64-bit)

Database Server

DB2 UDB v. 8 (LUW), 9.0 (LUW), 9.5 (LUW), 9.7 (LUW), 10.1 (LUW)
DB2 z/OS v. 9, v.10
Greenplum 4.1, 4.2
Ingres 9.3, 10.0
Microsoft Access 2000, 2002, 2003, 2007, 2010
Microsoft SQL Azure
Microsoft SQL Server 2000, 2005, 2008, 2012
MySQL 5.0, 5.1, 5.5
Oracle 9i, 10g, 11g R1, 11g R2, 12c
PostgreSQL 8.1, 8.2, 8.3, 8.4, 9.0, 9.1, 9.2
SQLite 3.7
Sybase ASE 12.5, 15, 15.5, 15.7
Sybase IQ 15.2
Sybase SQL Anywhere 11
Teradata 13

Cloud Database Server

Oracle databases running on Amazon EC2
SQL Server running on Microsoft SQL Azure
MySQL database running on Amazon RDS

Additional Software

Any PDF reader (for viewing the Installation Guide)

Virtualization Support

Review the following information about using Toad Data Modeler in virtual environments:


Application

Toad Data Modeler has been tested for Citrix support on Windows XP using the XenApps 5.0 Server.

Desktop (VDI)

Toad Data Modeler has been tested with the following:
Quest vWorkspace 7.0 running on Windows XP (32-bit)
Note: Problem during print on virtual printer - The problem occurs only in case of print from local machine (all printers from local machine are visible on vWorkspace). If the virtual printer is installed on vWorkspace directly, the problem doesn't occur.

Server

Oracle VM 3.0

Toad Data Modeler has been tested with VMware Server 2 running on Windows 7.

Note: Toad Data Modeler may works correctly in virtualization environments other than the tested ones. In case of virtualization servers, support for Toad Data Modeler is provided on the basis of supported operating systems.

Screenshots

Entity Relationship Diagrams – Logical Models

Entity Relationship Diagrams – Logical Models

Design new database structures using Logical or Physical entity relationship diagrams

Create basic objects and model inheritance in logical model

Define settings for conversion from logical to physical model

Entity Relationship Diagrams – Physical Models

Entity Relationship Diagrams – Physical Models

Add entities, relationships and views to your diagrams

Define other database specific items like Procedures, Triggesr, Domains, Sequences…

Categorize entities and/or divide large models to smaller parts

Basic Database Design

Basic Database Design

Define properties of Entities, Attributes and Relationships comfortably

Propagate foreign key attributes to child entities automatically

Change or modify settings and let the tool to update data in child entities

Advanced Database Design

Advanced Database Design

Define database specific objects

Create Functions, Procedures, Sequences…

Verification

Verification

Verify your model

Generate a list of errors, warnings and hints

SQL Code Generation

SQL Code Generation

Define types of objects for SQL code generation

Define settings how to generate SQL code

Select entities and other objects and generate SQL code automatically

Reverse engineering

Reverse engineering

Connect to already existing database system

Reverse engineer database structure and visualize it or

Import and visualize SQL file (some databases only)

Generate HTML/RTF/PDF Report

Generate HTML/RTF/PDF Report

Select report type

Choose layout and design

Define options for report generation

Create Documentation

Create Documentation

Document your database structure

HTML/RTF/PDF formats are available

Compare, Convert, Merge or Generate Change Scripts

Compare, Convert, Merge or Generate Change Scripts

Compare two models

Merge two models

Convert model from one target database to another system

Generate change scripts (Alter Scripts)

Project and Subversion, Gallery

Project and Subversion, Gallery

Keep track of changes using subversion

Group models into projects

Store frequently used part of models to Gallery

Refactoring Utility

Refactoring Utility

Rename objects and use Refactoring Utility to change properties of other objects, e.g. Stored procedures, views etc.

Customization

Customization

Customize forms

Reposition existing items

Create new textboxes, checkboxes and customize the application