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.
In the realm of data management software, Talend Data Management Platform and Oracle GoldenGate stand as prominent contenders. Talend seems to have the upper hand due to its cost-effectiveness and user-friendly features.
Features: Talend Data Management Platform is recognized for its real-time data integration, a vast selection of connectors, and open-source ETL transformations. It is also praised for its advanced monitoring capabilities and seamless integration with cloud infrastructure. Oracle GoldenGate, on the other hand, is known for its real-time data replication across multiple databases, offering robust CDC capabilities and excellent compatibility with Oracle databases.
Room for Improvement: Talend faces challenges with installation errors, crashes, and limited multitasking capabilities. Its documentation and administrative interfaces require enhancements, and there's a need for improved platform connectivity. Oracle GoldenGate needs to address its complex user interfaces, high licensing costs, and inadequate monitoring tools. There is also a call for better cross-platform database integration and troubleshooting abilities.
Ease of Deployment and Customer Service: Talend offers a combination of on-premises and cloud deployments, with mixed reviews on its technical support, highlighting a need for more knowledgeable assistance. Oracle GoldenGate is predominantly used in on-premises and hybrid cloud settings, but it receives criticism for its costly and less intuitive service, indicating a requirement for improved customer support and technical help.
Pricing and ROI: Talend provides a cost-effective solution with flexible subscription models that lower upfront costs, maintaining a competitive pricing strategy. Oracle GoldenGate, however, is perceived as expensive due to its core-based pricing and additional service fees. Despite this, its strong performance and stability may justify the higher investment for larger enterprises. Both platforms offer savings in data integration, enabling quicker ROI compared to traditional solutions.
It effectively manages larger databases, such as those of 15 terabytes and above.
Oracle GoldenGate is quite stable.
We have not encountered many issues with remote engines, and the interfaces are properly developed.
The configuration process could be made simpler.
Data management could also encompass APIs and real-time streaming data integration.
The pricing of Oracle GoldenGate is quite high.
The ability to sync data in real time is a key feature I rely on.
I have successfully requested the necessary patch from Talend support multiple times to align different studio versions across the team of developers.
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."
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.
