OLEDB_Provider
Section: Server
Default Value: SQLOLEDB
Valid Values: SQLOLEDB, SQLNCLI11, MSOLEDBSQL
Changes Take Effect: After restart
Dependencies: None
Introduced: 8.5.000.00
Specifies the name of the MS OLE DB driver that will be used for the connections between WFM Data Aggregator and the MS SQL database.
OLEDB_Provider
Section: Server
Default Value: SQLOLEDB
Valid Values: SQLOLEDB, SQLNCLI11, MSOLEDBSQL
Changes Take Effect: After restart
Dependencies: None
Introduced: 8.5.000.00
Specifies the name of the MS OLE DB driver that will be used for the connections between WFM Server and the MS SQL database.
Securing connections on WFM servers
Workforce Management (WFM) supports Transport Layer Security (TLS) 1.2 for connections within WFM, and Genesys Management Framework, and between WFM and third-party software (with the exception of SMTP servers). WFM supports configurations that use only FIPS 140-2-compliant algorithms for encryption, hashing, and signing secure network connections.
Secure connections between servers
The information in this topic is provided to help you to configure secure connections between servers.
TLS configuration for WFM servers adhere to the common guidelines in the Genesys Security Deployment Guide with one limitation, parameters of the secure connection must be configured on the Host level.
WFM servers support Mutual TLS within WFM, and between WFM and Genesys Framework.
WFM Server, Builder, Data Aggregator, and Daemon use Windows security provider SChannel when running on Windows hosts. To support configurations that use only FIPS 140-2 compliant algorithms for security connections, enable the FIPS local/group security policy flag. For more information, see Microsoft FIPS 140 Validation.
WFM Web and WFM Daemon
Since WFM Web and Daemon have a dependency on Java, the TLS implementation uses Java Secure Socket Extensions from Oracle JDK along with a configured provider.
You must configure two certificate stores on the WFM Damon and WFM Web hosts:
- Java Keystore for certificates that are required for TLS communications with WFM components
- Windows Certificate Store for certificate that is required for TLS communications with Framework components
To configure these secure connections, complete the procedure below and adhere to common guidelines in the Genesys Security Deployment Guide.
Procedure: Importing Certificates for WFM Web and Daemon
Purpose: To import certificates that support secure connections for WFM Web and WFM Daemon.
Start procedure
- Import certificates to the Java Keystore that is used by WFM Daemon and Tomcat (WFM Web):
- For WFM Daemon—Import the WFM Daemon, Server, and Web host certificates to the Java Keystore used by WFM Daemon. By default, the path is JAVA_HOME/jre/lib/security/cacerts
- Find the value for JAVA_HOME by opening the wfmdaemon.cmd file in the WFM Daemon installation folder in line set JAVA_HOME.
- For WFM Web—Import the WFM Web (Tomcat), Data Aggregator, Daemon, Builder, and Server host certificates to the Java Keystore used by Tomcat.
- You can use the Java Keytool to import certificates to the Java Keystore. For example
- keytool.exe -import -alias tomcat -file C:\Certificates\tomcat.crt -keystore “C:\Program Files\Java\jdk1.8.0_181\jre\lib\security\cacerts” -storetype JKS -storepass changeit
- For WFM Daemon—Import the WFM Daemon, Server, and Web host certificates to the Java Keystore used by WFM Daemon. By default, the path is JAVA_HOME/jre/lib/security/cacerts
- Import the host certificate (on which WFM Daemon or WFM Web is installed) to the Windows Certificate Store for the user account that starts WFM Daemon or Tomcat (WFM Web) as a service.
- After installation, the WFM Daemon and Tomcat (WFM Web) user account is Local System, by default.
- Complete the following steps, using the Microsoft PsExec tool to import certificates to Windows Certificate Store for the Local System account.
- Download the Microsoft PSTools.
- Unpack PsExec64.exe.
- Run the Command Prompt as Administrator.
- Execute the command PsExec64.exe –i –s mmc.exe.
- This command is run Microsoft Management Console for the Local System account
- Click File > Add/Remove Snap-in…
- Add the certificates snap-in for the My user account
- Import the certificate to the Personal folder
- Verify that the Trusted Root Certification Authorities folder contains the issuer certificate.
- Repeat steps 5 to 8 to import the certificate for the Computer account.
End procedure
Secure connections between WFM Web server and WFM Web clients
The information in this topic will help you to configure secure connections between WFM Web and WFM Web clients.
WFM Web
WFM Web server runs in an Apache Tomcat Servlet/JSP container. Therefore, the secure connection must be configured in the servlet container. For more information see Apache Tomcat SSL/TLS Configuration HOW-TO.
To support configurations that use only FIPS 140-2 compliant algorithms in security connections between WFM Web server and WFM Web clients, configure Apache Tomcat to support FIPS 140-2. For more information, see Apache Tomcat Native Library.
WFM Web clients
TLS support must be enabled in browser that runs WFM Web for Supervisor, WFM Web for Agents, and WFM Agent Mobile Client.
To run WFM Web for Supervisor Java-based views, you must also import the WFM Web (Tomcat) server certificate to the Java Keystore that is used by the browser or by the Java Webstart application on the host on which you plan to run WFM Web for Supervisors.
Secure connections between WFM servers and MS SQL database
By default, WFM Server and WFM Data Aggregator use the outdated Microsoft OLE DB Driver (SQLOLEDB) to connect to MS SQL Server. However, this driver does not support TLS 1.2.
Procedure: Installing the latest Microsoft OLE DB Driver
Purpose: To support TLS 1.2 in the connections between WFM servers and MS SQL database
Start procedure
- Install the Microsoft OLE DB Driver (MSOLEDBSQL) 18.2.2 or later on the WFM Server and WFM Data Aggregator hosts.
- In Genesys Administrator:
- Set the [Server] OLEDB_Provider configuration option value to MSOLEDBSQL in the WFM Server Application.
- Set the [Server] OLEDB_Provider configuration option value to MSOLEDBSQL in the WFM Data Aggregator Application.
- If the [Server] section does not exist, create it. See Creating New Sections and Options in the Workforce Management Options Reference.
- Configure MS SQL Server to force encryption.
- Restart WFM Server and Data Aggregator.
End procedure
Next step: Configure the WFM Backup/Restore Utility (BRU).
Configuring the WFM BRU
After the latest Microsoft OLE DB Driver is installed, the WFM Backup/Restore Utility must be configured to use the following connection switch:
-DSN "Provider=MSOLEDBSQL;Data Source=<DBMS Name>;Initial Catalog=<Database Name>;User ID=<User Name>;Password=<Password>;"
For example:
WFMBRU.exe -BACKUP -DSN "Provider=MSOLEDBSQL;Data Source=<DBMS Name>;Initial Catalog=<Database Name>;User ID=<User Name>;Password=<Password>;" -FILE <backup>.db