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 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.
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.
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.
VU
Verified User
Engineer in Information Technology (Information Technology and Services company, 501-1000 employees)
Within my team we use Toad to view data in Oracle tables and easily slice and dice it for analysis purposes. I am not a technical person that has the ability to write complex SQL to view the data within tables so I have to rely heavily on the schema browser with Toad to view the data. This allows me to quickly filter on data in specific tables to get the information with ease.
Pros
Great interface to filter on data in tables with ease using the UI
The options for exporting a table subset of data to an excel or text file is great. There are a lot of options to choose from with the date fields and how to handle number of records, null values, conversion of field types to others and ability to update the where clause for pulling the data
The sql generator interface is great for a non-technical person to drag and drop tables, fields, and where clauses and run queries
Cons
Possible improvement of the schema browser capabilities. I know that this is not the primary use of this software but if there were a few more features with the schema browser we could use this for a lot more data analysis versus having to go to Tableau or Hyperion reporting.
The process of adding tnsnames to the oracle file through Toad could be a little more user friendly.
Have a way to protect your PASSWORD file within TOAD. This file has a tendency to get overwritten or removed frequently making you loose all your saved connections within TOAD.
Likelihood to Recommend
Our team has started to go directly to the data with Toad versus using a reporting tool like Hyperion or Tableau. This allows us to cut out the reporting aspect and go directly to the data. This review is tailored to a non technical group of people. With a little bit of training the tool is extremely useful for anyone trying to slice and dice data quickly.
VU
Verified User
Analyst in Information Technology (Information Technology and Services company, 10,001+ employees)
This software was used for my client project (a top US bank). Most of the projects across the entire organization used Toad for Oracle although the decision to use a particular software like this was based on two main factors: 1. Budget 2. Suggestion from the technical leads of individual projects.
I was part of the Business Intelligence team and we used Toad for ad-hoc-query analysis, data analysis, to verify SQL logic, database development, code formatting, extracting reports and much more.
Pros
Ease of use with a well designed and pleasant interface.
The Schema browser is very simple and easy to navigate between different levels of a database schema which is a great time saver! It looks simple and its use will make more sense when you use tools that don't have this feature.
The ability to run multiple queries in a single window without having to save the queries.
Very useful built-in features that help in better code analysis, are easy for comparing different versions of code, extracting reports, query evaluation, code formatting and editing.
Better code de-bugging capabilities.
Cons
Occasionally, the application crashes without warning. Leaving me to start my work all over again. This was not a frequent issue but it does happen from time to time.
Likelihood to Recommend
It is well suited for day to day database development, database management, code analysis, query optimizations, executing ad-hoc queries, generating reports and much more.
Toad was used by different teams within our project and was suitable for users of all skill levels:
Database development team: For end-to-end database development.
Database support team: For fixing bugs in code logics within procedures and functions and for monitoring day to day jobs.
Database Administrator: For administering database and automating code analysis, performance analysis etc.
Business Intelligence/ Reporting team: For Analysing SQL logics and comparing database vs. report logic and output.
QA team: For creating test data and validating various functionalities.
Front-end team : For verifying database objects that are linked to front-end application.
