Change Data Capture

Hello,

In Azure Data Factory or Azure Synapse Analytics, it is possible to natively use CDC (Change Data Capture) enabled on a SQL Server On-prem or Azure database.

Is the same or similar functionality for incremental loading planned?

Thanks

data factory

Data Factory | Pipelines

4 Comments

fbcideas_migusr
New Member
2 years ago
Glad to see it's planned. Would love to see an update and ETA on this.
nishalit
New Member
1 year ago
You are encouraged to try Copy Job in Fabric Data Factory, which delivered multiple data delivery style including both batch copy and incremental copy.

Native CDC is on the roadmap of Copy Job, which will come soon.
fbcideas_migusr
New Member
1 year ago
Status added:
Planned
yexu
Microsoft Employee
1 year ago
Status changed:
Planned
to
Completed
Please check this: Change data capture (CDC) in Copy Job - Microsoft Fabric | Microsoft Learn

Recent ideas

Provide a Read-Only / Source-Safe Mode for Schema Shortcuts in Lakehouse
Schema Shortcuts provide a much better management experience than individual Table Shortcuts because they preserve the source schema structure and allow multiple tables to be onboarded at once. Howev...
Junghyoen
Microsoft Employee
36 minutes ago
New
10Views
4likes
0Comments
Access Variable Library in Semantic Models
Enable the Variable Library as a centralized location for storing all environment‑specific variables, allowing us to adjust them for promotion scenarios (e.g., from dev to prod) without relying on de...
FreddyH
Advocate II
11 hours ago
New
920Views
31likes
2Comments
Enhance Fabric Pipeline Monitoring with Parent-Child Pipeline Lineage and Parameter Visibility
Currently, Microsoft Fabric Pipeline monitoring lacks several capabilities that are available in Azure Data Factory, making troubleshooting and operational support challenging in enterprise environme...
dwramreddy
Regular Visitor
12 hours ago
New
8Views
0likes
0Comments
Dynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...
mfink_db
New Member
16 hours ago
New
238Views
2likes
2Comments
Reintroduce Tenant/Capacity Switch to Control "Users can create Plan items" Post-GA
During the Preview phase of Fabric Plan items, administrators had access to a dedicated tenant/capacity setting: "Users can create Plan items". With General Availability (GA), this granular administr...
Sri-Surendra_Ku
New Member
19 hours ago
New
106Views
14likes
1Comment

Change Data Capture

Provide a Read-Only / Source-Safe Mode for Schema Shortcuts in Lakehouse

Access Variable Library in Semantic Models

Enhance Fabric Pipeline Monitoring with Parent-Child Pipeline Lineage and Parameter Visibility

Dynamic ADLS-Gen2 path input for Spark Jobs Main definition file

Reintroduce Tenant/Capacity Switch to Control "Users can create Plan items" Post-GA