Software Toolbox Technical Blog

OPC Router Adds OPC UA Pub/Sub, UA Cloud Library & Docker Sample

5 min read

By Kevin Rutherford on May 12, 2022 2:00:00 PM


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
Continue Reading

How MariaDB Compares to MySQL

6 min read

By Kevin Rutherford on Nov 11, 2021 2:00:00 PM


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.

Continue Reading

OPC Router Adds Docker Support, Remote Config, InFluxDB 2 & More

5 min read

By Kevin Rutherford on Oct 27, 2021 2:00:00 PM


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 
Continue Reading

MongoDB and How a NoSQL Database is Different

7 min read

By Kevin Rutherford on Sep 30, 2021 2:00:00 PM


I think it's safe to say that when we're discussing databases in the context of industrial process control, SQL Server is where most of our brains tend to jump. The proliferation of SQL (and other traditional relational databases) across most, if not all, industries for process control applications cannot be denied. But SQL (and others) do certainly have some limitations.

This blog post (based on an article by partner company, inray Industriesoftware GmbH) discusses how MongoDB, a non-relational database (i.e. NoSQL database) are fundamentally different from the SQL Servers of the world and how MongoDB can be a good alternative to relational databases for some applications.

Continue Reading

Integrating RESTful Web Services with OPC and SQL

2 min read

By Marc Holbach on Sep 17, 2020 2:00:00 PM

Access to various industrial data via RESTful web services is increasingly becoming necessary in this era of inter-connectivity and big data. From sources such as devices with self-hosted web services to relevant market data such as weather information and pricing for commodities and energy, there is a host of relevant data to be integrated from such RESTful web services.

In this video training blog post, we will cover step-by-step how to easily connect to and consume data from RESTful web services and then push that data to OPC and SQL systems with the OPC Router.

Continue Reading

OPC Router Basic Training - Writing SQL Data to OPC Servers

2 min read

By Marc Holbach on Jul 23, 2020 1:45:00 PM

As we discussed in Part 1 of our OPC Router Basic Training series, it is quite common for process industry projects to require logging of industrial process data to a database such as Microsoft SQL.  On the other side of the coin, it is also quite common for information such as recipes or other data to be stored in a database such as SQL and to then need to push that data down to process devices.

In Part 2 of the series, we will cover step-by-step how to write stored SQL data to OPC UA and DA servers based on flexible scripted trigger conditions with the OPC Router.

Continue Reading

OPC Router Basic Training - Connecting SQL to OPC Data Sources

2 min read

By Marc Holbach on Jul 9, 2020 2:00:00 PM

Logging industrial process data to a database such as Microsoft SQL is a common requirement of many projects across industries.  One of the key applications for storing industrial process data is providing historical context and reporting of the process so that better decisions can be made.

In Part 1 of our OPC Router Basic Training series, we will cover step-by-step how to easily connect to OPC UA and DA data sources to SQL databases for logging process data with the OPC Router.

Continue Reading

Accessing Industrial Data from OPC & SQL Sources with HTTP Clients

6 min read

By Marc Holbach on Jun 18, 2020 2:00:00 PM

Having ready access to the wide array of industrial data available in an enterprise is increasingly important these days, for a variety of reasons.  With ever-expanding applications for using "big data" towards efficiency initiatives such as digital twins, predictive analytics and predictive maintenance, having the ability to bring all of your industrial data together is essential.

In order to analyze that data, however, the upstream systems performing that analysis need access to the actual data - data that is typically widely dispersed geographically and even departmentally within locations.  One interface that is relatively common for such systems is the ability to act as an HTTP (or REST) client.

This blog post will provide an overview of an easy and secure way to share industrial process data available common OPC UA, OPC DA and SQL database sources with big data and other systems that can act as an HTTP / REST Client using the OPC Router. You'll also have a chance to download our free guide with step-by-step instructions.

Continue Reading

About this Blog

We're engineers like you, so this blog focuses on "How to" appnotes, videos, tech team tips, product update announcements, user case studies, and other technical updates.  Subscribe to updates below. Your feedback and questions on posts are always welcomed - just use the area at the bottom of any post.

Subscribe to our Blog

Recent Posts

Posts by Topic

See all