Toad Data Modeler is a  tool allowing users to visually create, maintain, and document new or existing database systems, and to deploy changes to  across different. It is used to construct logical and physical , compare and synchronize models, generate complex DDL, create and modify scripts, and reverse and forward engineerand systems. Toad’s data modelling software is used for database design, maintenance and documentation. 

Toad Data Modeler was previously called “CASE Studio 2” before it was acquired from Charonware by  in 2006.It was acquired  on September 28, 2012. On October 31, 2016, Dell finalized the sale of Dell Software to which relaunched on November 1, 2016 as Quest 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 Data Modeler simplifies database design, maintenance and documentation — at a price your organization can afford. 

 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. 

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 Data Modeler simplifies database design, maintenance and documentation — at a price your organization can afford.

Visualization 

Visualize database structures and better understand existing databases and relationships. Create high-quality logical and physical data models. Reverse engineer existing database structures to view them in a diagram. Generate detailed HTML, RTF or PDF reports. 

 Data modeling 

Create quality database structures or make changes to existing models automatically, and provide documentation on multiple platforms. Build complex logical and physical entity relationship models, and easily reverse and forward engineer databases. 

Database Flexibility 

Connect multiple databases natively and simultaneously, including Oracle, SAP, MySQL, SQL Server, PostgreSQL, DB2, Ingres, and Microsoft Access. Synchronize models with existing databases using Change Script Generations and Update Model features. Easily convert data structures from one database platform to another to support business migration initiatives. 

 What is toad database management? 

• Toad Software is a database management toolset from Quest that database developers, database administrators and data analysts use to manage both relational and non-relational databases using SQL. Take a proactive approach to database management. 

What is Toad Data Model? 

• Toad Data Modeler is a database design tool allowing users to visually create, maintain, and document new or existing database systems, and to deploy changes to data structures across different platforms. 

Installation 

Toad Data Modeler helps organizations create, maintain and document their database systems with an easy-to-use graphical interface into new or existing database structures. Toad Data Modeler enables users to reverse engineer database structures, update models, design and generate SQL, compare models and generate alter scripts, create HTML or RTF reports, in addition to versioning of database designs and creation of to-do lists. 

Installation Guide 

Getting Started 

Open and unzip the installation package that contains: 

• Installation file (MSI) 
• Release Notes (PDF) 
• Installation Guide (PDF) 

Pre-Installation 

Starting with Toad Data Modeler 5.4, all databases are now installed with the application. You can enable/disable them after installation in the application itself. 

To install Toad Data Modeler successfully, Administrator privileges are necessary. 

Toad Data Modeler supports side-by-side installation. 

• Upgrade – New version of Toad Data Modeler is installed to the same folder where the previous version was installed. 

• Side-by-side Installation – New version of Toad Data Modeler is installed to another location. 

1. Limitations of trial version: 30 – day trial period and multiple features limited to a maximum of 25 entities. 
2. Do NOT open and resave models originally created in a developmentally higher version of Toad Data Modeler (e.g. in v. 5.2.x) in lower version of Toad Data Modeler (e.g. in v. 5.0.5). 
3. Version 5.2 contains new system of relationship lines. Models created in version 5.1 and lower are automatically converted to the newer format. Backup your models prior to opening them in version 5.2 or newer.
4. Do NOT install commercial version to BETA version folders. BETA uses different folders for configuration files and other default directories than Toad Data Modeler Commercial version. You can install and use both versions on one computer. However, Do NOT install commercial version to BETA version folders. 
5. Import and export of settings between Toad Data Modeler versions is possible (see Settings Menu | Options | Import and Export buttons.) 

Freeware Version Information 

Freeware Version Limitations 

Freeware version of Toad® Data Modeler does not require licensing. 

Functionality Restrictions 

Freeware version of Toad Data Modeler has the following restrictions: 

• Save Model – You can save a model with max 25 entities. 

• Preview – You can preview a model with max 25 entities. 
• Print – You can print a model with max 25 entities. 
• Export to Graphic File – You can export a model with max 25 entities to graphic file. 
• Alter Report – You can generate alter report for a model with max 25 entities. 
• Report – PDF reports with watermark are limited to a maximum of 25 entities. Number of reported other objects is not limited. HTML and RTF reports cannot be generated. 

• XSL Transformation Report – You can generate the XSL Transformation report only for first 25 entities of the model. Other objects (procedures, functions etc.) don’t have any limitation. 
• SQL/DDL Script Generation – You can generate SQL/DDL script only for first 25 entities of the model. Other objects (procedures, functions etc.) don’t have any limitation. 
• Change Script Generation – This feature is not available at all. 
• Reverse Engineering – Reversing database schema is limited to 25 entities. Other objects have no limitation. 
• Undo – Only one step back is available in Freeware version. 

System Requirements 

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

Review the following information about Toad Data Modeler supported databases: 

Virtual Appliances 

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

This video shows you how to install Toad Data Modeler in your Windows environment. Minimum requirements are given, different installation scenarios are discussed and you will see a quick demonstration of the installation process. The Installation Guide documentation is also discussed, as it will give further details on more advanced topics such as silent installation. 

Toad Data Modeler on cloud For AWS

Major Features of Toad Data Modeler:

Multiple database support
Connect multiple databases natively and simultaneously, including Oracle, SAP, MySQL, SQL Server, PostgreSQL, DB2, Ingres, Microsoft Access and more.

Simplified database modeling
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.

• Installation Instructions For Windows

Installation Instructions For Windows

A) Click the Windows “Start” button and select “All Programs” and then point to Toad Data Modeler

B) RDP Connection: To connect to the operating system,

1) Connect to virtual machine using following RDP credentials :

• Hostname: PublicDNS  / IP of machine
• Port : 3389

Username: To connect to the operating system, use RDP and the username is Administrator.
Password : Please Click here  to know how to  get password .

C) Other Information:

1.Default installation path: will be on your root folder “C:\Program Files\Dell\Toad Data Modeler 6.1\”
2.Default ports:

• Windows Machines:  RDP Port – 3389
• Http: 80
• Https: 443

Configure custom inbound and outbound rules using this link

Installation Step by Step Screenshots