Azure SQL Database Managed Instance connector overview
The Azure SQL Database Managed Instance connector is supported in Data Factory for Microsoft Fabric with the following capabilities.
Support in Data pipeline
The Azure SQL Database Managed Instance connector supports the following capabilities in Data pipeline:
Supported capabilities | Gateway | Authentication |
---|---|---|
Copy activity (source/destination) | None On-premises |
Basic Organizational account Service principal |
Lookup activity | None On-premises |
Basic Organizational account Service principal |
GetMetadata activity | None On-premises |
Basic Organizational account Service principal |
Script activity | None On-premises |
Basic Organizational account Service principal |
Stored procedure activity | None On-premises |
Basic Organizational account Service principal |
To learn more about the copy activity configuration for Azure SQL Database Managed Instance in Data pipeline, go to Configure in a data pipeline copy activity.