Heterogeneous data replication - connect_cdc_sqdata - 4.1

Connect CDC (SQData) Architecture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
4.1
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Architecture
Topic type
Installation
How Do I
Copyright
2024
First publish date
2000
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T13:24:57.122078

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.