Data Connection setup user authentication

[albert_alaluf]

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)

[fmvizcaino]

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.

Best,

Fernando Vizcaino