🔌Setting up a PostgreSQL Connector

Configuring the PostgreSQL connector in Toucan

Fill in the mandatory connection information:

• Host/ server name

• Username

• Password

• Port

PostGreSQL Connection form

• Then you can finally hit the TEST CONNECTION and SAVE the connection

• After testing the connection, you should have something like this :

PostGreSQL Connection Test

After successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab

Selecting data from PostgreSQL

To create a dataset from PostgreSQL, click on the "create from icon". You will then be able to:

• Select the Database

• Select the Schema

• Select Table or Views

• Only keep the columns you need

For more info, see the dedicated section Creating datasets

After selecting data from your connector you will be able to create a dataset thanks to YouPrep using the selection as "source step".