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.