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."Scalability-wise, I rate the solution a ten out of ten."
"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."
"GoldenGate's best features are the desktop security features."
"GoldenGate can aggregate various data types from different sources."
"Its drag-and-drop interface lets me and my team implement all the solutions that we need in our company very quickly. It's a very good tool for that."
"The abstraction is quite good."
"I can use Python, which is open-source, and I can run other scripts, including Linux scripts. It's user-friendly for running any object-based language. That's a very important feature because we live in a world of open-source."
"One of the valuable features is the ability to use PL/SQL statements inside the data transformations and jobs."
"Sometimes, it took a whole team about two weeks to get all the data to prepare and present it. After the optimization of the data, it took about one to two hours to do the whole process. Therefore, it has helped a lot when you talk about money, because it doesn't take a whole team to do it, just one person to do one project at a time and run it when you want to run it. So, it has helped a lot on that side."
"I can create faster instructions than writing with SQL or code. Also, I am able to do some background control of the data process with this tool. Therefore, I use it as an ELT tool. I have a station area where I can work with all the information that I have in my production databases, then I can work with the data that I created."
"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 use Lumada’s ability to develop and deploy data pipeline templates once and reuse them. This is very important. When the entire pipeline is automated, we do not have any issues in respect to deployment of code or with code working in one environment but not working in another environment. We have saved a lot of time and effort from that perspective because it is easy to build ETL pipelines."
"The initial setup was a little complex, and we required support from Oracle to complete it."
"Oracle GoldenGate Cloud Service lacks AI. If AI gets introduced in Oracle GoldenGate Cloud Service, it would be much easier to do analysis."
"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."
"I would like to see more improvements with AS400 DB2."
"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."
"The support for the Enterprise Edition is okay, but what they have done in the last three or four years is move more and more things to that edition. The result is that they are breaking the Community Edition. That's what our impression is."
"There is not a data quality or MDM solution in the Pentaho DI suite."
"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..."
"I would like to see improvements made for real-time data processing."
"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."
"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."
More Oracle GoldenGate Cloud Service Pricing and Cost Advice →
More Pentaho Data Integration and Analytics Pricing and Cost Advice →
Oracle GoldenGate Cloud Service is ranked 19th in Cloud Data Integration with 4 reviews while Pentaho Data Integration and Analytics is ranked 16th in Data Integration with 48 reviews. Oracle GoldenGate Cloud Service is rated 8.8, while Pentaho Data Integration and Analytics is rated 8.0. The top reviewer of Oracle GoldenGate Cloud Service writes "A cost-effective and easy-to-use tool that needs to introduce AI features". On the other hand, the top reviewer of Pentaho Data Integration and Analytics writes "It's flexible and can do almost anything I want it to do". Oracle GoldenGate Cloud Service is most compared with AWS Database Migration Service, Confluent, Oracle GoldenGate and Azure Data Factory, whereas Pentaho Data Integration and Analytics is most compared with Azure Data Factory, SSIS, Talend Open Studio, Oracle Data Integrator (ODI) and AWS Glue. 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.
