How to Create Custom SQL Service Instance SmartObject

  • 26 April 2018
  • 1 reply
  • 35 views

 1. In SQL Server Management Studio create a new Database
 

 

 17183iFB84F6FC38395130.png
 

 

 


2. Create a new table within Database
 

 

 

14065iA82A557722E8814A.png
 

 

 

3. Add a new Column and then “Set Primary Key”

12695i15DC7A91382B6F12.png

 

 

Note: If you don’t set a primary key, you will get an error when trying to create smartobject.

 

 



4. Apply proper Permissions for the Database

16688iD0552D5CCFD3EE57.png
Note: If you don't have the proper permissions, you wont be able to connect to DB.

 

 



5. In K2 Management under “Integration” find "Service Instances"
 

 

 

15810iD6CC74565C92B39E.png 
Note:  This is where you will create a new Instance for SQL Service Instance.

 

 



6. Create New Services Instance for SQL Service Instance
 

 

 

 10814iBF8146B8191220F8.png

 

 

Note: Database * should be the name of the SQL Database you are referencing. Also make sure “Generate SmartObjects for this Service Instance” is checked.

13441iA8E4D1F1205B0040.png

 

 

 Note: If all settings are correct the above message should appear.

 

 

 

 

 


7. Check to make sure new SmartObject was created in SQL Instance folder in Management
 

 

 

15220iCAE797041E981C03.png 
 

 

 


8. Test to see if you can execute "List" to display your column with no error 

11525i9F3195AFEDBCB35D.png

Note: You can add a value to the column as well to test to see if your value appears.

 

 

 
 

 

 

From here, you can then attach or modify it however you would like to work with the project that you are creating it for.

 


1 reply

Badge +8

Thank you for the information MichaelS.

Reply