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.
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://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/installing/supported-data-sources.html
Release : 2.10+
CA Agile Requirements Designer (ARD)- Agile Designer + CA Test Data Manager (TDM)- 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:
If you experience any further issues, please open a support case by going to https://casupport.broadcom.com/user/ or https://www.ca.com/us/services-support/ca-support/contact-support.html?intcmp=footernav.