| title | SQL database connector overview | ||
|---|---|---|---|
| description | This article explains the overview of using SQL database. | ||
| ms.reviewer | jianleishen | ||
| ms.topic | how-to | ||
| ms.date | 03/04/2026 | ||
| ms.custom |
|
The SQL database connector is supported in Data Factory for [!INCLUDE product-name] with the following capabilities.
| Supported capabilities | Gateway | Authentication |
|---|---|---|
| Dataflow Gen2 (source/destination) | None On-premises Virtual network |
Organizational account |
| Pipeline - Copy activity (source/destination) - Lookup activity - Get Metadata activity - Script activity - Stored procedure activity |
None On-premises Virtual network |
Organizational account |
| Copy job (source/destination) - Full load - Incremental load - Append - Override - Upsert - CDC Merge |
None On-premises Virtual network |
Organizational account |
To learn about how to connect to SQL Database in pipelines, go to Set up your SQL Database connection.
To learn about the copy activity configuration for SQL database in pipelines, go to Configure SQL database in a copy activity.