Edit

Share via

SQL database connector overview (Preview)

  • Article

SQL database in Microsoft Fabric is a developer-friendly transactional database, based on Azure SQL Database, that allows you to easily create your operational database in Fabric. A SQL database in Fabric uses the same SQL Database Engine as Azure SQL Database. For more information, see this article.

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

Support in data pipelines

The SQL database connector supports the following capabilities in data pipelines:

Supported capabilities Gateway Authentication
Copy activity (Source/Destination) None
On-premises		 User Auth
Lookup activity None
On-premises		 User Auth
GetMetadata activity None
On-premises		 User Auth

To learn about how to connect to SQL Database in data pipelines, go to Set up your SQL Database connection.

To learn about the copy activity configuration for SQL database in data pipelines, go to Configure SQL database in a copy activity.