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.
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 Service principal |
| Lookup activity | None On-premises |
Basic Service principal |
| GetMetadata activity | None On-premises |
Basic Service principal |
| Script activity | None On-premises |
Basic Service principal |
| Stored procedure activity | None On-premises |
Basic Service principal |
Note
The Service principal authentication only applies to SQL Server on Azure VMs.
To learn more about the copy activity configuration for SQL Server database in Data pipeline, go to Configure in a data pipeline copy activity.