Connector
To configure the connector to iFIX, from the Project Explorer select Connect, Connectors.
Click Add
Select GE Vernova, iFIX Alarms.
Click OK
Primary Database
This setting defines the SQL Server connection where the iFIX Alarms are configured to log to. Use the browse button […] to define the database connection.
Table/Column
Once the Primary Database is configured, set Table to the table where the alarms are being logged. This should match the Database Identifier configured in iFIX.
Set the Date Column to ALM_NATIVETIMEIN or ALM_NATIVETIMELAST and check Date includes Time.
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.