Create new users with API V3 macro on Windows Authentication configured server instance

[Frederik1]

Hi Community,

We are currently in the midst of migrating from one Alteryx Server to another and need to migrate both workflow, users, and more.

We are using the macros developed by Alteryx to call the API v3, but the POST users endpoint does not work with Windows Authentication configured servers, which is what we have.

The documentation for the user endpoint says, "Note: This endpoint can’t be used for Windows Authentication configured Server instances." - https://help.alteryx.com/20214/server/user-endpoints

Does anyone know about alternative ways of migrating users from one server to another with Windows Authentication configured?

We are not limited to the use of these macros, so any input is highly appreciated.

Thank you in advance!

[fmvizcaino]

Hi @Frederik1 ,

An option could be to migrate the whole mongoDB database from one server to another with the host recovery process. This would be a good option if your objective is to copy everything you have on the other server.

https://help.alteryx.com/20221/server/server-host-recovery-guide

Another option would be to use the MongoDB input and output tool and query the users' collections from MongoDB directly.

https://help.alteryx.com/20221/server/alteryxgallery-mongodb-schema

Best, 

Fernando Vizcaino

[Frederik1 · Accepted solution]

Thank you for the suggestions! The second option seems feasible, but it is hard for us to know how it behaves without doing a thorough set of testing, which we can't.

The solution we proceed with is to create new users on the new server with default settings and then update the users with the PUT Users endpoint with the information we got from a combination of GET Users and GET Specific Users. Their IDs will change but that is OK since we can join on the users of the two servers on email to get the right information to each user.