Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

In this article we are going to take a look on how 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.

Image Added

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

Image Added

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.

Image Added

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

Image Added

Import and export data





Clear the database