Software Toolbox Technical Blog

Video Tutorial - Logging Dynamic JSON Data to SQL or MES

3 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

Tech Support Corner: Client/Server Roles & Read Types with TOP Server

7 min read

By Nicole Knox on Feb 23, 2023 2:00:00 PM


A common misconception about TOP Server as an OPC server is that TOP Server will poll your device/devices automatically with no OPC client connected. So, when you are getting started with TOP Server, it is good to have an accurate understanding of how interactions occur between each node of a basic OPC architecture— client-server and server-device— to ensure that the configuration meets your needs and can be scalable to more demanding projects.

Continuing our Tech Support Corner blog series, in this blog post, we will discuss some basics of the interactions between an OPC client and server, including different types of reads and the expected behavior that you'll see as a result of those interactions.

Continue Reading

Tech Support Corner: Using TOP Server with OPC UA Discovery Servers

7 min read

By Zachary Parham on Feb 16, 2023 2:00:00 PM


If you're a TOP Server user with OPC UA client connections to TOP Server, you may have noticed a section in the OPC UA Configuration Manager titled "Discovery Servers". Possibly you're using an OPC UA Local Discovery Server (LDS) but many of our users aren't sure what an LDS is, how to use one with TOP Server or why they should.

Continuing our Tech Support Corner blog series, in this blog post, I will step through how to make TOP Server discoverable via a Local Discovery Server or a Global Discovery Server using the OPC UA Configuration Manager, as well as what this does behind the scenes so that you can make other OPC UA servers discoverable even if they don’t have a similar built-in configuration tool.

Continue Reading

Let's Take a REST...API and Integrate a Wide Variety of Data

5 min read

By Kevin Rutherford on Feb 9, 2023 2:00:00 PM

So, no, we're not actually taking a rest - we're looking at what REST the acronym means from a practical perspective. But perhaps after reading this, if you're looking to connect to a RESTful API, you can give your mind a rest knowing you have a path forward.

I know the first time I ever heard the term, I had no idea what it meant or how to approach it. Maybe you've been told a certain data source has a REST API for accessing it, but you're not sure where to get started leveraging that API with your control system.

This post will provide a practical explanation of what REST is, how it can be useful to you and how you can take advantage of data provided by RESTful APIs or web services in your operations.

Continue Reading

Video Tutorial: AVEVA InTouch to DataHub via OPC UA Expands Options

2 min read

By Kevin Rutherford on Jan 12, 2023 2:00:00 PM


Users of AVEVA software are already familiar with the native connectivity options they have for interfacing with different systems and devices. AVEVA users often turn to Cogent DataHub® for integration of a wide variety of industrial and other data sources such as MQTT clients/brokers, SparkplugB systems, databases, historians and much more.

AVEVA InTouch users have traditionally connected to DataHub via its OPC DA Classic interface (via AVEVA OI Gateway). AVEVA's OI Gateway also provides those users the additional option of connecting to OPC UA data sources, for easier and more secure remote connections to such data sources.

In this video blog post, we will cover the basic steps to connect AVEVA InTouch to DataHub via OPC UA, expanding the variety of connectivity options available to AVEVA users.

Continue Reading

Video Tutorial: AVEVA InTouch to OmniServer via OPC UA Expands Options

2 min read

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


Most AVEVA users are already familiar with the native connectivity options they have for interfacing with different systems. AVEVA users have turned to OmniServer for many years to integrate non-PLC devices such as barcode scanners, weigh scales, vibration monitors, RFID readers and more, all without custom code.

Those users of AVEVA InTouch have traditionally connected to OmniServer directly via its native SuiteLink interface. AVEVA's OI Gateway provides those users the additional option of connecting to OPC UA data sources, for easier and more secure remote connections to such data sources.

In this video blog post, we will cover the basic steps to connect AVEVA InTouch to OmniServer via OPC UA, expanding non-PLC device connectivity options for AVEVA users.

Continue Reading

Video Tutorial: AVEVA InTouch to TOP Server via OPC UA Expands Options

2 min read

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


Most AVEVA users are already familiar with the native connectivity options they have for interfacing with different systems. Many AVEVA users have also turned to TOP Server over the years, both for standardizing device connectivity in a single server and for drivers/protocols not available as native AVEVA options as a complementary solution.

Those users of AVEVA System Platform have traditionally connected to TOP Server directly via either its native SuiteLink interface. AVEVA's OI Gateway provides those users the additional option of connecting to OPC UA data sources, for easier and more secure remote connections to such data sources.

In this video blog post, we will cover the basic steps to connect AVEVA InTouch to TOP Server via OPC UA, expanding device connectivity options for AVEVA users.

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

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