Toad Data Modeler
Watch how easy it is to create high-quality logical and physical data models with Toad Data Modeler — a simple-to-use data modeling software tool for database design, data structure modification and database documentation.
Easy-to-use, cross-platform database modeling software
Easily create high-quality data models. Toad Data Modeler enables you to rapidly deploy accurate changes to data structures across more than 20 different platforms. It allows you to construct logical and physical data models, compare and synchronize models, quickly generate complex SQL/DDL, create and modify scripts, as well as reverse and forward engineer both databases and data warehouse systems. Toad's data modeling software simplifies database design, maintenance and documentation — at a price your organization can afford.
Features
Multiple database support
Connect multiple databases natively and simultaneously, including Oracle, SAP, MySQL, SQL Server, PostgreSQL, DB2, Ingres, Microsoft Access and more.
Simplified data modeling tool
Create quality database structures or make changes to existing models automatically, and provide documentation on multiple platforms.
Logical and physical modeling
Build complex logical and physical entity relationship models, and easily reverse and forward engineer databases.
In-depth reporting
Easily generate detailed reports on existing database structures.
Model customization
Add logical data to your diagrams to customize your models.
Synchronization with your database
Synchronize a model with your existing database using ALTER script generation (Oracle and SQL Server) and model merge features.
Effortless migration
Simply migrate structures across database platforms.
Unmatched visibility
View relationships and work with attributes and columns from linked entities and tables.
Data access with project folders
Easily gain data access by creating project folders to store models, business requirements, specifications and other files.
Tour
ER diagrams — logical models
ER diagrams — physical models
Basic database design
Advanced database design
SQL code generation
Reverse engineering
Create documentation
Model sync and convert wizard
Specifications
- Processor
1GHz or faster 32-bit (x86) or 64-bit (x64) CPU
- Memory
Minimum 1GB, 4GB recommended
- Hard disk space
Minimum 400MB, 1GB recommended
- Operating system
- Microsoft Windows 10 (64-bit)
- Microsoft Windows 8.1 Pro (64-bit)
- Microsoft Windows 8 Pro (64-bit)
- Microsoft Windows Server 2012 (64-bit)
- Microsoft Windows Server 2008 R2 (64-bit)
- Microsoft Windows Server 2008 (32-bit or 64-bit)
- Microsoft Windows 7 (32-bit or 64-bit)
- Microsoft Windows Vista (32-bit or 64-bit)
- Microsoft Windows Server 2003 (32-bit or 64-bit, Service Pack 2)
NOTE: Microsoft .NET Framework 3.5 is required on first application start.
- Application
Toad Data Modeler has been tested for Citrix support on the Citric XenApp 6.5 Server.
- Desktop (VDI)
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 should not occur.
- Server
Oracle VM 3.0
Toad Data Modeler has been tested with 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.
- Supported model types
- Logical
- Universal
- Physical
- Supported databases
- DB2 z/OS v.11
- DB2 z/OS v.10
- DB2 z/OS v.9
- DB2 LUW v. 10.5
- DB2 LUW v. 10.1
- DB2 LUW v. 9.7
- DB2 LUW v. 9.5
- DB2 LUW v. 9
- DB2 LUW v.8
- Greenplum 4.2
- Greenplum 4.1
- Ingres 10.0
- Ingres 9.3
- Microsoft Access 2007-2010
- Microsoft Access 2000-2003
- Microsoft Azure
- Microsoft SQL Server 2014
- Microsoft SQL Server 2012
- Microsoft SQL Server 2008
- Microsoft SQL Server 2005
- Microsoft SQL Server 2000
- MySQL 5.7
- MySQL 5.6
- MySQL 5.5
- MySQL 5.1
- MySQL 5.0
- Oracle 12c
- Oracle 11g R2
- Oracle 11g R1
- Oracle 10g
- Oracle 9i
- PostgreSQL 9.5
- PostgreSQL 9.4
- PostgreSQL 9.3
- PostgreSQL 9.2
- PostgreSQL 9.1
- PostgreSQL 9.0
- PostgreSQL 8.4
- PostgreSQL 8.3
- PostgreSQL 8.2
- PostgreSQL 8.1
- SQLite 3.7
- SAP ASE 16.0
- SAP ASE 15.7
- SAP ASE 15.5
- SAP ASE 15
- SAP ASE 12.5
- SAP IQ 15.2
- SAP SQL Anywhere 11
- Teradata 13
- Other databases (Universal Model)
Download the free trial to see the full list of requirements.
Resources
Why Data Modeling is Still Relevant
There are those who think that data modeling is passé or no longer relevant. After all, data modeling theory is more than 30 years old and some data modeling tools have been around for up to 20 years. In this paper, Domain Expert Bert Scalzo discusses sev
Toad Training Day NZ
Toad Training Day - Auckland, 5 December, 2017Join us from 8.30 am -12 pm NZSTQuest® is back, and we’re excited to show you how to simplify data management with our powerful, new versions of Toad® – the leading productivity toolset for database professionals. We’re committed to helping database administrators, developers and analysts save hours each day, increase accuracy and work smarter, not harder. You’ll s
- More Resources
- Communities
- Research Docs
Take the next step
Related Products
Toad Data Point
Simplify data access, preparation and provisioning.
Toad for Oracle
Develop and manage Oracle databases with less time and effort.
Toad for IBM DB2
Improve and accelerate daily development and administrative tasks on Linux, Unix and Windows
Toad for SQL Server
Reduce time spent on SQL Server application development and database administration.
Toad for SAP Solutions
Streamline SAP development and administration.
Support & Services
Product Support
Self-service tools will help you to install, configure and troubleshoot your product.
Support Offerings
Find the right level of support to accommodate the unique needs of your organization.