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

OneLake Catalog full-text and content search
Why is it not possible to search OneLake by item description or even content? So I was thinking about how a user can find a table if they don't know in which lakehouse it is located? Why can't you se...
TePe
Helper IV
13 hours ago
Planned
1.1KViews
21likes
5Comments
Allow External OneLake Data Shares to Be Accepted into Multiple Fabric Item Types
Fabric External Data Sharing provides an excellent zero-copy mechanism for sharing OneLake data across tenants. However, the receiving tenant currently has to accept the share into a Lakehouse. I w...
Mourak
New Member
1 day ago
New
6Views
0likes
0Comments
Allow OneLake Shortcut Authentication Mode to Be Changed In Place
OneLake shortcuts support passthrough and delegated authentication, but changing the authentication model currently requires deleting and recreating the shortcut. I would like shortcut authenticatio...
Mourak
New Member
1 day ago
New
7Views
0likes
0Comments
Tenant-Wide OneLake Shortcut Lineage and Impact Analysis
This is grounded in a documented limitation: shortcut lineage is currently workspace-scoped, and Microsoft specifically says lineage for shortcuts to warehouses and semantic models isn't currently av...
Mourak
New Member
1 day ago
New
17Views
0likes
1Comment
Add an End-to-End Production Reference Architecture for Microsoft Fabric Real-Time Intelligence
I would like to see a complete end-to-end Microsoft Fabric Real-Time Intelligence reference architecture that demonstrates how the individual RTI capabilities work together in a production-oriented s...
Mourak
New Member
1 day ago
New
6Views
0likes
0Comments

Change Data Capture

OneLake Catalog full-text and content search

Allow External OneLake Data Shares to Be Accepted into Multiple Fabric Item Types

Allow OneLake Shortcut Authentication Mode to Be Changed In Place

Tenant-Wide OneLake Shortcut Lineage and Impact Analysis

Add an End-to-End Production Reference Architecture for Microsoft Fabric Real-Time Intelligence