How to connect K2 blackpearl with MS SQL R2?

Welcome to the K2 forum!

The steps provided by Johan is correct and will work when
you have existing SQL DB with tables that you want to expose as K2 SmartObjects,
however it sounds like you are creating the SQL DB and Tables manually and then
want to link that with K2 SmartObjects, this is not needed as K2 provides a way
out of the box to create new SmartObjects from scratch the end result being a Table
on your existing SQL Server. I will explain the easy way that will safe you
some time by cutting back on a number of manual steps.

For this example let continue using Employee, follow the
steps below:

-         
Open K2 Studio by clicking Start > K2 blackpearl
> K2 Studio

-         
Create a new K2 Project by clicking File >
New, from K2 Type select K2 SmartObject. At the bottom of the screen rename
SmartObject to Employee and click create.

-         
Now in K2 Studio you should see (In Solution Explorer)
K2Project1 and under that your K2 SmartObject called Employee, on the right you
can now start to define the properties you need for your SmartObject

-         
From the Ribbon locate the Add icon under the properties
section and click it, in the Add SmartObject Properties dialog go ahead and
create the following properties

o   Employee
ID (you can make this a auto number of leave this as Text)

Important: Select this as
your Key field

o   Domain
Name

o   First
Name

o   Last
Name

o   Email

Feel free to add additional properties
if you need them

-         
Once done with adding properties click OK

-         
Review the properties and if you are happy you
can go ahead and deploy your Employee SmartObject by clicking the Deploy button
from the Ribbon on the Home tab

This will do the following, create the Employee SmartObject
and also create  table in SQL where you
can store the data related to your employee SmartObject

You can open SQL Management Studio and once logged in check
under Databases you will find  a Database
called K2SmartBox, expand this and under Tables you will find a newly created Employee
table, open this table and you will find it created all the field you specified
for your SmartObject

At this point you can go ahead and add some records or you
can do this using a K2 utility that allows you to test your SmartObjects

To test your Employee SmartObject follow the steps:

-         
Open windows explorer and brows to C:Program
Files (x86)K2 blackpearlBinSmartObject Service Tester.exe

-         
Once open, expand the SmartObject Explorer node,
you should see a folder called K2Project1 (assuming you did not rename the K2
Project created in the steps above), expand the folder and under that you
should see your Employee SmartObject

-         
Right click on the Employee SmartObject and
select Execute SmartObject

-         
From the Method to execute dropdown select
Create, fill out some info for your employee and click Execute to create the
employee record

Repeat this step if you want to create multiple
Employees

-         
Once you have a couple you can change the Method
to execute to Get List and hit execute to get a list of employees created

-         
Using the Load method you can load a specific
employee provided you know the corresponding ID or you can use the Get List
method and provide some of the properties as an example Name or even Domain Name
and hit execute, this will return all records matching the input info you have
provided

Let me know if these steps helped you to get going, if not
please give me a shout with your questions and we can take it further

Hi,

The SQL Service instance works in such a way that it only gives list methods if your tables do not have primary keys defined. I would suggest that you add a primary key to your table and refresh your service instance using the SmartObject Service Tester and then recreate your SmartObject. You should find that all the methods will be available. You will also find that these methods will have the input properties correctly defined.

Please give this a try and let us know whether it resolved your problem.

Regards,