Skip to main content
  • Create a user and grant it minimum permissions required for Integrate.io ETL to read or write data from the database.
  • Allow access from Integrate.io ETL’s IP addresses to your PostgreSQL database port (Refer to this article if you’d prefer to create an SSH tunnel or reverse SSH tunnel.)

​
To create a PostgreSQL database connection in Integrate.io ETL

1
Click the Connections icon (lightning bolt) on the top left menu.
2
To create a connection, click New connection.
New connection button in the Connections page
3
Choose PostgreSQL and name the connection.
Selecting PostgreSQL as the connection type
4
Select your access type (direct connection if you’ve whitelisted Integrate.io ETL’s IP addresses.)
5
Enter your PostgreSQL database host name or IP address.
6
Enter the database name.
7
Enter the username.
8
Enter the user’s password.
9
If you need to connect to PostgreSQL through custom SSL certificate, check on custom SSL certificate. Then upload files of Certificate file, Private key, Ca Cert.
10
Click Test Connection to make sure the connection details are correct.
11
Click Create connection to create the connection.
PostgreSQL connection configuration form with host, database, and credentials
Successful PostgreSQL connection test confirmation
Last modified on April 20, 2026