TDM Portal Configuration to High Availability Databases Setup

Products

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

Issue/Introduction

We recently came across a situation where primary SQL DB Server went down and we have to manually change the database details to re-point to secondary SQL DB server. Is TDM supports the configuration to High Availability database?

Environment

Release:
Component: ITKOTD

Resolution

If SQL server database is configured in HA, you can give HA listener name while connecting to SQL server database in portal. If you have already configured repository database details for TDM portal, change the details in application.properties file as below:
     

spring.datasource.url =jdbc:sqlserver://<DB_listener_name>:1435;database=gtrep
spring.datasource.username=sa
spring.datasource.password=<password>