Database connections of different types can be set up here. For example, Oracle and MSSQL databases.

Database connections that have been set up can be edited or deleted at any time.

To create a database connection, click on “Connections” in the Project Explorer under Database.

Click on “Add database connection”.

Specify a name for the connection. Depending on the database type, select the appropriate JDBC string.

---

JDBC Strings

QuickHMI contains the following JDBC drivers, whose strings must be structured as follows:

• MariaDB (MySQL)
  jdbc:mariadb://<host>:<port>/DB?user=<MyUser>&password=<MyPassword>
• Oracle
  jdbc:oracle:thin:<MyUser>/<MyPassword>@<host>:<port>:< MyService>
• Firebird
  jdbc:firebirdsql:<host>/<port>:<PathIncludingDatabaseName>?encoding=UTF8&userName=<MyUser>&pass-word=<MyPassword
• PostgresSQL
  jdbc:postgresql://<host>/test?user=<MyUser>&password=<MyPassword>&ssl=true
• Sqlite
  jdbc:sqlite:<PathIncludingDatabaseName>

If you create a new database connection in the QuicKHMI Editor, you have the option of accessing the JDBC drivers installed in QuickHMI via the “Open driver folder” button in the “Create or edit connection” dialog.

You can also copy your own JDBC drivers here if required.

---

Installed JDBC drivers are also listed, whose folders you can view with “Open driver folder“.

Then continue with “Add“.

---

Example for MYSQL database

For the connection to a MYSQL database with the following data

Host: localhost

Port: 3306

Database schema: qhmi

User: qhmi

Password: qhmi2025

the jdbc string is structured as follows:

jdbc:mariadb://localhost:3306/qhmi?user=qhmi&password=qhmi2025

Free choice of SQL databases

QuickHMI supports all relational SQL databases for which a JDBC driver is available. Suitable JDBC drivers are already supplied for some common databases. The subsequent installation of your own JDBC drivers is possible without any problems.

---