Configure the Database Connection

Kanoa MES uses a Microsoft SQL Server database connection named kanoaCore. This connection is required.

Create the database connection in the Ignition Gateway

In the Ignition Gateway, create a new database connection and name it:

• kanoaCore (required name)

Reference: Connecting to Databases (Ignition 8.1)

• The database connection name must be kanoaCore.
• Set Max Active to -1 in the advanced options.
• Recommend setting Include Schema in Table Name to true.

Schema creation and updates

The Kanoa MES module installer handles both:

• creation of the required database schema (on first install), and
• updating the schema (on upgrade)

You do not need to manually create tables as part of the install process.