DB SQL connection - create account issue

[itinjic]

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'.

[Raghu]

@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...

[NM]

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

[rushikeshvartak]

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

[itinjic · Accepted solution]

I fixed it

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

[rushikeshvartak]

Yes in Saviynt you need to use EXEC instead of CALL

[itinjic]

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


Connector:

database_connector_guide.pdf

[rushikeshvartak]

provide feedback on documentation article