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.
The front end has most of the requisite bells and whisstles, but every so ofen a query of the raw data or even a tweak of the raw data is needed. For me, this is where Toad Database Developer Tools comes in. I can get any selection of data quickly and easily exported to Excel and go from there.
Pros
SQL Query
Easy output to varying formats
Cons
Tools could be simplified a bit - Too many options
Likelihood to Recommend
I can only speak to my use need and use which is limited. I use it to acquire data for spicific analysis as required to do on any given day. I also have occasional need to tweak data directly. It works great for what I need and use it for. It would be unfair of me to look for less appropriate uses.
VU
Verified User
Manager in Information Technology (51-200 employees)
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.
VU
Verified User
Team Lead in Information Technology (501-1000 employees)
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.
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.
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
<ul><li>Accessing Oracle RDBMS</li><li>Exporting database data into spreadsheet format</li><li>Cross-database implementations (connecting different database software, i.e. bridging Microsoft SQL server to Oracle RDBMS)</li><li>Real-time database session monitoring</li><li>Visibility into database metadata without requiring explicit knowledge of data dictionary</li><li>Easy to install on common workstation operating systems</li><li>Access to RDBMS procedural code outside of non-graphical interfaces (i.e. ability to call dbms_datapump)</li></ul>
Toad for Oracle is used to connect to our Database. It is used to do query, write PL/SQL, execute and fine-tune our database queries for better performance and optimization.
Pros
Database query execution
Connection to various database
Multiple DB connections
Cons
DB query optimization
DB query auto formation
Improve explain plan
Likelihood to Recommend
Toad is very popular and widely used across organizations and teams. It is useful to connect to the individual database schema or if you have multiple database schemas. It can be useful when you need to connect to your development, test and production database simultaneously. The user interface is very friendly and easy to use for the newbie to advance database programmer.
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.
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.
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.
VU
Verified User
Technician in Finance and Accounting (10,001+ employees)
