Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Use of custom DB function to replace the ascend character with english character

Swetha
New Contributor III
New Contributor III

Hi All, 

We have a requirement to replace the ascend character with english character, we have received the below function to be used from saviynt team.

Kindly let us know how to use this below custom DB function to replace the ascend character with english character. attached the document received from saviynt for reference.

FN_EIC_REPLACE

Also, please let us know if anyone has used this function in any project.

2 REPLIES 2

pruthvi_t
Saviynt Employee
Saviynt Employee

Hi @Swetha ,

The DB function '' is used to replace the accented letters and special characters with alternatives to transform them into normalized characters that can be used by EIC. This db function works in parallel with a dataset with entries of accented characters and what their replacement character would be. For this dataset, you can either use Saviynt's default dataset (REPLACE_MAPPING) or a custom dataset as per your requirement. The dataset looks like below: Screenshot 2023-03-13 at 2.15.56 PM.png

If you have a dataset in the form of CSV, you can directly import that into EIC using CSV upload option to create it in EIC. For more information regarding creating datasets can be found in below link.

https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter02-Identity-Repository/Creat...

The documentation portal has all the syntaxes for both default and custom datasets, examples of how you can call DB functions in user preprocessor jsons and other identity lifecycle configurations.

The below link has information on database functions (similar to the PDF you've received) and also please go through other hyperlinks like 'Normalizing the Identity Data Using the User Import Preprocessor' and 'Configuring Identity Lifecycle Setup' which has syntax examples on how to configure jsons to remove accents and normalize identity data.

Database functions : https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter02-Identity-Repository/Datab... 

Thanks,


Regards,
Pruthvi

Sampo
New Contributor III
New Contributor III

How should we read the default dataset? For example if which special characters will be replaced by U with this line:

Sampo_0-1680014262091.png

 

I have also tried to use the default dataset by running queries like select FN_EIC_REPLACE('Aa Öä Ąćę_&!', null) but It doesn't replace any characters. If I use a custom dataset, then it does replace characters according to the mapping that I've created.

best regards,

Sampo