🔌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
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
PostGreSQL Connection Test

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

Last updated

Was this helpful?