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

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

Video Tutorial: Conditional Logging to Database from Non-Standard Devices

2 min read

By Kevin Rutherford on May 31, 2018 2:00:00 PM


OmniServer Wedges are included with OmniServer Professional Edition.  Wedges are built-in components providing additional useful capabilities that expand the functionality of OmniServer beyond its core connectivity and data parsing abilities for non-standard devices.

The OmniServer Database Wedge allows you to log your device data to any ODBC-compliant database, including SQL, with a highly configurable format and flexible conditions.  And this ability is built into OmniServer, eliminating the need for separate external components or applications.

In this video blog, I'll show you how to get started using the OmniServer Database Wedge to easily log process data based on specified conditions, making it possible to monitor trends in your process and easily report on your process data or troubleshoot any issues that are discovered.

Continue Reading

Yes, You Can Integrate Business & Other Databases with Control Systems

5 min read

By Win Worrall on Nov 16, 2017 2:00:00 PM


It is common for companies to use databases for long-term storage of their critical information.  In our experience, we also see machine setup information, short term operational data and much more besides traditional historical data put into shop floor databases in the operations technology or “OT” world.

Over on the business side or the “IT” world, everything somehow ends up in a database: Production plans, forecasts, orders, it’s all there.  Increasing business demands and IT/OT convergence are driving more real-time integration between these databases and control systems.

This blog discusses some of the key reasons users like yourself need this information and then shows how the DataHub can help move this data from a database to your control systems via OPC DA, OPC UA, Modbus and other interfaces or protocols that are common in the automation layer.

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.

Subscribe to our Blog

Recent Posts

Posts by Topic

See all