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

Oracle OBIEE vs Pentaho Business Analytics comparison

Sponsored
 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Cognos
Sponsored
Ranking in BI (Business Intelligence) Tools
7th
Ranking in Reporting
4th
Average Rating
8.0
Number of Reviews
134
Ranking in other categories
No ranking in other categories
Oracle OBIEE
Ranking in BI (Business Intelligence) Tools
5th
Ranking in Reporting
3rd
Average Rating
7.8
Number of Reviews
157
Ranking in other categories
No ranking in other categories
Pentaho Business Analytics
Ranking in BI (Business Intelligence) Tools
21st
Ranking in Reporting
15th
Average Rating
8.0
Number of Reviews
42
Ranking in other categories
Cloud Operations Analytics (4th)
 

Mindshare comparison

As of November 2024, in the BI (Business Intelligence) Tools category, the mindshare of IBM Cognos is 3.8%, down from 4.4% compared to the previous year. The mindshare of Oracle OBIEE is 3.9%, down from 4.9% compared to the previous year. The mindshare of Pentaho Business Analytics is 0.6%, down from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Featured Reviews

Carlos Larrad Salgado - PeerSpot reviewer
Jul 27, 2022
Improved the quality of our KPIs, while reducing calls to the IT department
I don't like that when we use Colab packages, we get less functionality. For example, you can make groups of data with Excel or with the data sets from the packages, but when you use the Colab packages directly, you can only group the data when you analyze it with Analysis Studio. I think Cognos needs to improve more on this functionality. The user experience is also very important. Cognos is not very easy to understand sometimes, especially when they change the layout but keep the functionality the same. The help is not very graphic and they have no examples. Cognos has to make a big effort to help with understanding the functionality by improving the documentation. There is a lot of documentation, but the examples are hard to find and they should make their help section easier to understand for non-technical users.
VishnuReddy - PeerSpot reviewer
Jul 18, 2024
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
Feb 16, 2022
Flexible, easy to understand, and simple to set up
It's a data warehouse for finance and central bank reporting purposes, and an ETL tool in this environment It's easily understandable. The product is quick and flexible, with very good steps to make data transformation possible.  The initial setup is pretty straightforward. The repository should…

Quotes from Members

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

Pros

"Using custom controls, it is possible to extend the application with even more functionality and make the application intuitive and attractive."
"We use the account statement report. When you use an account in HSBC, you receive various types of accounts, such as the stock market, fixed accounts, credit cards, and business accounts. We can create one consolidated report called CCS support, which includes all these accounts. In that statement, we are consolidating all those accounts."
"The most valuable feature of IBM Cognos is security. The solution has updated features that other competitors' solutions come out with long after IBM Cognos has had them."
"It is a stable product."
"If they want dashboarding, storytelling, and analyzing why KPIs are met or not, then Cognos is a better candidate than Qlik Sense."
"The product is a very good reporting tool and is very flexible. It allows for the users to get a scheduled report."
"Previously, we were doing static reporting. Management would request a report, and it would take staff a week or more to provide it. With Cognos, we have dynamic reporting, and it has reduced both reporting and decision making times significantly. With the solution's dashboard, the company's management team has updated records at their fingertips. This means that they can directly access the data they need to make decisions."
"The tool can join data from different sources, write back to databases, generate alerts, and be customized to our preferences. It's an enterprise BI tool that's more powerful than just visualization tools like Power BI or Tableau."
"The primary reason for using OBIEE is connectivity with Oracle E-Business Suite. It makes it easy to connect with our Oracle E-Business Suite. There are the standard dashboards available, which we sometimes use, and now we are looking for customized dashboards."
"Some of the dashboard capabilities are good. The dashboard capabilities that tell you what kind of reports are available and provide you a summary of the reports are valuable. It is easy to navigate and easy to download reports into Excel to utilize them."
"It is a very stable solution."
"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 easy to use and very flexible."
"Integration-wise, it's good."
"The most valuable feature is the openness of the solution. It helps us integrate some of our clients."
"I think having the conformed structures makes it a lot easier for end users and pulling reports together."
"The most valuable feature of Pentaho is the Tableau report."
"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."
"We were able to install it without any assistance from tech support."
"Easy to use components to create the job."
"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."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
 

Cons

"Compared to Tableau and PowerBI, the IBM interface is easier to use. However, the drag-and-drop functionality isn't as straightforward. Formatting is also more challenging in the cloud than in other applications, like Power BI. Also, if you encounter an issue, it takes more time to resolve it on the formatting side."
"Need improvement towards Visualization."
"They were lacking in the initial phases of development in the area of big data, and they still need to improve that aspect of the product."
"Chart quality: many other competitors have charts and graphics that look much better and that provide dynamic effects. Cognos doesn't."
"Most of our company's customers want to be able to deploy IBM Cognos on a web application and use it as a desktop application, which is not possible currently."
"There are many problems with the product's stability part, making it an area where improvements are required."
"Data modeling needs to be improved. We use the ETL process, and when we get errors, we then need to identify which structural change is required. The error messaging should be better. They should be descriptive rather than semantic."
"We would like to see development of the product's UI function, to make it more of a UI tool that can be configured as required."
"We needed some technical expertise during setup."
"I would like to see the data wrangling features enhanced."
"It takes a lot of maintenance to support the architecture, which is something that should be improved."
"OBIEE doesn't have audit logs."
"The tool's downside is that it is very expensive, making it an area where improvements are needed."
"I would like to see Machine Learning included in this solution."
"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."
"There could be better integration with other solutions, such as Microsoft Office."
"Another concern is that Pentaho is not customizable or interactive."
"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."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"Version control would be a good addition."
"Pentaho Business Analytics' user interface is outdated."
"Logging capability is needed."
"The repository should be improved."
 

Pricing and Cost Advice

"IBM Cognos offers competitive pricing similar to other BI vendors in the market."
"It is averagely priced."
"It is pretty expensive."
"IBM Cognos price is on the higher side of the spectrum. However, with the features that it brings, such as correlation analysis, it's worth the money. They should look at the pricing more clearly because it's a little on the higher side."
"It's more expensive than similar solutions like Tableau and Power BI."
"There is need to assess the purchase license accordingly so as to avoid audit penalties."
"There is some additional licensing that we needed to purchase because we were touching data outside of our core data platform. The cost was approximately $25,000 for the additional licenses, which were approximate 45 licenses. For the application itself, updates, and the core platform it was approximately $50,000. Giving a total cost of $75,000 annually for our usage of IBM Cognos."
"The licensing costs are a little bit higher for IBM Cognos. I don't think there is any additional cost apart from the licensing charges."
"This was not an expensive product for us, although the price varies depending on conditions for each company."
"I think to spread this across an enterprise will be a significant investment."
"Compared with the other products in the market, I feel Oracle OBIEE is an expensive product."
"It is reasonable, but it depends on how you're going to use it. There are no costs in addition to the standard licensing fees."
"The cost of this solution is a little bit high compared with other products like Zoho, so reducing it would make OBIEE more competitive."
"The licensing cost for Oracle OBIEE is expensive."
"Power BI is less expensive than Oracle OBIEE. A benefit to Power BI is having the option to work with concurrent licensing."
"Pricing is an area that could be improved."
"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.
814,649 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
Educational Organization
57%
Financial Services Firm
7%
Computer Software Company
5%
Government
4%
Financial Services Firm
17%
Government
12%
Computer Software Company
11%
Manufacturing Company
8%
Financial Services Firm
25%
Computer Software Company
14%
Educational Organization
8%
Government
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik ...
What do you like most about IBM Cognos?
The solution's most valuable feature is its ease of use, which makes it easily compatible with other tools.
What needs improvement with IBM Cognos?
I need improvements, particularly with the Framework Manager, which has an outdated user interface from older version...
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 ...
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 ass...
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 f...
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 wou...
What is your experience regarding pricing and costs for Pentaho Business Analytics?
The organization has both options based on their needs and budget constraints. The Enterprise Edition is expensive wi...
What needs improvement with Pentaho Business Analytics?
The product to me is not as user-friendly as other players in the market. It also still needs improvement in the repo...
 

Also Known As

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

Overview

 

Sample Customers

More than 23,000 leading organizations across multiple industries use Cognos. Some examples of Cognos customers include BMW Financial Services, Quinte Health Care, Troy Corporation, Michigan State University, and GKN Land System.
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: October 2024.
814,649 professionals have used our research since 2012.