InDB connection creation programatically

[rupali_nayak]

Can the InDB connections be created/updated programmatically from command line instead of doing it from Designer everytime?

[KaneG]

Theoretically, you could update the connection in a workflow by editing the XML of the workflow. 

The information for each of the stored connections is in %USERPROFILE%\AppData\Roaming\Alteryx\Engine\UserConnections.xml and so could be updated there.

I'll note that there is no real documentation on this as it's a workaround, not designed functionality.

[rupali_nayak]

When password is updated via Designer Alteryx stores it in encrypted format, so in order to do it programmatically we would like to know what encryption Alteryx uses so that we can generate in similar compatible format.

[KaneG]

Ah, if you would like to create new connections from scratch programmatically, that is harder. What most orgs do in that case is create the XML on one machine and then deploy that to the others. One massive thing to be careful of is the Password Encryption field as Encrypt for Machine will use that machines Bcrypt.

You can find the encryption info here: https://help.alteryx.com/current/designer/password-encryption