Toad Data Modeler

Data modeling tools that create high quality data models

Create high-quality data models and easily deploy accurate changes to data structures.

Toad™ Data Modeler helps you create high-quality data models. This data modeling tool enables you to easily deploy accurate changes to data structures across more than 20 different platforms.

This cross-platform database modeling software offers the following functionality:

  • Enables you to build high-quality logical and physical data models
  • Allows you to compare models and then synchronize them
  • Makes generating complex SQL/DDL fast and easy
  • Permits you to create and modify scripts
  • Enables you to reverse and forward engineer both databases and data warehouse systems

Features

  • Enables you to connect multiple databases natively and simultaneously; these include Oracle, Sybase, MySQL, SQL Server, PostreSQL, DB2, Ingres, MS Access and more
  • Helps you create quality database structures in addition to providing documentation on multiple platforms
  • Enables you to generate new database structures or make changes to existing models automatically
  • Allows you to build complex entity relationship models (logical and physical)
  • Lets you easily reverse and forward engineer databases
  • Permits importing of models from SQL scripts
  • Allows you to migrate structures across database platforms
  • Provides you with detailed reports on existing database structures
  • Enables you to add logical data to your diagrams to customize models
  • Facilitates synchronization of a model with your existing database using “ALTER” script generation (Oracle and SQL Server) and model merge features
  • Allows you to view relationships and work with attributes and columns from linked entities and tables
  • Enables quick and easy data access by allowing you to create project folders to store models, business requirements, specifications and other files

Specifications

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

loading

Toad Data Modeler

Take a tour of key functionality in Toad Data Modeler interface to experience its capabilities and ease of use.

Take a Screenshot Tour

Toad Data Modeler-Entity Relationship Diagrams – Logical models

Toad Data Modeler 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

Toad Data Modeler-Entity Relationship Diagrams – Physical models

Toad Data Modeler 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

Toad Data Modeler - Basic database design

Toad Data Modeler 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

Toad Data Modeler - Advanced database design

Toad Data Modeler Advanced Database Design

Define database specific objects

Create Functions, Procedures, Sequences…

Toad Data Modeler - Verification

Toad Data Modeler Verification

Verify your model

Generate a list of errors, warnings and hints

Toad Data Modeler - SQL code generation

Toad Data Modeler 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

Toad Data Modeler - Reverse engineering

Toad Data Modeler Reverse engineering

Connect to already existing database system

Reverse engineer database structure and visualize it or

Import and visualize SQL file (some databases only)

Toad Data Modeler - Generate HTML/RTF/PDF report

Toad Data Modeler Generate HTML/RTF/PDF Report

Select report type

Choose layout and design

Define options for report generation

Toad Data Modeler - Create documentation

Toad Data Modeler Create Documentation

Document your database structure

HTML/RTF/PDF formats are available

Toad Data Modeler - Compare, convert, merge or generate change scripts

Toad Data Modeler 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)

Toad Data Modeler - Project and subversion, gallery

Toad Data Modeler Project and Subversion, Gallery

Keep track of changes using subversion

Group models into projects

Store frequently used part of models to Gallery

Toad Data Modeler - Refactoring utility

Toad Data Modeler Refactoring Utility

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

Toad Data Modeler - Customization

Toad Data Modeler Customization

Customize forms

Reposition existing items

Create new textboxes, checkboxes and customize the application