Forum Discussion
How to Use a Fabric SQL Database as a Source in Fabric Eventstream?
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.
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.
1 Reply
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.