Data Warehouse connector overview
The Data Warehouse connector is supported in Data Factory for Microsoft Fabric with the following capabilities.
Support in Dataflow Gen2
To learn about how to connect to a Data Warehouse in Dataflow Gen2, go to Set up your connection in Dataflow Gen2.
Support in data pipeline
The Data Warehouse connector supports the following capabilities in data pipelines:
| Supported capabilities | Gateway | Authentication |
|---|---|---|
| Copy activity (source/destination) | None On-premises |
User Auth |
| Lookup activity | None On-premises |
User Auth |
| GetMetadata activity | None On-premises |
User Auth |
| Script activity | None On-premises |
User Auth |
| Stored Procedure Activity | None On-premises |
User Auth |
To learn more about the copy activity configuration for Data Warehouse in data pipelines, go to Configure in a data pipeline copy activity.