While Importing Users (Complete) in a DB connector, mapped a custom property for the "Middle Name" rather than using the existing Saviynt property for the same.
Can anyone please assist me on how to get this fixed.
Need to nullify the value which exist in custom property and update the same in "Middle Name" Saviynt property.
I appreciate you reaching out to the Saviynt forums.
The table named "users" with columns firstname, customproperty, and lastname, you can use the following SQL query to replace the values in the customproperty(customproperty that is mapped) column with the values in the middlename column:
query:-UPDATE users SET customproperty = Middle Name;
You can use custom query job for this.
Thank you for your reply, my ask was different and above solution is the current mapping.
Also, we have updated the user details & fixed it and updated the JSON as well so that Incremental Import will be updated with proper mapping.
Actually, instead of using the Saviynt property "Middle Name" we mapped it to a Custom Property and users got imported as well from DB.
So, we updated the values which was mapped in Custom Property to Middle name and then Nullified all the values mapped to that Custom Property & updated the Import JSON mapping accordingly by removing the old mapping i.e. "Custom Property - Middle Name"