Top  | Previous | Next

Historical Group

The historical group makes it easy to quickly log data historically to a SQL database.

 

General Description

The historical group inserts records of data into a SQL database, mapping items to columns. Full support for triggering, expression items, hour & event meters and more means that you can also set up complex historical transactions. Unlike the standard group, the historical group cannot update rows, only insert. It also cannot write back to items (besides trigger resets and handshakes).

 

Group Settings

The settings of the historical group are identical to the settings in the Standard Group, but limited to inserting rows.

 

Typical Uses

•Basic historical logging - Recording data to a SQL database gives you incredible storage and querying capabilities, and makes your process data available to any application that has DB access.
•Shift tracking - Use an expression item to track the current shift based on time, and then trigger off of it to record summary values from the PLC. Use a handshake to tell the PLC to reset the values.