Integrating RESTful Web Services with OPC and SQL

3 min read

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.Watch this video to see how to consume data from a RESTful web service and then deliver it to OPC UA and DA servers and SQL databases using OPC Router.


In this video, using OPC Router's Visual Workflow capability, we've shown you:

  1. How to configure a connection to any RESTful web service (the example shown is accessing the OpenWeather API).
  2. How to configure requests for data from the RESTful web service.
  3. How to configure OPC Router to log data from the web service to SQL.
  4. How to configure OPC Router to push data from the web service to OPC servers (the example shown is pushing data to a TOP Server driver that then writes the data to some PLCs).

While this how-to video specifically demonstrates pushing web service data to SQL and OPC servers, the OPC Router supports many other interfaces and can take any data accessible by the OPC Router and integrate it with other systems.

Don't forget to subscribe to our blog to find out about the latest updates regarding OPC Router and for other how-to videos on using OPC Router.  Try OPC Router with your own connectivity and integration projects using the fully-functional free trial.

Click to Download OPC Router Free Trial

Marc Holbach
Written by Marc Holbach

Software Toolbox Technical 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