K2 uses SQL Databases for just about everything it does.  From storing process data to process definitions and everything in between.

Thanks...does that mean that it stores workflows there?

Yes

Could you tell me how to go about doing this? How do we connect the MS SQL server to the K2 blackpearl environment??

I have created a smart object called Employee. It contains Employee ID, Domain Name. I have created a table in SQL server that contains EmployeeID, Domain Name and EmployeeName. How do i connect the two? How do i retrieve the Domain Name based on the Smart Object?

Will be of GREAT help to let me know this. I'm extremely new to K2 and would really appreciate the help!! :-)

Thanks

Sravanthi

it sounds like you need to setup a SmartObject Association.  Reference the help documentation in the following section.

Concepts > SmartObjects > SmartObjects Overview >
SmartObject Relationships