Select the Database tab on the Configuration page to configure the external database connection.

Do not merge tables from different solutions or from tables required by the product during installation into a single database, as each solution component requires its own database. 

Database URL

The IP address or Fully Qualified Domain Name (FQDN) of the database host.

As explained in Database requirements, the SSL certificate for the database host must include the IP address or FQDN of the host.

The connection port defaults to 5432; however, you can specify a custom port using the following syntax.

<dbUrl> port=<dbPort>

Where:

  • <dbURL> is the database URL
  • <dbPort> is the database port.

For example:

192.168.1.100 port=5435

Mandatory: Yes.

Database Name

The name of the database

Mandatory: Yes.

Database username

The username for connecting to the database.

Mandatory: Yes.

Database password

The password for connecting to the database.

Mandatory: Yes.

Enable SSL mode for the PostgreSQL database

yes to enable SSL security in the database connection; no otherwise.

The no option is for testing environments only.

Mandatory: Yes.

CA Certificate(s)

The CA certificate chain for validating the database SSL certificate. Click Select Files to import each certificate file in PEM format and Base64 encoding.

As explained in Database requirements, the SSL certificate for the database host must include the IP address or FQDN of the host.

Mandatory: When Enable SSL mode for the PostgreSQL database is yes.