Local ID vs. Oracle Discoverer (discontinued)

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.

Incentivized

• 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.

Incentivized

• 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.

Incentivized

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.

Incentivized

• 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.

Incentivized