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

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


Article ID: 7917


Updated On:


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


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. 


Release : 2.10+

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


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. 


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:

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-