Skip to main content

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