Using a Stored Procedure and making it to a SmartObject

Hello Gozni,

Documentation discussing stored procedure integration can be found here:

https://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#ServiceBrokers/SQLServer/SQL-Server-Service.htm

For a step-by-step example of creating SmartObjects from a SQL service instance, please see the following:

How To: Create a SmartObject to connect to a SQL Database

https://help.k2.com/onlinehelp/k2five/userguide/5.3/default.htm#How-Tos/AdvancedSmartObjects/SQLServer/CreateAdvSmartObject-SQL.htm?Highlight=sql%20stored%20procedure

The above how-to does not explicitly go over integration with stored procedures, but if the database you are connecting to has stored procs present, they will present themselves in the creation of the SmartObject.

Cheers,

qT

K2 will not accept any liability for any issues arising from actions taken in respect of information provided by any forum member.

Hi Gozni,

You can follow the steps below to generate the SmartObjects:

1. In Management Site, expand "Integration" and then Click on to select "Service Types". A list of service types will appear on the panel on the right. Make sure that "SQL Server Service" is on the list. See image below;


2. Assuming that "SQL Server Service" exists, click on to select "Service Instance". Click "add" and a screen will pop up. This is where you configure a service instance from which you will be able to generate your SmartObjects for stored procedures. On Display Name, give a desireable name for the service instance, On Service Type, select "SQL Server Service" which was on the list of Service types in the previous step and then select desisred service authentication method. See image below;


3. On the same screen, scroll down to Settings, make sure to input "K2" on DATABASE and the name of the server on SERVER. Finally, at the bottom of the screen, there is a checkbox named "Generate SmartObjects for this service instance". You have to check that box. See image below;


4. Finally, the service instance has successfully been created.


5. After this, your SmartObjects should be available in Designer and named after the display name give to it when you were setting it up in step 2. See image below;

Let me know if this was helpful.

Thanks,

Katleho