{"id":9336,"date":"2024-04-23T08:35:26","date_gmt":"2024-04-23T08:35:26","guid":{"rendered":"https:\/\/vnodeautomation.com\/index.php\/module\/vnode-sql-to-opc-ua-solution\/"},"modified":"2024-06-12T13:55:42","modified_gmt":"2024-06-12T13:55:42","slug":"solution-vnode-sql-vers-opc-ua","status":"publish","type":"module","link":"https:\/\/vnodeautomation.com\/fr\/modules\/solution-vnode-sql-vers-opc-ua\/","title":{"rendered":"vNode SQL To OPC UA Solution"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"9336\" class=\"elementor elementor-9336 elementor-2463\" 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 To OPC UA Solution<\/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\">SQL et OPC, deux environnements diff\u00e9rents qui partagent aujourd\u2019hui quelque chose en commun, la DATA. OPC UA est devenu le successeur d\u2019OPC classique, dans lequel l\u2019ensemble du mod\u00e8le de communication est orient\u00e9 vers les services Web, en fournissant la s\u00e9curit\u00e9 et un libre choix d\u2019OS pour travailler. <\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0bc3349 elementor-widget elementor-widget-button\" data-id=\"0bc3349\" 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\/fr\/vnode-centre-de-telechargement-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\">T\u00e9l\u00e9charger Maintenant!<\/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-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-b5562d6 e-con-full e-flex e-con e-child\" data-id=\"b5562d6\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-661a716 e-flex e-con-boxed e-con e-child\" data-id=\"661a716\" 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\">Comment exporter vos donn\u00e9es SQL existantes sur OPC UA?<\/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_1671275298904\">\n<div class=\"wpb_wrapper\">\n<p>OPC UA est n\u00e9 en 2006, en raison du besoin d\u2019interop\u00e9rabilit\u00e9 entre l\u2019environnement industriel et de multiples applications au niveau de la couche sup\u00e9rieure sur la pyramide CIM. UA a \u00e9t\u00e9 con\u00e7u non seulement pour fournir des donn\u00e9es aux SCADA, mais aussi pour envoyer vos donn\u00e9es PLC ou capteurs sur le r\u00e9seau de l\u2019entreprise, les environnements Web et vers le Cloud. <\/p>\n<p>SQL est un langage de base de donn\u00e9es standard qui est n\u00e9 sur la base de plusieurs syst\u00e8mes de gestion de bases de donn\u00e9es relationnelles. Chacun d\u2019entre eux fournit une mani\u00e8re diff\u00e9rente de traiter les donn\u00e9es, mais au fil des ann\u00e9es, nous avons cherch\u00e9 \u00e0 tout int\u00e9grer dans un seul environnement appel\u00e9 SQL.<br \/>Vous voulez savoir \u00e0 quel point il est facile de prendre des donn\u00e9es d\u00e9j\u00e0 enregistr\u00e9es sur un serveur SQL et de les utiliser pour les partager au sein de syst\u00e8mes industriels ou informatiques via OPC UA ? Alors cette solution est faite pour vous!<\/p>\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<div class=\"elementor-element elementor-element-d0bc434 elementor-widget elementor-widget-heading\" data-id=\"d0bc434\" 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<h4 class=\"elementor-heading-title elementor-size-default\">Comment pouvons-nous int\u00e9grer les deux syst\u00e8mes entre eux?<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a9c837 elementor-widget elementor-widget-text-editor\" data-id=\"9a9c837\" 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_1671275298904\">\n<div class=\"wpb_wrapper\">\n<div class=\"wpb_text_column wpb_content_element \">\n<div class=\"wpb_wrapper\">\n<p>vNode Automation est une passerelle IoT qui d\u00e9place les informations depuis diff\u00e9rentes applications ou appareils.<br \/>L\u2019une de ses fonctionnalit\u00e9s est de lire les bases de donn\u00e9es SQL et en m\u00eame temps, il agira en tant que serveur OPC UA, exportant les donn\u00e9es vers n\u2019importe quel client UA, tels que SCADA, ERPS, Historian, AWS, Azure IoT, serveurs Web et bien d\u2019autres\u2026<\/p>\n<\/div>\n<\/div>\n<div class=\"divider-wrap\" data-alignment=\"default\"> <\/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<div class=\"elementor-element elementor-element-99c5ae2 elementor-widget elementor-widget-button\" data-id=\"99c5ae2\" 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\/fr\/vnode-centre-de-telechargement-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\">T\u00e9l\u00e9charger Maintenant!<\/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-186f91d e-flex e-con-boxed e-con e-child\" data-id=\"186f91d\" 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-78cca2d elementor-widget elementor-widget-image\" data-id=\"78cca2d\" 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=\"734\" src=\"https:\/\/vnodeautomation.com\/wp-content\/uploads\/Captura-de-pantalla-2021-01-05-a-las-10.56.36-1024x940.png\" class=\"attachment-large size-large wp-image-2464\" alt=\"\" srcset=\"https:\/\/vnodeautomation.com\/wp-content\/uploads\/Captura-de-pantalla-2021-01-05-a-las-10.56.36-1024x940.png 1024w, https:\/\/vnodeautomation.com\/wp-content\/uploads\/Captura-de-pantalla-2021-01-05-a-las-10.56.36-300x275.png 300w, https:\/\/vnodeautomation.com\/wp-content\/uploads\/Captura-de-pantalla-2021-01-05-a-las-10.56.36-768x705.png 768w, https:\/\/vnodeautomation.com\/wp-content\/uploads\/Captura-de-pantalla-2021-01-05-a-las-10.56.36.png 1386w\" 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-9336","module","type-module","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/vnodeautomation.com\/fr\/wp-json\/wp\/v2\/module\/9336","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vnodeautomation.com\/fr\/wp-json\/wp\/v2\/module"}],"about":[{"href":"https:\/\/vnodeautomation.com\/fr\/wp-json\/wp\/v2\/types\/module"}],"version-history":[{"count":1,"href":"https:\/\/vnodeautomation.com\/fr\/wp-json\/wp\/v2\/module\/9336\/revisions"}],"predecessor-version":[{"id":9337,"href":"https:\/\/vnodeautomation.com\/fr\/wp-json\/wp\/v2\/module\/9336\/revisions\/9337"}],"wp:attachment":[{"href":"https:\/\/vnodeautomation.com\/fr\/wp-json\/wp\/v2\/media?parent=9336"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}