Azure SQL Database connector overview

  • Article

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.