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:

Hardware requirements

Processor

Pentium® IV

Memory  

Minimum 512 MB, 4 GB recommended

Hard disk space
Minimum 200 MB, 400 MB recommended

Software requirements

Operating system

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), 2008 R2 (64-Bit)

Microsoft Windows 7 (32-Bit or 64-Bit)

Microsoft Windows 8 PRO, 8.1 PRO (64-Bit)

NOTE: Microsoft .NET® Framework 3.5 is required on first application start.

Virtual appliances

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)

Server

Oracle VM 3.0

VMware® Server 2 running on Windows 7.

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

Database platforms

Supported model types
  • Logical
  • Universal
  • Physical
Supported databases
  • DB2® z/OS 9, 10
  • DB2 LUW 8, 9, 9.5, 9.7, 10.1, 10.5
  • Greenplum® 4.1, 4.2
  • Ingres® 9.3, 10.0
  • Microsoft Access® 2000-2003, 2007-2010
  • Microsoft SQL Azure®
  • Microsoft SQL Server® 2000, 2005, 2008, 2012, 2014
  • 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
  • SAP® ASE® 12.5, 15, 15.5, 15.7
  • SAP IQ® 15.2
  • SAP SQL Anywhere® 11
  • Teradata® 13

Download the free trial to see the full list of requirements.

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