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.