Who should use Smile public schema?

The Smile public schema uses SQL technology to allow you to query the Smile database using standard commands. The SPS is intended for people who are familiar with SQL queries and related reporting concepts.

If you need to use the public schema to extract data from Smile, but you do not know how SQL works, then there are a number of SQL tutorials on the Internet. W3Schools has an interactive SQL tutorial which you can find at

http://www.w3schools.com/sql/default.asp

The SPS is SQL specific, so if you do not know about SQL and do not wish to learn it, then this document not for you.

The SPS is compatible with third party reporting tools, including Pentaho Reports.