Toad Database Developer Tools Reviews & Insights

Score8 out of 10

124 Reviews and Ratings

Community insights

TrustRadius Insights for Toad Database Developer Tools are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

GUI interface: The GUI interface of Toad for Oracle is highly praised by users, who consider it to be the best in its class. They find it easy to learn and get used to.

Performance monitoring capabilities: Users appreciate the performance monitoring capabilities of Toad for Oracle, which allow them to effectively monitor database performance and long running transactions. It is preferred over native tools like SQLPLUS or OEM for most performance issues.

Data modeling features: The data modeling features in Toad for Oracle are highly regarded by users. They find it easy to develop data models for their database design and generate scripts to create objects in the database instance. Users particularly value the ability to utilize features like SQL Loader, Export/Import, etc. with ease.

Toad Database Developer Tools Reviews

7 Reviews

Mid-sized Companies (51-1,000 employees)

Living in the fast lane with Toad.

Rating: 9 out of 10

Incentivized

May 9, 2021

Use Cases and Deployment Scope

Toad is not a free product. Therefore, where I work, only the "real" Oracle developers get a license, while the rest can use the free SQL Developer. Which is a great product that can do anything you want or need. The fact that the Oracle developers get to use Toad does not mean that the company I work for has money to spare... it means it has some real added value where the company is willing to pay for. Toad is a real powertool that is used by Oracle developers as well as DBA's.

Pros

Tools, tools, tools... for a developer this is a dream product. You feel as if you're in a airplane cockpit where the whole database is at your full control.
Quick links or shortcuts are particularly handy, write down a table name and shortcut directly to the definition. Same goes for packages and stored procedures.
If you know your way around, development goes really fast. One reason for this is the endless ways in which you can add screens and windows.

Cons

The power and control it gives is at the same time kind of a negative thing. There's too many options available, even when you don't need them. For simple database operations it's sometimes easier to just use SQL Developer since navigation is way more intuitive and easy.
Related with the above: there is a steep learning curve. However, since this is the main tool for any Oracle developer, this is not that much of a problem.
If I remember well, Toad used to be free, some 20 years ago. Or at least had a free version. It would be nice to have a free version. The dedicated Oracle developers and DBA's won't use the free version, but all the rest of us developers might use it instead of SQL Developer. It would make communications between everybody somewhat easier.

Likelihood to Recommend

Well suited for development of stored procedures, packages, running scripts, and each and every DBA operation. Not very well suited for quick and simple querying. Toad seems to be overkill for simple things. Also, it's not very well suited for non-Oracle developers, who might be scared of by the endless amounts of options, tools and windows that Toad offers.

Verified User

Team Lead in Information Technology (Consumer Services company, 501-1000 employees)

Vetted Review

6 years of experience

Ribbit All About It! My Review of Toad for Oracle.

Rating: 10 out of 10

Incentivized

March 20, 2020

Use Cases and Deployment Scope

Toad for Oracle is being used by my team to manage our databases. Working with medical data, we use Toad to manage the data we store, which involved packages, sequences, procedures, and schemas. Toad makes it easy to manage schemas in different instances and make modifications quickly. It addresses many business problems like this.

Pros

Giving scripts for table modification commands.
Easy access of different instances and schemas.
Capabilities to monitor running packages.

Cons

Speed as to which changes can be made.
Efficiency of the tool.
The user interface could be better.

Likelihood to Recommend

Toad for Oracle is a great tool to use for teams who are managing a lot of data. We have 4 instances in which there are around a hundred schemas, each with tables and packages of their own. Toad for Oracle makes it easy to mange these tables in the databases and make the required changes as necessary.

Jatel Desai

Programmer Analyst in Information Technology at Department of Industrial Relations (Government Administration, 501-1000 employees)

Vetted Review

3 years of experience

View profile

Oracle DB Toad is aight

Rating: 8 out of 10

Incentivized

September 14, 2019

Use Cases and Deployment Scope

It solves our integration projects and database queries, and the need for transactions to set up standards for our customers.

Pros

Sql database queries.
A developer database tool.
Integration support.

Cons

License support that is manageable.
Previous version support.
Better installer and push support.

Likelihood to Recommend

It's used for our database support users, for Oracle DB, and to solve standards for queries and other things that SQL developer doesn't have.

Verified User

Administrator in Information Technology (Information Technology and Services company, 51-200 employees)

Vetted Review

3 years of experience

The perfect program for database manipulation and administration!

Rating: 10 out of 10

Incentivized

May 20, 2019

Use Cases and Deployment Scope

We are currently using Toad for Oracle to monitor the various Oracle databases and their connections between each other. We also utilize the editor part to run SQL queries on our databases and to modify entries via script as needed. It allows us to see a visual layout of what entries we're working with instead of using command prompt / SQL plus.

Pros

Allows for modifying table data
Performs powerful, complex commands by clicking a single button
Offers tools for running complex scripts on tables and exporting for reports

Cons

There is a steep learning curve to use the software
Slightly expensive
Can cause significant damage to your databases if you are untrained

Likelihood to Recommend

If you have very large, complex databases, then Toad for Oracle is the software you need for monitoring and manipulating the data. However, if you have only one or two small databases with very little data, you might be better off saving the money and using a free SQL script compiler instead.

Verified User

Employee in Information Technology (Transportation/Trucking/Railroad company, 201-500 employees)

Vetted Review

2 years of experience

Toad for Oracle is well suited for technical advanced database admin

Rating: 6 out of 10

Incentivized

September 27, 2018

Use Cases and Deployment Scope

I mainly use Toad to access our Oracle database. The Oracle database is hosting all of the legacy data. Not many people in the organization use it. The main purpose of using Toad was to export legacy data.

Pros

The interface offers a lot of customization options.
Connecting time to the server was on par with other database software.
Exporting wizard is easy to use.

Cons

Query run time were extraordinarily long. Though It could be caused by lack of support on the legacy database.
User interface is too busy, difficult to navigate and sometimes confusing
Common function NOLOCK is not recognized

Likelihood to Recommend

Toad is well suited for advanced users like DBA. I was an analyst so I had a more difficult time using it. I would imagine DBA would use it with no problems because of its high level of customization.

Verified User

Analyst in Product Management (Consumer Services company, 201-500 employees)

Vetted Review

1 year of experience

Beginners best to use Toad

Rating: 10 out of 10

Incentivized

July 16, 2018

Use Cases and Deployment Scope

Toad for oracle is easy to use for the new users who are working on databases. It is used by some of science and technology teams at our workplace. We mostly use it to store JSON data a lot.

Pros

Filtering result set records quickly
Great graphical user interface.
Easy to use.
Visual treat for writing queries.

Cons

Can improve while connecting to schemas. It's quite slow some times.

Likelihood to Recommend

For beginners instead of using sqlplus editor toad helps a lot write / execute queries.

Verified User

Engineer in Information Technology (Information Technology and Services company, 501-1000 employees)

Vetted Review

2 years of experience

Toad for Oracle Makes Oracle database simple

Rating: 10 out of 10

Incentivized

November 6, 2017

Use Cases and Deployment Scope

It is being used by one department. We have different sources which feed data into our Oracle database at a Co-location. Toad for Oracle makes it easy to access the database and work with the tables and schema. When having to either add tables or build out a new database for new data, Toad for Oracle make it a breeze to get those tasks done in no time with minimal effort.

Pros

One key feature I use all the time is the stored procedure Toad makes it easy not just to create them but also to debug them which speeds up the process to get them down with minimal downtime.
The other key feature I just love is the query builder since we have a lot of tables it makes it easy to build a query using data from the different tables by just using the table name.
Toad for Oracle makes it easy to connect to different databases via the GUI.

Cons

I would like to see them build in version control for stored procedures, right now I have to cut and paste the procedure before making changes to it in case something happens in my coding.

Likelihood to Recommend

In my mind there is no other way to work with Oracle except to use Toad for Oracle, it makes everything you do with Oracle Databases so much easier. The GUI is very easy to use and things are arranged in a way that makes sense. If you do a lot of stored procedure then it is a must-have for it makes creating, troubleshooting and deploying so easy.

Robb Glietz

Technology Advisor in Information Technology at RE/MAX Advantage Redlands (Real Estate, 51-200 employees)

Vetted Review

10 years of experience

View profile

Loading Reviews List....

Living in the fast lane with Toad.

Rating: 9 out of 10

Incentivized

May 9, 2021

Use Cases and Deployment Scope

Pros

Tools, tools, tools... for a developer this is a dream product. You feel as if you're in a airplane cockpit where the whole database is at your full control.
Quick links or shortcuts are particularly handy, write down a table name and shortcut directly to the definition. Same goes for packages and stored procedures.
If you know your way around, development goes really fast. One reason for this is the endless ways in which you can add screens and windows.

Cons

The power and control it gives is at the same time kind of a negative thing. There's too many options available, even when you don't need them. For simple database operations it's sometimes easier to just use SQL Developer since navigation is way more intuitive and easy.
Related with the above: there is a steep learning curve. However, since this is the main tool for any Oracle developer, this is not that much of a problem.
If I remember well, Toad used to be free, some 20 years ago. Or at least had a free version. It would be nice to have a free version. The dedicated Oracle developers and DBA's won't use the free version, but all the rest of us developers might use it instead of SQL Developer. It would make communications between everybody somewhat easier.

Likelihood to Recommend

Verified User

Team Lead in Information Technology (Consumer Services company, 501-1000 employees)

Vetted Review

6 years of experience