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 SQL connection - create account issue

itinjic
Regular Contributor
Regular Contributor

Hello community,

We have a issue configuring the field CREATEACCOUNTJSON.

This is our configuration:  (Is this syntax I provided good ? )

{
"CreateAccountQry": [
"CALL CREAT_ACCOUNT('${accountName}', '${password}', 'master')"
]
}




CREAT_ACCOUNT is store procedure in SQL db, this store procedure accepts 3 parameters:

accountName should be the account name obtained using the name rule on the endpoint and generated during ARS process. (example value  dbtest-user1 )

password should be auto-generated using password policy (20-25 characters)

'master' should be hard coded string value



This is the error I get : 
SAV - Error while creating account - dbtest-user1- Exception occured in Create Account Query - Incorrect syntax near 'dbtest-user1'.

Sapere aude
7 REPLIES 7

Raghu
All-Star
All-Star

@itinjic  try like below format without  ][:

{
"createaccountqry": "call createaccount(${user.id}, '${user.displayname}', '${user.email}', '${user.employeeid}', '${user.firstname}','${user.lastname}','${user.systemusername}', '${user.username}','${randompassword}')"
}

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

 


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

NM
Valued Contributor II
Valued Contributor II

Hi @itinjic, can you try passing without square bracket?

rushikeshvartak
All-Star
All-Star
  • Does it works with hardcoded values ?
  • Does stored procedure needs string input ?
  • password policy can be configured in security system - password policy

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

itinjic
Regular Contributor
Regular Contributor

I fixed it

{
"CreateAccountQry": [
    "EXEC [master].[dbo].[CREAT_ACCOUNT] '${accountName}', '${password}', 'master'"
]
}



Sapere aude

Yes in Saviynt you need to use EXEC instead of CALL


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

itinjic
Regular Contributor
Regular Contributor

Yes but example is really poorly written in connector and  documentation, it's very confusing.


Connector:

itinjic_1-1718984843084.png

database_connector_guide.pdf

itinjic_0-1718984805060.png

 






Sapere aude

provide feedback on documentation article 


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