Use case solutions - 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

This section details some of the solutions that Connect CDC (SQData) solves.

The tools provided by Connect CDC (SQData) address many different business issues with a single installation on your source and target platforms. Some of the most common use cases include:

  • Real-Time Streaming - Simplify propagation of business events and operational data directly into Kafka or Hadoop using JSON or AVRO
  • Heterogeneous Data Replication - Change Data capture, Transformation and Load/Apply are not restricted to identical database managers or operating platforms
  • Active - Active Replication - Synchronization between two or more like databases, with near-real-time latency for load balancing and/or continuous operation and disaster recovery
  • Event Publishing - Identify Key business events, through the changes that are captured and published with near-real-time latency, to downstream process or message queuing tool.
  • Data Conversion / Migration - Content from any type of source datastore can be extracted, transformed and loaded to any other type of datastore, either all at once or using CDC, for phased implementations where data must flow back and forth to the database of record.