Agile Designer Data Painter Error: ODBC connections with DSN not supported

Products

• CA Agile Requirements Designer
• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When trying to validate a query using the Data Painter function inside Agile Designer, I am receiving the following error message: 

Exception: MetaFunctions : uf_process_function : Exception: ODBC connections with DSN not supported - please use a DSN-less connection. 

à GT.TDMoD.Services.Repository.ConnectionProfile.ConnectionString(String passDec) 
à GT.TDMoD.Services.Generator.PublishEngine.CreateConnectionFromProfile(Int32 iSUID, String sProfile) 
à GT.TDMoD.Services.Generator.MetaFunctions.uf_sqllist(String ps_connection, String ps_sql, String ps_shuffle) 
à GT.TDMoD.Services.Generator.MetaFunctions.uf_process_function(String ps_function_call) 

Other Data Painter functions work from within Agile Designer and the connection to Datamaker repository is successful. 

Environment

Release : 2.10+

CA Agile Requirements Designer (ARD)- Agile Designer + CA Test Data Manager (TDM)- Datamaker

Cause

This error message is occurring because the profile being used to connect is not a 'DSN-less' connection.
To use the profile with ARD and on the Test Data on Demand (TDoD) Service Layer, you must create a 'DSN-less' profile.
TDoD only supports 'DSN-less' connection profiles and ARD uses the TDoD service to connect with Datamaker. 

Resolution

To resolve this you will need to create a new profile in Datamaker that is 'DSN-less' and then change that in the Data Painter window in ARD so it validates correctly. 

Here is the documentation on creating new profiles in general:
https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/installing/install-test-data-manager/connect-datamaker-to-test-data-source-and-target-databases.html

How to create a DSN-less profile:

1. Launch Datamaker.
2. Connect to the repository.
3. Login.
4. Click the yellow folder icon on the profile page to create a new profile.
5. Enter a profile name.
6. From the DBMS drop down, choose the DSN-Less ODBC option.
7. Click the green checkmark.
8. Select the ODBC driver.
9. Fill in the database connection details.
10. Click the green gear icon to test the connection.
11. Click the green checkmark to save the new profile. 

Additional Information

This is noted in our TDM documentation around supported data sources- https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/installing/supported-data-sources.html