Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music

Prompt single user database login for multiple input data SQL queries

Highlighted
7 - Meteor

I am running multiple SQL queries using multiple 'Input Data' tools.

 

All of the tables in the SQL queries are from a single database, which requires a username and password to establish connection.

 

Since I am sharing the workflow with multiple users, hard coding username/password in the 'Input Data' tool is not ideal and so I introduced macro to prompt users for Username and Password when the workflow is run.

 

The one issue I am having is, I need to have a set of username & password macro for each 'Input Tool', since the username & password macros have only 1 out anchor.

How can I change the current workflow or the existing macro so that a user's input is used for multiple 'Input Data' tools?

JJH_0-1590765842840.png

 

Highlighted
Moderator
Moderator

Hello @JJH 

Could you please upload your workflow so I can see what you have set up so far? This will help to troubleshoot how to accomplish what you are looking to do.

Initially what I am thinking would be setting up a text input tool to receive the username/password information and from there connect to each field you need to update with the credentials.

Thanks!

TrevorS 

Community Moderator
Highlighted
10 - Fireball

Action Tool above each Query, multiple Action Tools connected to the Control Parameter tool shown here:

Control Parameter to Mulitple Action Tools.jpg

Highlighted
7 - Meteor

So in the current workflow, I am asking username and password using the 'Text Box' tool.

Edit:

It seems I may have overcomplicated it.

What I ended up doing was have 1 text box to ask for username, 1 text box to ask for password. These are then outputted to multiple 'Action' tools, which are connected to 'Input Date' tools. Screen print below:

 

JJH_0-1591034894772.png

 

Labels