How do I connect to a database?

Ignition is able to connect to many different types of databases so that you can store and access data from your Ignition projects, but it is not itself a database. There are many different third party software packages that provide database solutions, some of the most popular being MySQL, MS SQL Server, and Oracle.  Ignition connects to these databases using JDBC drivers that are unique to each database.  Drivers for the most popular databases are included so there is usually no need to install the JDBC driver manually.

It is important to note that Ignition does not install any database.  It is your job to choose the database solution that is best for you and then install it either on the server that Ignition resides on or a server that can be reached over the network from the Ignition server.

Connecting to a database

The process for creating a database connection in Ignition is the same for all databases. The only place the process differs is in the connection properties. Information regarding creating a new database connection can be found here: Creating and Editing Connections. See the two guides below for a more detailed walkthrough on connecting to two of the most popular databases used with Ignition.

Guides

Connecting to MySQL - MySQL is extremely easy to connect to and should give you little problem.

Connecting to Microsoft SQL Server - MS SQL Server can be a bit more complicated to get a valid connection going, but this guide gives you step by step directions for getting connected that should make the process much easier.