Software Toolbox Technical Blog

It's important for any enterprise to have actionable data in the timeliest fashion for making decisions. Minimizing downtime and increasing performance are important to the profitability of any company and knowledge at the point of action is key.

To that end, automating notifications or reports based on the latest process data from your various systems can ensure you're never in the dark when it comes to your processes.

In this post, I will cover step-by-step how to easily automate email notifications and reports for OPC and data sources with the OPC Router for giving you and other decision makers the knowledge you need to make informed decision as quickly as possible.

OPC Router provides connectivity to a wide range of data sources including ERP systems such as SAP, a variety of relational and other databases, conversion of file data including CSV, XML, JSON and others, IIoT systems including REST and SOAP web services and MQTT brokers and more. It's often necessary for OPC UA client applications (such as HMIs, SCADAs and other software clients) to need access to such data sources. OPC Router also supports acting as an OPC UA server.

In this blog post, we will cover the basic steps to map such non-OPC UA data sources supported by OPC Router to OPC UA nodes/items for access by external OPC UA clients.

A common use case that we encounter with many AVEVA™ users is the need to share data from System Platform with some other client or system (HMI, SCADA, other). It's not uncommon for a company to be acquired by another company and its assets and a non-AVEVA HMI/SCADA came as part of the assets.  Or perhaps a system is being add with limited interfaces for external connectivity.  Your options for sharing data largely depend on what software interfaces these "other systems" support.

In this blog post, I'll discuss how to share your AVEVA System Platform 2020 (or newer) data via OPC UA (without using OI Gateway) using the OPC Router for situations where you have another non-OPC UA capable client application that needs access to process data in your AVEVA system such as an ERP system, IIoT platform, web service and more.

OPC Router already includes a wide range of features that you may already be taking advantage of. You're likely also aware that OPC Router is regularly updated to add additional useful features and tools, and to resolve any known issues, as part of its continuous improvement process.

In this post, I will cover new features and enhancements available in OPC Router V4.27 including:

• New plug-in for OPC UA Pub/Sub (Publish/Subscribe) for expanded OPC UA functionality with a new efficient method for transferring data
• Support for the  OPC UA Cloud Library providing the ability to create and use centralized specifications based on OPC UA Companion Specifications
• Easier Docker container support with an included, ready-configured Docker sample script

The Google Cloud Platform (GCP) is Google’s cloud solution that brings all of Google’s cloud computing services together. Google’s own services, such as Google Search and YouTube, run on the GCP, but end users can also use their cloud services.

Google Cloud Platform, for the Internet of Things (IoT) area, offers their “Cloud IoT Core” services, which provide the functionalities to connect large quantities of devices via an integrated MQTT broker. In this blog post, we will show the necessary steps for connecting this Cloud IoT Core to the different data interfaces supported by OPC Router.

For various reasons, many organizations still have one or more disconnects between the PLCs and other control devices closest to the ultimate process and the upstream systems responsible for coordinating efforts across the enterprise. In an ideal world, all data exchange between all systems in an enterprise would be automated for the greatest efficiency.

In this post (based on the article "Removing five critical media gaps" by our partner company, inray Industriesoftware GmbH), we will discuss five of the most common gaps where an organization's ERP system may still be disconnected from underlying processes and data sources. And we'll discuss how OPC Router provides the ability to eliminate those unnecessary gaps.

In a recent blog post about MongoDB, we discussed how non-relational database differ from relational databases like SQL and MySQL. The fact of the matter is, relational databases are widely used and still just as popular in the industrial automation space as ever. A popular alternative to SQL and MySQL is MariaDB which is an open source relational database.

This blog post (based on the article "What is MariaDB? A comparison with MySQL" by our partner company, inray Industriesoftware GmbH) discusses what MariaDB is, comparing it to MySQL so you can determine if MariaDB is a better database option for your company.

If you're already taking advantage of the wide range of features in OPC Router, you're likely aware that OPC Router is regularly updated to add additional useful features and tools, and to resolve any known issues as part of its continuous improvement process.

In this post, I will cover new features and enhancements available in OPC Router V4.26 including

• Expanded Edge device flexibility with support for Docker container instances
• Remote configuration for management of one or more instances (including Docker instances)
• Support for Influx DB2 and InfluxDB Cloud
• Enhanced support for referencing and management of external libraries