Copy job is the go-to solution in Microsoft Fabric Data Factory for simplified data movement, whether you’re moving data across clouds, from on-premises systems, or between services. With native support for multiple delivery styles, including bulk copy, incremental copy, and change data capture (CDC) replication, Copy job offers the flexibility to handle a wide range of data movement scenarios—all through an intuitive, easy-to-use experience.
This update introduces several enhancements related to CDC capabilities, including more supported data source stores, destination stores and enhanced monitoring experience with more detailed statistics for watermark values, load type, and row counts for inserts, updates, and deletions.
More CDC source store
Copy job now supports CDC (Change Data Capture) for even more sources, including SAP via Datasphere, Snowflake, and Google BigQuery.
Expanded_CDC_Support_for_More_Sources_amp_Destinations_-_Simplifying_Data_Ingest
With this enhancement, you can automatically capture inserts, updates, and deletions from these sources and replicate them to supported destinations—no watermark columns required, no manual refreshes, and no extra effort. This makes your data ingestion faster, more efficient, and reliable.
If you have interest to try Oracle CDC and more CDC source under Private Preview in Copy job, please feel free to submit your request Copy Job Sign Up Form.
Fabric Lakehouse table as CDC destination store
In addition, Copy job now supports merging CDC data into more destinations, including Fabric Lakehouse.
You can seamlessly merge inserts, updates, and deletions from supported sources into Fabric Lakehouse tables, ensuring your data is always up to date.
Observability enhancements for watermark info, load type, and detailed CDC statistics
What’s more, the monitoring experience of Copy job has been enhanced: you can now access more detailed statistics for each run, including watermark values, load type, and row counts for inserts, updates, and deletions, giving you full visibility over your Copy job.
Expanded_CDC_Support_for_More_Sources_amp_Destinations_-_Simplifying_Data_Ingest
Additional Resources
To learn more, explore the Microsoft Fabric Copy Job documentation.
Submit your feedback on Fabric Ideas and join the conversation in the Fabric Community.
If you have a question or want to share your feedback, please leave us a comment.
Microsoft Employee