| title | SQL Server database connector overview | ||
|---|---|---|---|
| description | This article provides an overview of the supported capabilities of the SQL Server database connector. | ||
| ms.topic | how-to | ||
| ms.date | 07/09/2025 | ||
| ms.custom |
|
The SQL Server database connector is supported in Data Factory for [!INCLUDE product-name] with the following capabilities.
| Supported capabilities | Gateway | Authentication |
|---|---|---|
| Dataflow Gen2 (source/-) | None On-premises Virtual network |
Basic Organizational account Service principal Workspace identity Windows (Only for on-premises gateway) |
| Pipeline - Copy activity (source/-) - Lookup activity - Get Metadata activity - Script activity - Stored procedure activity |
None On-premises Virtual network |
Basic Organizational account Service principal Windows (Only for on-premises gateway) |
| Copy job (source/destination) - Full load - CDC - Incremental load - Append - Override - Upsert - CDC Merge |
None On-premises Virtual network |
Basic Organizational account Service principal Windows (Only for on-premises gateway) |
Note
The Service principal authentication only applies to SQL Server on Azure VMs.
To learn about how to connect to SQL Server database, go to Set up your SQL Server database connection.
To learn more about the copy activity configuration for SQL Server database in a pipeline, go to Configure in a pipeline copy activity.