Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/22/2024 07:14 PM
Hi all,
I am wondering how to use ACCOUNTEXISTSJSON ? Can we reference it in another JSON in the connector? Thanks
-Fran
Solved! Go to Solution.
05/22/2024 07:47 PM - edited 05/22/2024 07:48 PM
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...
05/23/2024 06:58 AM
Hi @rushikeshvartak , it checks on target end of on saviynt side only?
05/23/2024 08:33 AM
05/23/2024 08:43 AM - edited 05/23/2024 08:43 AM
@Saathvik So if it finds an account at the time of create account does it error out the task
05/23/2024 08:35 AM
Hi Rushikesh,
Thanks for the info.
You meant that Saviynt evaluates ACCOUNTEXISTSJSON in DB connection while executing New Account tasks to provision to DB target, and once it returns true, a DB new account is created in Saviynt as manually provisioned? Thanks
-Fran
05/23/2024 10:15 AM
{"AccountExistQry":"SELECT * FROM test.user_table WHERE samaccountname = '$(user.customproperty27)' "}
this configure threw errors while saving the connection. Any idea on this error? what is wrong with my configuration? Thanks
-Fran
05/23/2024 10:21 AM - edited 05/23/2024 10:22 AM
{"AccountExistQry":"SELECT * FROM test.user_table WHERE samaccountname = '${user.customproperty27}' "}
{} was missing
05/23/2024 10:28 AM
I still have the same errors after changing to
{
{"AccountExistQry":"SELECT * FROM test.user_table WHERE samaccountname = '${user.customproperty27}' "}
}
05/23/2024 10:35 AM
{"AccountExistQry":"SELECT * FROM test.user_table WHERE samaccountname = '${user.customproperty27}'"}
05/23/2024 03:20 PM
yeah. That works. Thanks
05/23/2024 08:22 PM
Hi @frayang , if an account exists on application end did the task got errored out .. or account was created in saviynt?