Connector
To configure the connector, from the Project Explorer select Connector, Connectors.
Click Add
Select Inductive Automation, Ignition Historical Values
Click OK
Primary Server
This defines a connection to the database where Ignition is logging historical data. A browse button […] is provided to define.
Secondary Server
These settings define the (optional) secondary Ignition to connect to if a connection to the Primary Server fails.
Gateway/System Name
The name of the Gateway/System from which to retrieve historical data. Each Gateway/System logged must be set up as its own connector. The Name drop-down provides a list of available gateways logged to the database server.
Settings
The Settings button opens the Settings dialog that defines characteristics of the database that are used to retrieve data.
 |
Typically, these settings are defaulted correctly for the Primary Server.
If queries timeout, increase the Client Wait Time.
The delimiter and timestamp settings are typically filled in automatically for the database and can be modified for other databases.
The Date/Time Storage settings define how timestamps are stored in the database. Using this setting the timestamps are manipulated when data is retrieved so that local timestamps are submitted in and returned.
Many databases require the Date format to be YYYY-MM-DD so that no interpretation needs to occur based on the Region settings of the Windows Operating System. It is recommended to always have this option checked.