Azure SQL Database connector overview
This Azure SQL Database 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 SQL Database in Dataflow Gen2, go to Set up your connection in Dataflow Gen2.
Support in data pipelines
The Azure SQL Database connector supports the following capabilities in data pipelines:
| Supported capabilities | Gateway | Authentication |
|---|---|---|
| Copy activity (Source/Destination) | None On-premises |
Basic OAuth2 Service principal |
| Lookup activity | None On-premises |
Basic OAuth2 Service principal |
| GetMetadata activity | None On-premises |
Basic OAuth2 Service principal |
| Script activity | None On-premises |
Basic OAuth2 Service principal |
| Stored procedure activity | None On-premises |
Basic OAuth2 Service principal |
To learn about how to connect to Azure SQL Database in data pipelines, go to Set up your Azure SQL Database connection.
To learn about the copy activity configuration for Azure SQL Database in data pipelines, go to Configure Azure SQL Database in a copy activity.