Software Toolbox Technical Blog

2 min read

OPC Router Basic Training - Connecting SQL to OPC Data Sources

Jul 9, 2020 2:00:00 PM

Logging industrial process data to a database such as Microsoft SQL is a common requirement of many projects across industries.  One of the key applications for storing industrial process data is providing historical context and reporting of the process so that better decisions can be made.

In Part 1 of our OPC Router Basic Training series, we will cover step-by-step how to easily connect to OPC UA and DA data sources to SQL databases for logging process data with the OPC Router.

Watch this video to see how easy it is to get connected to OPC UA and DA server data sources and SQL databases using OPC Router, including logging that OPC data to SQL based on conditional triggers.

In this video, we've shown you:

  1. How to navigate the OPC Router user interface
  2. How to configure a connection to any OPC UA or DA data source.
  3. How to configure a connection to a SQL database.
  4. Mapping OPC data parameters into corresponding columns of a database using OPC Router's Visual Workflow capability.
  5. Using flexible triggers to initiate logging of the OPC data to SQL.

While this how-to video specifically demonstrates logging OPC data to databases, 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 on your own connectivity and integration projects with the fully-functional free trial.

Download OPC Router Free Trial

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