Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
How To Manually Change A Domain User To New Domain
It is not uncommon for customers to migrate existing users from an old domain to a new domain. This article explains how to achieve this manually in MongoDB.
Robo Studio 3T
For Windows Authentication, Gallery user is created automatically when logging in the first time. Below is the information Gallery synced from domain AD and stored in the users collection in the AlteryxGallery MongoDB:
Collection users documents <--> AD attributes
Email <--> mail FirstName <--> givenName LastName <--> sn WindowsIdentity.Sid <--> objectSid WindowsIdentity.DisplayName <--> displayName WindowsIdentity.Name <--> domain\user format WindowsIdentity.SamAccountName <--> sAMAccountName
We can update all this information and still keep the unique ObjectId which is used as a "Foreign Key" in other collections to build the relationship between this user and the user's assets in Gallery.
Based on this knowledge, here are detailed steps to change a domain user to the new domain.
3. Right-click the record and select "Copy Json" and save the content to a notepad. 4. Right-click again and select "Edit Document". 5. Update/verify the value of the following fields:
The correct values should be from the new domain AD.
6. Once the changes are made, click Save at the bottom right.
In MongoDB AlteryxGallery, under the most situation, the ObjectId is used to refer to the user. However, if a collection is shared with a domain user for Windows Authentication, then Sid is used instead of ObjectId.
Please run the following query in Robo Studio 3T to find if the old Sid is used for sharing collection.