Working with MySQL Database

This Jump Start is aimed at administrators and power users who wish to set up a connection between system:inmation and a MySQL database. This Jump Start will provide step by step instructions on how to set up an ODBC connection and also how to utilize Lua scripting within system:inmation to create, read, update and delete data in the database. MySQL is a widely used open-source software that can be downloaded here. It is useful to have some knowledge of programming, and a basic knowledge of system:inmation and DataStudio before attempting these examples. It is also useful to read the Lua Scripting and LuaCRUD Jump Starts as these give an introduction to the Lua scripting engine in system:inmation and cover different database connection scenarios. For further information on the Lua scripting language visit the Lua website.