Integrate with PostgreSQL

You can push the data from a Next Matter workflow to the database or pull the data you need into a workflow.

Before you begin

• 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:

     pgsql

     $ 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

1. Go to Automations library

2. In the PostgreSQL app tile, click Connect.

3. 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.

1. Click Connect.

Use the integration

1. Click a workflow in which you want to use PostgreSQL.

2. Click + Add step.

3. Select Integrations > PostgreSQL.

4. Click Settings.

5. 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.

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.