Oracle BI Foundation Suit - Good or bad
Sumeet Saraf | TrustRadius Reviewer
November 02, 2017

Oracle BI Foundation Suit - Good or bad

Score 9 out of 10
Vetted Review
Verified User
Review Source

Modules Used

  • Enterprise BI Platform
  • Scorecard and Strategy Management
  • Mobile BI

Overall Satisfaction with Oracle BI Foundation Suite

Oracle BI Foundation Suite is implemented for an automobile industry in Sydney and has been used by its major departments. The main purpose of the tool is to manage, load and extract data from its DB to its own BI tool which makes it faster, reliable and easy to manage. It mainly addresses the problem of extensions of existing reports to major reports or dashboards, SQL based reports with complex outputs, etc.
  • It allows easy extension of reports from simple to complex dashboards
  • The tool goes well with Oracle DB and has great performance
  • Since the base is built on Java, it is supported to run on different platforms and portable devices
  • The tool does not support all the external databases, just works perfect with Oracle DB and few others
  • Since it is based to run on JVM, there are few new systems that has stopped using JVM and has switched to ajax and other platforms. Hence the right plugins are required to be installed in addition
  • The tool is not easy to use. A new user can not work on it unless trained or is highly techy person.
SAP Business Object license is not cheap and was a bigger pain for the client to implement and adapt a new tool. QlikView is mainly used for dashboards and is not the best fit for reporting and ad-hoc reports. Since the client was using an Oracle tool set for their application and DB, we found Oracle BI was a much appropriate tool for them.
It does not support all the external data sources but does support commonly used external databases. They do not support merging of data from different data sources completely but does allow you to use other Oracle tools to do the job and get the data in the reports. The tool also supports Real Time data but you need to consider the performance base of the amount of data you are trying to retrieve and the server bandwidth.
The tool does not allow sharing of data via FTP or on Sharepoint location whereas it does allow sharing the data by scheduling to email and shared locations. It does allow a few standard formats of report extraction like PDF, Excel and CSV but does not support report publication or broadcasting.
Yes - I am a member of the Independent Oracle User Group.

This user group allows reliability and acts as a forum for all your questions. The group allows you to get a solution if you are stuck somewhere or if you are looking for a solution. There are experts in the group who would consider your problem as theirs and will help you dig into the solution.
If the client is using Oracle based tools like the DB, ETL and application, Oracle BI Foundation Suite is one of the best fit for the client.
For e.g. The automobile industry where we had implemented OBI, there was a cube built at the ETL level for calculating aggregations of their financial data. The client was using one another non-oracle tool to extract data from this cube to get their financial data but they were facing a lot of performance issues. We switched this reporting from the non-oracle to Oracle BI suit and the performance came down from 6 min to 40 seconds. That was just amazing what the client was looking for.

Oracle BI Foundation Suite Feature Ratings

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