vNode SQL Client module provides full connectivity to multiple databases by performing real time reads, inserts, updates, recipes, and custom queries. Enables data logging information in time series SQL, MYSQL Postgre and MariaDB databases.
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.
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.