Alarm Source Options
- 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.
| Option | Description |
|---|---|
| Database Type | The type of database your iFIX alarms are stored in. The following options are available:
Note: If you are unsure of which database your iFIX alarms are stored in, contact your systems administrator |
| User Name | The user name required to authenticate with your database. |
| Password | The password required to authenticate with your database. |
| Database Identifier | The 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.
| Option | Description |
|---|---|
| iFIX Field Name | The iFIX Field name of the alarm. |
| Attribute Name | The 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.
| Option | Description |
|---|---|
| Low | The severity to assign to low priority alarms. |
| Medium | The severity to assign to medium priority alarms. |
| High | The 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.
| Option | Description |
|---|---|
| Table Name | Enter the name of the database table in which iFIX Alarms and Events collector data is stored. |
| Fetch Columns | Selecting this button will fetch all columns from the table. |
| SQL Column Name | Identifies the name of the column within the database table. |
| iFIX Field Name | Identifies which iFIX Field name the SQL Column name maps to. |
| Clear Column Settings | Select to clear all column settings. |
| Save Column Settings | Select 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.