Parameterize DB connection

[sidatm]

Hi All,

I need to use "Write to file or Database" to output a data to database table. I am trying to parameterize DB connection string by storing following values in formula, creating a new column "abc" and putting that column as [abc] in DB connection. However, i am getting error no table is chosen. Can someone please advise what i am doing wrong?

"odbc:DRIVER={ODBC Driver 17 for SQL Server};DATABASE=master;SERVER=<<server name>>;Trusted_Connection=yes|||[databaseName].schema.tableName"  

please see attached screenshot;

[geraldo]

@sidatm 

One way to change the connection is to put it in a macro and replace the connection string
Here's an example