---
title: "Database Connections"
id: "database-connections"
project: "MES User Manual"
url: "https://docs.sepasoft.com/articles/user-manual/database-connections"
updated: 2026-09-23T22:43:38Z
---

# Database Connections

**Sepasoft MES Module Suite**
 ### Database Connections

Create datasource connections to databases.

See Below:

* [Create a Database Connection for MySQL](/articles/user-manual/database-connections/a/h4__849131081)
* [Other Database](/articles/user-manual/database-connections/a/h4__1886044479)
* [Database Configuration Best Practices](/articles/user-manual/database-connections/a/h4_190922633)
* [All databases](/articles/user-manual/database-connections/a/h5_2010578747)
* [Microsoft SQL](/articles/user-manual/database-connections/a/h5__1025432478)
* [MySQL](/articles/user-manual/database-connections/a/h5_1420522360)
* [Postgress](/articles/user-manual/database-connections/a/h5_1420947918)
* [Oracle](/articles/user-manual/database-connections/a/h5__697474532)

* * *

#### Create a Database Connection for MySQL

Verify which Ignition Gateway you are working in:

For **Ignition 8.3.x,** to create connections:

* In Ignition Gateway, go to **Connections &gt; Databases &gt; Connections &gt; Create Database Connection**.
* Follow the Create Database Connection wizard.

For **Ignition** **8.1.x**, to create connections:

* In **Ignition Gateway**, go to **Config &gt; Databases &gt; Connections &gt; Create New Connection.**

 **MySQL**
A variety of databases can be used with the Sepasoft MES modules. The MES modules create and maintain their own schemas to store configuration information and production data. All you have to do is provide the database for them to reside in. Since MySQL is free, reliable and easy to use, it is the most common choice for use with Ignition.

**To configure the MySQL database:**

* Choose the**MySQL ConnectorJ** and click **Next**.
* Complete the following configuration items below:
    * **Name**
    * **Connect URL**
    * **Username**
    * **Password**
    * **Extra Connection Properties:** Append *serverTimezone=UTC* to the end of the settings. This is a new requirement for MyQL Connector/J 8.0. More info is available in Section 4.14 and Section 4.3.3.1.7 of the MySQL documentation.
* Click **Create New Database Connection** at the bottom of the page.
* Verify that the connection displays "valid" on the database status page before continuing to the next section. We now have a connected database to store the MES data in.
![](/resources/Storage/user-manual/database/db.png)

![](/resources/Storage/user-manual/database/Append%20serverTimezone%20-%20with%20curly%20brace.png)

![](/resources/Storage/user-manual/database/dbconnectionsuccessfully.png)
 * * *

#### Other Database
 You can use any of the other databases supported by Ignition.

#### Database Configuration Best Practices

##### All databases

* In the gateway database configuration set Maximum Database Connections to at least **24** for the database used for MES. If you are setting up a database for an Enterprise gateway, then that value must be 24 plus 2 for each gateway connected to the Enterprise.

##### Microsoft SQL

* Set **READ\_COMMITTED\_SNAPSHOT** to **ON**. If this is not ON, then you will see an exception in the Ignition logs and the production module will not start.
You can use this query to determine your database's snapshot level: DBCC USEROPTIONS WITH NO\_INFOMSGS

 ![](/resources/Storage/user-manual/mes-module-settings-in-gateway/mes-module-settings-in-gateway-2024-03-22.png)

##### MySQL

* Nothing specific to MySQL.

##### Postgress

* Nothing specific to Postgress.

##### Oracle

* Nothing specific to Oracle.

**Sepasoft MES Module Suite**