Configuration file containing database connection parameters used by the AUDIT, REGISTRY, RENDITION-REPOSITORY and COMMANDER services.

Characteristics

Profile Name	`application-dbs.yml`
Referenced by Services	audit,registry,rendition-repository,commander
Storage Location	Git root directory

Parameters

Parameter Description Default Value

storage

Section of individual database configurations.

databases

List of database definitions with the following required parameters:

datasource – Reference on a configuration in storage.datasources.
predicate – SPEL statement specifying the condition under which the database should be used. As of version 2022 Winter, the condition can only reference the system:tenant property of DMS objects.
default – Boolean value that specifies whether the database should be used as default database (true) or not (false).
Note: Exactly one database has to be the default database.

For each database action requested for a DMS object, the list of databases is read from the top. The first database for which the predicate is evaluated to true is used. If no predicate is true, the default database is used.

Note

If you apply changes to the configuration of a running system, ensure that existing tenants are directed to their previous database.

defaultdb:
   datasource: defaultds
   predicate: 'spel:false'
   default: true

datasources

List of database configurations with the following required parameters:

url
user
password
driver-class-name

defaultds:
    url: jdbc:postgresql://postgresql.infrastructure:5432/${DBNAME}
    username: yuuvis_${NAMESPACE}
    password: ${DBPWD}
    driver-class-name: org.postgresql.Driver

The values of the parameters can be modified as described here.
>> Configuring Services using Profiles.

Example Configuration

This example is structured for use in product version 2022 Winter.

Example application-dbs.yml

storage:
    databases:
        defaultdb:
            datasource: defaultds
            predicate: 'spel:false'
            default: true
        database2:
            datasource: db2source
            predicate: "spel:properties['system:tenant']['value']=='tenant2'"
            default: false
    datasources:
        defaultds:
            url: 'jdbc:postgresql://abc/def'
            username: yuuvis-postgresql
            password: changeme123
            driver-class-name: 'org.postgresql.Driver'
        db2source:
            url: 'jdbc:sqlserver://ghi/jkl'
            username: yuuvis-sqlserver
            password: changeme456
            driver-class-name: 'com.microsoft.sqlserver.jdbc.SQLServerDriver'