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 dialog box. 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. Click the Browse button to bring up the Database IDs Available dialog box. 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 Alarm and Event 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 alarm and event data is stored. |
| Fetch Columns | Clicking 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 | Click to clear all column settings. |
| Save Column Settings | Click to save all column settings in the dialog. |
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:\dynamics\local\ifixalmmig.ini. When working with a different database table, you can erase the iFIX meanings by deleting the ifix-almmig.ini file or clicking the Clear Column Settings button.