vNode SQL Client Module
SQL Client Module
Relational databases establish an orderly and clear storage of any information structure. They use tables to filter the data according to a criteria and are organized in views and indexes. In this way, tables can be combined with each other to obtain an accurate result of the information.
Relational databases are used in all kinds of environments for multiple purposes, such as inventory tracking, e-commerce, web pages, as well as being used in industrial automation, for predictions, efficiency calculations, decision making based on historical data, among others…
Unlike the Classic OPC technology which is linked to COM / DCOM Windows (Microsoft), OPC UA can become indifferent to the operating system or the environment where it can be implemented either Linux, Windows, Android or even embedded systems, likewise the client-server connection methods are based on TCP with security level encryption managed by digital certificates and encryption. Its data modeling is a unified combination of DA, HA and A&C specifications.
SQL Client Module: Main Features
Storing our plant data for decision making analysis, reporting and productivity control is a fundamental part of an automation process.
The vNode Automation SQL Client module provides full connectivity to multiple databases by performing real-time reads, inserts, updates, recipes and custom queries to or from popular engines such as SQL Server, MySQL, PostgreSQL or MariaDB.
- Automatic creation of tables within the database.
- Supports inserts, updates, and reads.
- Implementation of triggers or conditionals.
- Bidirectional writing and reading.
- Supports SQL Server, MySQL Server, PostgreSQL and Maria DB engines.
- Custom queries.
- Unlimited connections.
Download vNode and start processing and integrating data from your automation systems in just a few minutes.
Programing And Syntax: SQL Client Module
vNode SQL Client module provides full connectivity to multiple databases by performing real time reads, inserts, updates, recipes, and custom queries. SQL has basic commands such as:
- SELECT: Allows to select the data to download.
- WHERE: Allows to select which filter to apply to the data to download.
- INSERT: Allows to insert data.
- DELETE: Allows to delete data.
- UPDATE: Allows to update data.
Frequently Asked Questions
Which databases does the vNode SQL Client support?
MySQL, SQL Server, Oracle, and PostgreSQL via standard SQL/ODBC drivers.
Can vNode write real-time PLC data directly to a database?
Yes. The SQL Client stores tag values from PLCs and industrial sources directly into database tables in real time.
Can vNode read from a database and expose it via OPC UA?
Yes. The SQL-to-OPC UA module reads data from a SQL database and exposes it as an OPC UA server, so SCADA or historian systems can consume it.
Does vNode support bidirectional database communication?
Yes. vNode can both read from and write to SQL databases, supporting setpoint synchronization, recipe management, and production reporting use cases.
Does the database integration require custom scripts?
No. Database connections, table mappings, and data routing are all configured through vNode’s no-code web interface.