Using the OPC AE Collector with FIX32 SCADA Systems

You cannot use an OPC alarms and events server with FIX32 SCADA systems. To collect alarm data from these systems, you can use a proxy for alarms through an iFIX node with an OPC alarms and events server. The OPC Classic Alarms and Events collector of Proficy Historian can then collect the data.

There are two different configurations that can occur in this instance:
  1. A single proxy in which only one FIX32 system forwards its alarms through a particular iFIX node. In this case, you can link the OPC Classic Alarms and Events collector to the FIX32 data collector. Refer to Configure the OPC Alarms and Events Collector. You can then query the data using clients such as Configuration Hub, Historian Excel add-in, and so on.
  2. Multiple FIX32 system proxy alarms through a single iFIX node.

    In this case, you cannot set the Link To Data Collector parameter to both FIX32 data collectors. As a result, it is not possible to create a relationship between alarm and tag data. Therefore, you cannot link the data using Historian Excel add-in.

    To link the alarm and tag data in this scenario, perform an OLE DB query with a join between the ItemID column of the ihAlarms database and the TagName column of the ihRawData database. You can do this only if No Prefix has been added to the tagname.

    The following example shows a parametrized query that uses the AlarmID property to find all values read from the corresponding tag for that alarm during the duration of the alarm.
    SELECT   ihRawData.'Value', ihRawData.Tagname, ihRawData.'TimeStamp' 
    FROM     ihRawData, ihAlarms
    WHERE    ihRawData.Tagname = ihAlarms.ItemID
    AND    ( ihRawData.'TimeStamp' >= ihAlarms.Starttime ) 
    AND    ( ihRawData.'TimeStamp' <= ihAlarms.'Timestamp' ) 
    AND    ( ihAlarms.AlarmID = 13240 )
    AND    ( ihRawData.SamplingMode = 'RawByTime' )