SAP To Alteryx connection using odbc

Question

Hi,

from last 1 year i have developed over 100 workflows which are suing input data tool to get data from SAP via ODBC Connection.
Now the problem is every three months SAP Password gets changed and in all the workflows wherever input tool is used to fetch the data i have to change the password and if i run any workflow with old password , it gets locked.
so are their any option that whenever the password change i just need to change it any one place and all my workflows run on this new password.

jrlindem · Accepted Answer

Agree with @alexnajm.  In lieu of DCM as an option, though, couldn't you also use the "Manage Data Connections" under:

* Options > Advanced Options > Manage Data Connections

This is what I do when I have a credential "rotate."  I go here, update the specific credential that's called for in my workflows, and it updates for whenever that connection is used in a given workflow.

Here's what the screen looks like (don't mind all the warnings and errors 😅 ):

DCM is better but does require some configuration.  Hope that helps,  -Jay

alexnajm · Accepted Answer

DCM is a centralization of connections essentially. I think you should research online / the Community first, and come to us with specific questions / issues that we can help with - lots of resources available!

* How to Set up DCM for Designer and Server
* What’s New in Alteryx 2021.4 | Data Connection Manager