Test Data Manager

i am not getting entries to enter multiple DB IP addresses.

Hi Vinay,

Here is our documentation for creating connection profiles.

CA TDM Portal will only support the Oracle Service Name.

       Oracle Service Name
         (For Oracle) Specifies the name of the Oracle service. TNS names are not supported.

Thank you,

Ryan McKlveen

Hi Ryan,

1. I am unable to access the documentation link, kindly re-share it.

2. Yes, CA TDM Portal will not support TNS names, but due to security reasons Client has given access to DBs to connect via HOST IPs but not from Host names. As we have ORACLE RAC DB servers, each Oracle DB host service has 3 IPs and the connection ping can reach DB via any of the 3 IPs, and each time it takes random IPs out of 3. 

In CA Subset tool, this issue is addressed by providing option to enter multiple IPs with its Ports, and the connection type is ORACLERAC.

how to go forward in my case?  

Hi Vinay,

Here is the link I was referring to:
https://docops.ca.com/ca-test-data-manager/4-4/en/provisioning-test-data/defining-test-data/defining-test-data-using-the-ca-tdm-portal/create-a-connection-profile

I will look for other possible solutions.

I don't think we currently have the option to enter multiple IP's in TDM so you could just enter any one of the IP's and establish a connection and this should work. If you still want to use all three IP's, then you could create a connection profile for each ip and switch between the 3 connection profiles as needed

Thanks Anil - But i guess if Database has a RAC server - then the ping to DB can go from any of the IPs or the VIP. In this case the stability of the connection will not be stable.

Any steps to fix this new requirement in CA TDM portal ?

Hi Vinay,

I would suggest that you submit an Idea to the Community group, and have it voted up for a possible Enhancement Request into the product.
Here below are the steps to do so:
https://comm.support.ca.com/kb/how-to-submit-an-enhancement-request-for-test-data-manager/kb000009611