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