Business Intelligence Discoverer, a relatively simple and straightforward BI solution
yixiang Shan | TrustRadius Reviewer
December 07, 2018

Business Intelligence Discoverer, a relatively simple and straightforward BI solution

Score 5 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Business Intelligence Discoverer

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
TIBCO Spotfire or SaaS BI are much more flexible and comprehensive, being compared with Business Intelligence Discoverer, they support many ways of scripting and has rich data visualization options, and furthermore, they can be linked with recent popular ML/DL frameworks.
By merging the data from different SQL based data sources, it looks ok, but if you merge from different data sources with different types (JSON, Excel, CSV, XML), it doesn't behave very well, and also when a large data size is there, real-time aggregation and performance management is not so well done.
For simple reports, sharing across teams and members is quite straightforward. The access control is ok, but the support to the mobile device is not as nice as we expected.
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

Oracle Business Intelligence Discoverer Feature Ratings

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