Редактиране

Споделяне чрез


Set up your PostgreSQL database connection

This article outlines the steps to create a PostgreSQL database connection.

Supported authentication types

The PostgreSQL database connector supports the following authentication types for copy and Dataflow Gen2 respectively.

Authentication type Copy Dataflow Gen2
Basic (Username/Password) n/a

Set up your connection in Dataflow Gen2

Data Factory in Microsoft Fabric uses Power Query connectors to connect Dataflow Gen2 to a PostgreSQL database. The following links provide the specific Power Query connector information you need to connect to a PostgreSQL database in Dataflow Gen2:

In some cases, the Power Query connector article might include advanced options, troubleshooting, known issues and limitations, and other information that could also prove useful.