Activity continuity between Azure Data Factory (ADF) and Data Factory in Fabric

This documentation provides an overview of the activity continuity between Azure Data Factory (ADF) and Data Factory in Fabric. As you plan your data integration and orchestration workflows, it's essential to understand which activities are available on each platform. Data Factory in Fabric aims to offer comprehensive capabilities while maintaining compatibility with ADF.

Activity parity overview

With Data Factory in Microsoft Fabric, we continue to maintain a high degree of continuity with Azure Data Factory. Approximately 90% of activities accessible in ADF are already available under Data Factory in Fabric. Here is a breakdown of the activities and their availability in both ADF and Data Factory in Fabric:

Activity ADF Data Factory in Fabric
Append Variable Y Y
Copy Y Y
Delete Y Y
Execute/Invoke Pipeline Y Y
Fail Y Y
Filter Y Y
For Each Y Y
GetMetadata Y Y
If Y Y
Lookup Y Y
Script Y Y
Set Variable Y Y
Sproc Y Y
Switch Y Y
Until Y Y
Wait Y Y
Web Y Y
Webhook Y Y
Synapse Notebook Y Y
Azure Function/Functions Y Y
ADX/KQL Y Y
Azure Machine Learning Y Y
Azure Batch Y Y
Azure Databricks (3 activities in ADF) Y Y
Validation Y N
HDInsight (5 activities in ADF) Y N
SSIS Y N
Mapping Dataflow Y N
Dataflow Gen2 N/A Y
Office 365 Outlook N/A Y
Teams N/A Y
Dataset Refresh N/A N
Azure ML Batch Execution Deprecated N/A
Azure ML Update Resource Deprecated N/A
Power Query (ADF only - Wrangling Dataflow) Deprecated N/A
USQL Deprecated N/A

New activities in Fabric Data Factory

In addition to maintaining activity continuity, Data Factory in Fabric introduces some new activities to meet your richer orchestration needs. These new activities are:

  1. Outlook: Available in Fabric Data Factory to facilitate integration with Outlook services.
  2. Teams: Available in Fabric Data Factory to enable orchestration of Microsoft Teams activities.
  3. Dataset Refresh: In progress in Fabric Data Factory to enhance dataset refresh capabilities.
  4. Dataflow Gen2: Available in Fabric Data Factory to empower data orchestration with advanced dataflow capabilities.

Conclusion

With Data Factory in Fabric, you can confidently transition from Azure Data Factory while maintaining a high degree of activity continuity and benefiting from new capabilities. Please refer to this documentation Activity overview when planning your data integration and orchestration workflows in Fabric Data Factory.