MS SQL Server Email notification

Email notification via SMTP

Email remains one of the simplest and most common notification and alerting methods. The Email notification Plug-in works with the simple SMTP protocol and thus has easy access to almost any mail system. With the Email notification Plug-in you can create your own email templates for various alerting functions and fill them at precisely definable times with data from connected systems such as OPC UASAPSQL databasesRESTMQTT and many more.
The graphical designer allows you to project your own email alerting according to application-specific requirements (see example).

Run a free test now

Example of email notification with OPC and SQL data:

In this example, data is loaded from OPC UA with the OPC UA Client Plug-in and from a Microsoft SQL database with the Microsoft SQL Plug-in. They are supplemented by variables, constants and a file as an attachment. The file for the attachment is loaded with the script function from the OPC Router Basic Plug-in. All data is finally written into the email template and the email for the alert is created. In this example, the email is sent when an OPC trigger is triggered, which checks the data point of a PLC for an alarm condition.

That’s how easy it is.

Connecting Systems

What’s Transfer, Trigger and Browsing?

Transfer Objects

The transfer object of the Email notification plug-in offers individual email template configurations. When a transfer is prompted the current data is transferred and sent via SMTP.

Text and variables

The text of the email notification can be provided with any placed variables. The variables are described with values during the transfer from outside.

consignees, consignor, subject

The fields consignees, consignor and subject are available as standard data fields for each email and can be freely described with data. Dynamic emails are sent for each application case.

Trigger

The Email notification plug-in does not have trigger functions of its own but uses the standard trigger function the OPC Router offers.

Browsing

The Email notification plug-in reads out all variables contained in the email template.

Variables

The variables are automatically configured as data fields inside the transfer object and can be written to with any given value of various data types. During the writing process an automatic conversion occurs: The data is converted into a “string” (i.e. sequence of characters).

OPC Router Application Box E-mail Plug-in

Notification of exceptional situations

In its connections, OPC Router transfers data between systems, which often have a controlling influence on the process in Industry 4.0 applications. By accessing this data and triggering the connections to certain events, it is also possible to handle exceptional situations. The triggers of a connection can explicitly evaluate signals from the PLC (OPC UA) or specific database queries (SQL Server) and, in exceptional cases, send an e-mail alert to responsible parties via the e-mail plug-in, who can then react to the exceptional situation.

Email notification via SMTP
MS SQL Server

Involving people in Industry 4.0

The e-mail plug-in of the OPC Router enables information from the automated flow of an Industry 4.0 process to be sent as e-mail. The information from the process can be collected by the OPC router from various sources and packed into an e-mail including attachment that can be easily evaluated by humans. If humans are necessary in a process, such an e-mail can be used to inform them precisely with the request and all relevant data in your normal working environment (e-mail client) and to request them to take action. In this way, the Industry 4.0 process and the human being work together optimally.

Here you will find further information
about OPC Router and Plug-ins.

Plug-ins
Run a free test now