Alarm Source Options

The Alarm Source Options window is split into four sections:
  • ODBC Login Information
  • Attribute Names
  • Severity Mapping
  • Database Configuration

ODBC Login Information

The following configuration fields are shown in the ODBC Login Information section of the Alarm Source Options window. In general, the settings in this section should match the settings used in your iFIX Alarm ODBC Configuration in the iFIX SCU.

OptionDescription
Database TypeThe type of database your iFIX alarms are stored in. The following options are available:
  • Access
  • Oracle
  • SQL Server
  • Sybase
Note: If you are unsure of which database your iFIX alarms are stored in, contact your systems administrator
User NameThe user name required to authenticate with your database.
PasswordThe password required to authenticate with your database.
Database IdentifierThe name of the database your iFIX alarms are stored in. Select the Browse button to bring up the Database IDs Available window.
Note: If you are migrating on a machine other than the machine running Alarm ODBC, you may have to configure a DSN in the control panel before entering it in the Database Identifier.

Attribute Names

Use this section only if you have logged alarm user and/or extension fields AND you want to control the name of the fields created in Historian. If you have changed the default names in the iFIX Real Time Alarms and Events Server, edit the configuration in this section to match.

OptionDescription
iFIX Field NameThe iFIX Field name of the alarm.
Attribute NameThe mapped attribute name of the alarm.

Severity Mapping

If you have changed the default severity settings in the real-time AE Server, edit the configuration in this section to match.

OptionDescription
LowThe severity to assign to low priority alarms.
MediumThe severity to assign to medium priority alarms.
HighThe severity to assign to high priority alarms.

Database Configuration

If you have set up custom column names in the iFIX Alarm ODBC configuration, you may need to map the SQL Column Names to iFIX Field Names. If you have kept the default column names in the iFIX Alarm ODBC configuration, you should not have to make any changes in this section.

OptionDescription
Table NameEnter the name of the database table in which iFIX Alarms and Events collector data is stored.
Fetch ColumnsSelecting this button will fetch all columns from the table.
SQL Column NameIdentifies the name of the column within the database table.
iFIX Field NameIdentifies which iFIX Field name the SQL Column name maps to.
Clear Column SettingsSelect to clear all column settings.
Save Column SettingsSelect to save all column settings in the window.

SQL columns and their iFIX meanings are automatically matched up when the columns are fetched. You only need to configure iFIX meanings if you have used a non-default column name. If you want to exclude columns from migration to save space in Historian, set the iFIX meaning to blank. For example, if you logged both Native Time Last and Time Last in Alarm ODBC, you only need to migrate the Native Time Last field. Set the iFIX meaning of Time Last to blank.

If you use the Save Column Settings option, iFIX meanings are saved to C:\Program Files (x86)\GE\iFIX\local\ifixalmmig.ini. When working with a different database table, you can erase the iFIX meanings by deleting the ifix-almmig.ini file or selecting the Clear Column Settings button.

Note: The Alarms and Events database version must match the SQL Server version that it is running on.