Sep 09, 2021
We have experiences only in Pentaho Data Integrator (open source competitor of the Oracle Data Integrator).
But OLAP exporting wasn't in our scope until now.
Pentaho Data Integration and Oracle GoldenGate both compete in the realm of data solutions. Pentaho garners an advantage with its affordability and ease of use for small to medium-sized tasks, while Oracle GoldenGate stands out for real-time replication capabilities.
Features: Pentaho Data Integration features a user-friendly drag-and-drop interface, enhancing ease of use and rapid ETL development. It supports a wide range of data formats and allows seamless integration with big data technologies. Oracle GoldenGate shines in providing robust, real-time data replication capabilities and integrates strongly with Oracle databases, facilitating cross-platform migrations.
Room for Improvement:Pentaho could improve its debugging tools and upgrade processes, and enhance its documentation. Additionally, there's a need for better scheduling functionalities in its community version and improved cloud platform support. Oracle GoldenGate should focus on simplifying user experience, particularly for non-technical users, and advances are needed in monitoring tools and overall interface friendliness.
Ease of Deployment and Customer Service:Pentaho offers flexibility across on-premises, hybrid, and public cloud environments, complemented by strong community support, although technical support experiences vary. Oracle GoldenGate supports similar environments but often requires higher technical expertise, with complex management processes. Oracle provides comprehensive support, albeit at a higher cost and sometimes slower response rate.
Pricing and ROI: Pentaho is an affordable solution, especially with its free Community Edition, delivering good ROI by shortening ETL development time. This cost-effectiveness appeals to smaller businesses seeking robust BI solutions. On the other hand, Oracle GoldenGate is associated with high upfront costs due to core-based pricing but is valued by larger enterprises for its reliable replication services, with pricing models indicating a focus on large-scale enterprise needs.
Communication with the vendor is challenging
It effectively manages larger databases, such as those of 15 terabytes and above.
Pentaho Data Integration handles larger datasets better.
Oracle GoldenGate is quite stable.
It's pretty stable, however, it struggles when dealing with smaller amounts of data.
The configuration process could be made simpler.
Pentaho Data Integration is very friendly, it is not very useful when there isn't a lot of data to handle.
The pricing of Oracle GoldenGate is quite high.
The ability to sync data in real time is a key feature I rely on.
I find the drag and drop feature in Pentaho Data Integration very useful for integration.
Oracle GoldenGate is a real-time data integration and database replication solution. It can detect data events and route them across networks at very low latencies and integrates well with 100s of combinations of non-Oracle databases, data stores, and clouds.
Oracle GoldenGate Features
Oracle GoldenGate has many valuable key features, including:
Oracle GoldenGate Benefits
Some of the benefits of using Oracle GoldenGate include:
Reviews from Real Users
Below are some reviews and helpful feedback written by Oracle GoldenGate users.
PeerSpot user Steve-J., Cloud Migration Software Consultant - UK & EMEA at 1PLACE, says, "What I have found the most valuable about GoldenGate is that it does real-time and no-downtime migrations. Its migrations are fast. There are not many tools like it on the marketplace."
Pinak S., Senior Manager of System and Database at ESL, mentions, “We like how in GoldenGate the heterogeneous database is supported. Sometimes the client actually needs a schedule and needs to ensure the state of databases for reporting purposes. With that in mind, we have been able to configure GoldenGate for certain schema. The solution is quite stable. They've recently improved the ease of implementation.”
A Database Administrator at a manufacturing company explains, "It moves the data as you set it up, and it works. I am also very impressed with its stability and scalability. It is not super feature-rich, but the new releases have more functionality. It recently had more native integrations with Oracle Database. If you are using it against an Oracle database, it has a lot more functionality."
An Oracle ERP DBA Consultant - Oracle Super Cluster T5-8 Admin at a government comments, "GoldenGate can connect and collect data from multiple sources, such as SQL Server."
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.
We monitor all 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.
