Showing results for 
Search instead for 
Did you mean: 
New Member

Change Data Capture

I'm hoping that we will see an increase in connectors that support CDC, we have SQL Server and SAP I believe now, but would love to see this expanded out over Oracle, DB2 (LUW & AS400), MySQL, Postrgre etc.  Working with larger source systems across Wans; it's just not efficent to move millions let alone billions of rows repeatedly, not everything has a reliable timestamp, nor the control to modify the source table structures to add.



Could you please share more information? What are you referring to Change Data Capture in the context of Microsoft Data Factory Dataflows?

I'm sure he's in exactly the same case I am. We have an on-prem SQL server database that will most likely never move to the cloud - is supports our EPIC medical system. I'd love to move the data from it up to Fabric. But there is no way that nightly I can move billions of rows of data.


We'd like CDC so we can do one gigantic "initial load", and after that run nightly incremental processes to only get records that changed. That "should" be doable from a volume standpoint - I don't think copying the entire database is.


Note this is on-prem SQL server, not Azure SQL.


Hope this helps,


Helpful resources

Welcome to the Data Factory (preview) Community

Join Today

Learn more about the Data Factory (preview) Community and how you can participate.

Get Help with Data Factory in the General Discussion Forum

General Discussion Forum

Ask your questions about Data Factory here!

Webinars and Video Gallery

Webinars and Video Gallery

Learn more about Data Factory through webinars and short videos.


Check out the latest on analytics in Microsoft Fabric!

Microsoft Fabric brings everything you need into one analytics solution.

Top Solution Authors
Top Kudoed Authors