Oracle Data Integrator Cloud Service vs Pentaho Data Integration and Analytics comparison

Oracle and Hitachi Vantara are both solutions in the Cloud Data Integration category. Additionally, 100% of Oracle users are willing to recommend the solution, compared to 95% of Hitachi Vantara users who would recommend it.

Oracle Data Integrator Clou...

Read 7 Oracle Data Integrator Cloud Service reviews

758 Views
371 Comparison Views

100% willing to recommend

Pentaho Data Integration an...

Read 60 Pentaho Data Integration and Analytics reviews

3,976 Views
3,181 Comparison Views

95% willing to recommend

Oracle Data Integrator Clou...

Pentaho Data Integration an...

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Oracle Data Integrator Cloud Service and Pentaho Data Integration and Analytics based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Oracle Data Integrator Cloud Service vs. Pentaho Data Integration and Analytics Report (Updated: March 2026).

Buyer's Guide

Oracle Data Integrator Cloud Service vs. Pentaho Data Integration and Analytics

March 2026

Download the complete report

Helped 885,311 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 Data Integrator Clou...

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Cloud Data Integration (27th)

Pentaho Data Integration an...

Average Rating

8.0

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Data Integration (8th)

Featured Reviews

Aditya Devaguptapu

Senior Solution Architect at a financial services firm with 10,001+ employees

A well-established product that meets all our specifications in terms of usability

In the initial stage when we went with Data Integrator Cloud Service it was primarily the nativity factor that was key for us. Having a single vendor supporting the entire suite of applications, and the ability to configure activities and direct integration with various other Oracle products, were the main attractive features within ODI. This is a well-established product that's good to have if you hold an Oracle suite of applications. It meets all our specifications in terms of usability.

Read full review

Michelle Lawson

Principal Software Engineer at a tech vendor with 10,001+ employees

Streamlines complex data workflows and has supported automated customer payment notifications

I haven't used Pentaho Data Integration and Analytics in a couple of years, so I don't know how it can be improved. I was pretty pleased with it and was self-taught on it, working a lot with their team at various times, but they were surprised that I was able to learn it all by myself. The documentation is not bad, and documentation is the main thing that any product can do to make themselves better because the easier it is to find examples of what you're trying to do improves the learning curve. I think it took me the longest to learn how to do the asynchronous processing and have things wait for other things to finish processing before continuing on in the workflow. I choose 8 out of 10 because the one reason that it's been rejected at T-Mobile is that everything has to go through a provisioning process and has to get approved, meaning the actual code base has to be investigated by T-Mobile before they'll allow us to use tools of that nature. For whatever reason, we just haven't been able to get that approval; I don't know if it's on Pentaho Data Integration and Analytics' side or if it's on our side. The more you can make it easier for companies to feel comfortable that your product is secure, robustly tested and bug-free, and free of any other kind of negative hacks, the more quickly it will get accepted.

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

"This is a well-established product that's good to have if you hold an Oracle suite of applications."

"Oracle Data Integrator helps us build tables and data marts and allows us to schedule them daily, for nearly real-time data warehousing."

"The solution is very stable and it's great once you get it working correctly."

"It's on the cloud, so it's scalable and quite easy to work with."

"The solution is easy to manage and offers good integration. You can run all the tasks one by one which is really helpful, and pick the day and time to do so."

"Having a single vendor supporting the entire suite of applications."

"The most valuable thing to me is its simplicity. A person with zero knowledge can also develop the integration without having extensive technology knowledgebase. They can also work on creating their own integration."

"The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process."

More Oracle Data Integrator Cloud Service pros

"Pentaho Data Integration and Analytics positively impacted my organization by organizing data that was scattered across many different databases and APIs, reducing a lot of manual work and centralizing it into one data warehouse."

"The way it has improved our product is by giving our users the ability to do ad hoc reports, which is very important to our users."

"I find the drag and drop feature in Pentaho Data Integration very useful for integration."

"It has a really friendly user interface, which is its main feature. The process of automating or combining SQL code with some databases and doing the automation is great and really convenient."

"Lumada Data Integration definitely helps with decision-making for our deans and upper executives, and the fact that we're able to reuse some of the ETLs with the metadata injection saves us time and costs while making it a pretty quick process for our developers to learn and pick up ETLs from each other."

"Flexible deployment, in any environment, is very important to us. That is the key reason why we ended up with these tools. Because we have a very highly secure environment, we must be able to install it in multiple environments on multiple different servers. The fact that we could use the same tool in all our environments, on-prem and in the cloud, was very important to us."

"You can get ETL, reporting, analysis, and analytics in a single shop."

"Sometimes, it took a whole team about two weeks to get all the data to prepare and present it, and after the optimization of the data, it took about one to two hours to do the whole process."

More Pentaho Data Integration and Analytics pros

Cons

"The solution is expensive."

"Licensing costs for this Oracle solution are expensive. ODI forms an integral part of the overall PaaS solution and becomes a kind of backbone for that particular service, which is painful because from a PaaS perspective, the licensing costs just shoot off the roof."

"It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot."

"The pricing could be more competitive."

"It can be made much easier for users. They should be allowed to easily monitor the data extraction and flow, allowing them to observe real-time data flow within the software, making the process straightforward."

"It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot."

"This is an expensive solution compared to other products on the market."

"Bulk uploading can be a problem when you hit the upper limit."

More Oracle Data Integrator Cloud Service cons

"The technical support does not reply in a timely manner. The support they have in place does not work very well."

"The web interface is rusty, and the biggest problem with Pentaho is debugging and troubleshooting. It isn't easy to build the pipeline incrementally. At least in our case, it's hard to find a way to execute step by step in the debugging mode."

"Since Hitachi took over, I don't feel that the documentation is as good within the solution."

"Some of the scheduling features about Lumada drive me buggy. The one issue that always drives me up the wall is when Daylight Savings Time changes. It doesn't take that into account elegantly. Every time it changes, I have to do something. It's not a big deal, but it's annoying."

"Stability is a bit of an issue. The GUI quite often ‘freezes’ and there is no alternative to killing the session."

"I experience difficulties when handling millions of rows, as the data movement from one source to another becomes challenging."

"The product needs more plugins."

"While Pentaho Data Integration is very friendly, it is not very useful when there isn't a lot of data to handle."

More Pentaho Data Integration and Analytics cons

Pricing and Cost Advice

"The price is competitive compared to Boomi which is much higher."

"There was a cost analysis done and Pentaho did favorably in terms of cost."

"We did a two or three-year deal the last time we did it. As compared to other solutions, at least so far in our experience, it has been very affordable. The licensing is by component. So, you need to make sure you only license the components that you really intend to use. I am not sure if we have relicensed after the Hitachi acquisition, but previously, multi-year renewals resulted in a good discount. I'm not sure if this is still the case. We've had the full suite for a lot of years, and there is just the initial cost. I am not aware of any additional costs."

"If a company is looking for an ETL solution and wants to integrate it with their tech stack but doesn't want to spend a bunch of money, Pentaho is a good solution"

"The price of the regular version is not reasonable and it should be lower."

"There is a good open source option (Community Edition)."

"When we first started with it, it was much cheaper. It has gone up drastically, especially since Hitachi bought out Pentaho."

"The pricing has been pretty good. I'm used to using everything open-source or freeware-based. I understand that organizations need to make sure that the solutions are secure, and that's basically where I hit a roadblock in my current organization. They needed to ensure that we had a license and we had a secure way of accessing it so that no outside parties could get access to our data, but in terms of pricing, considering how much other teams are spending on cloud solutions or even their existing solutions, its price point is pretty good. At this time, there are no additional costs. We just have the licensing fees."

"I use it because it is free. I download from their page for free. I don't have to pay for a license. With other tools, I have to pay for the licenses. That is why I use Pentaho."

More Pentaho Data Integration and Analytics pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

885,311 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

No data available

Financial Services Firm

11%

Educational Organization

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	3
Large Enterprise	4

By reviewers
Company Size	Count
Small Business	18
Midsize Enterprise	17
Large Enterprise	31

Questions from the Community

Ask a question

Earn 20 points

Which ETL tool would you recommend to populate data from OLTP to OLAP?

Hi Rajneesh, yes here is the feature comparison between the community and enterprise edition : https://www.hitachivantara.com/en-us/pdf/brochure/leverage-open-source-benefits-with-assurance-of-hita...

See all answers

What do you think can be improved with Hitachi Lumada Data Integrations?

In my opinion, the reporting side of this tool needs serious improvements. In my previous company, we worked with Hitachi Lumada Data Integration and while it does a good job for what it’s worth, ...

See all answers

What do you use Hitachi Lumada Data Integrations for most frequently?

My company has used this product to transform data from databases, CSV files, and flat files. It really does a good job. We were most satisfied with the results in terms of how many people could us...

See all answers

Comparisons

Informatica Intelligent Data Management Cloud (IDMC) vs Oracle Data Integrator Cloud Service

Compared 39% of the time

Oracle Data Integrator (ODI) vs Oracle Data Integrator Cloud Service

Compared 24% of the time

Oracle GoldenGate Cloud Service vs Oracle Data Integrator Cloud Service

Compared 17% of the time

Jitterbit Harmony vs Oracle Data Integrator Cloud Service

Compared 11% of the time

Fivetran vs Oracle Data Integrator Cloud Service

Compared 9% of the time

More Oracle Data Integrator Cloud Service Competitors

Airbyte Cloud vs Pentaho Data Integration and Analytics

Compared 16% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 8% of the time

Oracle Data Integrator (ODI) vs Pentaho Data Integration and Analytics

Compared 6% of the time

SnapLogic vs Pentaho Data Integration and Analytics

Compared 6% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 5% of the time

More Pentaho Data Integration and Analytics Competitors

Product Reports

Buyer's Guide

Oracle Data Integrator Cloud Service

March 2026

Oracle Data Integrator Cloud Service report

Download Oracle Data Integrator Cloud Service product report

Buyer's Guide

Pentaho Data Integration and Analytics

March 2026

Pentaho Data Integration and Analytics report

Download Pentaho Data Integration and Analytics product report

Also Known As

No data available

Hitachi Lumada Data Integration, Kettle, Pentaho Data Integration

Overview

Oracle Data Integrator Cloud Service provides pushdown data processing; high performance ETL with less data movement which is best for the Cloud. Oracle Data Integrator Cloud Service executes data transformations where the data lies without having to copy data unnecessarily to remote locations.

Oracle

Pentaho Data Integration stands as a versatile platform designed to cater to the data integration and analytics needs of organizations, regardless of their size. This powerful solution is the go-to choice for businesses seeking to seamlessly integrate data from diverse sources, including databases, files, and applications. Pentaho Data Integration facilitates the essential tasks of cleaning and transforming data, ensuring it's primed for meaningful analysis. With a wide array of tools for data mining, machine learning, and statistical analysis, Pentaho Data Integration empowers organizations to glean valuable insights from their data. What sets Pentaho Data Integration apart is its maturity and a vibrant community of users and developers, making it a reliable and cost-effective option. Pentaho Data Integration offers a range of features, including a comprehensive ETL toolkit, data cleaning and transformation capabilities, robust data analysis tools, and seamless deployment options for data integration and analytics solutions, making it a go-to solution for organizations seeking to harness the power of their data.

Hitachi Vantara

Sample Customers

Amplifon

66Controls, Providential Revenue Agency of Ro Negro, NOAA Information Systems, Swiss Real Estate Institute

Buyer's Guide

Oracle Data Integrator Cloud Service vs. Pentaho Data Integration and Analytics

March 2026

Free Report: Oracle Data Integrator Cloud Service vs. Pentaho Data Integration and Analytics

Find out what your peers are saying about Oracle Data Integrator Cloud Service vs. Pentaho Data Integration and Analytics and other solutions. Updated: March 2026.

DOWNLOAD NOW

885,311 professionals have used our research since 2012.

See our Oracle Data Integrator Cloud Service vs. Pentaho Data Integration and Analytics report.

See our list of best Cloud Data Integration vendors.

We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.