Alteryx App - Multiple usernames & Password and Constant SQL Query

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?

Developer

Input

Tips and Tricks

Common Use Cases

Best Practices

Apps

Dynamic Processing

Interface Tools

Database Connection

Accepted answers

alexnajm

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:

Alteryx App - Multiple usernames & Password and Constant SQL Query snap.PNG

Alteryx App - Multiple usernames & Password and Constant SQL Query.yxwz

All comments

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

Alteryx App - Multiple usernames & Password and Constant SQL Query snap.PNG

Alteryx App - Multiple usernames & Password and Constant SQL Query.yxwz

Eswaran

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

alexnajm

Fantastic news!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703