Is there official support for storing alarms and events in a database such as MS SQL or SQLite?

Hi Rohan Patel ,

I've seen many customers implement their own Alarm storage solutions (in addition to the built-in Alarm storage).

Some examples:

1. AVEVA Historian + AVEVA Plant SCADA Historian Connector to store alarm history. This alarm history can then be quiried via sql commands or oData interface.

2. Setup directly within Plant SCADA, an Alarm device that outputs to a SQL database. See the help topic "Configure SQL Device" and "Add an alarm category" for more information on how to do this.

3. Custom Cicode which opens the alarm event queue and stores each event in a SQL database using the SQL Cicode functions. This is more advanced and requires some engineering to implement.

Hope this information helps.

There might also be examples on the Knowledge Base of the above or Toolbox (https://softwareforums.aveva.com/citect_community/f/toolbox).

Kind regards

Olivier

Hi, 

It is also possible to make sql queries to citect alarm database via the ODBC Citect Alarm Driver. There is a table for realtime alarm values and another for historical alarms and events.

Hi Olivier  In 2nd & 3rd option if communication between Plant SCADA & SQL Database fails & restore after 8 hours can it backfill previous data or it only stores real time alarm, event data to sql database.  

Olivier  We also looking solution of Plant SCADA Trend data logging to SQL Database located at different PC in same network without using Historian server. How can we Log Trend data to SQL Database without interruption, If communication fails for some time between Plant SCADA & SQL Database after comm restore, automatically Trend data should backfill in SQL. If we use ODBC connection then it only stores real time Data. We required continuous data logging even if communication fails & restore.  Please support, Thanks in advance