Likelihood to Recommend Discoverer is well suited as a reporting tool where data integration doesn't play a major role. Discoverer suits very well situations where a user has to run a query every day. Discoverer reports can be scheduled and the user can just view the data instead of running the query manually. Also, Discoverer takes away the pain of managing the database credentials. Discoverer is not well suited to situations where the whole enterprise wants to view the same dashboard. Discoverer is more of a departmental BI tool. Discoverer doesn't offer many options to integrate data unless one has to create and handle integration using PL/SQL.
Read full review Appropriate for general querying and some DBA work. It's the universal least-offensive solution for most environments - not best of breed, but not subject to unusual/extensive requirements. It just works. On the other hand, some functionality (e.g. data import/export, snippets) are perfunctory and minimal and seem to be either difficult or impossible to automate. If you need to streamline those operations, you'll be forced to rely on third-party solutions that mostly work on top of (instead of with) TOAD.
Read full review Pros SQL friendly which allows for fast adoption for those users who know how to write in SQL. This makes integration with other programs much easier. Accessing data is very fast even with larger data sets. The layout is clean and organized similar to a spreadsheet which allows for easier viewing and analyzing of the data. Read full review Export data into excel. Export data into excel using a pivot table functionality. Navigation between windows is intuitive and easy to understand. Good for SQL novices and experts alike. Read full review Cons There is always room for more scalability and optimization of performance. Oracle BI changes a lot from version to version. A smoother transition into a new version would be very helpful. Oracle BI's reporting tool is a little hard to use at first. The UI/UX of the tool can use improvement. Read full review The workflow is a relatively new feature. Quest is adding additional functionality and the workflows are useful now. Would be nice if the 'Automate' feature was a bit easier to use. Would be nice if some of the SQL Editor features in the traditional interface worked better in the new workflow interface (although, these are being fixed with each release). Would be nice if there were fewer releases. Read full review Usability I find Toad Data Point easy to use for both the novice and the experienced business analyst. If all you desire is to access data and create spreadsheets...this is a snap. Toad Data Point actually has cool data analysis features built into it. The newer workflow interface makes automating steps a snap
Read full review Alternatives Considered Discoverer was already in place when I joined the company so I was not involved in the selection process. However, I have been involved in the review of Discoverer as compared to alternatives including Business Objects, OBIEE, and SSRS. On a cost benefit analysis Discoverer always came out on top. Changing to another tool never provided enough additional functionality to overcome the cost of conversion and ongoing maintenance.
Read full review Although Toad and
UltraEdit are both great products, from an SQL standpoint Toad is a much better editor and troubleshooter.
Read full review Return on Investment We have used Discoverer to respond to state sales and use tax audits and saved the company more than the cost of the product. Discoverer has thus assisted in our objective of managing costs. Discoverer is used to provide reports for EEOC reporting assisting our goal of complying with all government requirements. Read full review It is the least common denominator - not particularly optimized for our environment or workflows. Hangs or slowdowns add anywhere from 5% - 7% for projects utilizing large/complicated data setts. (This could be due to other IT-imposed constraints and not entirely due to TOAD.) Trying to perform some operations requires reading documentation and experimenting in order to figure out the TOAD-specific approaches and commands. It just works (when we understand it). Updates don't break things and things don't suddenly start behaving differently. Best of all, we don't mysteriously lose functionality. Read full review ScreenShots