TrustRadius
Business Intelligence Discoverer is a business intelligence software offering from Oracle.https://dudodiprj2sv7.cloudfront.net/product-logos/99/UN/O3D473MNSAHT.pngNot everything that can be counted counts, and not everything that counts can be counted. - EinsteinBeing used across the entire organization. We use Discoverer to help mine data from our CRM (Oracle). The tool fills a gap between the raw data and the reporting needed by various departments. Some of the reports that are run are created centrally and stored in a company-wide, company-accessible database. Other reports are created "on the fly" and stored locally.,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.,8,SAP Crystal and Microsoft Dynamics GP,7,9,Not a member of any user groups,Atlassian Confluence, JIRA Software, Oracle Agile PLMBusiness Intelligence Discoverer, a relatively simple and straightforward BI solutionBusiness Intelligence Discoverer was used for some departments (majorly the BI department), the main focus user group is those who don't have enough in-depth SQL or let's say database knowledge. It's also only for those databases which don't have a complex relationship, and where the business user's graphic report requirement is quite straightforward. So, the end user can quickly transfer the info buried in the Oracle database to a more understandable chart and share with team members.,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,5,TIBCO Spotfire,4,4,Not a member of any user groupsOracle BI Discoverer ia greatWe use it in accounting and IT for fast and easy querying and analysis of data.,Intuitive discovery Data analysis Simple querying,Interface could be a little more modern,8,10,10,Not a member of any user groupsDiscover your data with Discoverer!Discoverer is a great reporting tool and currently we use it across the organization but divided by business units - each business unit within the organization has their own setup for Discoverer. Discoverer puts great control in the hands of the end users. We divided user groups into Super Users and Consumers. Super Users of that group understand the data and create reports. Consumers will consume the reports and make a decision accordingly.,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.,7,Oracle Business Intelligence Cloud Service,10,9,Not a member of any user groups,Oracle Business Intelligence Cloud Service, Oracle Analytics Cloud Day by Day, Oracle Analytics Cloud Synopsis, Amazon Web Services, Oracle Cloud Infrastructure (OCI), Oracle Cloud Infrastructure ComputeDiscoverer: Your Gateway to Database ManagementAt my previous company, I was one of only two people who knew how to manage and work with databases as we were primarily using SQL in Access. Our organization had a need for deeper database integration with the amount of data we were pulling in and so they had opted to go with Oracle Business Intelligence Discoverer as it did not require each user to know how to use or work in a database. This way, each member of the team could access the data and generate reports without needing to access the actual database.,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.,7,Sisense,6,8,Boston Area Oracle Service Cloud User Group,Sisense
Unspecified
Business Intelligence Discoverer
501 Ratings
Score 7.4 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Business Intelligence Discoverer Reviews

Business Intelligence Discoverer
501 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.4 out of 101
Show Filters 
Hide Filters 
Filter 501 vetted Business Intelligence Discoverer reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-7 of 7)

  Vendors can't alter or remove reviews. Here's why.
David Lisauskas profile photo
December 08, 2018

Business Intelligence Discoverer Review: "Not everything that can be counted counts, and not everything that counts can be counted. - Einstein"

Score 8 out of 10
Vetted Review
Verified User
Review Source
Being used across the entire organization. We use Discoverer to help mine data from our CRM (Oracle). The tool fills a gap between the raw data and the reporting needed by various departments. Some of the reports that are run are created centrally and stored in a company-wide, company-accessible database. Other reports are created "on the fly" and stored locally.
  • 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.
Well suited for mining large sets of data to build reports for financials, order history, or quality mining from your database. It is less appropriate for small business where this level of tool might be too much overhead to use. For me, does not do a great job dealing with duplicate data due to cross-tabs, might be my lack of knowledge in this area, I usually clean some of this up post-data through excel.
Read David Lisauskas's full review
yixiang Shan profile photo
December 07, 2018

Review: "Business Intelligence Discoverer, a relatively simple and straightforward BI solution"

Score 5 out of 10
Vetted Review
Verified User
Review Source
Business Intelligence Discoverer was used for some departments (majorly the BI department), the main focus user group is those who don't have enough in-depth SQL or let's say database knowledge. It's also only for those databases which don't have a complex relationship, and where the business user's graphic report requirement is quite straightforward. So, the end user can quickly transfer the info buried in the Oracle database to a more understandable chart and share with team members.
  • 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
For some businesses with a small database and a small group of users with basic BI demand, this is recommended. Otherwise, it's better to choose other more advanced tools. For example, SAAS or TIBCO Spotfire
Read yixiang Shan's full review
Greg Madden, CISSP profile photo
December 08, 2018

Business Intelligence Discoverer Review: "Oracle BI Discoverer ia great"

Score 8 out of 10
Vetted Review
Verified User
Review Source
We use it in accounting and IT for fast and easy querying and analysis of data.
  • Intuitive discovery
  • Data analysis
  • Simple querying
  • Interface could be a little more modern
It is great in environments where users need to constantly access databases. The instant access to DBs and the simplicity of the querying has allowed even unskilled employees to work with the database.
Read Greg Madden, CISSP's full review
No photo available
December 11, 2018

Business Intelligence Discoverer Review: "Discover your data with Discoverer!"

Score 7 out of 10
Vetted Review
Verified User
Review Source
Discoverer is a great reporting tool and currently we use it across the organization but divided by business units - each business unit within the organization has their own setup for Discoverer. Discoverer puts great control in the hands of the end users. We divided user groups into Super Users and Consumers. Super Users of that group understand the data and create reports. Consumers will consume the reports and make a decision accordingly.
  • 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.
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 this authenticated review
Joseph R. Sweeney profile photo
February 14, 2018

Business Intelligence Discoverer Review: "Discoverer: Your Gateway to Database Management"

Score 7 out of 10
Vetted Review
Verified User
Review Source
At my previous company, I was one of only two people who knew how to manage and work with databases as we were primarily using SQL in Access. Our organization had a need for deeper database integration with the amount of data we were pulling in and so they had opted to go with Oracle Business Intelligence Discoverer as it did not require each user to know how to use or work in a database. This way, each member of the team could access the data and generate reports without needing to access the actual database.
  • 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.
Discoverer is definitely well suited for a company that is working with a lot of data but does not have a large database knowledgeable team. It allows for basic database management while permitting users to access the data in a simple and efficient way. Reporting is easy to do and, again, does not require a lot of database know-how. If you are looking for more in-depth customization and multiple data sources from various vendors, though, you may want to look into a more robust platform.
Read Joseph R. Sweeney's full review
No photo available
October 31, 2017

Business Intelligence Discoverer Review: "Using Oracle Discoverer"

Score 2 out of 10
Vetted Review
Verified User
Review Source
We use Discoverer as a way to provide self-service reporting and analytic services to our organization. It provides a graphical interface for simplifying data access.
  • 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.
It is a good product, however it has been discontinued.
Read this authenticated review
Glen Norman profile photo
October 18, 2016

Business Intelligence Discoverer Review: "Discover the benefits of Discoverer"

Score 8 out of 10
Vetted Review
Verified User
Review Source
Business Intelligence Discoverer has been the key user self-service reporting tool against Oracle E-Business Suite. Empowering the application users to create and run their own reports by developing a robust reporting structure has enabled application users to get the data they need when they need it without waiting on requests to the IT department. Discoverer is also used by Audit and Tax to pull data to support filings and respond to data requests.

  • 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.
For a company using Oracle EBS this is a very good product that quickly provides value.
For non-Oracle EBS environments, building out the data definitions is no better than any other product and may therefore be hard to justify over another tool that provides the same types of reporting features.
Read Glen Norman's full review

Feature Scorecard Summary

Pixel Perfect reports (4)
6.2
Customizable dashboards (5)
5.2
Report Formatting Templates (5)
6.3
Drill-down analysis (7)
8.0
Formatting capabilities (7)
7.3
Integration with R or other statistical packages (3)
6.0
Report sharing and collaboration (7)
8.2
Publish to Web (7)
6.2
Publish to PDF (6)
7.5
Report Versioning (5)
6.0
Report Delivery Scheduling (7)
7.5
Delivery to Remote Servers (4)
5.4
Pre-built visualization formats (heatmaps, scatter plots etc.) (5)
5.5
Location Analytics / Geographic Visualization (5)
5.5
Predictive Analytics (5)
5.3
Multi-User Support (named login) (7)
8.0
Role-Based Security Model (6)
7.1
Multiple Access Permission Levels (Create, Read, Delete) (6)
7.3
Single Sign-On (SSO) (4)
5.5
Responsive Design for Web Access (5)
5.9
Dedicated iOS Application (2)
2.6
Dedicated Android Application (1)
2
Dashboard / Report / Visualization Interactivity on Mobile (2)
3.5
REST API (2)
3.1
Javascript API (2)
2.5
iFrames (2)
2.5
Java API (1)
3
Themeable User Interface (UI) (1)
2
Customizable Platform (Open Source) (1)
3

About Business Intelligence Discoverer

Business Intelligence Discoverer is a business intelligence software offering from Oracle.