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.