Supported Databases

QIE uses a standard SQL hierarchal database to store system configuration, channel configuration, message data and audit logging information. It is recommended that large and enterprise QIE deployment environments be configured to run against a MariaDB, MySQL, or MSSQL database management system.

Note

For a Linux or MacOS install the Arguments are located in the start.sh script located in the home directory. Any Arguments referenced must be added to the script after

-Djetty.port=80

The Connection URL must be modified to escape the ; as it is a control character. For example:

-Dconnection.url=jdbc:sqlserver://{server}:{port, default=1433}\\databaseName={qie}

• Microsoft SQL Server covers the driver, connection URL, dialect, and the in-memory table setup high availability requires.
• MySQL covers the driver, connection URL, and dialect.
• MariaDB covers the driver, connection URL, and dialect.
• Encrypting the Database Connection Password covers keeping the password out of the startup arguments in plain text.