Edit

Share via

SQL Server database connector overview

  • Article

The SQL Server database connector is supported in Data Factory for Microsoft Fabric with the following capabilities.

Support in Dataflow Gen2

For information on how to connect to a SQL Server database in Dataflow Gen2, go to Set up your SQL Server database connection.

Support in Data pipeline

The SQL Server database connector supports the following capabilities in Data pipeline:

Supported capabilities Gateway Authentication
Copy activity (source/destination) None
On-premises		 Basic
Lookup activity None
On-premises		 Basic
GetMetadata activity None
On-premises		 Basic
Script activity None
On-premises		 Basic
Stored procedure activity None
On-premises		 Basic

To learn more about the copy activity configuration for SQL Server database in Data pipeline, go to Configure in a data pipeline copy activity.