Executing same query for multiple connection

[kschmittjr]

I have 6 different DB locations that I need to execute the same query on and append them all together into one data set.  Instead of creating a connection for each one and then append is there a way to configure a tool or macro to loop through the connection names or strings to reduce the steps?

[apathetichell · Accepted solution]

connection names:

batch macro:

text input:

first db name - query (two columns)

dynamic input-in-db

datastream out.

macro out

control paramter - action tool - text input (field 1 with your connection name)

outerworkflow - macro - feed in connection names.

alternative approach - use a batch macro with dynamic input/input data/whatever you use that isn't in-db - and update string there.

I prefer option 1. 

No - I will not provide you a sample workflow unless  - you provide me a sample query and sample db name.