PostgreSQL data source

Learn how to set up a PostgreSQL data source and then move its data to one of the data destinations supported by Coupler.io.

2 steps to complete the setup

Set up your data source
Set up your data destination

1. Set up your data source

1.1 Select an application: PostgreSQL

1.2. Define your PostgreSQL server and credentials

Click "Connect".
Define your PostgreSQL server and user credentials:

> Host - your host on which the PostgreSQL server is running. The value can be a host name, IPv4 address, or IPv6 address.
> Port - specify the port. The default port number is 5432.
> Database - name of the database to connect to.
> User - user name of the PostgreSQL account to use for connecting to the server. (Make sure user has needed permissions for the database and table you would like to export)
> Password - corresponding password of the PostgreSQL account used for connecting to the server.

Click "Save.

1.3. Setup Basic Settings

Two report types are available - Table/View and Custom SQL.

Select "Table/View" for simple export of all fields. In the next fields specify Schema and enter Table / View name - table or view you want to export.

Select "Custom SQL" for creating custom SQL query.
Only queries that fetch data are allowed. (e.g. UPDATE, INSERT are not supported)

Note: you’ll need to allowlist Coupler.io IP addresses if your organization only allows access from “selected networks” . Those IP addresses are:
34.123.243.115
34.170.96.92

2. Set up your data destination

Continue setting up the integration depending on the system you want to import data to. Select your tool from the list of supported data destinations and follow the relevant setup guide.