Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The SQL Server database connector is supported in Data Factory for Microsoft Fabric with the following capabilities.
Supported capabilities
| Supported capabilities | Gateway | Authentication |
|---|---|---|
| Dataflow Gen2 (source/-) | None On-premises Virtual network |
Basic Organizational account Service principal Windows |
| Data pipeline - Copy activity (source/-) - Lookup activity - Get Metadata activity - Script activity - Stored procedure activity |
None On-premises Virtual network |
Basic Organizational account Service principal |
| Copy job (source/destination) - Full load - CDC - Incremental load - Append - Merge |
None On-premises Virtual network |
Basic Organizational account Service principal |
Note
The Service principal authentication only applies to SQL Server on Azure VMs.
Related content
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 Data pipeline, go to Configure in a data pipeline copy activity.