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."GoldenGate can aggregate various data types from different sources."
"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."
"Scalability-wise, I rate the solution a ten out of ten."
"GoldenGate's best features are the desktop security features."
"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."
"It makes it pretty simple to do some fairly complicated things. Both I and some of our other BI developers have made stabs at using, for example, SQL Server Integration Services, and we found them a little bit frustrating compared to Data Integration. So, its ease of use is right up there."
"The fact that it enables us to leverage metadata to automate data pipeline templates and reuse them is definitely one of the features that we like the best. The metadata injection is helpful because it reduces the need to create and maintain additional ETLs. If we didn't have that feature, we would have lots of duplicated ETLs that we would have to create and maintain. The data pipeline templates have definitely been helpful when looking at productivity and costs."
"The amount of data that it loads and processes is good."
"I absolutely love Hitachi. I'm one of the forefront supporters of Hitachi for my firm. It's so easy to integrate within our environments. In terms of being able to quickly build ETL jobs, transform, and then automate them, it's really easy to integrate throughout for data analytics."
"One of the most valuable features is the ability to create many API integrations. I'm always working with advertising agents and using Facebook and Instagram to do campaigns. We use Pentaho to get the results from these campaigns and to create dashboards to analyze the results."
"Data transformation within Pentaho is a nice feature that they have and that I value."
"It has improved our data integration capabilities."
"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."
"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."
"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."
"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."
"I work with the Community Edition, therefore I do not have support. There was an issue that I could not resolve with community support."
"The product needs more plugins."
"As far as I remember, not all connectors worked very well. They can add more connectors and more drivers to the process to integrate with more flows."
"I work with different databases. I would like to work with more connectors to new databases, e.g., DynamoDB and MariaDB, and new cloud solutions, e.g., AWS, Azure, and GCP. If they had these connectors, that would be great. They could improve by building new connectors. If you have native connections to different databases, then you can make instructions more efficient and in a more natural way. You don't have to write any scripts to use that connector."
"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."
"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..."
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, Azure Data Factory and JumpMind SymmetricDS, 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.