Solved: How to Use a Fabric SQL Database as a Source in Fa...

bhavya5903 · ‎03-06-2025

Hi Community,

I am trying to set up Microsoft Fabric Eventstream and would like to use a Fabric SQL Database as a source to capture real-time changes. However, I don’t see a direct option to connect a Fabric SQL Database as a source in Eventstream.

TomOs · ‎03-06-2025

Currently, Microsoft Fabric Eventstream doesn’t support a direct connection to a Fabric SQL Database as a source. However, you can work around this by using Change Data Capture (CDC) in Synapse or Event Grid to stream changes. One approach is to enable CDC on your Fabric SQL table, push the changes to an Azure Event Hub, and then use that as a source for Eventstream.

Alternatively, if you have Power Automate or Logic Apps, you can set up a trigger on database updates and forward the data.

View solution in original post

TomOs · ‎03-06-2025

Currently, Microsoft Fabric Eventstream doesn’t support a direct connection to a Fabric SQL Database as a source. However, you can work around this by using Change Data Capture (CDC) in Synapse or Event Grid to stream changes. One approach is to enable CDC on your Fabric SQL table, push the changes to an Azure Event Hub, and then use that as a source for Eventstream.

Alternatively, if you have Power Automate or Logic Apps, you can set up a trigger on database updates and forward the data.