AnsweredAssumed Answered

Request forms for user onboarding

Question asked by Venkata Palakaveeti on Jul 19, 2016
Latest reply on Jul 27, 2016 by Kin Kiu Yiu

Hi All,

 

I have an use case where contractor users can be onbarded using VIA portal.

1. I have created a request form to accept user firstname, lastname, department and date of joining.

2. I have created a table in local database (AVDB) and a stored procedure to accept the parameters along with a sequence (for the user id attribute).

3. Now to provision the values entered in the form I am trying to create workflow that accepts the parameters given in the form and insert them to the table created in AVDB.

for example in the SQL EXECUTE node am trying to pass these parameters:

execute avuser.insertCONTRACTORS ('${avform.Lname}','${avform.Fname}', '${avform.Dept}', '${avform.DOJ}');

But the above is not working as the sql node giving error for the above execute command saying "INVALID SQL COMMAND".

May I know how to resolve this or is there any better way to achieve this?

(NOTE: My plan is after we insert the data into a table, I can create an Identity Collector to pull back the user and create an account in VIA)

Outcomes