SQL Server to ClickHouse® CDC with Debezium 3.5 and Kafka 4: A Complete Beginner's Guide
Step-by-step tutorial to stream live changes from Microsoft SQL Server to ClickHouse® using Debezium 3.5, Apache Kafka 4, and the ClickHouse Kafka Connect Sink. Real Docker Compose setup, enabling SQL Server CDC and Agent, an open dataset with an ingest script, CDC verification steps, and a ReplacingMergeTree design that handles inserts, updates, and deletes.
Sanjeev Kumar GJune 22, 202613 min read