Display name generation

[srikanthj]

Hi Team,

We have a query where we are generating and updating the displayname through custom query( Job control panel à Execute Extension Queries **DEPRECATED** (CUSTOMQUERYJOB)).

Query is,

update users set displayname = CONCAT(lastname,', ',firstname) where (displayname is null or displayname='') and employeetype='Non-Employee'

The above job will run after SCHEMA_USERS_IMPORTà -->File based Users Import (SchemaUserJob)

The above solution is having some issue with respect to audit since there is no evidence to show case how display name generated or updated. similar way, we have few other customer query jobs. 

Is it good idea to migrate this custom query job to Database--> Users Import (Complete) from Database (UserImportFullJob) through Saviynt connection?

Appreciate your suggestions

[rushikeshvartak]

Instead of Database connector use saviynt 4 saviynt rest connector & saviynt rest api to update user

[srikanthj]

Thanks for the response.

Can you please share more info and related links to read through. 

[rushikeshvartak]

Saviynt 4 Saviynt REST CONNECTOR 

https://saviynt.freshdesk.com/support/solutions/articles/43000669684-saviynt-for-saviynt-rest-based-...

SAVIYNT rest api to update user

https://documenter.getpostman.com/view/1797923/Uz5KmEhE#5bb6acd1-6fc6-4fef-ad8b-32778b84dfe3

or you can use jar connector 

[srikanthj]

Thank you Rushikesh.

I have already DB type connection. Is it good idea to have one more connection with Saviynt 4 Saviynt REST CONNECTOR. instated of having one more connection, can't we use Users Import (Complete) from Database (UserImportFullJob) through Saviynt connection. what advantage we get if go with Saviynt 4 Saviynt REST CONNECTOR.  

If yes, All user operations(displayname, user status, city update etc) can be used through Update Account JSON. Is it correct understanding

[rushikeshvartak · Accepted solution]

You can use db connector but from v2021 saviynt team will not share db credentials hence better to use rest connector

[srikanthj]

Thank you.