Manage local databases of INVENTA Desktop (MySQL or PostgreSQL)

By default, INVENTA Desktop uses a local MySQL database which is stored in the following directory: C:\Users\[Username]\AppData\Local\Inventa Desktop\database.sql

However, it is also possible to connect a PostgreSQL database to INVENTA Desktop. Click on the database icon at the top right of INVENTA Desktop, change the radio button to ‘PostgreSQL’ and fill in the following five required fields with the connection information of a PostgreSQL instance of your choice:

• Host (Host name of the machine that runs the Postgres server)
• Port (Communication port of the machine that runs the Postgres server)
• Database (Name of the Postgres database that INVENTA Desktop shall use)
• User (Name of the Postgres user of the database that INVENTA Desktop shall use)
• Password (Password of the Postgres user)

Press the ‘Connect’ button to establish the access to the Postgres database.