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

Document ID : KB000105939
Last Modified Date : 10/07/2018
Show Technical Document Details
Introduction:
We need to move the GTREP to a different DB server, how can we reconfigure TDM Portal to connect to the new DB?
Instructions:
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