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 Azure SQL Database connector is supported in Data Factory for Microsoft Fabric with the following capabilities.
Supported capabilities
| Supported capabilities | Gateway | Authentication |
|---|---|---|
| Dataflow Gen2 (source/destination) | None On-premises Virtual network |
Basic Organizational account |
| Data pipeline - Copy activity (source/destination) - Lookup activity - Get Metadata activity - Script activity - Stored procedure activity |
None On-premises Virtual network |
Basic Organizational account Service principal Workspace identity |
| Copy job (source/destination) - Full load - Incremental load - CDC - Append - Merge |
None On-premises Virtual network |
Basic Organizational account Service principal Workspace identity |
Related content
To learn about how to connect to Azure SQL Database, go to Set up your Azure SQL Database connection.
To learn about the copy activity configuration for Azure SQL Database in data pipelines, go to Configure Azure SQL Database in a copy activity.