Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Data Connection setup user authentication

10 - Fireball

Hello community,


Maybe this was already answered, but I couldn't find it.


I have a new server setup 2023.1 . I like to create and share Data Connections to my users, not SQL or Oracle, it is Teradata. I have DSN setup. What I want to do that to define the connection without username and password, and I want to my users connect by using their credentials. If it is service account, it is easy, nothing needs to be done, just connect. But, user authentication, I was not able to figure it out. 


Any suggestion?


My sample connection string is on the gallery: 

odbc:DSN=TERADATA_DSN_NAME (This is without user and password)

odbc:DSN=TERADATA_DSN_NAME;UID='USER;PWD=PASSWORD (This is kinda sample connection string, user must provide their own username and password, I couldn't figure it out that part)


17 - Castor
17 - Castor

Hi @albert_alaluf ,


Couldn`t find anything related to that other than this post, which is not helpful.


An option you have is, instead of using a DSN-less connection, use a DSN connection. This would require for all the designer users to have the same DSN configured on their machines but would solve the Windows authentication part.

Screenshot 2023-07-12 164905.png



Fernando Vizcaino