How to Log OPC UA Alarms to SQL Server

Open Automation Software can be configured to connect to OPC UA servers using the OPC UA connector, trigger alarms and log them to a SQL Server database. This guide walks you through downloading and installing OAS, configuring an OPC UA connector, configuring tags, setting an alarm limit and configuring alarm logging to SQL Server.

For this guide on how to log OPC UA alarms to SQL Server you will need:

• A SQL Server instance and database

ℹ️ For simulation purposes, you will use the OPC UA server available in the OAS platform to write a Tag value. If you already have an OPC UA server or device available, you can also adjust your configuration to suit your own OPC UA server or device.

1 - Download and Install OAS

If you have not already done so, you will need to download and install the OAS platform.

Fully functional trial versions of the software are available for Windows, Windows IoT Core, Linux, Raspberry Pi and Docker on our downloads page.

On Windows, run the downloaded setup.exe file to install the Open Automation Software platform. For a default installation, Agree to the End User License Agreement and then click the Next button on each of the installation steps until it has completed.

If you'd like to customize your installation or learn more, use the following instructions:

• Windows Installation
• Linux Installation
• Raspberry Pi Installation
• Docker Installation

The OAS Service Control application will appear when the installation finishes on Windows.

Click on each START SERVICE button to start each of the three OAS services.

2 - Configure OAS

Web Configuration Application

Configuration of the OAS server is performed from the built-in Web Configuration Application. This is the main application for accessing any settings within the OAS server and is completely self-contained within the server.

You can reach this by opening your browser to:

http://<your server>:58725/app/config

If you are browsing from the OAS machine itself, you can use localhost, otherwise use the IP address of the machine. You will also need to ensure port 58725 is open on both the client and the server or you may not be able to reach the application.

On a new installation the OAS engine has no accounts yet, so the first screen you see is Create Admin Account. Once the administrator account exists that screen is not shown again, and browsing to the application displays the sign in screen instead.

1. Enter a name for the administrator in the Admin user name field. Typically you would use admin, but you can use whatever name you choose.

2. Enter a password in the Password field, then enter the same password again in the Confirm password field.

3. Click on the Create admin & sign in button. The account is created and you are signed in to the engine.

To sign in from then on, enter the Network node of the OAS engine, then the Username and Password of your account, and click on the Sign in button.

Legacy Configuration Application

1. From your operating system start menu, open the Configure OAS application.

2. Select the Configure > Tags screen.

   Important

   If this is the first time you have installed OAS, the AdminCreate utility will run when you select a screen in the Configure menu. This will ask you to create a username and password for the admin user. This user will have full permissions in the OAS platform.

   For further information see Getting Started - Security.

3. If this is the first time you are logging in, you will see the AdminCreate utility. Follow the prompts to set up your admin account. Otherwise, select the Log In menu button and provide the Network Node, username and password.

   

   

3 - Configure OPC UA Data Source

In the following steps you will create and configure a OPC UA Connector to connect to the OAS internal OPC UA server on port 58728 and act as a data source.

ℹ️ If you want to use your own third-party OPC UA server you can provide the relevant Server URL and security credentials instead of the details provided below.

1. Select Drivers in the sidebar.

2. Click + Add, enter a meaningful Driver Interface Name to give this driver interface instance a unique name, and click Create. Once created, the driver interface name should appear in the list of drivers.

3. Ensure the following parameters are configured:

   • Driver: OPC UA
   • Server Url: opc.tcp://localhost:58728

4. Click on the Browse… button next to the Security Profile field. In the Security Profile window choose the appropriate security profile. For this guide we will choose None:None:Binary, then click on the Use this profile button.

   

5. Set Authentication to Username and enter the Username and Password credentials created in the earlier section.

   

6. Turn on Enable and click on the Apply changes button. The driver interface is not active until it is enabled and the changes are applied.

   

4 - Add Simulated OPC UA Tag for Temperature Input

In this section you will create a Tag to represent a Temperature input in a destination OPC UA server. This Tag is used for simulation because we are using the OAS OPC UA server.

ℹ️ If you have your own third-party OPC UA server where you can simulate a Tag value then you can skip this step.

1. Select Tags in the sidebar.

2. Make sure no Tag Group is selected and click on the + button, then choose Add tag.

   

3. Provide a Tag Name such as OPCUA_TemperatureInput and click the Create button.

   

This tag will have a default value of zero. It will automatically update once your destination data connector and tag are configured.

5 - Assign OPC UA as Tag Data Source

You will now set the Tag's data source to the OPC UA driver interface that you created previously to act as a data source.

1. Select the Tag that will source data from the local OPC UA data source.

   

2. Set the Data Source to OPC UA.

3. Set the Select Driver Interface drop-down to the OPC UA Connector interface created previously.

4. Click on the Browse… button next to the NodeId field. The Browse for Node ID window lists the nodes available on the OPC UA server that the driver interface is connected to.

   

   Expand the Local node, expand OPCUA_TemperatureOutput, and select Value, so that the NodeId reads OPCUA_TemperatureOutput.Value. Click on the Use this node button to select this node.

5. Click on the Apply changes button to apply the changes.

   

6. Check that the quality status is Good and the Tag value is as expected.

   

7. If you change the value of the OPCUA_TemperatureOutput Tag then you should see the same value update in the TemperatureSensor Tag. This means your OPC UA interface is working.

6 - Set Tag Alarm Limit

1. Select the Tag where you want to enable the alarm limit.

   

2. Expand the High section to open the high alarm limit configuration.

   

3. Configure the following setting to enable the high alarm limit:

   • Turn on Enable Alarm
   • Set the High Limit value to your desired value threshold for triggering the alarm

   Optionally you can also configure:

   • Alarm Text to customize the alarm text that will be shown. You can combine this with different Alarm Text Type settings in order to prepend, append, overwrite or replace the alarm text with a calculation.
   • Group to categorize the alarm into a specific group. This can be used to filter alarms when configuring logging and notifications.
   • Priority to order and apply a specific priority to each alarm.
   • Time Delay which suppresses the alarm for the specified amount of time after it is triggered.
   • Log As Event which means the alarm will only be recorded as a single instance without an acknowledgement state.

   

4. Click on the Apply changes button to apply the alarm limit configuration.

7 - Configure Alarm Logging

You will now configure alarm logging to a SQL Server database.

1. Select Alarm Logging in the sidebar.

2. Click + Add, enter a meaningful Logging Group Name to give this alarm logging group a unique name, and click Create. Once created, the alarm logging group name should appear in the list of logging groups. An alarm logging group is defined by a specified filter, OAS node list (default localhost) and database connection or CSV file configuration.

3. In the Common section turn on Logging Active. New logging groups are created inactive, so this is what makes the logging group active. Leave the remaining values at their defaults.

   

4. In the Filters section you can customize which alarms should be included in your logging. This includes filtering by:

   • Alarm state
   • Alarm priority
   • Alarm type
   • Alarm group

   

5. In the Nodes section you can leave the default settings if you only want to include alarms generated on the local node. The localhost node is added to the list automatically.

   

6. In the Database section you will configure the database type and connection parameters:

   • Turn on Log to Database to enable logging to a database
   • Set Provider to SQL Server
   • Set Server to your SQL Server instance (e.g., localhost or servername\instancename)
   • Set Database to AlarmLog
   • Set Table to a table name such as Alarms
   • Set User Name to a user with permissions to manage the AlarmLog database
   • Set Password to the user password

   

7. Click on the Apply changes button to apply the alarm logging group configuration.

   

8. Your alarm logging group is now active.

8 - Save Changes

Once you have successfully configured your OAS instances, make sure you save your configuration.

On each configuration page that has a Save button, click on it.

If this is the first time you are saving the configuration, or if you are changing the name of the configuration file, OAS will ask you if you want to change the default configuration file.

If you select Yes then OAS will make this configuration file the default and if the OAS service is restarted then this file will be loaded on start-up.

If you select No then OAS will still save your configuration file, but it will not be the default file that is loaded on start-up.