TrustRadius: an HG Insights company

Oracle Discoverer (discontinued)

Score5.6 out of 10

634 Reviews and Ratings

What is Oracle Discoverer (discontinued)?

Oracle's Business Intelligence Discoverer is an ad- hoc query and analysis reporting tool oriented for end users to have easy access to relational and multi-dimensional data. The product is now end of life. The vendor has stated that Discoverer 11g release 11.1.1.7.0 is the terminal release of Discoverer.

Categories & Use Cases

Top Performing Features

  • Multi-User Support (named login)

    Named model access means that users have access based on name and password.

    Category average: 8.6

  • Role-Based Security Model

    Role-based access means that access to data is determined by job or position in the corporation.

    Category average: 8.4

  • Single Sign-On (SSO)

    Allows users to use one set of login credentials to access multiple applications

    Category average: 8.5

Areas for Improvement

  • Drill-down analysis

    Drill down analysis is the ability to get to a further level of detail by going deeper into the hierarchy.

    Category average: 8.4

  • Java API

    A Java application programming interface (API) is a list of all classes that are part of the Java development kit (JDK)

    Category average: 8.1

  • Customizable Platform (Open Source)

    A customizable, open source API Gateway is a fast and scalable type of API

    Category average: 7.7

Oracle BI Discoverer Review

Pros

  • We get very fast reports.
  • Being compatible with ERP makes our work easier.
  • As it is a safe application, we use it comfortably in every field.

Cons

  • Sometimes we have difficulties in preparing reports.
  • There may be problems in importing the reports we have prepared into live environments.
  • We are having trouble preparing reports of very big data.

Alternatives Considered

Oracle Analytics Server (formerly Oracle BI Foundation Suite)

Other Software Used

Oracle Analytics Server (formerly Oracle BI Foundation Suite), MicroStrategy Analytics, QlikView

Best Tool Set for Ad-Hoc Database Management

Pros

  • Find data that you know.
  • Drilling up and down through data.
  • Share data with other people.
  • View data in a familiar spreadsheet-style.

Cons

  • Control access to data.
  • Manage summary data.
  • Administer batch scheduling.
  • End User Layer management.

Oracle BI Discoverer Review

Pros

  • Business Intelligence Discoverer helps with our Reporting team. We are able to run reports needed immediately using this tool.
  • Business Intelligence Discoverer helps with getting analysis of monthly and yearly medical data from across the state.
  • Business Intelligence Discoverer helps with web publishing and sending information to the trading partners.

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.

Alternatives Considered

Axibase Enterprise Reporter (AER)

Other Software Used

Oracle Analytics Cloud, Toad Decision Point, Epicor Eclipse

Amazing Business Intelligence suite

Pros

  • Access data quickly without waiting for the computer to search through the entire database
  • View data in a familiar spreadsheet-style format that is easy to read and understand
  • Analyze data using a variety of powerful techniques
  • Share data with other people, and in other applications (for example, Microsoft Excel)

Cons

  • You have to know relational database and SQL
  • Slow when you manage a lot of data
  • Run in Java VM, you have to buy Java SE

Alternatives Considered

Microsoft Power BI and SAP BusinessObjects Business Intelligence (BI) Platform

Other Software Used

Microsoft Azure, Elasticsearch, MongoDB, Windows Server, Windows Server AppFabric, Azure Kubernetes Service (AKS), Redis Cloud, Apache Kafka, Microsoft Power BI, RabbitMQ, Amazon Simple Queue Service (SQS), Mule ESB, IBM Business Automation Workflow on Cloud, ARIS Business Process Management (BPM), Bizagi Digital Business Platform, Automation Anywhere, UiPath Enterprise RPA Platform, Red Hat Enterprise Linux (RHEL), CentOS

Business Intelligence Discoverer and OBIEE

Pros

  • Detailed report generation
  • Drag and drop report creation
  • Exporting data for integration with other tools

Cons

  • Visualization
  • Star Schema Integration with different tables

Alternatives Considered

Tableau Prep and Tableau Desktop