PostgreSQL database connector overview
The PostgreSQL database connector is supported in Data Factory for Microsoft Fabric with the following capabilities.
Support in Dataflow Gen2
For information on how to connect to a PostgreSQL database in Dataflow Gen2, go to Set up your PostgreSQL database connection.
Support in Data pipeline
The PostgreSQL database connector supports the following capabilities in Data pipeline:
| Supported capabilities | Gateway | Authentication |
|---|---|---|
| Copy activity (source/-) | None | Basic |
| Lookup activity | None | Basic |
To learn more about the copy activity configuration for PostgreSQL database in Data pipeline, go to Configure in a data pipeline copy activity.