SmartBox Service

The SmartBox Service Service Type is used internally by K2 for SmartBox-based SmartObjects. (SmartBox is a K2-managed SQL schema in the K2 database, and is used for storing SmartObject data when there is no existing system that can store the data. By default, SmartObjects you create will use the SmartBox provider unless you specifically change the SmartObject to use data from another Service Object. K2 automatically generates and updates tables in the SmartBox database when SmartBox-based SmartObjects are deployed. A service instance of this service type is registered automatically when you install K2.

You would not normally need to configure a Service Instance of the SmartBox database. The configuration content in this topic is provided for information purposes only.

Service Keys (Service Instance Configuration Settings)

Key Can be modified Data Type Sample Value Notes
sqlconnection Yes Text Server=localhost; Database=SmartBox; User ID = k2; Password=k2; Pooling=false

The connection string to the K2 SmartBox database.

This property contains sensitive information. You can enter and see your values when you first configure this value. The value will be masked when the service instance is updated.

throwErrorNothingLoaded Yes True/ False False
throwErrorNothingCreated Yes True/ False False
differentSQLServer Yes True/ False False Specifies whether the target database is located on a different SQL server than the server where the K2 databases are located.

Service Objects

The standard SmartBox Service Instance has several out-of-the-box Service Objects that are used internally by the K2 environment. In addition, any SmartBox-based SmartObjects will be exposed as Service Objects as well.

SmartObjects

K2 automatically generates SmartObjects for these Service Objects. SmartObjects can be automatically created by selecting the Generate SmartObjects for this Service Instance check box when creating a new Service Instance. Designers can use the SmartObject design tools to build advanced SmartObjects that leverage the Service Objects in this service. It is recommended to use the SmartObject design tools to create SmartObjects rather than generating SmartObjects, since this allows better control over the naming, behavior and design of the SmartObject and its methods and properties.

Considerations

  • The default Service Instance of this service is used internally by the K2 environment. Do not modify or delete the existing service instance.
  • K2 manages the SQL databases in the SmartBox database automatically. If you would rather have full control where and how data is stored in SQL, create your own database in SQL and use the SQL Server Service to expose that database as SmartObjects.