'Need information on different CDC tools
as part of my project we need to use a CDC tool for near real time data replication of batches, delta information and metadata. The replication is from mainframe DB2 database to remote application.
I am not familiar to CDC concepts but need to screen and evaluate various tools to come up with a final one which will be best for solution. The parameters I could think of are,
- How does CDC tool transfers data with delta processes, batches or periodic jobs (CQRS Pattern)?
- How does it select relevant data and to transfer them with the required level of detail (schemas, tables, records, attributes)?
- Performance requirements regarding the latency and throughput and how to measure it.
- Reliability and Fault Tolerance
- Usability, Maintainability
Also, the tools I need to compare are IBM Infosphere, Qlik, Oracle Golden Gate, Talend Data Integration, Stream Sets, Striim, Equalum.
Could you please suggest any other parameters I should look for in the tools. If you could share any information regarding any parameter about any of the tools then it will be very helpful.
Thank you.
Solution 1:[1]
As for performance and latency, I would highly recommend Qlik Replicate. It captures changes from the transaction log files using the minimum resources. The data transfer between the source system and the target is really fast.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | grok82 |