Software Toolbox Technical Blog

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

How to Develop Custom OPC Clients with Minimal Code

3 min read

By Ganesh Kalipershad on Aug 13, 2020 2:00:00 PM

As we discussed in the first post of this series, the term "OPC client" often refers to off-the-shelf HMI or SCADA applications.  OPC clients can also be other custom developed software applications in your enterprise that could benefit from access to OPC process data.  Or there might be a new custom application you need to develop that requires access to OPC process data.  In those situations, you need a reliable, straightforward method to enable those applications as OPC clients.

In Part 2 of our series on How to Develop Custom OPC Clients, we will cover step-by-step how to use low-code techniques to read, write and subscribe to OPC process data through building a basic OPC client application in Visual Studio.NET.

Continue Reading

How to Develop Custom OPC Clients with No Code

2 min read

By Ganesh Kalipershad on Jul 30, 2020 2:00:00 PM

When you hear the term "OPC client", you may initially think of off-the-shelf HMI or SCADA applications.  However, it's common in enterprises across most industries for there to be other custom developed software applications that could benefit from access to OPC process data.  Or perhaps there is a new custom application you're working on that needs to access OPC process data.  The question, then, is how to enable those applications as OPC clients.

In Part 1 of our series on How to Develop Custom OPC Clients, we will cover step-by-step how to use no-code techniques to bind production data to various types of user interface elements for reading, or writing, or both to build a basic OPC client application in Visual Studio.NET.

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

Connect Your Barcode Scanners to Barcode Printers

2 min read

By Kevin Rutherford on May 28, 2020 2:00:00 PM

Barcode scanners and printers are devices that are very common in a variety of industries, whether it's for use in a manufacturing process or a multitude of other possible uses.  But how do you go from scanning a barcode to printing that barcode?

In this video, we will cover how to connect to both a Datalogic barcode scanner and a Zebra barcode printer, as well as, transferring the scanned barcode data to the printer automatically.

Continue Reading

Connect Your HMI/SCADA to Barcode Scanners

5 min read

By Kevin Rutherford on Jan 28, 2016 1:59:16 PM

Barcode scanners are one of those types of devices that are extremely common in a variety of industries, whether it's for use in a manufacturing process or for cataloging inventory or a multitude of other possible uses.  But how do you go from scanning a barcode to making that barcode data available to your monitoring applications such as an HMI or a SCADA?

Over the years of working in the automation software realm, I've seen dozens of clients have this seemingly basic need to bring barcodes up into various software packages.  Regardless of the make/model of the scanner, the process is almost identical.  For example, you could connect to a DataLogic scanner in under five minutes. (Click for How-To Video)

This post will cover the steps for bridging that gap between your scanners and your client applications.

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