Alteryx Server Discussions

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

Data Connection setup user authentication

albert_alaluf
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)

 

1 REPLY 1
fmvizcaino
17 - Castor
17 - Castor

Hi @albert_alaluf ,

 

Couldn`t find anything related to that other than this post, which is not helpful. https://stackoverflow.com/questions/58547697/teradata-connection-string-using-windows-authentication

 

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

 

Best,

Fernando Vizcaino