Software Toolbox Technical Blog
Software Toolbox: Full Stack Industrial AI Starts with the Right Foundation
1 min read
By Jay David on Feb 18, 2026 9:45:55 AM
Visualizing Real-Time Process Data in Power BI Using OPC Router’s REST Plug-in
7 min read
By Kyle Persyn on Aug 27, 2025 2:36:30 PM
Are you looking for a simple way to bring live process data into Power BI for dashboards and visualization? OPC Router’s REST plug-in provides a flexible and secure way to push data from your industrial systems to Power BI using its Streaming Dataset API.
In this blog, we’ll walk you through the steps of setting up a live connection between OPC Router and Power BI using the REST interface, so you can transform your raw data into real-time insights for your team.
While this blog is geared towards existing Router users, Even if you’re new to OPC Router, this walk through can show you what’s possible when combining live industrial data with Power BI. If you’d like to explore OPC Router further, check out our getting started videos—they’ll give you the foundation you need to begin building your own real-time dashboards.
Earth Day to Every Day: Driving Sustainability with JSON RESTful Data
6 min read
By Sarah Eckhoff on Apr 24, 2025 2:00:00 PM
Happy belated Earth Day! We hope you took the time on Tuesday to enjoy the great outdoors or made a plan to get outside this weekend. Perhaps you did neither and instead decided to put your reusable water bottle to use instead of grabbing another plastic bottle of water to drink from for the day. Whatever you did, we hope it made you happy because that’s part of what celebrating Earth Day is all about.
In this final post of our 2025 Environmental Sustainability blog series, we’re diving into how industries can make smarter, greener decisions using actionable RESTful web services. I know that may sound like a stretch to connect these things, but keep reading: I’m going to discuss the technology, the data sources that you can consume to impact your sustainability results, and how you can bring them together without writing any code.
Don't Sleep on Web Services: How RESTful APIs Improve Integration
5 min read
By Nicole Knox on Mar 13, 2025 2:00:00 PM
Each year, National Napping Day recognizes our need for rest the day following the return of daylight saving time, when many of us shift our clocks forward one hour. If you are one of the many who "sprang forward" this past Sunday, we hope you have been able to catch up on your rest over the past several days. Today, however, we’re going to talk about a different kind of "REST" and how it can help you spring forward in your OT/IT integration goals and Industry 4.0 initiatives.
From Canary to AVEVA CONNECT, many technologies include a RESTful interface that can be leveraged when other avenues are unavailable. In this blog, you’ll learn how you can take advantage of RESTful APIs to easily integrate systems that do not have a native way to interact with each other, resulting in a standardized, scalable, and secure way to exchange data between enterprise IT systems and industrial OT environments.
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.
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.
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.
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.
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.
Subscribe to our Blog
Recent Posts
Posts by Topic
- Device Connectivity (205)
- Wonderware (178)
- OPC UA (121)
- Cogent DataHub (111)
- TOP Server (108)
- OPC (103)
- Technical Support (99)
- OmniServer (73)
- Video Tutorials (69)
- OPC Router (52)
- OPC DA (42)
- Protocols (40)
- AVEVA (37)
- Automation 101 (28)
- Security (26)
- MQTT & IoT (24)
- OmniServer Did You Know (24)
- Data Tunneling (23)
- Connectivity (22)
- OPC Data Client (22)
- Development Tools (19)
- IT/OT (19)
- DCOM (17)
- LGH (14)
- OPC Tunnel (13)
- Alarms & Notifications (12)
- Database (12)
- Earth Day (12)
- Summer of IoT (12)
- Exploring OPC UA (11)
- OPC Gateway (11)
- REST & Web Services (11)
- Case Studies (10)
- Dream Report (10)
- EFM (10)
- Oil & Gas (10)
- Reporting (10)
- CSV (9)
- Database & Historian (9)
- OPC Integration (9)
- Flow (8)
- OPC Server (8)
- Redundancy (8)
- Sustainability (8)
- AVEVA OPC UA Client (7)
- Modbus (7)
- OPC Router Basic Training (7)
- SuiteLink (7)
- DataHub Training (6)
- ODBC (6)
- OPC Alarms and Events (6)
- OPC Conversion (6)
- OPC Data Logger (6)
- ProtocolDesign (6)
- xml (6)
- Data Bridging (5)
- Data Logging (5)
- Data Storage Deep Dive (5)
- Business Intelligence (4)
- Data Integration (4)
- InTouch (4)
- Industrial Decisions (4)
- Industry 4.0 (4)
- OPC Bridge (4)
- OPC Redundancy (4)
- OPC Toolkit Benefits (4)
- OmniServer User Stories (4)
- SLIK-DA (4)
- SQL (4)
- Collaboration (3)
- Error Detection (3)
- IT & Infrastructure (3)
- OPC Server Remote Config (3)
- Wedges (3)
- Windows (3)
- ControlLogix (2)
- Excel (2)
- Ignition (2)
- KEPServerEX (2)
- Kepware Edge (2)
- OPC Wizard (2)
- OSIsoft (2)
- Omron (2)
- PGAS (2)
- Predictive Maintenance (2)
- Process Alert (2)
- Scripting (2)
- Store and Forward (2)
- System Integrators (2)
- Building Automation (1)
- ERP (1)
- Industrial AI (1)
- LGH User Stories (1)
- LRC (1)
- Linux (1)
- Machine Learning (1)
- Mining/Metals (1)
- New Release (1)
- Omni Flow (1)
- Power & Utilities (1)
- Predictive Analytics (1)
- Process Alerts (1)
- QNX (1)
- Sparkplug B (1)
- Water & Wastewater (1)
