Toad Data Modeler Reviews

• Ability to save my custom queries and Macros
• Faster connectivity to databases than a SQL developer

UI/UX can be improved according to functionality.

I've used it for eight to nine months.

There were issues due to the databases connectivity.

No issues encountered.

I worked in a pre-deployed environment.

It was done by my employer's in-house IT team.

I find the script/text editing feature most valuable, as well as the ability to run scripts of any size against databases.

It saves time by allowing automated, as opposed to manual, data entry into databases.

I have used the product for about three years in total, at two different employers.

The issues I had in installation were due to database access restrictions.

It was straightforward from the software side.

I had the software implemented through in-house teams.

It is a very good option for creating and editing SQL scripts, especially large ones that I have run in support of government billing applications.

1. Horizontal layout for each connected database connection
2. Easy way to generate statements for select,insert and update
3. Easily identify the locks on the table and processes running on the database and their source information
4. It is easy to Explain plan
5. It is easy to optimize the query using optimizer
6. Table import and export are easy
7. Formatting of sql also makes it easy to read

1. Toad crashes sometimes and it will lose all the saved database information
2. We cannot the execute SQL, offline easily (If you are creating a MV and if you shut down your laptop it won't create it)