Integrate with PostgreSQL

Before you begin

Understand how data references work. See Use data references. This will help you use the captured data in the workflow steps.
You need to have a basic understanding of PostgreSQL queries.
Reach out to our Support team in case you need to allowlist our IP address.
Open PostgreSQL to outside connections. To do that:
1. Update the postgresql.conf file. To trace the file, run the following command:
```
$ find / -name "postgresql.conf"
/var/lib/pgsql/9.4/data/postgresql.conf
```
2. Replace the listen_addresses = 'localhost' line with listen_addresses = '*'.
3. Restart the PostgreSQL server.

Set up the integration in Next Matter

Go to Automations library
In the PostgreSQL app tile, click Connect.
Enter the required data. You might want to contact your admin about it.

Data	Description
Database hostname	The network host name or the IP address of the PostgreSQL server.
Database name	The PostgreSQL database name that you want to access. If not specified, normally the operating system username is used as the database name. To get the name log in to the server using the SQL Shell (psql) app and run `SELECT datname FROM pg_database`.
Port	The network port that the PostgreSQL server is running on. By default, this is port 5432.
Username	The database username you wish to connect as. If not specified, the default username is `postgres`.
Password	The PostgreSQL password associated with the specified username. To get the password, run the `psql` command `\password`.

Click Connect.

Use the integration

Click a workflow in which you want to use PostgreSQL.
Click + Add step.
Select Integrations > PostgreSQL.
Click Settings.
In Query, enter a PostgreSQL query you want to run. It can be an INSERT, SELECT, UPDATE, or DELETE query. Make sure it's one query per integration step. Nested queries and subselects are not allowed.

👍
Tip: You can use data references to dynamically build your query and fill it with values from your process instance. You can also store query results in variables for using them later in the workflow.