Forum Discussion
Eventstream from On-Premise (Azure VM) SQL Server CDC?
We have SQL Server Enterprise running on an Azure VM. While we are able to create a gateway, there does not appear to be a connector to bring it through an Evenstream. Our objective is to keep our ...
Microsoft solution: Add SQL Server Change Data Capture as a source to eventstream - Microsoft Fabric | Microsoft Learn
Non-Microsoft but open source options, both require CDC turned on on the SQL Server:
- Kafke with Kafke Connect with a Debezium connector to retrieve the changing data from the SQL Server as a Source, then the Apache Kafka endpoint from Event Streaming as Sink.
- Apache Pulsar with the Debezium connector to retrieve the changing data from the SQL Server as a Source, then the Apache Kafka endpoint from Event Streaming as Sink.
Add Apache Kafka source to a Fabric eventstream - Microsoft Fabric | Microsoft Learn