Sending parameters to Connection string of ODBC

[Purpose]

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.  

[TrevorS]

Hello @Purpose 

You may be able to do this by creating a macro. If you put the connection string directly into an input tool, you could modify parts of it and push it to update the changes downstream.
However, there are a few concerns.
1. It wouldn't be recommended to do this with any sensitive information like usernames and passwords.

2. The Data Source you are pointing to isn't Supported by Alteryx, so this could cause problems within the workflow itself.

If you can, please upload a copy of your existing workflow with some sample information (sample connection string, and sample replacements) and how you want this to function, the Community may be able to create a few mock macros which you can adapt.
Thanks!
TrevorS

[Purpose · Accepted solution]

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