This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
So in the current workflow, I am asking username and password using the 'Text Box' tool.
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: