Test Data Manager

Hi Team

I am unable to connect to mysql database using ODBC in CA Test Data Manager.

Is there any reference doc which help me to do so?

Thanks and Regards

Hi Pranoy, 

What issue or error are you experiencing when trying to connect? Can you please provide a screenshot?

Here is the documentation:

Connect to Test Data Source and Target Databases - CA Test Data Manager - 4.4 - CA Technologies Documentation 

Connect to the Repository - CA Test Data Manager - 4.4 - CA Technologies Documentation 

1. Launch Datamaker from the GTDatamaker icon on the Desktop. 
2. Select 'I need to provide credentials for my Test Data Repository', select Microsoft SQL Server, and click the blue arrow at the bottom right.
   Unless you have already created an ODBC connection, a Not Found dialog opens.
3. Click OK.

4. Click the icon next to the ODBC Sources drop down list to create a new ODBC connection for the repository.

   Important! If you are using a 64-bit Windows system, launch the ODBC administrator separately from C:\Windows\SysWOW64\odbcad32.exe.

   The ODBC Data Source Administrator dialog opens.

5. Select the System DSN tab and click Add.
   The Create New Data Source dialog opens.
6. Select SQL Server Native Client 10.0 and click Finish.
   The Create a New Data Source to SQL Server dialog opens.
7. Give the repository a name and a description, select the SQL Server that contains the repository, and click Next.
8. Select the SQL Server authentication option, enter valid login credentials to the database server, and click Next.
   Note: You can also use an Active Directory (AD) account for connecting to the Microsoft SQL Server repository in Datamaker. For more information about setting up integrated security to connect to the Microsoft SQL Server repository, see Enable Integrated Security for Repository Access in Datamaker.
9. Specify gtrep as the default database, select both ANSI check boxes, and click Next.
10. Leave the defaults on the final page and click Finish.
    A setup page opens that summarizes your settings.
11. Click Test Data Source and confirm that the connection is successful.
12. Click OK, verify that the repository data source you created appears on the System DSN tab of the ODBC Data Source Administrator, and click OK again.
    You are back to the Database Details tab where you have to select the ODBC connection for the repository.
13. Click the Refresh button next to the drop-down list, select the ODBC source you just created, and click the blue arrow at the bottom right.
    The User Details tab opens.
14. Select 'Use specified login details', enter valid database credentials, select Store Password, enter the default schema (gtrep), and click the green button at the bottom right.
    This runs a connection test.
15. After you get a successful connection test, click the green check mark at the bottom right.
16. Enter a name for the repository that you will remember, such as Repository or Test Repository, and click OK.
17. Click Yes to confirm your profile name.
    The repository profile you created should appear on the main Datamaker page.