So I have 2 different Denodo erm... sites/sections not sure what the technical term is, anyway one contains HR data and the other some trading data that I have access to.
Until we upgraded to Alteryx 2023 we were using an ODBC connection as there was no built in driver. Now we have 2023 installed, I am trying to connect using the Data Connection Manager and selecting the Quick Connect Denodo option. I can connect ok to our HR data but not my trading data, but what is strange is that if I test the ODBC connection it works fine but putting the same details into DCM it fails with an incorrect username or password. What is also strange is that if I open Tableau and put in the same username/password it works. So ODBC locally on my laptop works, Tableau works but the same username/password in DCM fails. I have no idea what to even test, anybody got any suggestions?
