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.
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:
- How to navigate the OPC Router user interface
- How to configure a connection to any OPC UA or DA data source.
- How to configure a connection to a SQL database.
- Mapping OPC data parameters into corresponding columns of a database using OPC Router's Visual Workflow capability.
- 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.