and more in a single search tool across platforms. Read the announcement here. |
02/16/2023 02:43 AM
Hi,
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.
Thanks, Jayashree
02/16/2023 05:10 AM - edited 02/16/2023 05:11 AM
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.
02/16/2023 05:15 AM - edited 02/16/2023 05:30 AM
Hi Dixshant,
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.
04/20/2023 10:55 AM
I tried executing this query from Admin Function > Data Analyser but this says "OPERATION NOT ALLOWED"
04/20/2023 03:03 PM
You cant execute update query from Data Analyzer. As suggested earlier please use Custom Query Job.
Thanks
02/17/2023 07:28 AM
Hi
I appreciate your update, however, I would like you to provide a detailed description of the steps that were taken from your end so that others may benefit as well
02/19/2023 11:24 PM
you want to make null on every time or on specific condition, You can make blank only using sql
02/20/2023 02:53 AM
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"