nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DSN run via server with user credentials

npsmith

Hello,

I want my users to pass their UID/PW for DSN connection when they run workflows on the gallery. In this case, we are connecting to AWS Redshift.

My understanding is this:

1) Install Redshift driver on server machine

2) Setup the Data Connection on the server where I provided the connection string (ODBC: ....DSN = ...... UID = ..... PW=.....)

3) User does the same on his/her PC (steps #2, #3)

When the user uploads the workflow, will his/her workflow's UID/PW override what was entered in the server's Data Connection connection string?

Thanks.

Database Connection

Accepted answers

AmeliaG

Hi @npsmith,

Thanks for your question!

To make this work as your desire, ensure the DSN set up on the server does not contain username and password.

Then, when the user utilizes the same DSN and adds his/her username/password and saves to the server, his/her credentials will be used.

Thanks,

Amelia

All comments

AmeliaG

Hi @npsmith,

Thanks for your question!

To make this work as your desire, ensure the DSN set up on the server does not contain username and password.

Then, when the user utilizes the same DSN and adds his/her username/password and saves to the server, his/her credentials will be used.

Thanks,

Amelia

npsmith

I also noticed that as long as I have the DSN / driver installed on the server machine then it's just a matter of passing the UID/PW in the workflow's Input Tool. I believe the DSN name has to be the same as the DSN name on the server machines as well to leverage the driver, but it does not need to be a data connection entry on the Alteryx server.

Thanks!

akshatoz

In Informatica Server we have Native and LDAP authentication modes. This can be addressed by configuring the LDAP authentication mode , but I'm not sure if Alteryx supports the same. Alteryx Gurus please confirm!!

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703