OPC Router Basic Training - Writing SQL Data to OPC Servers

3 min read

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.Watch this video to see how easy it is to write data from your SQL databases to OPC UA and DA servers using OPC Router.


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

  1. How to configure a conditional Database Trigger
  2. How to read values from a SQL table on trigger
  3. How to define a global variable for storing SQL data values
  4. How to use OPC Router's built-in scripting engine to calculate a time difference on monitored variables from SQL
  5. How to write a calculated value from a script to an OPC UA or DA server

While this how-to video specifically demonstrates reading from SQL and writing to OPC UA or DA servers, the OPC Router supports many other interfaces and can take any data accessible by the OPC Router and integrate it with other systems.

If you missed Part 1, which covered making the connections to SQL and the OPC server in this training example, you can get caught up here

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.

Lastly check out our upcoming OPC to REST to OPC Virtual Training

Click Now to Subscribe

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