Software Toolbox Technical Blog

Video Tutorial - Logging Dynamic JSON Data to SQL or MES

2 min read

By Rodrigo Restrepo on May 4, 2023 2:00:00 PM

JSON (JavaScript Object Notation) is a file format that has become fairly common in the industrial automation industry for storing data or information (including such things as configuration files). But also as one of the most common data formats used by RESTful APIs and web services, which are commonly used for providing a range of useful information including energy prices and weather data.

Sometimes, of course, depending on the application, some or all components of JSON packet might be variable or dynamic in nature, which can make it difficult for off-the-shelf industrial software solutions to properly parse the information from those packets.

In this post, I will cover step-by-step how to leverage the scripting capabilities of the OPC Router to access and parse JSON packets either from a JSON file saved to a specific file directory or from a RESTful web service after which that data can be used with any of the other connectors that OPC Router supports. For this example, we log the data to a SQL database.

Continue Reading

Using OPC Router for Real-Time Process Updates to Microsoft Teams Chat

13 min read

By Kevin Rutherford on Dec 1, 2022 2:00:00 PM

It's pretty common these days for companies to use Microsoft Teams™ for internal communications within and between departments and maybe even between IT and OT segments in an organization. This has become more and more important with increasing remote office scenarios, enabling vital collaboration between key members of an organization.

But what if you could also have real-time updates from your process and other systems in the same fashion? Rather than a colleague messaging you about an urgent matter, what if your actual processes and even business systems could message you via Teams with actionable information (possibly a line is down, or a tank level is approaching maximum level)?

In this blog post, we'll cover the steps necessary to use OPC Router to integrate your variety of systems with Teams so that you can have real-time updates and make important decisions about your business more quickly.

Continue Reading

OPC Router Adds MQTT SparkplugB, More Cloud Options, Flexibility

6 min read

By Kevin Rutherford on Nov 10, 2022 2:00:00 PM

OPC Router includes a wide range of features that you may already be taking advantage of. The product 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.28 including:

  • New MQTT Sparkplug A & B Plug-in 
  • MQTT V5 support
  • Support for Oracle Cloud Databases & Wago IoT Cloud 
  • Expanded Database and Variable Triggers
Continue Reading

AVEVA System Platform to OPC Router Connectivity Options via OPC UA

23 min read

By Kevin Rutherford on Nov 3, 2022 2:00:00 PM

AVEVA users have a range of native connectivity options for interfacing with different systems. OPC Router also supports connectivity to variety of different systems that users sometimes need to access from AVEVA System Platform. Users of AVEVA System Platform can leverage OI Gateway to easily and securely connect to OPC Router via OPC UA for connections to many other data sources.

In this blog post, we will cover the basic steps to connect AVEVA System Platform to OPC Router via OPC UA, enabling additional connectivity options for AVEVA users to systems such as SAP (and other ERPs), 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.

Continue Reading

Did You Know Google IoT Core is Shutting Down? Start Preparing Now!

4 min read

By Zachary Parham on Oct 27, 2022 2:00:00 PM

If you have been following our blog for a while or have been exploring IoT platforms available in the market, you may know that the Google Cloud Platform combined with the Google IoT Core is a frequently used combination in the industry. Google has recently announced that it will be shutting down the Google IoT Core. In doing so, Google is forcing many of its Cloud Platform users to switch platforms.

In this blog post, we will review detailed information about the alternatives to the Google Cloud Platform that are available for use with all of the IoT capable products we provide, and how the change works.

Continue Reading

Video Tutorial - Email Reports / Alerts from OPC & Other Data Sources

2 min read

By John Gonzalez on Sep 29, 2022 2:00:00 PM

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.

Continue Reading

Converting Non-OPC UA System Data for OPC UA Clients with OPC Router

9 min read

By Kevin Rutherford on Sep 15, 2022 2:00:00 PM

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.

Continue Reading

Accessing AVEVA System Platform with OPC Router via OPC UA

13 min read

By Kevin Rutherford on Jun 23, 2022 2:00:00 PM

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.

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