Try our new research platform with insights from 80,000+ expert users

Oracle OBIEE vs Pentaho Business Analytics comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 1, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Oracle OBIEE
Ranking in BI (Business Intelligence) Tools
5th
Ranking in Reporting
3rd
Average Rating
7.8
Reviews Sentiment
6.4
Number of Reviews
157
Ranking in other categories
No ranking in other categories
Pentaho Business Analytics
Ranking in BI (Business Intelligence) Tools
20th
Ranking in Reporting
16th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
44
Ranking in other categories
Cloud Operations Analytics (4th)
 

Mindshare comparison

As of April 2025, in the BI (Business Intelligence) Tools category, the mindshare of Oracle OBIEE is 3.8%, down from 4.6% compared to the previous year. The mindshare of Pentaho Business Analytics is 0.5%, down from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Featured Reviews

VishnuReddy - PeerSpot reviewer
Handles large datasets and easy to interact with and handle but performance could be better
Oracle's technical support usually recommends to upgrade when you contact them for support. They don't focus on fixing the issue at hand or providing guidance on how to do it. If you are in a lower environment, like one version down, they will blindly suggest upgrading. Additional patches are given for other Oracle products like WebLogic, databases, and apps. They fix issues and create patches based on client needs. But from an OBIEE point of view, they mostly provide bundle patches of around 5 to 6 GB that need to be applied and tested end-to-end. It's not an easy way to get small patches, and if issues arise after applying the patches, you have to contact Oracle again.
Sayan König - PeerSpot reviewer
Flexible, easy to understand, and simple to set up
The repository should be improved. There should be the possibility to have versioning, to make it combinable with some Git repositories or something like that, to check out the processes and make sure it has a traceable history. The solution could really be improved. There are too many bugs in our version.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Oracle OBIEE is very easy to use. Looking at analytics, I think they have come a long way by adding new features like visualization, which is really cool."
"The setup isn't too difficult."
"I like the scheduling feature. It has an inbuilt scheduler which is very good, and it allows us to create agents, and those agents can be scheduled. It's quite flexible in that respect and goes into our IT infrastructure. The outputs are sent encrypted to various endpoints. Some are internal, and some are our clients, and it's encrypted at a high level. I do find Oracle OBIEE flexible. If there is stuff that's not in your model or schema, it's very flexible to create SQL scripts and create the data you want. It's quite nice to create a dashboard in OBIEE, and that's pretty straightforward in the way you drag and drop everything. You can create sections, and you can add elements to your page. That bit of the interface is relatively straightforward."
"The most valuable feature is the ability to run it in Exalytics within memory coupled to a Repository on Exadata is where it flies. So it's not meant for mom and pop shops, but if you are a global 500 fortune 1000 company, this is a tool that can get you what you need on time and even in real time."
"We have scheduled reports delivered automatically to our business users using enterprise features."
"For me, it makes the difference is in terms of our users being able to take advantage of a product which allows you to get access to data, reports, make decisions quickly, and have better insights regarding operations."
"The solution is user-friendly."
"They were reasonable in terms of price."
"Easy to use components to create the job."
"Pentaho is an analytics platform that can be used when an organization has a lot of big data storage systems already installed and needs to manage and analyze that data. It has a specific use case for unstructured data, such as documents, and needs to be able to search and analyze it."
"Pentaho Business Analytics' best features include the ease of developing data flows and the wide range of options to connect to databases, including those on the cloud."
"The initial setup is pretty straightforward."
"We were able to install it without any assistance from tech support."
"The most valuable feature of Pentaho is the Tableau report."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"The interface of Pentaho Business Analytics is easy to use and does not require high-level skills to operate the tool."
 

Cons

"The performance could be better."
"While it is a user-friendly, data-driven tool, the data modeling should be easier to use."
"The graphical capabilities could be better. They are also cumbersome, and they are limited compared to Tableau, Power BI, or even Business Objects to a certain extent and Cognos. The error logging isn't great either. The errors that come out when you schedule aren't easy to understand. I find how they filter within a query quite cumbersome and difficult to debug if somebody else has done it. You can see as you build, and I think that's where the problem is. It doesn't lend itself to debug something. For example, if you create a formula that's quite complicated, it's not easy to understand what goes with what. It becomes spaghetti, and it's very difficult to unpick. That's really my gripe about it, and in some ways, it's too flexible. It tries to be a Jack of all trades when it's not. I think a lot of these products, if they concentrate on trying to produce your reports, then that's fine. But when they're trying to do all sorts of other things as well, then it isn't very easy. We get lots of support from Oracle, but I think the problem is that we get many invalid file operations. Nobody understands why. It can be a multitude of reasons, but no one reason could cause it. That's just one of the issues we've had in the last year. But the scope of reporting has gone through the roof over the previous 12 to 18 months. We want an end-of-life OBIEE in our environment because some of the infrastructure runs unclustered. We weren't allowed to go clustered for some reason, and we never knew why. Unfortunately, going down that route means that the platform we run it on, WebLogic, has now become non-standard within our organization. Everything's been moved off it and onto other platforms. Unfortunately, our OBIEE runs on that platform, and we're being pushed down different routes, and we don't know where we're going at the moment. Within the next two years, I don't think we'll have OBIEE in our part of the business. In the next release, I think having the capability of being able to develop and then promote to a production environment rather than having to have separate environments will help. I know that Tableau and Power BI can be created on a desktop application, and then when it's ready to go live, you can promote it."
"It needs a better security management system."
"They should develop greater visualization because their visualization isn't industry leading at the moment. The way you pull the data and see the data compared to other platforms, they're lagging a little bit behind. Also, their cost. I've got Oracle account managers trying to persuade me every day to purchase these licenses. Once you purchase OBIEE, then you have to purchase the virtualization and then you have to purchase the mobile license to operate on the mobile. It's really expensive."
"The pricing of the solution should be bettered."
"Its overall organization as an analytical tool, the layout of OBIEE, is not very good."
"Oracle OBIEE is lagging in data visualization."
"Pentaho, at the general level, should greatly improve the easy construction of its dashboards and easy integration of information from different sources without technical user intervention."
"Deployment is not simple. It is not simple because we are dealing with a lot of data; we are dealing with a lot of storage. So, it's not a simple process."
"Another concern is that Pentaho is not customizable or interactive."
"The repository should be improved."
"Version control would be a good addition."
"Pentaho Business Analytics is hard to learn and not suited for initial users as it requires knowledge of operating systems, Java, and other technical skills."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"The tool is very good, and yet it has some problems as it relies heavily on Java."
 

Pricing and Cost Advice

"The price of Oracle OBIEE is expensive, it is difficult for a small business to afford."
"The licensing cost is based on the number of users using it."
"The pricing we negotiated with Oracle. But, I do not have details."
"Compared with the other products in the market, I feel Oracle OBIEE is an expensive product."
"It's expensive."
"Pricing is an area that could be improved."
"It is an expensive solution."
"This was not an expensive product for us, although the price varies depending on conditions for each company."
"Pentaho is expensive ."
"We were lucky enough to find a Pentaho OEM partner who offered a data warehouse model and the ETL software for about 60K SGD per year."
"Free and commercial versions are available."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
847,772 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Feb 4, 2015
Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho
1. SAP BO/BI Enterprise scalability Security Ease of use Semantic layer 2. Tableau Visualization Data discovery Turnaround time 3. IBM Cognos Enterprise scalability Security In-memory feature 4. MS BI - Flexibility 5. Pentaho - Open source but still enterprise grade 6. QlikView Data…
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Government
13%
Computer Software Company
10%
Manufacturing Company
7%
Financial Services Firm
24%
Computer Software Company
13%
Educational Organization
7%
Real Estate/Law Firm
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Oracle OBIEE compare with Microsoft BI?
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle ...
Which Oracle product is better - OBIEE or Analytics Cloud?
Oracle OBIEE is designed to be relatively easy to set up and has a helpful customer support staff at the ready to assist customers. These are two attributes that make this system quite valuable. OB...
What do you like most about Oracle OBIEE?
The most valuable feature of Oracle OBIEE is its ability to handle large volumes of data and provide traditional BI functionalities that developers can easily understand.
Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
What is your experience regarding pricing and costs for Pentaho Business Analytics?
Pentaho Business Analytics is priced similarly to other competitors such as QlikView ( /products/qlikview-reviews ) and Tableau ( /products/tableau-reviews ). I usually use the community edition.
What needs improvement with Pentaho Business Analytics?
Pentaho Business Analytics ( /categories/bi-business-intelligence-tools ) is hard to learn and not suited for initial users as it requires knowledge of operating systems, Java, and other technical ...
 

Also Known As

OBIEE, Oracle Business Intelligence Enterprise Edition, Oracle BI, Oracle BI EE 11g
Pentaho, Kettle, Hitachi Pentaho Business Analytics
 

Overview

 

Sample Customers

Banca Transilvania, BeckmanCoulter, Hong Kong Housing Society, HealthShare, Ivanhoe Cambridge Unifies, and Home Credit, and Finance Bank.
Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
Find out what your peers are saying about Oracle OBIEE vs. Pentaho Business Analytics and other solutions. Updated: April 2025.
847,772 professionals have used our research since 2012.