Akin
Rookie

Stored Procedure

how do I consume a stored procedure from sql to K2?

Labels: (1)
0 Kudos
Reply
5 Replies
tbyrne777
Contributor

Re: Stored Procedure

First you'll need to register your database as a Service Instance in K2 Management - you can do so by drilling into the "Integration" node and selecting "Service Instances" on the left-hand navigation menu within K2 Management. Once that is done, you can design a new smart object that hooks into this new database service instance. If you can get this far I can give you more details
0 Kudos
Reply
AMolyneux
Nintex K2 Expert
Nintex K2 Expert

Re: Stored Procedure

Have a look at the K2 Five help documentation on the subject of SQL Service Type. https://help.nintex.com/en-US/k2five/userguide/5.5/default.htm#ServiceBrokers/SQLServer/SQL-Server-S...

 

Make sure you read the section on Stored Procedures since not all stored procedure types are supported.

0 Kudos
Reply
Akin
Rookie

Re: Stored Procedure

Thanks for the reply, this is already done. I am open to more details
0 Kudos
Reply
Akin
Rookie

Re: Stored Procedure

thanks for the recommendation
0 Kudos
Reply
AMolyneux
Nintex K2 Expert
Nintex K2 Expert

Re: Stored Procedure

I'm not sure what more details you need. Once you have created the SQL Service Instance you can generate smartobjects for your tables, views and stored procedures. Once generated, you can use them like any other smartobject.
0 Kudos
Reply