Microsoft SQL Server CDC

Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. The latest version, SQL Server 2022, integrates with Azure Synapse Link and Microsoft Purview to enable customers to drive deeper insights, predictions, and governance from their data at scale. Cloud integration is enhanced with managed disaster recovery (DR) to Azure SQL Managed Instance, along with near real-time analytics, allowing database administrators to manage their data estates with greater flexibility and minimal impact to the end-user. Performance and scalability are automatically enhanced via built-in query intelligence.

If you are interested in a direct Decodable Connector for SQL Server CDC, please contact support@decodable.co or join our Slack community and let us know!

Overview

Connector name

mssql-cdc

Type

source

Delivery guarantee

exactly once

Getting Started

Sending a data stream from SQL Server CDC to Decodable is accomplished in two stages, first by populating an AWS Kinesis stream with SQL Server CDC data, and then by adding and configuring a Kinesis source connector in Decodable.

Create Kinesis Data Source

To capture a data change stream from SQL Server, a Debezium server is created with an SQL Server CDC connector, which populates an AWS Kinesis stream.

  1. Set up SQL Server

  2. Enable CDC in MSSQL

  3. Create a Kinesis Stream in AWS

  4. Download Debezium server

  5. Download SQL Server JDBC Driver

  6. Edit the conf/application.properties

For more detailed information, please refer to the SQL Server CDC example in the Decodable GitHub repository.

Configure A Kinesis Source

Sign in to Decodable Web and follow the configuration steps provided for the AWS Kinesis to create a source connector. For examples of using the command line tools or scripting, see the How To guides.