|
Ignition has been tested with the following databases, and can connect to them directly after installation. It is possible to connect to other databases by installing additional JDBC drivers (the Java database connection specification), which are often provided by database vendors.
Full support
Database
|
Version
|
MySQL
|
5.0+ for full support. Ignition will connect to 4.x, but many features such as SQLTags have not been tested.
|
Microsoft SQL Server
|
2005, 2008, full and express editions. Ignition will connect to 2000, but has not been fully tested.
|
Oracle
|
10g, 11g, full and express.
|
PostgreSQL
|
8.0+
|
Limited support
Database
|
Version
|
Microsoft Access
|
Access support is very limited, and should only be used to integrate existing data into the project, not for storing new data.
|
Other JDBC drivers
|
Due to variances in databases, some features may not work fully through other non-tested JDBC drivers. However, it is usually possible to get full functionality though the careful use of the database translator feature.
|
Choosing a database
If you are new to working with SQL databases and are trying to choose a vendor, there are several factors to weigh:
| • | Existing company usage - Many companies already use SQL databases for other purposes, and thus most IT departments already have a defined standard. Going along with your company's existing standard is usually recommended, as there will already be staff available who are knowledgeable about the system. Furthermore, you may be able to tie into your company's existing database system instead of maintaining your own. |
| • | Price and Features - The fully supported databases above vary dramatically in price. Some systems can cost thousands of dollars, but may have a free "express" edition that will work perfectly well for your requirements. Others offer advanced features such as redundancy, which are either not offered or difficult to configure in the other systems. It is therefore important to clearly define the features and capabilities that you need. |
| • | Most common among Inductive Automation users - choosing a database that is commonly used by Inductive Automation users means that you are more likely to find examples and help in the forum, among other benefits. The supported database list above is sorted according to our current user install base. |
|