Business Intelligence Discoverer, a relatively simple and straightforward BI solution
December 07, 2018

Business Intelligence Discoverer, a relatively simple and straightforward BI solution

yixiang Shan | TrustRadius Reviewer
Score 5 out of 10
Vetted Review
Verified User

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.

Pros

  • 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

Cons

  • 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.
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 Discoverer (discontinued) 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
Mobile 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

Comments

More Reviews of Oracle Discoverer (discontinued)