Native SQL CDC Support in ADF

[@MrPkrol1]

Thanks for the great example, only problem I have with it it runs for the first time fine, second round it complains about invalid object some cdc internal function, no clue why?

[@MSDataFactory]

Can you open a support ticket with Azure so that we can take a look at your factory?

[@manuelfajardo1867]

I have a datetime column called _datafactory_modifieddate_, is there a way to update that date when the row has been altered?

[@sid0000009]

Are there any recommendations to choose between CDC and Change Tracking for Incremental Loads? Most customers would have a Self Hosted IR due to Security reasons so having a Change Tracking with Lookup and Copy operation could be a optimal fit ? While CDC would work only with Mapping DFs which would mean supported only by Azure IR. Storage overhead also would be lighter. It would be interest to know in which cases which one would be a better fit. thanks for your educational videos really helps!

[@MSDataFactory]

When you use the Azure IR with features in ADF like data flows, you can enable managed vnet on the IR in order to achieve the same security as provided by hosting the IR on your own with self-hosted VMs.

[@sid0000009]

@@MSDataFactory yeah that is a nice add on...although I feel for CDC given a choice Change Tracking would be a preferred option...given CDC has a big overhead....

[@anujgupta-lc1md]

Does this feature works when source is onprem sql server and destination is azure sql database.

[@MSDataFactory]

yes

[@sid0000009]

@@MSDataFactory how would a Mapping Data Flow support an on-prem SQL DB...is that connection possible at the moment. Also the MS documentation doesnt list in the supported connector list. Although SQL on-prem would have CDC enabled how we can possibly connect such data sources via the Data set used inside Mapping DF- Managed Vnet would support an on-prem connectivity ? thanks!

[@MSDataFactory]

@@sid0000009 Here is the list of supported CDC sources ... SQL Server on-prem is supported. learn.microsoft.com/en-us/azure/data-factory/concepts-change-data-capture

[@sid0000009]

@@MSDataFactory yeap i saw it before could only see Azure SQL family supported. Managed vnet doesn't support on-prem connections either... May be i am missing a point...i will revisit the MS docs :)

[@MSDataFactory]

@@sid0000009 Yes, you can use Managed Vnet to connect to SQL on prem: learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server

[@harikrishnarevuri5480]

Hi, is it support source as Teradata

[@MSDataFactory]

Not at this time