Controlling different Schema Names for static table names

[GauravRawal]

Hi,

What is the best to way to have control on different schema names, username and passwords without changing all the input nodes, in a flow?

For ex, there are there are 3 schema Dev, Test and Prod and a flow has been created for DEV which works on 10 tables as input nodes. Instead of making the flow ready for next TEST and PROD env, how can i control the working of flow by changing the schema name at a single place rather than changing it in 10 input nodes each time?

Thanks.

[Joe_Mako · Accepted solution]

One option is to use a Batch macro like in the attached.

For each record passed in the input it will use the Connection string and Query string to run an Input for.

I also attached an example use of it (you will need to edit to use a valid connection and query)

[GauravRawal]

Thanks Joe.

I managed to create the macro using your suggestions.