Oracle GoldenGate 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 94% of Hitachi Vantara users who would recommend it.

Oracle GoldenGate Cloud Ser...

Read 7 Oracle GoldenGate Cloud Service reviews

611 Views
263 Comparison Views

100% willing to recommend

Pentaho Data Integration an...

Read 53 Pentaho Data Integration and Analytics reviews

2,542 Views
1,932 Comparison Views

94% willing to recommend

Oracle GoldenGate Cloud Ser...

Pentaho Data Integration an...

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Oracle GoldenGate 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 GoldenGate Cloud Service vs. Pentaho Data Integration and Analytics Report (Updated: July 2025).

Buyer's Guide

Oracle GoldenGate Cloud Service vs. Pentaho Data Integration and Analytics

July 2025

Download the complete report

Helped 861,803 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 GoldenGate Cloud Ser...

Average Rating

8.0

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

Cloud Data Integration (21st)

Pentaho Data Integration an...

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Integration (19th)

Featured Reviews

Emmanuel Catalano

DBA at Gruppo SCAI

Offers reliable data management and simple to use but requires more intuitive configuration

I am not very happy with Oracle Support. Over the past four to five years, I have experienced many problems when opening support requests. A lot of the time, the support asks the same questions repeatedly, which takes time. Usually, I solve my issue myself before they give me solutions. It seems like they do not really understand my problem, even if I translate what I want to say from Italian with tools like Google Translate. Sometimes it is very difficult to communicate with them. We have some Oracle support staff in Italy whom I can reach directly, which helps, but there seems to be a problem with the support requests. It is also an issue when different Oracle representatives handle my request at different times and ask me to explain the problem again despite it being written in the support request. This makes it very frustrating. Additionally, issues arise with product understanding. For example, in dedicated infrastructure, the Oracle staff handling the support request may not be familiar with the product or suggest solutions suitable for other infrastructures but not mine. Oracle Support should know the solutions that fit my infrastructure since they manage it, not me.

Read full review

Aqeel UR Rehman

BI Analyst at a computer software company with 51-200 employees

Transform data efficiently with rich features but there's challenges with large datasets

Currently, I am using Pentaho Data Integration for transforming data and then loading it into different platforms. Sometimes, I use it in conjunction with AWS, particularly S3 and Redshift, to execute the copy command for data processing Pentaho Data Integration is easy to use, especially when…

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

"We are heavily involved with GitHub for managing repositories, automatic deployments, and inner source projects."

"Oracle GoldenGate Cloud Service is valued for its ability to replicate data in real-time, offering significant benefits from a data perspective."

"This has significantly eased the process of migration from on-premise to cloud. Instead of configuring everything from the ground up, the Oracle GoldenGate Cloud Service has made it seamless to build and render databases in cloud."

"Oracle Database generally guarantees a good response for customer use cases."

"GoldenGate's best features are the desktop security features."

"It provides a good response for external microservices applications."

"Scalability-wise, I rate the solution a ten out of ten."

"GoldenGate can aggregate various data types from different sources."

"The solution offers features for data integration and migration. Pentaho Data Integration and Analytics allows the integration of multiple data sources into one. The product is user-friendly and intuitive to use for almost any business."

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

"The fact that it's a low-code solution is valuable. It's good for more junior people who may not be as experienced with programming."

"It has improved our data integration capabilities."

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

"We can schedule job execution in the BA Server, which is the front-end product we're using right now. That scheduling interface is nice."

"This solution allows us to create pipelines using a minimal amount of custom coding."

"The amount of data that it loads and processes is good."

More Pentaho Data Integration and Analytics pros

Cons

"The initial setup was a little complex, and we required support from Oracle to complete it."

"Support could be improved. They lack knowledge."

"Pricing is rather expensive. Oracle typically prices on the higher side, and there is scope for them to reconsider the price, especially since it is a cloud service."

"I am not very happy with Oracle Support. Over the past four to five years, I have experienced many problems when opening support requests."

"Over the past four to five years, I have experienced many problems when opening support requests."

"More technical documentation is needed, especially in terms of mapping and conversion of data, while integration would also be very helpful."

"Oracle GoldenGate Cloud Service lacks AI. If AI gets introduced in Oracle GoldenGate Cloud Service, it would be much easier to do analysis."

"Oracle is always adding new features. I can't think of anything that's urgent currently."

"Lumada could have more native connectors with other vendors, such as Google BigQuery, Microsoft OneDrive, Jira systems, and Facebook or Instagram. We would like to gather data from modern platforms using Lumada, which is a better approach. As a comparison, if you open Power BI to retrieve data, then you can get data from many vendors with cloud-native connectors, such as Azure, AWS, Google BigQuery, and Athena Redshift. Lumada should have more native connectors to help us and facilitate our job in gathering information from these new modern infrastructures and tools."

"I would like to see support for some additional cloud sources. It doesn't support Azure, for example. I was trying to do a PoC with Azure the other day but it seems they don't support it."

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

"It's not very stable, at least not in the case of the community edition. I'm working with the community edition right now and I think perhaps it is because of that it is not very stable, it causes the system to sometimes hang. I'm not sure if this is the case for pair tiers."

"Its basic functionality doesn't need a whole lot of change. There could be some improvement in the consistency of the behavior of different transformation steps. The software did start as open-source and a lot of the fundamental, everyday transformation steps that you use when building ETL jobs were developed by different people. It is not a seamless paradigm. A table input step has a different way of thinking than a data merge step."

"Communicating with the vendor is challenging, and this hinders its performance in free tool setups."

"Since Hitachi took over, I don't feel that the documentation is as good within the solution. It used to have very good help built right in."

"If you're working with a larger data set, I'm not so sure it would be the best solution. The larger things got the slower it was."

More Pentaho Data Integration and Analytics cons

Pricing and Cost Advice

"I rate the product price a six on a scale of one to ten, where one is cheap, and ten is expensive."

"The solution reduced our ETL development time by a lot because a whole project used to take about a month to get done previously. After having Lumada, it took just a week. For a big company in Brazil, it saves a team at least $10,000 a month."

"We are using the Community Edition. We have been trying to use and sell the Enterprise version, but that hasn't been possible due to the budget required for it."

"Sometimes we provide the licenses or the customer can procure their own licenses. Previously, we had an enterprise license. Currently, we are on a community license as this is adequate for our needs."

"I primarily work on the Community Version, which is available to use free of charge."

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

"You don't need the Enterprise Edition, you can go with the Community Edition. That way you can use it for free and, for free, it's a pretty good tool to use."

"I believe the pricing of the solution is more affordable than the competitors"

"For most development tasks, the Enterprise edition should be sufficient. It depends on the type of support that you require for your production environment."

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

861,803 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

13%

Computer Software Company

Energy/Utilities Company

Manufacturing Company

Financial Services Firm

21%

Computer Software Company

14%

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Oracle GoldenGate Cloud Service?

Scalability-wise, I rate the solution a ten out of ten.

See all answers

What is your experience regarding pricing and costs for Oracle GoldenGate Cloud Service?

Pricing is rather expensive. Oracle typically prices on the higher side, and there is scope for them to reconsider the price, especially since it is a cloud service.

See all answers

What needs improvement with Oracle GoldenGate Cloud Service?

One area that could be improved is the configuration flexibility. There are a lot of restrictions on how it can be configured because it is being deployed in the cloud. More flexibility for develop...

See all answers

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

AWS Database Migration Service vs Oracle GoldenGate Cloud Service

Compared 43% of the time

Oracle GoldenGate vs Oracle GoldenGate Cloud Service

Compared 32% of the time

JumpMind SymmetricDS vs Oracle GoldenGate Cloud Service

Compared 9% of the time

Confluent vs Oracle GoldenGate Cloud Service

Compared 9% of the time

Fivetran vs Oracle GoldenGate Cloud Service

Compared 8% of the time

More Oracle GoldenGate Cloud Service Competitors

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

Compared 15% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 11% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 9% of the time

Talend Open Studio vs Pentaho Data Integration and Analytics

Compared 9% of the time

Azure Data Factory vs Pentaho Data Integration and Analytics

Compared 7% of the time

More Pentaho Data Integration and Analytics Competitors

Product Reports

Buyer's Guide

Cloud Data Integration

July 2025

Download Oracle GoldenGate Cloud Service product report

Buyer's Guide

Pentaho Data Integration and Analytics

June 2025

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

GoldenGate Cloud Service is a cloud based real-time data integration and replication service, which provides seamless data movement from various on-premises relational databases to databases in the cloud while maintaining data consistency and offering fault tolerance and resiliency.

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

FORTH, Capital One

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

Buyer's Guide

Oracle GoldenGate Cloud Service vs. Pentaho Data Integration and Analytics

July 2025

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

Find out what your peers are saying about Oracle GoldenGate Cloud Service vs. Pentaho Data Integration and Analytics and other solutions. Updated: July 2025.

DOWNLOAD NOW

861,803 professionals have used our research since 2012.

See our Oracle GoldenGate 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.