Heterogeneous data replication - connect_cdc_sqdata - Latest

Connect CDC (SQData) Architecture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Architecture
Copyright
2024
First publish date
2000
Last edition
2024-07-30
Last publish date
2024-07-30T20:18:12.036227

New application development as well as the integration of purchased applications are typically taking place on both platforms and using database technology unavailable when many primary line-of-business applications were implemented. Implementation inevitably requires data from existing applications. Typically the new applications can operate with a one way flow of data from the existing applications.

Replication of Change Data from the existing application database to an often newer database technology can be complex. Heterogeneous data replication is however a major strength of Connect CDC (SQData) and is the tool of choice for application integration requiring uninterrupted 24x7 operation every day of the year.

There are many examples of replication between dissimilar Source and Target database structures as well as different flavors of Relational Database managers.

IMS to Db2 and Kafka

A single source Capture can be published to two subscribing Engines, in this example an Apply Engine updating a Db2 target and a Replicator Engine updating Kafka.

Oracle to Db2 and Kafka

Another example would be single source Capture can be published to two subscribing Engines, in this example an Apply Engine updating a Db2 target and a Replicator Engine updating Kafka.