community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx connect Ideas

Share your Connect product ideas - we're listening!

Support connections without Userid/PW (SSO) when using "Use in Workflow" button

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:  odbcSmiley Very Happyriver={HDBODBC};SERVERNODE=saphXXX.europe.company.com:30415;Trusted_connection=yes;

 

instead of this: 

 

UseridPW:  odbcSmiley Very Happyriver={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-...

 

 

3 Comments
Alteryx
Alteryx
Status changed to: Accepted
 
Alteryx
Alteryx
Status changed to: Accepted
 
Alteryx
Alteryx
Status changed to: Implemented

hi @cbridge ,

this idea has been implemented and you can test it on your environment, it's in Beta program right now:

https://betaprogram.alteryx.com/project/home.html?cap=3bf92142c327436da99ab73edfa627ff

 

looking forward for you feedback,

Ondrej