Software Toolbox Technical Blog

2 min read

OPC Router Basic Training - Writing SQL Data to OPC Servers

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

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