{"id":2401,"date":"2024-04-23T08:05:07","date_gmt":"2024-04-23T08:05:07","guid":{"rendered":"https:\/\/vnodeautomation.com\/?post_type=module&#038;p=2401"},"modified":"2024-04-23T08:07:00","modified_gmt":"2024-04-23T08:07:00","slug":"sql-client","status":"publish","type":"module","link":"https:\/\/vnodeautomation.com\/pt-br\/modules\/sql-client\/","title":{"rendered":"SQL Client"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2401\" class=\"elementor elementor-2401\" data-elementor-post-type=\"module\">\n\t\t\t\t<div class=\"elementor-element elementor-element-285efbe e-flex e-con-boxed e-con e-parent\" data-id=\"285efbe\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2a06c61 elementor-widget elementor-widget-heading\" data-id=\"2a06c61\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">vNode SQL Client Module<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e5038fc elementor-widget elementor-widget-heading\" data-id=\"e5038fc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<span class=\"elementor-heading-title elementor-size-default\">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.\n\n<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c01b153 elementor-widget elementor-widget-button\" data-id=\"c01b153\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/vnodeautomation.com\/downloads\/latest\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Download Free Trial Now!<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3a81194 e-flex e-con-boxed e-con e-parent\" data-id=\"3a81194\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-0d4ec6b e-con-full e-flex e-con e-child\" data-id=\"0d4ec6b\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-68e8d4b elementor-widget elementor-widget-heading\" data-id=\"68e8d4b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">SQL Client Module<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4e35c7b e-flex e-con-boxed e-con e-child\" data-id=\"4e35c7b\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-faf44d3 elementor-widget__width-initial elementor-widget-mobile__width-inherit elementor-widget elementor-widget-text-editor\" data-id=\"faf44d3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>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.<\/p><p>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\u2026<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f9aef43 elementor-widget__width-initial elementor-widget-mobile__width-inherit elementor-widget elementor-widget-text-editor\" data-id=\"f9aef43\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>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&amp;C specifications.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f193135 elementor-widget elementor-widget-button\" data-id=\"f193135\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/vnodeautomation.com\/downloads\/latest\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Download vNode Now!<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-cc1436e e-flex e-con-boxed e-con e-parent\" data-id=\"cc1436e\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-ea30f44 e-con-full e-flex e-con e-child\" data-id=\"ea30f44\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-9429f37 e-flex e-con-boxed e-con e-child\" data-id=\"9429f37\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c55431c elementor-widget elementor-widget-heading\" data-id=\"c55431c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">SQL Client Module: Main Features<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9abb1f9 elementor-widget elementor-widget-text-editor\" data-id=\"9abb1f9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Storing our plant data for decision making analysis, reporting and productivity control is a fundamental part of an automation process.<\/p><p>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.<\/p><ul><li>Automatic creation of tables within the database.<\/li><li>Supports inserts, updates, and reads.<\/li><li>Implementation of triggers or conditionals.<\/li><li>Bidirectional writing and reading.<\/li><li>Supports SQL Server, MySQL Server, PostgreSQL and Maria DB engines.<\/li><li>Custom queries.<\/li><li>Unlimited connections.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6538ea3 e-flex e-con-boxed e-con e-child\" data-id=\"6538ea3\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-acaa8aa elementor-align-center elementor-widget elementor-widget-lottie\" data-id=\"acaa8aa\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;source_json&quot;:{&quot;url&quot;:&quot;https:\\\/\\\/vnodeautomation.com\\\/wp-content\\\/uploads\\\/tmpoh8cd9lj.json&quot;,&quot;id&quot;:2344,&quot;size&quot;:&quot;&quot;,&quot;alt&quot;:&quot;&quot;,&quot;source&quot;:&quot;library&quot;},&quot;loop&quot;:&quot;yes&quot;,&quot;lazyload&quot;:&quot;yes&quot;,&quot;source&quot;:&quot;media_file&quot;,&quot;caption_source&quot;:&quot;none&quot;,&quot;link_to&quot;:&quot;none&quot;,&quot;trigger&quot;:&quot;arriving_to_viewport&quot;,&quot;viewport&quot;:{&quot;unit&quot;:&quot;%&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:{&quot;start&quot;:0,&quot;end&quot;:100}},&quot;play_speed&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:1,&quot;sizes&quot;:[]},&quot;start_point&quot;:{&quot;unit&quot;:&quot;%&quot;,&quot;size&quot;:0,&quot;sizes&quot;:[]},&quot;end_point&quot;:{&quot;unit&quot;:&quot;%&quot;,&quot;size&quot;:100,&quot;sizes&quot;:[]},&quot;renderer&quot;:&quot;svg&quot;}\" data-widget_type=\"lottie.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"e-lottie__container\"><div class=\"e-lottie__animation\"><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d6ee7f5 e-flex e-con-boxed e-con e-parent\" data-id=\"d6ee7f5\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-a343688 e-flex e-con-boxed e-con e-child\" data-id=\"a343688\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f38a647 elementor-widget__width-initial elementor-widget-mobile__width-inherit elementor-widget elementor-widget-heading\" data-id=\"f38a647\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Download vNode and start processing and integrating data from your automation systems in just a few minutes.<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1ac82f9 elementor-widget elementor-widget-button\" data-id=\"1ac82f9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/vnodeautomation.com\/downloads\/latest\/\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Download vNode Now!<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1348f19 e-flex e-con-boxed e-con e-parent\" data-id=\"1348f19\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-4f6f395 e-con-full e-flex e-con e-child\" data-id=\"4f6f395\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-99d7a8c e-flex e-con-boxed e-con e-child\" data-id=\"99d7a8c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4f83ebe elementor-widget elementor-widget-heading\" data-id=\"4f83ebe\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Programing And Syntax: SQL Client Module<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b6d2f5f elementor-widget elementor-widget-text-editor\" data-id=\"b6d2f5f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"wpb_text_column wpb_content_element vc_custom_1671534751301\"><div class=\"wpb_wrapper\"><div class=\"wpb_text_column wpb_content_element vc_custom_1675676419330\"><div class=\"wpb_wrapper\"><div class=\"wpb_text_column wpb_content_element  vc_custom_1671538397172\"><div class=\"wpb_wrapper\"><p>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:<\/p><\/div><\/div><div class=\"wpb_raw_code wpb_content_element wpb_raw_html vc_custom_1671538491925\"><div class=\"wpb_wrapper\"><div><ul><li>SELECT: Allows to select the data to download.<\/li><li>WHERE: Allows to select which filter to apply to the data to download.<\/li><li>INSERT: Allows to insert data.<\/li><li>DELETE: Allows to delete data.<\/li><li>UPDATE: Allows to update data.<\/li><\/ul><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-93993b2 e-flex e-con-boxed e-con e-child\" data-id=\"93993b2\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-db9b568 elementor-widget elementor-widget-image\" data-id=\"db9b568\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"571\" src=\"https:\/\/vnodeautomation.com\/wp-content\/uploads\/SQL-Client-1024x731.png\" class=\"attachment-large size-large wp-image-2402\" alt=\"\" srcset=\"https:\/\/vnodeautomation.com\/wp-content\/uploads\/SQL-Client-1024x731.png 1024w, https:\/\/vnodeautomation.com\/wp-content\/uploads\/SQL-Client-300x214.png 300w, https:\/\/vnodeautomation.com\/wp-content\/uploads\/SQL-Client-768x548.png 768w, https:\/\/vnodeautomation.com\/wp-content\/uploads\/SQL-Client.png 1515w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"featured_media":0,"template":"","meta":{"_acf_changed":false},"class_list":["post-2401","module","type-module","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/vnodeautomation.com\/pt-br\/wp-json\/wp\/v2\/module\/2401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vnodeautomation.com\/pt-br\/wp-json\/wp\/v2\/module"}],"about":[{"href":"https:\/\/vnodeautomation.com\/pt-br\/wp-json\/wp\/v2\/types\/module"}],"version-history":[{"count":3,"href":"https:\/\/vnodeautomation.com\/pt-br\/wp-json\/wp\/v2\/module\/2401\/revisions"}],"predecessor-version":[{"id":2405,"href":"https:\/\/vnodeautomation.com\/pt-br\/wp-json\/wp\/v2\/module\/2401\/revisions\/2405"}],"wp:attachment":[{"href":"https:\/\/vnodeautomation.com\/pt-br\/wp-json\/wp\/v2\/media?parent=2401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}