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.
- 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.
- 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 theihAlarms
database and theTagName
column of theihRawData
database. You can do this only ifNo Prefix
has been added to the tagname.The following example shows a parametrized query that uses theAlarmID
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' )