Oracle BI Discoverer Review
We use Oracle Business Intelligence Discoverer as part of ERP for our purchasing and financial reports.
Overview
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…
Recent Reviews
Popular Features
- Multi-User Support (named login) (22)10.0100%
- Report Delivery Scheduling (22)8.080%
- Formatting capabilities (22)8.080%
- Drill-down analysis (21)7.070%
Pricing
N/A
Unavailable
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…
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
3 people also want pricing
Alternatives Pricing
What is Microsoft Power BI?
Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.
What is Spotfire?
Spotfire® is a data visualization platform that utilizes predictive analytics. In addition to data viz, it includes data wrangling capabilities, predictive analytics, location analytics, and real-time streaming analytics. Spotfire® is a business unit of Cloud Software Group, formerly known as…
Features
Return to navigation
Product Details
- About
- Competitors
- Tech Details
- FAQs
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.
Oracle Discoverer (discontinued) Competitors
- Tableau Desktop
- Microsoft
- IBM
Oracle Discoverer (discontinued) Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
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.
Tableau Desktop are common alternatives for Oracle Discoverer (discontinued).
Reviewers rate Multi-User Support (named login) and Role-Based Security Model and Single Sign-On (SSO) highest, with a score of 10.
The most common users of Oracle Discoverer (discontinued) are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(636)Attribute Ratings
Reviews
(1-22 of 22)Companies can't remove reviews or game the system. Here's why
November 08, 2021
Oracle BI Discoverer Review
- 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.
- 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.
September 10, 2020
Best Tool Set for Ad-Hoc Database Management
- Find data that you know.
- Drilling up and down through data.
- Share data with other people.
- View data in a familiar spreadsheet-style.
- Control access to data.
- Manage summary data.
- Administer batch scheduling.
- End User Layer management.
- Querying database, analyzing the data using data models
- Reporting and publishing on the web
- Integrates with Oracle Portal, Oracle WebCenter, and Oracle WebLogic Portal
- Tools look classic, more intuitive UI would be good
- Even though non-technical users can use it, relational data model creation needs technical knowledge
- Not a regular self-guiding reporting tool, needs training
November 20, 2019
BI Analysitcics
- We are able to look at trends and make strategic decisions based on that data.
- We're able to see where the business is driving, able to forecast any capital towards those gains.
- Too much visibility.
- Data could be overwhelming and need to ensure its the correct information and is telling the correct story.
November 04, 2019
Browser-based tool for your simple data needs.
- Browser-based access makes it easy for users.
- Provides all basic techniques for data analytics.
- It is easy to collaborate with other users on certain dashboards.
- Performance takes a hit when working with large databases.
- Limited features for visualisation.
- Use of RPDs are limited as well.
October 30, 2019
Oracle BI Discoverer Review
- 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.
- 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.
October 25, 2019
Oracle BI Discoverer - Your one stop solution to enterprise reporting and analytics!!!
- Complex reporting made easy.
- With ease, multiple levels of nested groupings possible within pivot functionality.
- A lot of formatting tools are available for more control of reports containing visual attributes.
- Maybe a more user-friendly worksheet wizard used in this tool.
- More tuning options or maybe SQL advisory hints when building the worksheets would be immensely helpful.
October 23, 2019
Amazing Business Intelligence suite
- 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)
- 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
October 17, 2019
Oracle BI Discoverer
- Can be used across different levels in the organization
- Faster and quicker
- Secure and immediate across to relational and multi dimensional data sources
- It has intuitive user interface
- I do not see anything major defects at this time
- With seasoning , the software will become more robust and cater to a large audience
- Some further improvement in performance of fetching results could be an added advantage.
October 16, 2019
A Media Customer's Review of Business Intelligence Discoverer
- User friendly interface
- Ease of use
- Fast report building
- The generated SQL queries should be standardized so that they could be re-used in TOAD
- Enable reading from different sources, not necessarily Oracle DB
September 18, 2019
Awesome tool to analyze data and reports
- Users were able to build complex queries and generate reports in a customize way.
- The most important benefit of this tool is users can drag and drop the fields they want to use.
- Users are able to schedule the reports and will generate and ready for the output.
- It would be useful if users could be allowed to write subqueries.
- It would be helpful if there was a way for users to download the reports on their PC.
- Most of the functionality is awesome and I would like to see more graphics in the reports.
September 17, 2019
Great at-a-glance reporting tool
- The ability to export to Excel and other reporting tools.
- The ability to allow users to create their own reports.
- The ability to report across different modules to show overall pictures.
- Using BI 12c, the look and feel of the application can be more modern.
- The creation of RPD's for seamless fast reporting can be done simply as OBIEE uses the Oracle database structure.
- Performance issues with reporting data directly from EBS.
September 16, 2019
Business Intelligence Discoverer and OBIEE
- Detailed report generation
- Drag and drop report creation
- Exporting data for integration with other tools
- Visualization
- Star Schema Integration with different tables
July 28, 2019
Data Extraction Made Easy
- Easy to create reports which can be shared across the organization.
- Formulas can be created to analyze the data.
- Multiple sheets can be created in a single workbook.
- If an error is present in a sheet, an improvement in repairing the errors would be useful.
- More standard data analyze tools would be useful, instead of creating formulas.
- Improved visual tools to show trends in the data.
January 28, 2019
Raw Data Mining with Ease
- Data analytics across the company, with ease.
- Scheduled reporting and ad-hoc queries.
- Clean and easy layout, very ease to use, even for lesser trained staff.
- A level of SQL knowledge is required for more complex arguments.
- The layout of the interface could be better.
December 12, 2018
Discover your data with Discoverer!
- Discoverer puts the control in end-user hands. Super Users, who have privileges to create reports, can create and test SQL Queries in SQL Developer and then use the Custom SQL option in Discoverer to create a report based on that SQL. This means the user doesn't have to run the query every day manually, but the report is ready whenever they want to access it.
- Discoverer eliminates the costly developer layer. Super Users are business users who can create reports for their team on their own. This means there is no need for developers or explaining to them how to use the data.
- Discoverer consolidates the tables into business areas. Each business area can serve a specific set of users within a department. This helps make the management of reports and data easy.
- Duplication of data. While Discoverer supports business areas, it allows a lot of duplication. The same table can exist in multiple business areas. Similar queries and reports exist in multiple places. As multiple Super Users exist in each business area, there are high chances of duplication and increased storage cost.
- OPatch doesn't work well with Discoverer. Patching Discoverer is a pain. OPatch may not be applicable in all scenarios.
- No direct path to upgrade Discoverer to OBIEE 12c. If an organization decides to upgrade their Discoverer to OBIEE12c, there is no direct path. They have to upgrade to OBIEE 11g and then to 12c, and even that process is flawed. As mentioned earlier, the duplication of business areas in each End User Layer may create a messy OBIEE RPD with a lot of duplications. It is always advisable to launch a new OBIEE project rather than migrating from Discoverer.
- Lack of dashboards. Unlike other BI tools, Discoverer lacks a dashboard. However, we can build one on OAS, but it needs lot of customizations and integrations. Discoverer web interface is bad at managing cache. Users frequently complain about stale data.
December 08, 2018
Not everything that can be counted counts, and not everything that counts can be counted. - Einstein
- Business Intelligence Discover does a good job mix of GUI interface for report building and access directly to the SQL for those of us who are comfortable with it.
- Discoverer also does a good job of making easy to create reports and linking the various tables together.
- I like the rules area where you can check and uncheck certain rules. This is useful to me where I may build a report and copy that same report for several reasons. I can just update the rules that I am using.
- My main "wish" for Discoverer when creating a new rule....Our tables are HUGE and you must scroll through several columns before finding the one that you want selected....my "wish" would be to have a search in this area where I could start to type the name of the column and find the selection that way.
- When creating reports, I often ask for user input (order number, etc...). The process of setting this field to accept multiple inputs is cumbersome and not intuitive.
December 08, 2018
Oracle BI Discoverer ia great
- Intuitive discovery
- Data analysis
- Simple querying
- Interface could be a little more modern
December 07, 2018
Business Intelligence Discoverer, a relatively simple and straightforward BI solution
- It is good for quickly building some ad-hoc report on top of the data
- It works well with the Oracle's own database of course
- The drop feature is very useful for the business user who hasn't mastered the SQL knowledge
- Allow customization of PL/SQL functions/procedures, to add more complex data processing logic
- In order to be able to add the data "processing" logic, for the basic business user without too much SQL or procedure knowledge, it is almost mission impossible. Simply hiding the complexity of basic technical things like "join" is not enough.
- Lack of the "hints" or "relationship explanation" when a report with complex joins is created
- Data visualization options are really too limited
February 14, 2018
Discoverer: Your Gateway to Database Management
- 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.
- Sometimes it can be a bit too rudimentary and rigid, not allowing users who can manage databases to customize other reports.
- Necessary to have a "Discoverer manager" who organizes the data and allots access to Discoverer, which requires a company to have someone on staff who is database savvy.
October 31, 2017
Using Oracle Discoverer
- Discoverer allows drop and drag for data elements onto reports. All technical aspects, like joins, are handled in the administration section and away from the end users. This makes it easier for them.
- Discoverer allows for the registering of PL/SQL functions for easily adding functionality to the reporting abilities.
- The creation of calculations can be difficult for end users. SQL creation skills are needed to understand complex additions.
- When multiple joins are added between reporting objects, it does not give enough details regarding what the differences might make.
October 18, 2016
Discover the benefits of Discoverer
- Discoverer is a good tool for providing customer ad hoc reporting. The UI is clean and easy to use.
- Built in interfaces to Oracle applications seamlessly integrate reporting with application security and data access restrictions. Having a reporting environment that matches the OLTP system security simplifies compliance with various legal, regulatory, and business data access requirements.
- The ability to link data from one report to another and drill to detail provides detailed data analysis from high-level reports with exception reporting.
- Discoverer needs better data visualization options.
- I would like to see built in integration with SharePoint so published management reports can more easily be delivered to users.
- Mobile tools for both report delivery and system maintenance would enhance usability.