Toad Data Modeler

{{Infobox software

| name = Toad Data Modeler

| logo =

| screenshot = Toad Data Modeler.png

| caption =

| latest release version = 7.3{{Cite web |title=Toad Data Modeler 7.3 - Release Notes |url=https://support.quest.com/technical-documents/toad-data-modeler/7.3/release-notes |access-date=2022-04-17 |website=support.quest.com}}

| latest release date = {{Start date and age|2020|10|19}}

| latest preview version =

| latest preview date =

| operating system = Windows

| platform =

| language =

| status =

| genre = Database modeling tools

| license =

| website = {{Official}}

}}

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. It is used to construct logical and physical data models, compare and synchronize models, generate complex SQL/DDL, create and modify scripts, and reverse and forward engineer databases and data warehouse systems. Toad's data modelling software is used for database design, maintenance and documentation.

Product History

Toad Data Modeler was previously called "CASE Studio 2" before it was acquired from Charonware by Quest Software in 2006.{{Cite web|url=https://www.bloomberg.com/research/stocks/private/snapshot.asp?privcapid=13560153|title=Charonware s.r.o.: Private Company Information - Bloomberg|website=www.bloomberg.com|access-date=2017-12-19}} Quest Software was acquired by Dell on September 28, 2012.{{Cite news|url=https://www.ecnmag.com/news/2012/07/dell-buying-quest-software-236-billion|title=Dell buying Quest Software for $2.36 billion|date=2012-07-02|work=Electronic Component News|access-date=2017-12-19}} On October 31, 2016, Dell finalized the sale of Dell Software to Francisco Partners and Elliott Management, which relaunched on November 1, 2016 as Quest Software.{{Cite news|url=https://www.quest.com/community/news/b/press-releases/posts/quest-launches|title=Quest Launches as an Independent Software Company Backed by Francisco Partners and Elliot Management|newspaper=Quest Community|access-date=2016-11-01}}

Features/Usages

Multiple database support - Connect multiple databases natively and simultaneously, including Oracle, SAP, MySQL, SQL Server, PostgreSQL, Db2, Ingres, and Microsoft Access.
Data modelling tool - Create database structures or make changes to existing models automatically and provide documentation on multiple platforms.
Logical and physical modelling - Build complex logical and physical entity relationship models and reverse, forward, and engineer databases.
Reporting - Generate detailed reports on existing database structures.
Model customization - Add logical data to user diagrams to customize user models.

All Toad products typically have 2 releases per year.

Other features

Model Actions (Compare Models, Convert Model, Merge Models, Generate Change Script)
Version Control System (Apache Subversion)
Naming Conventions
Auto Layout
Multiple Workspaces
Scripting and Customization
Automation
Object Gallery
Full Unicode Support
Integration with Toad for Oracle