K2 Management Console - SQL Server Service

The SQL Server Service enables users to create SmartObjects from an existing SQL Database. The SQL Server Service is able to use Tables, Views and Stored Procedures in a SQL database to create service objects within the SQL Server Service, which can then be mapped to a SmartObject.

SQL Server Service Limitations

Only 3 modes of authentication are supported in the SQL Server Service at this time:

Static - i.e. SQL Authentication will be used. So a SQL User (like sa) will be specified here.
Impersonation - Logged On user will be impersonated and executed in that context.
Service Account - Authentication will be reverted to the Service Account and executed in that context.

The following SQL Data Types cannot be used with the SQL Server Servce:

AutoNumber
AutoGuid
TimeStamp
Image
SQL_Variant
Binary
VarBinary
Numeric
Hierarchyid