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

Document ID : KB000007917
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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:
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. 

This is noted in our TDM documentation around supported data sources- https://docops.ca.com/ca-test-data-manager/4-3/en/installing/supported-data-sources

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://docops.ca.com/ca-test-data-manager/4-3/en/installing/install-ca-test-data-manager/connect-to-test-data-source-and-target-databases

Here are instructions on 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:

If you experience any further issues, please open a support case by going to https://support.ca.com or http://www.ca.com/us/services-support/ca-support/contact-support.html.