Preparing an MS SQL database for the User Management Services datasource

Edit online
Draft comment:
This topic only applies to BAW, and is located in the BAW repository. Last updated on 2025-01-20 10:38
 Containers: 
Configure a MS SQL database for User Management Services (UMS) single sign-on and teams options.

Procedure

  1. Create your MS SQL database, for example by issuing the command: 
    create database umsdb
    For more information, refer to your database documentation.
  2. Make a note of your values for the following configuration parameters that you will need later to add to the datasource_configuration section of the custom resource: 
    datasource_configuration:
    dc_ums_datasource: # credentials are read from ums_configuration.admin_secret_name
    # oauth database config
      dc_ums_oauth_type: sqlserver
      dc_ums_oauth_host: host_name
      dc_ums_oauth_port: 1433
      dc_ums_oauth_name: UMSDB
      dc_ums_oauth_driverfiles: mssql-jdbc-8.2.2.jre8.jar
      dc_ums_oauth_ssl: true
    # teamserver database config
      dc_ums_teamserver_type: sqlserver
      dc_ums_teamserver_host: host_name
      dc_ums_teamserver_port: 1433
      dc_ums_teamserver_name: UMSDB
      dc_ums_teamserver_driverfiles: mssql-jdbc-8.2.2.jre8.jar
      dc_ums_teamserver_ssl: true
    Where host_name is the host name of the database server, 1433 is the default port, and UMSDB is the name of the database.