Alteryx App - Multiple usernames & Password and Constant SQL Query

[Eswaran]

Hi,

I want to make an Alteryx App in which I want to make changes in the username & Password Field not in SQL Query when connecting to the source. Since SQL Query is constant, the same Alteryx app is used by multiple users. SQL Query is constant whoever is using.

How do I achieve this?

[alexnajm]

You can use two Text Box tools for users to insert a username and password, and then that would pass through into the connection string you have. Without knowing the connection string it'd be hard to advise any more, but that would ensure their credentials pass through!

[Eswaran]

Could you please share some sample flow?

[alexnajm · Accepted solution]

The problem is it highly depends on the database you are connecting to (SQL Server, Snowflake, etc.), how you are connecting to that database (Input Tool vs In-DB or Server connections), what connecting string is created, etc. Here's a very general sample:

[Eswaran]

Thanks !!!! It Works.!!!!!!!

[alexnajm]

Fantastic news!