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.
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.
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.
- Set up SQL Server
- Enable CDC in MSSQL
- Create a Kinesis Stream in AWS
- Download Debezium server
- Download SQL Server JDBC Driver
- Edit the conf/application.properties
For more detailed information, please refer to the SQL Server CDC example in the Decodable GitHub repository.
Sign in to the Decodable Web Console and follow the configuration steps provided for the AWS Kinesis Connector to create a
source connector. For examples of using the command line tools or scripting, see the How To guides.
|Delivery guarantee||exactly once|
Updated about 1 year ago