SAP To Alteryx connection using odbc

[Anasalter]

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.

[alexnajm]

Sounds like you need to look at DCM! DCM - Designer & DCM Supported Connectors and Tools

[jrlindem · Accepted solution]

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

[Anasalter]

Thanks for your responses @alexnajm @jrlindem .
today what i have tried is
File > manage connections > then added the data source and linked its credentials
after this i also tried the method @jrlindem mentioned 
But the problem still arises

I have not tried the DCM approach yet and it would be helpful if you can explain it.

[alexnajm · Accepted solution]

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