Clicking the ‘Use in Workflow’ button in connect downloads a workflow file with the Table which I can open in Alteryx Designer.
When I open in Alteryx it asks for Userid/PW but there is no option for SSO (single sign on):
If I leave the username and password blank then the connection fails and I get an error.
In the case of SSO the connection string should be:
SSO: odbc:Driver={HDBODBC};SERVERNODE=saphXXX.europe.company.com:30415;Trusted_connection=yes;
instead of this:
UseridPW: odbc:Driver={HDBODBC};SERVERNODE=saphXXX.europe.company.com:30415;UID=USERNAME;PWD=__EncPwd1__
Please note ALL of our users use SSO so current functionality is useless to us.
I have raised this as a bug with support but as usual they ask me to post here.
This option should also ask if the connection is In-DB connection also per this post:
https://community.alteryx.com/t5/Alteryx-Connect-Ideas/Have-In-Db-input-as-an-option-when-selecting-...