To begin with, it’s got a simple to use yet robust GUI. It’s so easy to connect to any database, and it can connect to heterogeneous DB’s including flat-files.
Querying could not be any easier (Query Builder), as well as learning an optimistic way of writing a query that is generated after selection from simple drag and drop. The wide variety of selections it offers, from data analysis, entity relationships, highlighting reserved words to help understand the query easily, drop-down to pick tables, column names, and explaining the plan for performance tuning the Query and many more are also valuable.
Improvements to My Organization
We used it extensively for data profiling, database management, data modelling, and data quality checks, apart from few other features. So, every time we needed to debug error in data, Toad proved extensively handy. Reusable queries help in faster debugging, and the data management has saved us a lot of time and money.
Room for Improvement
Although a lot of people get deceived by the name “Data Analysis”, it has capacity of any enterprise tool, but not to the point of creating multiple pipes in one integrated work-flow, batching the work-flows and running them parallel for data loads.
Use of Solution
I've used it for about three years.
I did not use Toad for any code or data deployment.
No. It is a very stable and high capacity tool. At one point, I could have 10 query windows open and would be connected to three databases at the same time, and not have a sign of instability.
No. Toad can handle large volumes of data with ease, helps maneuver around result data sets by click of mouse and it’s instantaneous with results.
Customer Service and Technical Support
Personally I have never had the need to call customer service. Most of the features I used were self-explanatory, and so understanding it was very easy. Technical Support
I have not had the need to call tech support either. I've never had any issues that required approaching Toad tech support, but I’m sure given the reputation, it must be good. Even if there was a problem, the error log is pretty simple to understand, and figure out what caused the problem.
I used SwisSQL data migration 5.0 and Oracle Developer. I wanted to connect to different databases, and be able to query across them, and Toad was perfect for that.
It was extremely easy to install, and once installed, I just needed a few things to connect to database, and I was all set. Very efficient tool.
It was done in-house. I used it in two different organizations, and both places had it already set up.
Toad is 100% value for money product. Especially for the features it offers vs. the price, it is totally worth it.
Pricing, Setup Cost and Licensing
If I have to manage a data warehouse project, Toad would be my first pick given the pricing it offers for the features. And, from a start-up to a large scale company, from five to 100 licenses, the pricing is a golden bargain.
Other Solutions Considered
- i-Series Navigator
- Oracle Developer
- SQL Plus
- SQL Pro
For any organization looking for a clean and robust all-in-one data tool, Toad is a good product to choose. There are a lot of tools in the market that promise a lot of things, but you will not be disappointed using Toad.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Jul 21 2015