Dynamic selection of connection string details from SQL Server

[Dinesh13]

Hi, I'm new to Alteryx. I have a requirement to run workflow in DEV, QA & PROD and move data from oracle(source) to MS SQL(destination). I want to get collection name and if collection name='qa' then connection string details data should be picked from config table from 'qa' db. If collection name='prod' then data should be picked from config table from 'prod'dB. Right now, I do not have provision to get collection name. So I will declare a variable='qa' then it should pick 'qa' dB(select * from config where sorname='Dev', whatever variable value(Dev/qa/prod) data should come from that Database. I have a configuration table in 'employee' DB in MS SQL server. I have below data in dbo.config, which is in MS SQL.

My source SOR - Oracle ; My Destination - MS SQL

Dev environment - 

SORName	Name	Value	SOR_DEST
Dev	servername	desti_server_dev	Dest
empsor	username	dinesh_dev	Sor
empsor	password	dinesh0	Sor
empsor	servername	dev_emp_server	Sor

QA  environment -

SORName	Name	Value	SOR_DEST
QA	servername	desti_server_qa	Dest
empsor	username	dinesh_qa	Sor
empsor	password	dinesh0	Sor
empsor	servername	qa_emp_server	Sor

PROD environment - 

SORName	Name	Value	SOR_DEST
PROD	servername	desti_server_prod	Dest
empsor	username	dinesh_prod	Sor
empsor	password	dinesh0	Sor
empsor	servername	prod_emp_server	Sor

I want to build my workflow based on above data. If i move workflow from one environment to other then workflow should be smart enough automatically pull data from dbo.config table. I will not change any values on run time. May be am wrong in picking values, u can correct me. Any help is really appreciate.

[TrevorS]

Hello @Dinesh13 
Can you please include a copy of your workflow and what you have completed so far?
This will help the Community to better assist you with any of the issues you have encountered with your workflow.
Thanks!
TrevorS

[Dinesh13]

Hi. I'm new this. I have added my workflow. I want to pull data from SOR to Destination. I have to get source connection details from config table. I have added my workflow. May be there are many changes required. Please help me out.

I have textbox=QA. If i give QA then i have to connection QA destination server. Whatever value defined in textbox destination connection string should connect to that server. If it can be doable in a better way please help me out.

[TrevorS]

@Dinesh13 

I looked into this further, and there is some material on the Community to help get you started.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Moving-from-Dev-to-Prod/ta-p/158825
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Allow-the-use-of-constant-after-the-quot-aka...

I hope this helps!