Page History
...
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
...
how to:
| Children Display |
|---|
Overview
Content Tools