If you are using the Alarm ODBC service, you can display the alarms logged to a relational database with the Alarm Analysis object (available with Proficy Portal Enterprise edition). In order to transfer the alarm data to this object, you need to set up an Alarms connector.
In the Administration application, you can add and configure an Alarms connector to the Proficy Portal server by opening the Alarms folder and selecting the Alarms node. The Administration application displays the following fields:
In the Proficy Portal client application, click the Administration button on the main toolbar. The Administration application appears.
Click the Connectors & Data Sources button. A directory tree appears.
Expand the Alarms folder and click the Alarms node in this folder. The Add New Alarms Data Source window appears.
In the Logical Name field, enter the name of the data source.
In the Connection Information section, either enter the user name, password, and database URL, or click the Connections button. The Connections button allows you to access SQL data sources. When you select the data source and click OK, the User Name, Password, and Database URL are filled in automatically.
In the Database Table field, enter the name of the table you want to read alarms from, or click the ellipsis button and select the table from a list.
In the Maximum Number of Rows in the Resultset box, enter the maximum number of alarms rows you want to retrieve from the database. If you do not want a limit, clear the check box.
If you want the number of rows to be displayed at run-time, select the Fetch row count at runtime check box.
To display SQL column headers/iFIX field mappings, click the Fetch Columns button.
If you want to change a mapping, click the iFIX field name. A drop-down list appears, allowing you to select a new field name to map to the SQL column.
NOTE: All field names will appear in the iFIX Field Name drop-down list, regardless of which fields have already been mapped to SQL columns.
Click the Apply button to save your changes. The Test, Copy, and Remove buttons appear.
Click the Test button to see if your connection is functioning properly. You will receive a message that the data source test passed or that it failed. If the test passed, you are ready to retrieve data. If the test failed, refer to Troubleshooting Connections to Data Sources.
