What can you do with Smile public schema?

The Smile public schema is intended specifically to allow the development of ad hoc reports for Smile users, and is designed to allow you to use report writers or command line tools to develop reports and other read-only data directly from the Smile database.

SPS does not provide the ability to update data within the Smile application. If you wish to integrate Smile with a third party application, you should use the Smile API, which provides SOAP and messaging methods for both reading and updating data within the application. For more information see the Smile Developer Guide.

Although all data is provided in real time from the Smile database, we do not guarantee that this will always be the case. If you have real time requirements then the best approach is to use the Smile message bus, which is part of the Smile API.