Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

DB connector

frayang
New Contributor
New Contributor

Hi all,

We have the following logic that need to implement in a DB connector

If account exist

do Update account...;

Else 

do Insert account..;

what is the best way to implement it? Can we configure a DB connector with this logic using  multiple SQL statements instead of a stored procedure? if so, where to configure it? in CreateAccountJSON?

 

 

 

Thanks

 

 

-Fran

 

 

2 REPLIES 2

rushikeshvartak
All-Star
All-Star

ACCOUNTEXISTSJSON is used to validate before creating new account , if ACCOUNTEXISTSJSON  return true then update Account json gets used else create account json

{"AccountExistQry":"select * from sys.server_principals where name='${accountName}'"}

Documentation - https://docs.saviyntcloud.com/bundle/Database-v24x/page/Content/Configuring-the-Integration-for-Impo...


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Same as mentioned in https://forums.saviynt.com/t5/identity-governance/accountexistsjson/m-p/95514/emcs_t/S2h8ZW1haWx8dG9...

@frayang 


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.