Oracle Analytics Cloud vs Pentaho Business Analytics comparison

Oracle Analytics Cloud vs. Pentaho Business Analytics

Download the complete report

Helped 911,039 peers since 2012

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 Analytics Cloud

Ranking in BI (Business Intelligence) Tools

19th

Average Rating

8.0

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Data Visualization (16th)

Pentaho Business Analytics

Ranking in BI (Business Intelligence) Tools

21st

Average Rating

8.0

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Cloud Operations Analytics (2nd), Reporting (15th)

Mindshare comparison

As of August 2026, in the BI (Business Intelligence) Tools category, the mindshare of Oracle Analytics Cloud is 1.4%, down from 2.6% compared to the previous year. The mindshare of Pentaho Business Analytics is 1.0%, up from 0.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.

BI (Business Intelligence) Tools Mindshare Distribution
Product	Mindshare (%)
Oracle Analytics Cloud	1.4%
Pentaho Business Analytics	1.0%
Other	97.6%

BI (Business Intelligence) Tools

Featured Reviews

DavidMalizia

Head Of Data And Ai at a tech services company with 11-50 employees

Data projects have grown rapidly and support complex analytics and quick dashboard delivery

Some things that could be improved in Oracle Analytics Cloud is definitely the way it works. In some cases, for example, if you want to create analytic functions such as the percentage of a measure over another, which is a straightforward question you might ask, it appears simple to do, but the result is not what you expect. I would make it more user-friendly in terms of creating new measures. The measure creation feature could be improved. In terms of functionality, there are not many functions that are completely missing. There is one aspect that if you compare it with Power BI from Microsoft, which works completely in memory and therefore puts everything in memory to allow many calculations on the fly on what is in memory, that is missing, but it is architecturally different and would not be possible to ask for something like that. Some time features and time series analysis functions could be improved. Calculating a year ago and previous period functions could definitely work with some improvement.

Read full review

Julien Baluka

Founder at SJT Consult

Solution enables effective ETL processes and exhibits high satisfaction

From an integration perspective, Pentaho Business Analytics is not the best tool on the market. There are things done by Apache that are better, though I am not the one implementing them, so this is based on what I have heard about novelties in the market. I do not see the need to extend the coverage of Pentaho Business Analytics's domain. For things that it does not do, there are better solutions on the market, and it would be costly to implement them. Pentaho Business Analytics is a very great tool for very specific standardized scenarios. If you need more complex elastic solutions because the process is different, there are better tools available.

Read full review

Quotes from Members

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

Pros

"The solution is user-friendly."

"I have found that the scalability quality of Oracle Analytics Cloud works extremely well."

"It's great for consolidation and creating one source of truth."

"The scalability is acknowledged as pretty good, although my evaluation is limited because I used the tool for a short period."

"It's robust. It has the ability to handle massive amounts. After reporting has been developed, there is an ease of use or a user-friendly interface for a trained workforce."

"The best feature may be data flow, which is used to prepare and clean data."

"The ability to quickly search for and access relevant data is crucial."

"It's rather user-friendly."

More Oracle Analytics Cloud pros

"Pentaho Business Analytics tool provides ETL and easy creation of Analyser, interactive and attractive dashboards."

"Pentaho data integration, where most of the ETL work can be done with minimal coding, along with its reporting capabilities, helped us manage data from different sources into one unique target."

"We were able to install it without any assistance from tech support."

"The initial setup is pretty straightforward."

"Pentaho is based on industry standards to build scalable solutions and it is very simple to scale up, horizontally, and vertically."

"Pentaho reports have enabled our client and their users to take calculated and informed tactical decisions."

"When I have a customer that wants to have a real ETL tool in a standardized way with a real code written product, it is the cheapest."

"We use both DataStage and Pentaho, but I don't see any special features in Pentaho that is not available in DataStage, except Big Data plugins and connectors."

More Pentaho Business Analytics pros

Cons

"The interfaces could be improved and some in-memory operations could be built into Oracle Analytics."

"Oracle Analytics Cloud is lacking in charts. They should add more charts to it."

"When you want to scale up and improve the computing power, it becomes extremely costly."

"It is expensive."

"One area of improvement is associated with more connectors needing to be added such as Microsoft OneDrive, Teradata and a few others. I think the list is limited to the top ones now."

"At this time, dataflows cannot be shared, but I think that this should be enhanced."

"I looked at the predictive analytics feature in Oracle Analytics Cloud, but I used it very little because, everything considered, it does not add very much."

"The product should be improved in terms of connectors; right now the top twenty connectors are available, but OneDrive and Teradata are missing."

More Oracle Analytics Cloud cons

"From which the latter is not yet the strongest use-case for using Pentaho yet."

"There are too many bugs in our version."

"For those that run the open source community edition at times it can be difficult to find updated references for support."

"It needs to improve scheduling for the integration aspect."

"In the reporting tool, I would like to see what code it generates. As of now, there is no provision to see the underlying code of the PRD file."

"Pentaho Business Analytics is not a good tool for visualization. Another concern is that Pentaho is not customizable or interactive."

"The repository should be improved."

"It's still not user friendly or robust enough for our needs."

More Pentaho Business Analytics cons

Pricing and Cost Advice

"I would rate it a five out of five in terms of the value received for the price charge."

"The price is reasonable; it's quite a bit lower than Tableau and Spotfire."

"Oracle Analytics Cloud's pricing is generally higher than that of other vendors."

"The product’s pricing is expensive. However, feature-wise, it fits the requirements of enterprise customers."

"The tool's pricing is not unreasonable or non-competitive."

"I rate the product's pricing a nine on a scale of one to ten, where one is cheap, and ten is expensive."

"I don't know the exact cost, but its pricing was good. Its pricing was competitive. I would rate it a three out of five in terms of pricing."

"A highly cost-effective solution"

More Oracle Analytics Cloud pricing and cost advice

"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."

"Pentaho is expensive ."

"Free and commercial versions are available."

See which vendors are best for you

Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.

See recommendations

911,039 professionals have used our research since 2012.

Comparison Review

it_user6978

Co-Founder at Helical IT Solution (Jaspersoft, Pentaho, Talend, Kettle, DWBI, ETL, Ctools, iReport, Jasper Report)

Jun 10, 2013

Jaspersoft vs. Pentaho – Which one to use & is there any need to purchase the commercial edition

Any company (be it technology, manfucaturing, human resource, ecommerce, SME etc) always has the need for Business Intelligence to some or the other extent. If cost is one of the consideration factor, then the 2 BI tools which are at the forefront are Pentaho and Jaspersoft. But, often the same…

Read full review

Top Industries

By visitors reading reviews

Government

10%

Financial Services Firm

Construction Company

Manufacturing Company

Construction Company

12%

Financial Services Firm

11%

Outsourcing Company

Comms Service Provider

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	13
Midsize Enterprise	7
Large Enterprise	11

By reviewers
Company Size	Count
Small Business	22
Midsize Enterprise	7
Large Enterprise	15

Questions from the Community

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 is your experience regarding pricing and costs for Oracle Analytics Cloud?

Pricing for Oracle Analytics Cloud works with how much you want it to cost. We have clients who have bought large amounts of Oracle and the price per product has gone down massively because they bo...

What needs improvement with Oracle Analytics Cloud?

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 offers the best value for money. While improvements can be made in some areas, particularly with more cloud-based solutions, it is not in their domain because they do not...

What needs improvement with Pentaho Business Analytics?

SAP Business Data Cloud vs Oracle Analytics Cloud

Comparisons

Compared 7% of the time

Oracle OBIEE vs Oracle Analytics Cloud

Compared 6% of the time

Zoho Analytics vs Oracle Analytics Cloud

Compared 6% of the time

Tableau Enterprise vs Oracle Analytics Cloud

Compared 6% of the time

SAP BusinessObjects Business Intelligence vs Oracle Analytics Cloud

Compared 6% of the time

More Oracle Analytics Cloud Competitors

Tableau Enterprise vs Pentaho Business Analytics

Compared 10% of the time

Knowage vs Pentaho Business Analytics

Compared 7% of the time

Microsoft Power BI vs Pentaho Business Analytics

Compared 6% of the time

icCube vs Pentaho Business Analytics

Compared 6% of the time

Oracle OBIEE vs Pentaho Business Analytics

Compared 4% of the time

More Pentaho Business Analytics Competitors

Product Reports

Oracle Analytics Cloud

Download Oracle Analytics Cloud product report

Pentaho Business Analytics

Download Pentaho Business Analytics product report

Also Known As

Oracle Analytics Cloud Service, OAC, Oracle Data Visualization, Oracle Data Visualization Cloud Service, ODV

Pentaho, Kettle, Hitachi Pentaho Business Analytics

Overview

Oracle Analytics Cloud offers enterprise-grade dashboarding, visualization, and data integration with machine learning and NLP capabilities. Its cloud infrastructure supports data preparation, predictive analysis, and business analytics, enhancing decision-making for global users.

Oracle Analytics Cloud excels in providing a comprehensive platform for financial, procurement, and HR analytics. It integrates seamlessly with systems like ERP and Primavera, allowing users to develop dashboards for financial status, personal data management, and predictive sales analysis. Known for its ease of use and capacity to handle large data volumes, it supports enterprise-level transactions across financials and logistics, offering stakeholders valuable insights. However, improvements are needed in visualization variety, cost efficiency, and performance speed. Certain areas such as connectors, data modeling features, flexibility, and support resources require enhancement.

What are the most significant features of Oracle Analytics Cloud?

Enterprise-Grade Dashboarding: Offers robust visualization and reporting capabilities.
Data Visualization: Provides intuitive visual tools for data analysis.
Data Integration: Seamlessly connects with ERP, Primavera, and other systems.
Machine Learning: Incorporates ML for smarter analytics and predictions.
Natural Language Processing: Simplifies search and data queries with NLP.
Automatic Dashboards: Generates dashboards through the Explain function.

What are the key benefits and ROI of choosing Oracle Analytics Cloud?

Ease of Use: User-friendly interface simplifies data analysis for teams.
Scalability: Handles large data volumes and grows with business needs.
Fast Performance: Quickly processes and analyzes data to aid decision-making.
Secure Business Analytics: Offers secure data preparation and analysis.

In industries like finance, procurement, and HR analytics, Oracle Analytics Cloud supports decision-making by integrating with existing systems such as ERP and Primavera. Users create dashboards for assessing financial status and predicting sales, aiding business intelligence and enterprise transactions, especially in financials and logistics.

Oracle

Pentaho Business Analytics, recognized for its powerful ETL capabilities, delivers robust data management and analytics. Its adaptable interface and custom plugins enable effective data transformations, appealing to enterprises seeking efficient data handling and integration.

Pentaho Business Analytics offers a comprehensive suite for data warehousing, ETL processes, and business intelligence. Known for integrating and analyzing data from multiple systems, it supports industries like marketing, automotive, telecom, and insurance. Despite critiques on its interface and Java reliance, its ability to manage both small and complex data loads makes it a cost-effective choice.

What are the key features of Pentaho Business Analytics?

Pentaho Data Integration: Delivers powerful ETL capabilities for seamless data transformations and connectivity.
Custom Plugins: Supports adaptability with diverse data transformation and integration options.
Dashboard Integration: Facilitates effective visualizations and dashboard creation.

What benefits can be expected from Pentaho Business Analytics?

Cost-Effective: Suitable for enterprises handling complex data loads.
Community Support: Driven by an active user community for better troubleshooting.

Pentaho Business Analytics finds application in sectors requiring extensive data storage and management like telecom and insurance. Companies utilize its capabilities for creating ETL pipelines, managing data flows, and enabling data-driven decision-making.

Hitachi Vantara

Sample Customers

Sejong Hospital

Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.

Oracle Analytics Cloud vs. Pentaho Business Analytics