If you use the installer to install Blueriq, then the PostgreSQL database will be installed as well. This database replaces the H2 database which was installed on older versions.

In this article we are going to take a look at:

• How to connect to a specific database.
• How to import/export data.
• How to clear the database.

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!

Import and export data

Clear the database