{"id":9151,"date":"2024-04-23T08:05:07","date_gmt":"2024-04-23T08:05:07","guid":{"rendered":"https:\/\/vnodeautomation.com\/index.php\/module\/sql-client\/"},"modified":"2024-05-02T13:51:04","modified_gmt":"2024-05-02T13:51:04","slug":"sql-client","status":"publish","type":"module","link":"https:\/\/vnodeautomation.com\/es\/modules\/sql-client\/","title":{"rendered":"SQL Client"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"9151\" class=\"elementor elementor-9151 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\">El M\u00f3dulo vNode SQL Cliente proporciona conectividad total a m\u00faltiples bases de datos al realizar lecturas, inserciones, actualizaciones y consultas personalizadas en tiempo real. Habilita el registro de informaci\u00f3n de datos en bases de datos SQL, MYSQL Postgre y MariaDB.\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\/es\/vnode-centro-de-descargas-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\">Descarga vNode Ahora<\/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>Las bases de datos relacionales permiten establecer un almacenamiento ordenado y claro de cualquier estructura de informaci\u00f3n. Con ello utilizan tablas para segmentar la data seg\u00fan un criterio y se organizan en vistas e \u00edndices. De esta forma, permite que se puedan combinar tablas entre si para obtener un resultado mas acotado de la informaci\u00f3n.<\/p>\n<p>Las bases de datos relacionales se utilizan en todo tipo de entornos con m\u00faltiples fines, como rastreo de inventarios, comercio electr\u00f3nico, p\u00e1ginas web, as\u00ed como tambi\u00e9n son utilizadas en la automatizaci\u00f3n industrial, para predicciones, c\u00e1lculos de eficiencia, toma de decisiones basadas en hist\u00f3ricos, entre otros\u2026<\/p>\n\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>A diferencia de la tecnolog\u00eda OPC Cl\u00e1sica que va ligada a COM\/DCOM Windows (Microsoft), OPC UA puede volverse indiferente al sistema operativo o al entorno donde se pueda implementar ya sea Linux, Windows, Android o incluso sistemas embebidos, as\u00ed como el cliente-servidor. Los m\u00e9todos de conexi\u00f3n est\u00e1n basados \u200b\u200ben TCP con nivel de seguridad cifrado gestionado por certificados digitales y cifrado. Su modelado de datos es una combinaci\u00f3n unificada de especificaciones DA, HA y A&amp;C.<\/p>\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<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\/es\/vnode-centro-de-descargas-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\">Descarga VNode Ahora<\/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\">M\u00f3dulo SQL Cliente: Principales caracter\u00edsticas<\/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>Almacenar nuestros datos de planta para la toma de decisiones, an\u00e1lisis, reportes y controlar productividad es parte fundamental de un proceso de automatizaci\u00f3n en cualquier industria.<\/p>\n<p>El m\u00f3dulo SQL Cliente de vNode Automation proporciona una conectividad total a m\u00faltiples bases de datos al realizar lecturas, inserciones, actualizaciones, recetas y consultas personalizadas en tiempo real hacia o desde los motores m\u00e1s conocidos como: SQL Server, MySQL, Postgre o MariaDB.<\/p>\n<ul>\n<li>Creaci\u00f3n autom\u00e1tica de tablas dentro de la base de datos.<\/li>\n<li>Soporta realizar Inserciones, actualizaciones y lecturas.<\/li>\n<li>Implementaci\u00f3n de triggers o condicionales.<\/li>\n<li>Escritura y lectura bidireccional.<\/li>\n<li>Soporta los motores SQL Server, MySQL Server, PostgreSQL y Maria DB.<\/li>\n<li>Consultas personalizadas.<\/li>\n<li>Conexiones ilimitadas.<\/li>\n<\/ul>\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-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\">Descarga vNode y comienza a procesar e integrar datos de tus sistemas de automatizaci\u00f3n en solo unos minutos.<\/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\/es\/vnode-centro-de-descargas-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\">Descarga VNode Ahora<\/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\">Programaci\u00f3n y Sintaxis: M\u00f3dulo SQL Cliente<\/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\">\n<div class=\"wpb_wrapper\">\n<div class=\"wpb_text_column wpb_content_element vc_custom_1675676419330\">\n<div class=\"wpb_wrapper\">\n<div class=\"wpb_text_column wpb_content_element vc_custom_1671538397172\">\n<div class=\"wpb_wrapper\">\n<p>El M\u00f3dulo vNode SQL Cliente proporciona conectividad total a m\u00faltiples bases de datos al realizar lecturas, inserciones, actualizaciones y consultas personalizadas en tiempo real. SQL cuenta con comandos b\u00e1sicos tales como:<\/p>\n<\/div>\n<\/div>\n<div class=\"wpb_raw_code wpb_content_element wpb_raw_html vc_custom_1671538491925\">\n<div class=\"wpb_wrapper\">\n<div>\n<ul>\n<li>SELECT: Permite seleccionar los datos para descargar<\/li>\n<li>WHERE: Permite seleccionar qu\u00e9 filtro aplicar a los a datos descargar<\/li>\n<li>INSERT: Permite insertar datos<\/li>\n<li>DELETE: Permite borrar datos<\/li>\n<li>UPDATE: Permite actualizar los datos<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/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-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-9151","module","type-module","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/vnodeautomation.com\/es\/wp-json\/wp\/v2\/module\/9151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vnodeautomation.com\/es\/wp-json\/wp\/v2\/module"}],"about":[{"href":"https:\/\/vnodeautomation.com\/es\/wp-json\/wp\/v2\/types\/module"}],"version-history":[{"count":1,"href":"https:\/\/vnodeautomation.com\/es\/wp-json\/wp\/v2\/module\/9151\/revisions"}],"predecessor-version":[{"id":9152,"href":"https:\/\/vnodeautomation.com\/es\/wp-json\/wp\/v2\/module\/9151\/revisions\/9152"}],"wp:attachment":[{"href":"https:\/\/vnodeautomation.com\/es\/wp-json\/wp\/v2\/media?parent=9151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}