Updating Data Input Connection String From Flow

vstherock

Hi,

we use a lot of workflows that connect to a Teradata database via ODBC, the account for this now has been put in a vault.

I can retrieve the password via the flow, or a PowerShell script, (or even save it temporarily in a csv) the question is can I use the retrieved password automatically in my workflows?

I currently use the ODBC connection with this string: odbc:DSN=dsn_name;UID=user_name;PWD=__EncPwd1__

Currently I manually update the password part whenever it changes, but automating this would be very useful. (I have tried macros but can't get it to work at all)

Thanks

Paul

Imaizumi

The workflow file format is XML You can edit the workflow file in notepad.

If your string is "odbc:DSN=dsn_name;UID=user_name;PWD=__EncPwd1__" then you just need something that replace that specific part or just the password if always unique,
 "odbc:DSN=dsn_name;UID=user_name;PWD=__EncPwd1__" to  "odbc:DSN=dsn_name;UID=user_name;PWD=__EncPwd2__"

There are several ways to go about it. You can create a python scrip to change that specific part.
You can also load the workflow in as a flat file and change it that way, might take a bit more knowledge of how to do it.

Then if you are using the API to upload to the server, you can create a python script or use Alteryx to do that too.

Hopefully this gives you a rough idea on how to go about it.