Debezium SQL Server CDC Connector

By Debezium Community




  • Single Message Transform
  • Control Center Integration
  • Kafka Connect API
Download Connector


Debezium SQL Server CDC Connector

Debezium Community


Debezium’s SQL Server Connector can monitor and record the row-level changes in the schemas of a SQL Server 2017 database. This connector was added in Debezium 0.9.0.nnThe first time it connects to a SQL Server database/cluster, it reads a consistent snapshot of all of the schemas.

When that snapshot is complete, the connector continuously streams the changes that were committed to SQL Server and generates corresponding insert, update and delete events. All of the events for each table are recorded in a separate Kafka topic, where they can be easily consumed by applications and services.


Install your connector

Use the Confluent Hub client to install this connector with:

confluent-hub install debezium/debezium-connector-sqlserver:0.9.4

Or download the ZIP file and extract it into one of the directories that is listed on the Connect worker's plugin.path configuration properties. This must be done on each of the installations where Connect will be run. See here for more detailed instructions.

Configure an instance of your connector

Once installed, you can then create a connector configuration file with the connector's settings, and deploy that to a Connect worker. See here for more detailed instructions.

The source code is located in this repository.

For more information, see the documentation.

Rate this connector

We use cookies to understand how you use our site and to improve your experience. Click here to learn more or change your cookie settings. By continuing to browse, you agree to our use of cookies.