This article will explain how to connect to the PostgreSQL database to be able view or modify data.

We can use many different database administration tools to view or modify the PostgreSQL database. In this article we will use DBeaver Community as a database tool. It is free to use and open source.

Connect to the database

To connect to a new database click the "New Database Connection" button.

In the next screen select "PostgreSQL" and click "Next"

Fill out the port, database, username and password. If you used the Blueriq installer, they can be found in:

• C:\Program Files\Blueriq(version)\Runtime\conf\application-external-datasources.properties for the Runtime databases.
• C:\Program Files\Blueriq(version)\Services\customerdata\conf\blueriq-customerdata-odata-service-v1.yml for the Customerdata SQL store.

It might show us a driver setting screen, asking us to choose an appropriate driver for PostgreSQL. In this case just choose the org.postgresql one and click "Download". 

That's it, we are now connected to the (in this example) process database!