Oracle Discoverer

Business intelligence?

Business intelligence is the ability to analyze data to answer business questions and predict future trends.

Oracle Business Intelligence Discoverer is a great business intelligence tool because it enables users to analyze data in an ad hoc way. Instead of relying on IT specialists to pre-define queries and reports, Discoverer users can choose the data to analyze and can continue manipulating results until they have the necessary information to take business decisions. Oracle Business Intelligence Discoverer also enables users to share the results of their data analysis with their colleagues in different formats (including charts and Excel spreadsheets).

How does Discoverer work?

Oracle Discoverer is an intuitive ad hoc reporting tool. It enables a developer or knowledgeable end user to create reports with impressive formatting and attractive exporting and publishing functionality. Oracle Discoverer empowers your user population by placing business and decision critical data at their fingertips

Users' requests for information from the database are in the form of worksheets.
When a user creates or opens a worksheet, Discoverer converts the worksheet into the corresponding SQL statements (e.g. by converting folder names and item names to table names and column names respectively) sends the SQL statements to the database displays the result set that is returned from the database

In the case of Discoverer Plus, Discoverer Desktop and Discoverer Viewer, the SQL statements are routed to the database via Discoverer processes running on an application server machine