On-premise deployments: Connecting to DQ+'s underlying databases

Note: connecting to the DQ+ underlying databases directly is not recommended in favor of using the APIs or the out-of-the-box scripts for backups and restores. However, direct connections may be leveraged for read-only monitoring purposes.

Note: connecting to DQ+'s underlying databases is not possible within a Precisely-hosted deployment in favor of using the APIs.

The connection information to the underlying databases is stored within the installation's property file:

<install home>/properties/install.properties

Within the file are the following properties:

• VERTICA_DB_HOST -- Vertica host
• VERTICA_DB_USER  -- Vertica user
• VERTICA_DB_PASSWORD -- Vertica password
• VERTICA_DB_URL -- Vertica connection URL
• DATABASE_SERVER -- Postgres server
• maintenanceUser -- Postgres username
• DATABASE_PASSWORD -- Postgres password
• DATABASE_URL -- Postgres connection URL

Any properties with a syntax of ${PROPERTY_NAME} are a variable to another property within the same property file.