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

23 Reviews

Enterprises (1,001+ employees)

Toad for Oracle is a great product

Rating: 10 out of 10

Incentivized

May 1, 2021

Use Cases and Deployment Scope

Toad for Oracle is being used by DBAs, application developers, and system analysts. It aids in issue troubleshooting, data validation, data comparison across systems, and easy application development testing.

Pros

Easy connections to databases
Easy to use UI
Robust Debug Tools
Great Explain Plan breakdowns
Excellent Customer Support and Training

Cons

Too many versions and options
Licensing too confusing across various versions and upgrades

Likelihood to Recommend

Toad for Oracle is an excellent resource for everyone from experienced DBAs to entry level analysts. Its just easy to use and a great tool to support application development work, testing, and database management. It is great for SQL server also, although less commonly used for that.

Christee Carter Selway

Sr. Manager, Distributed Systems, Retail Engineering, and ITSM Dvmt. in Information Technology at Office Depot (Retail, 10,001+ employees)

Vetted Review

15 years of experience

View profile

Toad is not better than SQL Developer

Rating: 6 out of 10

Incentivized

December 4, 2019

Use Cases and Deployment Scope

Toad was used comparably to Oracle SQL Developer. It's a good graphical interface to Oracle RDBMS and provides a bridge for non-native SQL developers and analysts. It's primarily used by the business analysts and database administrators. The demo version is feature-rich and provides limited support to database hardware monitoring.

Pros

Easy to install interface to Oracle RDBMS.
Ability to export data to many different spreadsheet software formats.
Converts common query language to standard ANSI SQL.

Cons

Toad is high-cost.
Not all tools are easy to navigate nor understand.
Error handling isn't as accurate as it should be.

Likelihood to Recommend

Accessing Oracle RDBMS
Exporting database data into spreadsheet format
Cross-database implementations (connecting different database software, i.e. bridging Microsoft SQL server to Oracle RDBMS)
Real-time database session monitoring
Visibility into database metadata without requiring explicit knowledge of data dictionary
Easy to install on common workstation operating systems
Access to RDBMS procedural code outside of non-graphical interfaces (i.e. ability to call dbms_datapump)

Maurice Samuels

DBA in Information Technology at Duquesne Light Company (Utilities, 1001-5000 employees)

Vetted Review

5 years of experience

Toad For Oracle - Way to Go

Rating: 8 out of 10

Incentivized

October 15, 2019

Use Cases and Deployment Scope

Toad is currently used by our DBA team and some of the development teams. It is primarily used for SQL building, SQL tuning exercises. We are also using it in DB design tasks. DBAs primary use it in their day to day operation. It is only used by oracle DBA team now. They use this to pull session information also.

Pros

SQL Formatting
Running multiple SQLs as multithreading operation
Data extract exports

Cons

Better syntax error information
Auto tracing options

Likelihood to Recommend

Toad is well suited with Oracle as it provides a mechanism to run multiple sqls at the same time against a single database. Performance and memory management of the tool is particularly good. The way it provides the explain plan generation is really handy when a developer needs to analyze their sqls in lower environment. It is also handy for DBA team for their daily operational tasks.

SUbrat Mishra

Account Director in Information Technology at CCC Information Services (Information Technology and Services, 1001-5000 employees)

Vetted Review

4 years of experience

A good alternative to Oracle SQL Developer

Rating: 7 out of 10

Incentivized

October 14, 2019

Use Cases and Deployment Scope

Toad for Oracle is used to interact with data in our Oracle Utilities Suite databases. It is also used by our DBAs to support those databases. We perform DML and DDL functions with the tool. It allows us to run more than 1 query at a time against the same database, unlike other products.

Pros

It is user-friendly for the most part.
It has all of the features you expect from a tool like it.
It allows you to run more than one query against the same database at the same time.

Cons

The date/time settings in Toad are kind of difficult to figure out. I have to use an ALTER SESSION command to format the dates so I can actually query date/time fields.
It seems to be updated too often. I get notifications very frequently about new versions being available.
The export function is difficult to use.

Likelihood to Recommend

Toad for Oracle is well suited for anyone who knows how to write SQL well. It has all the features you want although they're sometimes difficult to find. Toad is less well-suited for people brand new to writing SQL. SQL Developer is a little more user-friendly in my opinion. If the UI were better designed, it would be easily better than SQL Developer.

Aaron Baker

Senior Systems Analyst in Information Technology at Duquesne Light Company (Utilities, 1001-5000 employees)

Vetted Review

2 years of experience

Toad keeps me productive

Rating: 8 out of 10

Incentivized

October 2, 2019

Use Cases and Deployment Scope

This application is being used almost exclusively by our technical team. It provides a helpful environment for creating, testing and running SQL scripts. I really appreciate the library feature that allows me to save and catalog scripts for future use.

Pros

I appreciate the library feature that enables me to label and store previously created statements. These are saved off to a network share for future use.
I also really like the describe function that lists all fields in a table. This helps as I build new queries.
I wish I was better at using the tuning function. I have seen others use it and am very impressed with the graphical depiction of query costing.

Cons

I don't have any unmet needs from this tool. I mostly need more time to be able to get in and take advantage of its existing features.

Likelihood to Recommend

I mostly use this application to build SQL Queries. Its library and tuning aspects are very helpful.

Verified User

Technician in Finance and Accounting (Non-Profit Organization Management company, 10,001+ employees)

Vetted Review

3 years of experience

Working with Oracle Database made easy

Rating: 10 out of 10

Incentivized

January 18, 2019

Use Cases and Deployment Scope

My client organization is a big enterprise with thousands of Oracle Database instances. We bought unlimited organization level license of Toad for Oracle. This was done because almost everyone who works directly with Oracle Database used Toad, be it DBAs, developers, or testers. We have been extremely happy with the choice. I personally work on Toad for Oracle as a database administrator and developer. It gives you tons of features and makes working with Oracle Database super convenient.

Pros

Schema Level Administration: Toad for Oracle allows you to create and maintain schema objects conveniently. It's GUI interface is the best in this class of software. It's easy to learn and get used to.
Performance Monitoring: You can monitor database performance and long running transactions using Toad for Oracle interface. For most of the performance issues reported, i prefer using Toad for Oracle over Oracle's native tools like SQLPLUS or OEM.
Data Modelling: You can develop data models for your database design and generate scripts to create the objects in the database instance.
I like the ease with which Toad for Oracle lets you use features like SQL Loader, Export/Import, etc.

Cons

It sometimes hangs up if you are working on multiple Toad instances in parallel.
If you are running some few thousands statements through Toad, it's better you do it directly through SQL Plus interface. It takes way longer if you do it through the Toad for Oracle interface.
Toad for Oracle should consider including some graphs and histogram charts for performance monitoring . This will be especially useful for non-technical users like project managers.

Likelihood to Recommend

Toad for Oracle is very well suited for all Oracle implementations, be it single instance or RAC. It is best suited for use of Oracle DBA, Developer and Database Engineers.

I don't recommend Toad for Oracle for Project Managers or Solution Architects. This can be a pricier choice for these people. They can do fine with free options like SQL Developer.

Ravinder Gupta

Senior Oracle Database Administrator in Information Technology at CGI (Information Technology and Services, 10,001+ employees)

Vetted Review

7 years of experience

View profile

Toad: the best IDE for database developers

Rating: 9 out of 10

Incentivized

January 10, 2019

Use Cases and Deployment Scope

Toad for Oracle is used by all developers across my organizations. It is stable IDE for database developers and few DBAs in our organization can think of doing development in Oracle database without having Toad installed. It is mainly used by solution developers who design queries and test their performance using the explain plan module.

Pros

The UI of Toad has not changed much from the earlier versions and thus developers can focus on what they do instead of having to pay attention to the many redundant features which seem to come up every year.
Designing a query in toad is a breeze. It also helps while taking data dumps.
Performance analysis module of toad is also very robust providing graphic analysis of queries.
Toad is very reliable.

Cons

The full enterprise features come at a cost. Dell should think about how this wonderful solution can be made more viable for small companies.
Toad is not a very big player for non-RDMS DB clients.
All newer linguistics are not recognized by Toad.

Likelihood to Recommend

For a person who has newly been introduced to an RDMS database, Toad reduces the learning curve a lot by providing a very user-friendly UI on top of an Oracle database. The explain plan feature of Toad also helps a lot when it comes to optimizing queries. For someone who is not comfortable logging in to a box and taking data dumps, they can easily do so with the Toad user interface.

Dhruba Jyoti Nag

Associate in Information Technology at Cognizant (Entertainment, 10,001+ employees)

Vetted Review

7 years of experience

View profile

Great Platform for Data Management

Rating: 9 out of 10

Incentivized

December 8, 2018

Use Cases and Deployment Scope

Toad for Oracle is used to manage databases in our organization. Huge data generated in the oil and gas industry needs to be managed to make business decisions and managing such huge data needs an application which is able to handle such data. SQL builder helps to build queries which are used to extract data out of oracle databases. It is used across the organization so that everyone has the same data rather than having local databases in their system.

Pros

Manages huge volume of data and provides a platform to run queries. Not very expensive.
The SQL builder really helps those who are new to SQL. Very well integrated with other applications.
Very intuitive and user-friendly with lot of features and functionalities.

Cons

A Python platform to write scripts which can be used to extract and manage data would be really helpful.
Needs to be linked to more applications to import data such as SharePoint.
Reduced cost is like icing on the cake.

Likelihood to Recommend

While managing data one of the tasks is to work on a particular filtered data. In that case "views" play an important role. One can play with the the data on a particular dataset without disturbing the original data. Also it is very important to make sure everyone uses the same data in such a large organization which is updated to avoid any discrepancies.

Rajat Wadhwani

Process Data Engineer(Subsurface and Wells) in Engineering at Shell (Oil & Energy, 10,001+ employees)

Vetted Review

2 years of experience

View profile

The tool for Oracle

Rating: 8 out of 10

Incentivized

November 6, 2018

Use Cases and Deployment Scope

Toad is the best tool for SQL development, you can have thousands of tables and the indexation and current searches work fantastic, if I had to describe it in one word it should be fast.

Pros

Import/Export function where we are able to export the data in any of the format like .csv, xlsx, .txt etc., according to the number of rows required.
Database diagram - Easily able to generate the database diagram which will shows the relationship between objects.
Toad automation scripts and formatting SQL scripts for developer.
Transform function and cleansing the data.

Cons

License Key is costly since we have to pay rather than open-ended tool.
Some of the SQL commands are still not recognized by Toad like (NOSQL), PIVOT etc.
Reporting will not be exact since this is not owned by database production. An example of that is SSRS reports run by Microsoft.

Likelihood to Recommend

What I think is the best in this software is that it has a complete environment to work within the data base, you don't have to work with other tools. This is the form you have to work in, there you can see from a field of a table to the database relation, which is really complete. Backing up the databases is pretty easy, and you can restore it also in a few clicks.

Akshay Malhotra

Sr. Applications Analyst in Information Technology at Kate Spade & Company (Apparel & Fashion, 5001-10,000 employees)

Vetted Review

8 years of experience

View profile

Toad is a de-facto database development tool, but a bit much for just analytics

Rating: 8 out of 10

Incentivized

September 12, 2018

Use Cases and Deployment Scope

As a non-profit healthcare system consisting of hospitals and clinics, we run an electronic health record system to capture patient data and clinical workflow logs and store them into an enterprise data warehouse (EDW). The EDW is being used as a data source to pursue for clinical research and data driven quality improvement and clinical workflow optimization. Toad has been used as a database tool for our EDW team, by data developers who create data marts and ETL processes, and data analysts who extract KPIs from clinical data in the EDW.

Pros

Toad is a de-facto standard tool for data developers and analysts. Generally speaking it provides almost every function needed to manage data in EDW with great performance and stability.
The nature of clinical data is big-sized: one table may have billions of rows. Toad provides critical functions to manage SQLs, e.g. Top SQL that can monitor and manage SQLs using CPU power and network bandwidth, so that EDW administrator can optimize ETL operations in the best efficiency.
Many of our data analysts are not computer science backgrounded (having clinical / nursing background). Toad provides great auditing tools such as Tuning Lab or SQL Scanner, so that data analysts can train themselves with guidance of the tool.

Cons

It is an expensive tool, compared to SQL developer or Orange. It is worth its price, but for developers or analysts who need basic functions, other tools are good enough.
It is a heavy tool. It consumes a lot of resources especially when it runs in laptop. If hardware is not good enough and runs big query on top of that, Toad sometimes crashes.
Look and feel of ER diagram should be improved. We had need of printing it out and put on the wall and it wasn't so beautiful.

Likelihood to Recommend

Toad is basically a tool for everything about database management. We have two groups of people; one as data developers who create and manage data marts in our EDW, the other as data analysts who perform analysis using data in the EDW. Toad is perfect for data developers, but a luxury for data analysts.

Verified User

Project Manager in Research & Development (Hospital & Health Care company, 10,001+ employees)

Vetted Review

4 years of experience

Loading Reviews List....

Toad is a de-facto database development tool, but a bit much for just analytics

Rating: 8 out of 10

Incentivized

September 12, 2018

Use Cases and Deployment Scope

Pros

Toad is a de-facto standard tool for data developers and analysts. Generally speaking it provides almost every function needed to manage data in EDW with great performance and stability.
The nature of clinical data is big-sized: one table may have billions of rows. Toad provides critical functions to manage SQLs, e.g. Top SQL that can monitor and manage SQLs using CPU power and network bandwidth, so that EDW administrator can optimize ETL operations in the best efficiency.
Many of our data analysts are not computer science backgrounded (having clinical / nursing background). Toad provides great auditing tools such as Tuning Lab or SQL Scanner, so that data analysts can train themselves with guidance of the tool.

Cons

It is an expensive tool, compared to SQL developer or Orange. It is worth its price, but for developers or analysts who need basic functions, other tools are good enough.
It is a heavy tool. It consumes a lot of resources especially when it runs in laptop. If hardware is not good enough and runs big query on top of that, Toad sometimes crashes.
Look and feel of ER diagram should be improved. We had need of printing it out and put on the wall and it wasn't so beautiful.

Likelihood to Recommend

Verified User

Project Manager in Research & Development (Hospital & Health Care company, 10,001+ employees)

Vetted Review

4 years of experience