How to export your existing

SQL data over OPC UA
SQL and OPC, 2 different environments that nowadays share something in common, DATA. OPC UA became the successor for Classic OPC, in which the entire communication model is oriented to web services, by providing security and a free OS choice to work with. OPC UA born under 2006, due to the need of interoperability between industrial environment and multiple and one step higher applications. It has been build not only to provide data to SCADAs, it’s just more than that, with OPC UA Technology you can either send your PLCs or sensors data up the enterprise network, web environments and pretty much abstract to the Cloud.
Download our REST API Server module

What should I know about SQL?

SQL It’s a standard databases language that born based on multiple relational databases management systems, each of them provides a different way to treat their data, but withing the years was looking for integrate all of it in just one simple environment called SQL.
If you want to know, how ease is to take data already logged on SQL server and then use it to share it within industrial or IT systems over OPC UA , this solution is right for you!

How can we integrate both systems between each other?

vNode Automation it’s a IoT Gateway that moves information from different applications or devices.
One of its features is to read SQL databases and at the same time it will act as OPC UA Server, exporting the data to any UA Client, such SCADAs, ERPS, Historian, AWS, Azure IoT, web servers and many others…

Get vNode Free Trial Bundle now and get it going in minutes.

The bundle contains:

  • vNode Quick Guide.
  • Installer files. (Windows (x86 – x64) / Linux (x86) / Linux Debian 9 (x64) / Linux Debian 6, 7, 8 (x64) / Linux CentOS 7 (x64) / Linux ARM)

Default vNode WebUI users:

Full accessRead only access
Useradminuser
Passwordvnodevnode
Provide us with some info to receive our free software installer:

vNode SQL Client: how to pull data from SQL

vNode OPC UA Server: publish your industrial data in OPC UA format

Other vNode features:

Store&Forward

Default Store&Forward connection between Nodes allows the creation of complex architectures including slow or unstable connections such as Radio, GPRS, 2G, 3G or V-SAT. No data will ever be lost.

Crossed platform

vNode is out off- the- shelf, ready to be installed on any Windows version (32 and 64 bits), Linux (Intel, AMD and ARM processors). 

Unlimited tags

Make your system grow along with your needs, create and use as many tags as you need, without no limitation.

Remote web configuration

vNode are configured through an embedded web user interface. The Administrator will be able to configure all the remote vNodes just using a web browser.