How to reconfigure TDM Portal to point to a different DB server for the GTREP

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We need to move the GTREP to a different DB server, how can we reconfigure TDM Portal to connect to the new DB?

Environment

Release:
Component: ITKOTD

Resolution

1. Open C:\Program Files\CA\CA Test Data Manager Portal\conf\application.properties in a text editor (like Notepad++)

2. Modify the following values as needed:

spring.datasource.url
spring.datasource.username
spring.datasource.password
spring.datasource.driver-class-name

For example:

spring.datasource.url=jdbc:sqlserver://SQLHOST\\inst1;database=gtrep
spring.datasource.username=gtrep-user
spring.datasource.password={cry}A1wzNmnL5E9AIXAC2f4perkhMV-woosh+7r+XVagMawqTk421a
spring.datasource.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver

2a. If the password needs to be changed, use "EncryptionUtil.bat" to generate the encrypted password.

3. Save the file

4. Restart portal