How to change the Database Communication port used by DM

Products

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

Issue/Introduction

We are using GT DataMaker in an environment with firewall. The repository SQL Server is configured to use a non-standard communication port. When trying to connect DataMasker to Repository SQL Server database, a time out occurs. How do we reconfigure the connection for DataMaker to connect using a non-default port?

Environment

Release:
Component: TDMDTM

Resolution

If you are not using an rep.xml file, you will need to edit the connection profile from the DataMaker main page. You edit the configuration, right click on the connection profile, and select edit.

<Please see attached file for image>

If you are using an ODBC connection to connect to the SQL Server, then you need t verify the SQL Server is configured to listen on the correct port. For more information on this see https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-2017 for steps to specify the port used by the SQL Server.

Then launch the ODBC Data Source Administration utility and modify the ODBC connection so that it is communicating on the new port. You can specify the port the connection needs to use in the "Server" field, where you specify the hostname of the server. The syntax is [hostname],[port]. 

<Please see attached file for image>

For more information on connecting the Repository to the SQL SERVER see (https://docops.ca.com/ca-test-data-manager/4-5/en/installing/install-ca-test-data-manager/connect-to-the-repository).

If you are using a rep.xml file, you may still need to modify the connection profile. In some cases, you may need to delete and recreate the rep.xml file. If you need more information regarding creating the rep.xml file see https://docops.ca.com/ca-test-data-manager/4-5/en/installing/create-rep-xml-file-to-store-repository-credentials.