Ignition User Manual 8.0

Search

User Manual

GETTING STARTED


MODULES AND PLATFORM


APPENDIX


TUTORIALS & HELPFUL TRICKS


GLOSSARY


STRATEGIC PARTNER LINKS

Sepasoft - MES Modules
Cirrus Link - MQTT Modules

RESOURCES

Inductive University
Ignition Demo Project
Knowledge Base Articles
Forum
IA Support
SDK Documentation
SDK Examples

ALL MANUAL VERSIONS

Ignition 8.1
Ignition 7.9
Ignition 7.8

Deprecated Pages

Versions Compared

Old Version 4

changes.mady.by.user Sally Price

Saved on

compared with

New Version Current

changes.mady.by.user Sally Price

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Connect Once

Many of the advanced features of Ignition, such as the Transaction Groups and Tags Historian require a connection to an external database and most databases require special permissions for each computer that wants to connect. Fortunately, Ignition takes care of all of this for us. You can create a connection to your database once and every system in Ignition will use that central connection. There's no need to worry about updating your database settings to add another client.

This central database connection also makes it easy to swap between databases or schemas. You can tell every query to use the default connection, then just change the default to update everything. Alternatively, you can force specific queries or systems to use a particular connection. Create as many database connections as you want and start designing using all of them.


On_this_page

 




Common Connection Settings

Add a Database Connection

Now that we've installed your database, lets  let's connect to it. You can find detailed descriptions for many database connections in this User Manual, however, they all include the following three main same steps: 

Add a Database Connection

  1. On the Gateway Webpage, go to the Gateway Config tab. Use the menu on the left to go Scroll down to the Databases > Connections section. On  

    Image Added

  2. On at the Database Connections page, click on the Create new Database Connection... link at the bottom of the table.
    Pick

    Image Added


  3. The next step is to choose a JDBC Driver. 

    Ignition connects to 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.

    Ignition ships with drivers for Microsoft SQL Server, MySQL, Oracle, and PostgreSQL. Pick the JDBC driver for your database, and click on the Next button.
    If a suitable driver is not available in the list, you need to add a new JDBC driver for other databases, like IBM DB2, which is not very difficult to do, see Adding a JDBC Driver.
     

  4. Configure the Connection
    After selecting the driver, you'll configure the settings for the connection. Some settings, such as the Connect URL are specific to the driver that you're using.

    Main Database Connection Properties

    NameEach database connection needs a unique name, which consists of letters, numbers and underscores.
    DescriptionA brief description of the database.
    JDBC DriverThe JDBC driver dictates the type of database that this connection can connect to. It cannot be changed once created.
    Connect URLA string that instructs the driver how to connect to the database. This string is the server address, and may include the port, instance name, database name, and so on. The format and parameters depend on the driver being used.
    UsernameThe username to use when connecting. Some databases support other authentication methods, such as Windows authentication, in which case this field is not used.
    Change Password?Check the box to change the existing password.
    PasswordEnter password.
    PasswordRe-type password for verification.
    Extra Connection PropertiesDepending on which database you are connecting to, there will be different default values placed in this box. MS SQL Server requires you to place your database name here, but for other databases you can usually leave this at its default values.
    Each database has its own set of available extra connection properties so you must refer to your Database documentation to determine what is valid here.
    EnabledLets you to enable or disable a database connection.
    Validation TimeoutThe time in milliseconds between database validation checks. (default: 10,000)
    Failover DatasourceThe connection that is automatically used when this connection is not available.
    Failover ModeLets you select how to handle the database connection failing and recovering.
    Database connections support failover. This means that the objects which use a database connection will use a different connection if the one they are using becomes unavailable. The Failover Datasource property determines which connection is used, and the Failover Mode determines when, if ever, the connection is switch back to the primary connection. 
    There are two failover modes:
    • STANDARD mode means that this datasource will fail over when a connection cannot be retrieved, but when connectivity is restored, connections will again come from this datasource.
    •     STICKY mode means that once this datasource fails over, connections will continue coming from the failover datasource until the failover datasource itself fails or the Gateway is restarted.
    Slow Query Log ThresholdQueries that take longer than this amount of time, in milliseconds, will be logged. This helps to find queries that are not performing well. (default: 60,000)
    Validation TimeoutThe time in milliseconds between database validation checks. (default: 10,000)

    Advanced Settings

    There are many advanced settings that you don't need to change under normal circumstances. See the description for each property on the settings page.
 




Next_link