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 »
See What’s New with Toad Data Modeler
Check out the latest features and enhancements.
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
  • 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

System Requirements

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

PlatformPentium IV
MemoryMinimum 256 MB , 1 GB recommended
Hard Disk SpaceMinimum 160 MB, 320 MB recommended
Operating SystemMicrosoft Windows 2000 Professional Edition (Service Pack 4)
Microsoft Windows XP (32-bit or 64-bit)
Microsoft Windows Server 2003 (32-bit or 64-bit)
Microsoft Windows Vista (32-bit or 64-bit)
Microsoft Windows Server 2008 (32-bit or 64-bit)
Microsoft Windows 7 (32-bit or 64-bit)
Database ServerDB2 UDB v. 8 (LUW), 9.0 (LUW), 9.5 (LUW), 9.7 (LUW)
DB2 z/OS v. 9, v.10
Ingres 9.3, 10.0
Access 2000/2002/2003/2007/2010
SQL Server 2000, 2005, 2008
SQL Azure
MySQL 5.0, 5.1, 5.5
Oracle 9i, 10g, 11g R1, 11g R2
PostgreSQL 8.1, 8.2, 8.3, 8.4, 9.0
Sybase ASE 12.5, 15, 15.5
Sybase SQL Anywhere 11
Cloud Database ServerOracle databases running on Amazon EC2
SQL Server running on Microsoft SQL Azure
MySQL database running on Amazon RDS
Additional SoftwareAdobe Acrobat Reader 7.0 or later (for viewing the Installation Guide)

Virtualization Support

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

ApplicationToad 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.
ServerToad Data Modeler has been tested with VMware Server 2 running on Windows 7.

Language Supported:

  • US English

Take a tour of Toad Data Modeler

Screenshots 1 of 13

Screenshot #2 Screenshot #3 Screenshot #4Screenshot #5 Screenshot #6Screenshot #7Screenshot #8Screenshot #9Screenshot #10Screenshot #11Screenshot #12Screenshot #13

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
Image 1 of 13 Entity Relationship Diagrams – Logical 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
Image 2 of 13 Entity Relationship Diagrams – Physical Models

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
Image 3 of 13 Basic Database Design

Advanced Database Design

  • Define database specific objects
  • Create Functions, Procedures, Sequences…
Image 4 of 13 Advanced Database Design

Verification

  • Verify your model
  • Generate a list of errors, warnings and hints
Image 5 of 13 Verificationh

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
Image 6 of 13 SQL Code Generation

Reverse engineering

  • Connect to already existing database system
  • Reverse engineer database structure and visualize it or
  • Import and visualize SQL file (some databases only)
Image 7 of 13 Reverse engineering

Generate HTML/RTF/PDF Report

  • Select report type
  • Choose layout and design
  • Define options for report generation
Image 8 of 13 Generate HTML/RTF/PDF Report

Create Documentation

  • Document your database structure
  • HTML/RTF/PDF formats are available
Image 9 of 13 Create Documentation

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)
Image 10 of 13 Compare, Convert, Merge or Generate Change Scripts

Project and Subversion, Gallery

  • Keep track of changes using subversion
  • Group models into projects
  • Store frequently used part of models to Gallery
Image 11 of 13 Project and Subversion, Gallery

Refactoring Utility

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

Customization

  • Customize forms
  • Reposition existing items
  • Create new textboxes, checkboxes and customize the application
Image 13 of 13 Customization

Support Docs, Notes and Guides

Release Notes and User Guides back to top
 

Learn More

Related Products

Support for This Product