Getting Started – Alarm Logging

To open a new window for Alarm Logging modification, select Configure-Alarm Logging.

Select a Windows Service to modify, the node with the green arrow is the current Service being modified. Refer to Selecting Service for more information on selecting an OAS Service.

In order to log alarms to a database you must first define the Tag Alarm Limits as described in Configure Tags of this Quick Start section.

For a complete list of all Alarm Logging properties refer to the OAS Configuration – Alarm Logging section in this help file.

Step 1

OASStart the Configure OAS application if it is not already running.

 

 

Step 2

Select Configure-Alarm Logging.

Alarm Logging

Step 3

Select the Local OAS Service by selecting the Select button next to the Network Node.

Network Node

Note: The Configure application can be used to connect to remote systems using the network node name or IP address of the remote node the OAS Service is running on.  Simply enter the IP Address or network node name of the remote OAS Service you wish to connect to and click on the Select key.

Step 4

Enter the Logging Group Name of Simulation in the field in the upper right.

Logging Group Name

Step 5

Check Logging Active in the Common Properties Tab.

Logging Active

Step 6

Select the Database Tab.

Database Tab

Step 7

Logging to SQL Server

Use the following configuration for SQL Server and SQL Server Express. The Database and Table will automatically be created for you.

Database Configuration

The Server name may need to be adjusted from localhost to the proper Server name of the SQL Server engine you wish to log to. This Server name can be found when first bringing up the Connect dialog of the SQL Server Management Studio.

Also the login method can be with Windows Authentication or SQL Server mode. Contact your database administrator if you are unsure of what login type to use.

Getting Started-Data Logging 10

You can download a free version of SQL Server Express from www.microsoft.com.

Logging to Microsoft Azure

Use the SQL Server Provider and view the following guide to setup Microsoft Azure:

Windows Azure Setup

Logging to Oracle

If you are using Oracle you must first create the database. All other steps are the same as SQL Server except the provider should be set to Oracle.  Oracle does not create the database.

If you do not have a TNSNAMES.ORA file or need to log to a remote database engine refer to the Frequently Asked Questions in this Data Logging topic.

Logging to mySQL

All steps are the same as using SQL Server except the provider should be set to mySQL.

Logging to PostgreSQL

All steps are the same as using SQL Server except the provider should be set to PostgreSQL.

Logging to Cassandra

All steps are the same as using SQL Server except the provider should be set to Cassandra.

Logging to MongoDB

All steps are the same as using SQL Server except the provider should be set to MongoDB.

Logging to MariaDB

All steps are the same as using SQL Server except the provider should be set to MariaDB.

Logging to SQLite

All steps are the same as using SQL Server except the provider should be set to SQLite and the File Path should be set to the directory and file name to log to.

Logging to Microsoft Access

Use the following configuration for Microsoft Access. The Database and Table will be automatically created for you.
When logging to MS Access 2007 or greater use the extension .accdb, use .mdb for the older versions of versions of Access.

Access Configuration

Use the following configuration for CSV text logging:

Note: There is no historical replay to alarm windows with CSV logging.

CSV Configuration

Step 8

Select the Add Group button to add the Alarm Logging group.

Add Group

Step 9

Select the Save button on the toolbar at the top.

Save Button

Step 10

Save the file DemoAlarmLogging.AlarmLog in the directory C:\OAS\OASDemo\.

Save Log

You can specify for this configuration to load automatically when the Service starts using Configure-Options which is described also in this Training Guide.