Oracle GoldenGate Cloud Service vs Pentaho Data Integration and Analytics comparison

Oracle GoldenGate Cloud Service vs. Pentaho Data Integration and Analytics

Download the complete report

Helped 869,760 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.1

Number of Reviews

Ranking in other categories

Cloud Data Integration (22nd)

Pentaho Data Integration an...

Average Rating

8.0

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Integration (18th)

Featured Reviews

Tarek Diab

Advisor Business Analysis & Data Management at Saudi Telecom Company

Real-time integration and seamless data synchronization enhance user experience

The stability of Oracle GoldenGate Cloud Service is one of its most useful features, although its performance is not too steady. It excels with bidirectional data synchronization. It supports diverse databases and platforms. We link the ODS with numerous source systems, including Oracle, Tarek Data, and Microsoft, with no integration issues. The solution caters to enterprise needs, fitting any organizational requirement, apart from data security issues common to cloud solutions. The cloud data security challenge is notable, necessitating solutions such as private cloud offerings to allay security concerns.

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

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

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

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

"The stability of Oracle GoldenGate Cloud Service is one of its most useful features, although its performance is not too steady; it excels with bidirectional data synchronization and supports diverse databases and platforms."

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

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

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

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

More Oracle GoldenGate Cloud Service pros

"Provides a good open source option."

"The area where Lumada has helped us is in the commercial area. There are many extractions to compose reports about our sales team performance and production steps. Since we are using Lumada to gather data from each industry in each country. We can get data from Argentina, Chile, Brazil, and Colombia at the same time. We can then concentrate and consolidate it in only one place, like our data warehouse. This improves our production performance and need for information about the industry, production data, and commercial data."

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

"It is easy to use, install, and start working with."

"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. We can do predictive analysis on trends coming in for contracts, which is what our product does. The product helps users decide which way to go based on the predictive analysis done by Pentaho. Pentaho is not doing predictions, but reporting on the predictions that our product is doing. This is a big part of our product."

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

"We also haven't had to create any custom Java code. Almost everywhere it's SQL, so it's done in the pipeline and the configuration. That means you can offload the work to people who, while they are not less experienced, are less technical when it comes to logic."

More Pentaho Data Integration and Analytics pros

Cons

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

"With Oracle GoldenGate Cloud Service, we have usual cloud solution issues such as privacy and data security."

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

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

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

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

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

"Support could be improved. They lack knowledge."

More Oracle GoldenGate Cloud Service cons

"In the Community edition, it would be nice to have more modules that allow you to code directly within the application. It could have R or Python completely integrated into it, but this could also be because I'm using an older version."

"The product needs more plugins."

"I would like to see more improvements with AS400 DB2."

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

"I was not happy with the Pentaho Report Designer because of the way it was set up. There was a zone and, under it, another zone, and under that another one, and under that another one. There were a lot of levels and places inside the report, and it was a little bit complicated. You have to search all these different places using a mouse, clicking everywhere... each report is coded in a binary file... You cannot search with a text search tool..."

"Larger data jobs take more time to execute."

"Parallel execution could be better in Pentaho. It's very simple but I don't think it works well."

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

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

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

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

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

"You need to go through the paid version to have Hitachi Lumada specialized support. However, if you are using the free version, then you will have only the community support. You will depend on the releases from Hitachi to solve some problem or questions that you have, such as bug fixes. You will need to wait for the newest versions or releases to solve these types of problems."

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

"I mostly used the open-source version. I didn't work with a license."

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

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

869,760 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

12%

Manufacturing Company

10%

Computer Software Company

Performing Arts

Financial Services Firm

18%

Computer Software Company

11%

Government

Manufacturing Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	3
Midsize Enterprise	1
Large Enterprise	4

By reviewers
Company Size	Count
Small Business	17
Midsize Enterprise	16
Large Enterprise	25

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.

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

I do not have an idea about the solution's cost, but given the ongoing use, it appears to be good for them.

What needs improvement with Oracle GoldenGate Cloud Service?

With Oracle GoldenGate Cloud Service, we have usual cloud solution issues such as privacy and data security. These issues especially concern clients needing a private cloud solution to meet regulat...

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

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

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

AWS Database Migration Service vs Oracle GoldenGate Cloud Service

Comparisons

Compared 32% of the time

Oracle GoldenGate vs Oracle GoldenGate Cloud Service

Compared 27% of the time

JumpMind SymmetricDS vs Oracle GoldenGate Cloud Service

Compared 17% of the time

SEEBURGER Business Integration Suite vs Oracle GoldenGate Cloud Service

Compared 14% of the time

Fivetran vs Oracle GoldenGate Cloud Service

Compared 10% of the time

More Oracle GoldenGate Cloud Service Competitors

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

Compared 14% of the time

Informatica PowerCenter vs Pentaho Data Integration and Analytics

Compared 10% of the time

SSIS vs Pentaho Data Integration and Analytics

Compared 9% of the time

SnapLogic vs Pentaho Data Integration and Analytics

Compared 9% of the time

Talend Open Studio vs Pentaho Data Integration and Analytics

Compared 8% of the time

More Pentaho Data Integration and Analytics Competitors

Product Reports

Cloud Data Integration

Download Oracle GoldenGate Cloud Service product report

Pentaho Data Integration and Analytics

Download Pentaho Data Integration and Analytics product report

Pentaho Data Integration and Analytics 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

Oracle GoldenGate Cloud Service vs. Pentaho Data Integration and Analytics