Looking for help with macro to have users enter ODBC credentials

csh8428

My team collaborates on a lot of workflows and our security does not allow service user access to databases; therefore, each person on the team has to change the ODBC connection credentials to their credentials for multiple inputs each time they want to work on it.

I'm not very familiar with macros and was wondering if somebody could help develop one that takes the username, pass, and connection string(I think) that then passes it to the ODBC connection.

Thanks,

Craig

TrevorS

Hello @csh8428 

Thank you for posting to the Community!
I would recommend you start out by reviewing the material we have for our macros to get a better understanding of how they work.
You can start with the below resources!

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Macros

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%20Analytic%20Apps

Also, looking at the Community, this post may be able to get you started as well!
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/ODBC-connections-parameterize-authentication/td-p/50855

I hope this helps!

TrevorS