Azure Synapse Analytics connector overview

This Azure Synapse Analytics connector is supported in Data Factory for Microsoft Fabric with the following capabilities.

Support in Dataflow Gen2

To learn about how to connect to Azure Synapse Analytics in Dataflow Gen2, go to Set up your connection in Dataflow Gen2.

Support in data pipelines

The Azure Synapse analytics connector supports the following capabilities in data pipelines.

Supported capabilities Gateway Authentication
Copy activity (Source/Destination) None
On-premises
Basic
Organizational account
Service principal
Lookup activity None
On-premises
Basic
Organizational account
Service principal
GetMetadata activity None
On-premises
Basic
Organizational account
Service principal
Script activity None
On-premises
Basic
Organizational account
Service principal
Stored procedure activity None
On-premises
Basic
Organizational account
Service principal

To learn about the copy activity configuration for Azure Synapse Analytics in data pipelines, go to Configure Azure Synapse Analytics in a copy activity.