| title | PostgreSQL database connector overview | ||
|---|---|---|---|
| description | This article provides an overview of the supported capabilities of the PostgreSQL database connector. | ||
| ms.topic | how-to | ||
| ms.date | 02/14/2026 | ||
| ms.custom |
|
The PostgreSQL database connector is supported in Data Factory for [!INCLUDE product-name] with the following capabilities.
| Supported capabilities | Gateway | Authentication |
|---|---|---|
| Dataflow Gen2 (source/-) | 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 |
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.