A simple-to-use data modeling tool. Verse 1 in the 12 Days of …

Our gift to you this season is wrapping up our favorite blogs about a product into a collection, with a song to go with each! Each week in December, stay tuned as we add on to the song and post new verses in our version of "The 12 Days of … Projects."  Watch the video below.

Watch the video!

The first verse of "The 12 Days of Projects" is about Toad Data Modeler.

With each new post, hear one more verse of our version of "The 12 Days of … Projects."  At the end of the month, we'll post the entire song with a summary and links to our favorite posts. Can you guess which Toad product will be next?

Keep reading! The following blogs are my favorite collection of Toad Data Modeler videos. 

5 essential Toad® Data Modeler videos

[Photo of female tourist with a map. You need a Toad Data Modeler map.]

It’s the time of year where the days are getting shorter and at Quest Software® we’re all about getting things done faster and easier. If you’ve followed my previous blogs, you know when tasks are complex, people are less and less likely to do them. Toad® Data Modeler makes it easy to create detailed data models of your favorite Relational Database Management System (RDBMS).

Santa has a list and he checks it twice. Why? Because he wants to make sure he gets it right before flying off around the world making his deliveries. That’s why you should have a model that maps out your database. Like Santa, you can look it over, check it twice, make sure you understand what you’ve got, solve issues quickly, and get it right. Figure out where your database is naughty or nice.

By the time you finish this blog and watch these videos you can have a model of your database.

Why do you need a database model?

Having models makes it easier to understand the database structure and how all your tables and entities relate to each other. This knowledge will help you in resolving issues as well as communicating changes to other teams. Having models can help make sure the DBA and developers are on the same page in regards to schema design.

If you’re a systems engineer, developer, DBA, or data architect, check out these five essential videos that will help get you started:

Introduction to Toad Data Modeler

How to Create a Model

How to Generate DDL Scripts and Reports

How to use the Sync and Convert Wizards

How to Reverse Engineer and Manage Models in Toad Data Modeler


I hope that by watching these five videos you’ll have a database model you can “gift” to your DBA, data analyst, or application developer. You can help make it easier for them to work with the database, help them understand how the table entities relate to each other, and how changes can affect the database. I hope you can see how easy it is to get started making ER Diagrams with Toad Data Modeler.

Learn more

Toad Data Modeler enables business analysts to rapidly connect to and view data structures across more than 20 different database platforms including Oracle, SQL Server, MySQL, PostgreSQL and IBM DB2. It allows you to reverse engineer both databases and data warehouse systems as well as re-engineer from one database type to another. Toad Data Modeler is an extremely cost effective, simple-to-use data modeling tool, ideally suited to someone new to data modeling.

Whether you are currently a Toad Data Modeler customer or just getting started with our free 30-day trial, learn more and access the Toad Data Modeler User Guide.

If you're in a trial and Toad Data Modeler is helping you access and prepare data for faster business insights, buy it now or contact a sales representative.


Got questions?

If you have any questions, please post questions to the Toad Data Modeler forum on Toad World.


Share on social media

If you think your colleagues would benefit this blog, share it now on social media with the buttons located at the top of this blog post. Thanks!


About the Author

Mathew Phan

Mathew Phan began his career as a technical support engineer for Toad for Oracle soon after graduating from the University of California, Irvine, where he obtained a bachelor's degree in computer and information science. Mat has devoted his entire 14-year career with the Toad family of database solutions and held various positions helping to shape the direction and growth of Toad. Early in his tenure, his focus was on Oracle databases from a developer point of view. Now as a systems consultant, he continues to work with customers to build effective solutions that meet their needs.

Start the discussion at forums.toadworld.com