Software Toolbox Technical Blog

Using OPC Router to Log OPC Data to JSON Files Without Code

9 min read

By Jessica Dillon on Nov 2, 2023 2:00:00 PM

In today's business landscape, the exchange and storage of data plays a pivotal role in ensuring efficient and robust operations. Whether operating in sectors like Pharmaceuticals, Manufacturing, Power, or related industries, the exchange of data between services and applications has become standard practice, often an imperative. Consequently, many organizations leverage resources such as databases and historians to archive their invaluable data. However, there are instances where the need for simpler storage methods or direct interchange of data via Webservices is required to maximize application interoperability. Unfortunately, this solution area is often one filled with custom software applications. In this blog, we'll show you how to eliminate custom code and build sustainable solutions.

Continue Reading

Video Blog: OT Data Integration to/from InfluxDB

2 min read

By Dawid Sadie on Sep 7, 2023 2:00:00 PM

Round-trip InfluxDB Integration using OPC Router

Software Toolbox offers a variety of tools for integrating with InfluxDB.  Today we focus on OPC Router, a solution that enables visual workflow integration of traditional OT data sources with time-series databases such as InfluxDB.  The InfluxDB connector provides for reading and writing to InfluxDB (local or cloud-based). OPC Router's workflow engine provides visual data mapping, for ultimately extracting analytics and results from InfluxdB and making them available to the plant floor in OPC UA (or other) format.

Continue Reading

OPC Router Configuration Management Overview, Methods & Tips

7 min read

By Nicole Knox on Jul 20, 2023 2:00:00 PM

When working with OPC Router, especially as you build larger and more powerful projects to integrate OPC, web services, databases, ERP, SAP, and other systems in your Industry 4.0 initiatives, it’s good to have an idea of the underlying operations of the application. That knowledge can empower you to get the best results from the software’s many connectors and visual workflow engine.  If you’ve never heard of or are new to OPC Router, we invite you to explore the OPC Router website and view the OPC Router Getting Started Virtual Training Video

Topics: OPC Router
Continue Reading

OPC Router Power Tips - Using OAuth 2.0 with REST APIs

2 min read

By Rodrigo Restrepo on Jul 13, 2023 2:00:00 PM

In the ever-changing landscape of industrial control, the ability to establish connections and facilitate efficient data exchange between different technologies is crucial. With digital transformation, the industry requires robust integration solutions more than ever before. This is where the powerful combination of OPC Router, it's ability to both call and host REST APIs using industrial data, and OAuth 2.0 comes into play, enabling organizations to achieve secure and streamlined communication across their automation and other systems.

Continue Reading

Leveraging Visual Studio for Efficient OPC Router Scripting

3 min read

By Rodrigo Restrepo on Jun 1, 2023 2:00:00 PM

OPC Router is a standards based tool for data integration from the shop floor through all levels even up to ERP systems, with a visual workflow engine, scalable configuration templates, and integration to many OT and IT systems. Leveraging OPC UA, REST, SOAP, MQTT and more, it can be an essential enabling tool for your Industry 4.0 applications. Solutions can be extended using C# scripting, and this blog shows a live built example of how to efficiently use Visual Studio to build those scripts. 

Topics: OPC Router REST
Continue Reading

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

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