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.
I have seen a return on investment; my team was able to stay extremely small even though we had a lot of data integrations with many companies.
I can testify to the return on investment with metrics regarding time saved; we have increased our efficiency by about 20 to 30 percent due to the swift migration processes facilitated by the tool.
The rating for Oracle GoldenGate support is a three.
The support team responds quickly, providing feedback which we then implement.
24/7 assistance is available for the Enterprise Edition.
take the time to understand our business requirements, offering appropriate recommendations.
Communication with the vendor is challenging
It effectively manages larger databases, such as those of 15 terabytes and above.
It can be scaled well until you reach a point where you need to perform a lot of operations, and the issue arises when it runs out of memory to handle some data.
Pentaho Data Integration handles larger datasets better.
Pentaho Data Integration and Analytics' scalability is commendable, as it allows us to scale up according to our needs.
Oracle GoldenGate is quite stable.
Performance issues arise due to reliance on a flowchart-based mechanism instead of scripts, which can lead to longer execution times.
I find that version 3.1 is the most stable version I have ever used.
It's pretty stable, however, it struggles when dealing with smaller amounts of data.
The configuration process could be made simpler.
For Oracle GoldenGate, customers face challenges with patching, the latest updates, and encountering bugs.
You can tune Oracle GoldenGate to use more RAM on the source side or more processes.
We should also explore more effective partitioning for parallel processing and fine-tuning database connections to reduce load times and improve ETL speed.
Pentaho Data Integration and Analytics can be improved by working with different environments, specifically the possibility to change the variables, meaning I write my variables only once and can change them for different environments such as production or development.
I also lack the option to use programming languages beyond Python and SQL, and a provision to incorporate Scala code in the scripting component would be beneficial.
The list price is high, and the price can sometimes seem expensive if the appropriate discount is not applied.
The pricing of Oracle GoldenGate is quite high.
I use the community version of Pentaho Data Integration and Analytics, and I do not need additional costs.
The setup cost was minimal, and the pricing experience was pretty good.
The most valuable feature of Oracle GoldenGate is its ability to sync data in real-time, which is crucial for me.
Oracle GoldenGate is beneficial for data replication and ensures secure data transport.
With Oracle GoldenGate, we were able to apply transformations to the data during the streaming between source and target.
Pentaho Data Integration and Analytics has positively impacted my organization because it meant we didn't have to write a lot of custom API back-end processing logic; it did the majority of that heavy lifting for us.
It automates the data workflow, including extraction, cleansing, and loading into warehouses for BI reporting purposes, while also removing duplicates, validating data, and standardizing formats, enabling real-time decision-making.
Pentaho Data Integration and Analytics has positively impacted my organization because it is easier to use, and my knowledge about this work facilitates the translation from the source to my final system.
| Product | Market Share (%) |
|---|---|
| Oracle GoldenGate | 1.8% |
| Pentaho Data Integration and Analytics | 1.5% |
| Other | 96.7% |
| Company Size | Count |
|---|---|
| Small Business | 22 |
| Midsize Enterprise | 5 |
| Large Enterprise | 30 |
| Company Size | Count |
|---|---|
| Small Business | 18 |
| Midsize Enterprise | 18 |
| Large Enterprise | 29 |
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.
