Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Connecting multiple tables from SQL database using analytic app

renjankj
6 - Meteoroid

Hi,

 

I have my multiple SQL database like A1,A2,A3,A4 and A5.

Each DB has 10 tables all with same table names.( like T1,T2.....T10)

I have created a workflow where it perform actions from each DB.

 

I need to create an analytic app where input should be the data base name.

So each time i change the db name the functions should be performed.

 

Can anyone help me this.

 

Regards

2 REPLIES 2
EddieW
Alteryx
Alteryx

Hi @renjankj,

 

Thank you for the post! There are so many ways to do this and one of them is the one below. 

 

1) When you configure the Input Tool, include the database name and schema in the 'Table or Query' field.

Capture.PNG

 

2) In the Action Tool, you will want to update the database name with the selection you make. For example, if you select database 'ABC123', the Action Tool will update the query from "Select * From AdventureWorks2014.dbo.edtestapp" to "Select * From ABC123.dbo.edtestapp"

Capture1.PNG

 

3) The available database selections can be configured using a Drop Down Tool.

Capture2.PNG

 

 

Attached please find the sample workflow. Hope this helps!

Eddie Wong
Customer Support Engineer
Alteryx
renjankj
6 - Meteoroid
Hi Eddie,

Please see the below thread for more details.

I have multiple tables as input

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connecting-multiple-tables-from-SQL-da...