Sending parameters to Connection string of ODBC

Question

Is there a way to have the user to send a parameter to the connection string to change it.  EntityGroupCode is the one I am after.    See below image. Connection string is saved as an alias aka:ColumnarReportTest

Details of the connection string are not exposed to the Action tool

I can see the alias is being translated correctly in the workflow results.

Purpose · Accepted Answer

Hi TrevorS,

I used DSN-less connection to solve the issue.  I was then able to pass some parameters to the connection string.  Connection string does not store authentication information.

Thanks for looking into the issue.

Purpose