Toad Data Modeler
Introducing Toad Data Modeler
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 database schema and scripts, as well as reverse and forward engineer both databases and data warehouse systems. Toad's database modeling tools simplify 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
Toad Data Modeler
Create high-quality data models and easily deploy accurate changes to data structures
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
How DataOps Is Democratizing Data Analytics
In this White Paper by DBTA Lead Analyst Joe McKendric, you’ll learn about the advantages DataOps provides, as well as best practices to implement DevOps in your organization.
Upgrading Quest Toad for Greater Security
This Technical Brief details Quest’s adherence to software security standards for continually testing and delivering versions of Toad products that you can safely install and run.
Quest Partner Webcast FY21 Q2 EMEA
Quest has the technology solutions your customers need to connect, manage and secure a remote workforce.
Quest Partner Webcast FY21 Q2 NAM + LATAM
Quest has the technology solutions your customers need to connect, manage and secure a remote workforce.
Quest Partner Update FY21
Rapidly developing and unprecedented world events have challenged organizations to quickly adapt to a new reality. Recent events have forced governments to enact social distancing measures and business closures that have disrupted daily life and work.Quest & One Identity understand the complex chall
The simple way to convert an Oracle database to a new database - Ask Toad
With the emergence of open source database software solutions, more companies are looking to break free from the grip of high cost database software. But, just as quickly as management sees the savings, data architects and DBAs see the headaches from making this change a reality. Toad Data Modeler s
- More Resources
- Communities
- Events & Demos
- Research Docs
- Videos
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.