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:

Hardware requirements

ProcessorPentium® IV
MemoryMinimum 512 MB, 4 GB recommended
Hard disk spaceMinimum 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.

Resources

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 - 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 - 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)