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