Pass Dyanmic connection string (SQL SERVER) to Output Data Tool

[ShanmugaArthi]

Hi Team,

As per my requirement, I need to write data into an SQL Server database using the output data tool. To accomplish this, I must dynamically pass the connection string. For reading data we are using dynamic input, how to configure the output tool for writing. 

[apathetichell]

put in  a batch macro - use an action tool to update the connection string. use a control parameter to pass in the connection string.

[ShanmugaArthi]

Hi, 

my requirement is not to create a batch macro, 

We have already built a standard macro which will output the connection string and we are calling this macro in the workflow and passing it dynamically to the input data tool. 

within this same workflow, I need to dynamically pass the SQL server ODBC connection string as a parameter to the output data tool. 

please let me how to implement it. 

[apathetichell]

There are seven ways that I can think of to implement this - I have identified the normal way but if you don't want to use the normal way feel free to try another:

1) a batch macro

2) an app - where your user does something which generates the connection string.

3) dynamic input in-db - to use this you would toggle in workflow between different IN-DB pre-configured database connections. You can send one record in with each dynamic input-in-db.

4) the python tool.

5) the R tool.

6) the Download tool via api.

7) the run command tool where you do something via scripting via either CURL or CLI pending your underlying DB.