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 PostgreSQL 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 |
| Pipeline - Copy activity (source/destination) - Lookup activity |
None On-premises Virtual network |
Basic |
| Copy job (source/destination) - Full load - Incremental load |
None On-premises Virtual network |
Basic |
Important
To use PostgreSQL as a Dataflow Gen2 data destination through an on-premises data gateway, install the June 2026 gateway update (version 3000.322) or later.
Related content
For information on how to connect to a PostgreSQL database, go to Set up your PostgreSQL database connection.
To learn more about the copy activity configuration for PostgreSQL database in a pipeline, go to Configure in a pipeline copy activity.