Software Toolbox Technical Blog

6 min read

Accessing Industrial Data from OPC & SQL Sources with HTTP Clients

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
2 min read

Connect RESTful Web Services to Databases, OPC UA / DA & More Systems

By Kevin Rutherford on Jun 4, 2020 2:00:00 PM

Accessing various industrial data via RESTful web services has become increasingly necessary over the past decade.  From 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 web services.

In this video, we will cover step-by-step how to easily connect to RESTful web services and perform reads and writes, as well as, logging data to and reading data from a database or connecting that data to other systems such as OPC UA - all with the OPC Router.

Continue Reading
5 min read

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

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

Join Our Journey

Working in industrial automation since 1996, the Software Toolbox team has seen a lot. The level of automation system sophistication of our integrators and users has evolved, each driven by the demands of their market and clients.  Everyone's learning continues as technological change accelerates.

This blog is about sharing from these journeys.  From tips on implementing software, successes our clients have experienced, or new ideas and things to consider in your journey, we'll be sharing them here.

Subscribe to our Blog

Recent Posts

Posts by Topic

See all