{"id":1381,"date":"2021-06-07T17:35:31","date_gmt":"2021-06-07T15:35:31","guid":{"rendered":"http:\/\/adisrav.cluster028.hosting.ovh.net\/?page_id=1381"},"modified":"2022-06-23T17:44:26","modified_gmt":"2022-06-23T15:44:26","slug":"base-de-donnees","status":"publish","type":"page","link":"https:\/\/www.adisra.fr\/?page_id=1381","title":{"rendered":"Base de donn\u00e9es"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1381\" class=\"elementor elementor-1381\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ffbe4de elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ffbe4de\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8419660\" data-id=\"8419660\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8b7343e elementor-widget elementor-widget-eael-simple-menu\" data-id=\"8b7343e\" data-element_type=\"widget\" data-widget_type=\"eael-simple-menu.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<div data-hamburger-icon=\"&lt;i aria-hidden=&quot;true&quot; class=&quot;fas fa-bars&quot;&gt;&lt;\/i&gt;\" data-indicator-class=\"fas fa-angle-down\" data-dropdown-indicator-class=\"fas fa-angle-down\" class=\"eael-simple-menu-container eael-simple-menu-align-left eael-simple-menu-dropdown-align-left preset-1\" data-hamburger-breakpoints=\"{&quot;mobile&quot;:&quot;Mobile (&gt; 767px)&quot;,&quot;tablet&quot;:&quot;Tablette (&gt; 1024px)&quot;,&quot;none&quot;:&quot;None&quot;}\" data-hamburger-device=\"tablet\"><ul id=\"menu-obtenir-de-laide\" class=\"eael-simple-menu eael-simple-menu-dropdown-animate-to-top eael-simple-menu-indicator eael-simple-menu-vertical\"><li id=\"menu-item-1914\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1914\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1319\" class=\"menu-link\">Introduction<\/a>\n<ul class=\"sub-menu\">\n\t<li id=\"menu-item-1400\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1400\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1350\" class=\"menu-link\">Architecture<\/a><\/li>\n\t<li id=\"menu-item-1401\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1401\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1352\" class=\"menu-link\">Conditions<\/a><\/li>\n\t<li id=\"menu-item-1402\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1402\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1361\" class=\"menu-link\">Installation d\u2019ADISRA SmartView<\/a><\/li>\n\t<li id=\"menu-item-1404\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1404\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1363\" class=\"menu-link\">License ADISRA SmartView<\/a><\/li>\n\t<li id=\"menu-item-1403\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1403\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1365\" class=\"menu-link\">Interface Intuitive d\u2019Ing\u00e9nierie<\/a><\/li>\n\t<li id=\"menu-item-1406\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1406\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1367\" class=\"menu-link\">Script<\/a><\/li>\n\t<li id=\"menu-item-1876\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1876\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1863\" class=\"menu-link\">Obtenir de l&rsquo;aide<\/a><\/li>\n<\/ul>\n<\/li>\n<li id=\"menu-item-1396\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1396\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1371\" class=\"menu-link\">Modules<\/a>\n<ul class=\"sub-menu\">\n\t<li id=\"menu-item-1408\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1408\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1373\" class=\"menu-link\">Ing\u00e9nierie<\/a><\/li>\n\t<li id=\"menu-item-1409\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1409\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1375\" class=\"menu-link\">Ex\u00e9cution<\/a><\/li>\n\t<li id=\"menu-item-1410\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1410\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1377\" class=\"menu-link\">Visionneuse<\/a><\/li>\n<\/ul>\n<\/li>\n<li id=\"menu-item-1395\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1395\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1379\" class=\"menu-link\">Hot Topics<\/a>\n<ul class=\"sub-menu\">\n\t<li id=\"menu-item-1411\" class=\"menu-item menu-item-type-post_type menu-item-object-page menu-item-1411\"><a href=\"https:\/\/www.adisra.fr\/?page_id=1381\" class=\"menu-link\">Base de donn\u00e9es<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fd6381e\" data-id=\"fd6381e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-921db3c elementor-widget elementor-widget-heading\" data-id=\"921db3c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">Base de donn\u00e9es<\/h1>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cd1cf74 elementor-widget elementor-widget-heading\" data-id=\"cd1cf74\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">R\u00e9sum\u00e9<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-5587c21 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5587c21\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-f34d98d\" data-id=\"f34d98d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f2a054a elementor-widget elementor-widget-text-editor\" data-id=\"f2a054a\" data-element_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<p>Ce document d\u00e9taille les diff\u00e9rentes mani\u00e8res de cr\u00e9er des connexions entre ADISRA SmartView et la ou les bases de donn\u00e9es relationnelles souhait\u00e9es.<\/p><p>Il existe diff\u00e9rentes mani\u00e8res de cr\u00e9er une connexion entre ADISRA SmartView et les bases de donn\u00e9es, il est donc important d&rsquo;\u00e9tablir pourquoi chaque connexion sera n\u00e9cessaire et comment elle sera utilis\u00e9e.<\/p><p>Exemples:<\/p><ul><li>Si l&rsquo;utilisateur souhaite simplement stocker les valeurs des balises dans la base de donn\u00e9es, il n&rsquo;aura qu&rsquo;\u00e0 cr\u00e9er une connexion \u00e0 la base de donn\u00e9es globale dans le ruban sup\u00e9rieur et utiliser cette connexion dans le document Historique des balises.<\/li><li>Si l&rsquo;utilisateur souhaite stocker l&rsquo;historique des alarmes, ce sera une solution similaire. L&rsquo;utilisateur devra cr\u00e9er une connexion \u00e0 la base de donn\u00e9es globale et utiliser cette connexion dans le document Historique des alarmes.<\/li><li>Si l&rsquo;utilisateur doit ex\u00e9cuter des requ\u00eates telles que \u00ab\u00a0cr\u00e9er une table\u00a0\u00bb, \u00ab\u00a0s\u00e9lectionner\u00a0\u00bb, \u00ab\u00a0mettre \u00e0 jour\u00a0\u00bb ou \u00ab\u00a0supprimer\u00a0\u00bb, l&rsquo;utilisateur peut utiliser la connexion \u00e0 la base de donn\u00e9es globale et la biblioth\u00e8que de fonctions syst\u00e8me ou l&rsquo;utilisateur peut \u00e9crire la connexion enti\u00e8re en utilisant ses propres sc\u00e9nario. Dans ce deuxi\u00e8me exemple, l&rsquo;utilisateur n&rsquo;aura pas besoin de la connexion globale \u00e0 la base de donn\u00e9es.<\/li><\/ul><p>Veuillez consulter les sections suivantes et n&rsquo;h\u00e9sitez pas \u00e0 utiliser l&rsquo;une des solutions dans un application.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c190178 elementor-widget elementor-widget-heading\" data-id=\"c190178\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Configurer la connexion \u00e0 la base de donn\u00e9es globale<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-04f27e6 elementor-widget elementor-widget-heading\" data-id=\"04f27e6\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Cr\u00e9er une nouvelle connexion<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<div class=\"elementor-element elementor-element-89f7ac9 elementor-widget elementor-widget-text-editor\" data-id=\"89f7ac9\" data-element_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<p>La connexion globale \u00e0 la base de donn\u00e9es fait partie des param\u00e8tres du projet. Il permet \u00e0 l&rsquo;utilisateur de cr\u00e9er une connexion \u00e0 une base de donn\u00e9es via un assistant de connexion et d&rsquo;utiliser cette connexion dans son application. Pour configurer une nouvelle connexion globale \u00e0 la base de donn\u00e9es, veuillez suivre les \u00e9tapes ci-dessous :<\/p><ul><li>Dans le ruban ADISRA SmartView, allez dans \u00ab Connexions \u00e0 la base de donn\u00e9es \u00bb et cliquez sur le bouton \u00ab Connexions \u00e0 la base de donn\u00e9es \u00bb, la fen\u00eatre \u00ab Connexions \u00e0 la base de donn\u00e9es \u00bb s&rsquo;ouvrira.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3844776 elementor-widget elementor-widget-image\" data-id=\"3844776\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"491\" height=\"311\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-17.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-17.png 491w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-17-300x190.png 300w\" sizes=\"auto, (max-width: 491px) 100vw, 491px\" \/>\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<div class=\"elementor-element elementor-element-a75c002 elementor-widget elementor-widget-text-editor\" data-id=\"a75c002\" data-element_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<ul><li>Pour ajouter une nouvelle connexion \u00e0 une base de donn\u00e9es, cliquez sur le bouton \u00ab\u00a0+\u00a0\u00bb pr\u00e9sent dans l&rsquo;encadr\u00e9 rouge ci-dessous<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a4e6207 elementor-widget elementor-widget-image\" data-id=\"a4e6207\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"358\" height=\"252\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-1-3.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-1-3.png 358w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-1-3-300x211.png 300w\" sizes=\"auto, (max-width: 358px) 100vw, 358px\" \/>\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<div class=\"elementor-element elementor-element-dceb95b elementor-widget elementor-widget-text-editor\" data-id=\"dceb95b\" data-element_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<ul><li>Dans cet exemple, nous allons configurer une connexion PostgresSQL, s\u00e9l\u00e9ctionnez PostgresSQL puis cliquez sur OK :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-897e69e elementor-widget elementor-widget-image\" data-id=\"897e69e\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"375\" height=\"221\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-2-3.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-2-3.png 375w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-2-3-300x177.png 300w\" sizes=\"auto, (max-width: 375px) 100vw, 375px\" \/>\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<div class=\"elementor-element elementor-element-0ab962b elementor-widget elementor-widget-text-editor\" data-id=\"0ab962b\" data-element_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<ul><li>La fen\u00eatre \u00ab\u00a0Propri\u00e9t\u00e9s de Connexion\u00a0\u00bb va appara\u00eetre, l&rsquo;utilisateur doit alors entrer les informations de la base de donn\u00e9es \u00e0 laquelle il veut se connecter. L&rsquo;image ci-dessous repr\u00e9sente seulement un exemple :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-483a1d9 elementor-widget elementor-widget-image\" data-id=\"483a1d9\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"310\" height=\"348\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-3-3.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-3-3.png 310w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-3-3-267x300.png 267w\" sizes=\"auto, (max-width: 310px) 100vw, 310px\" \/>\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<div class=\"elementor-element elementor-element-76c1606 elementor-widget elementor-widget-text-editor\" data-id=\"76c1606\" data-element_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<ul><li>Cliquez sur le bouton \u00ab\u00a0Tester la connexion\u00a0\u00bb, si toutes les informations sont correctes, le logiciel va afficher la boite de dialogue suivante :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cb1f616 elementor-widget elementor-widget-image\" data-id=\"cb1f616\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"208\" height=\"135\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-4-3.png\" class=\"attachment-large size-large\" alt=\"\" \/>\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<div class=\"elementor-element elementor-element-8a27338 elementor-widget elementor-widget-text-editor\" data-id=\"8a27338\" data-element_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<ul><li>Si le test de connexion a r\u00e9ussi, veuillez cliquer sur OK.<\/li><li>Si le test \u00e9choue, un message d&rsquo;erreur s&rsquo;affichera avec la description de l&rsquo;erreur. Le message d&rsquo;erreur peut indiquer qu&rsquo;une installation de pilote est manquante ou que les informations de connexion ne correspondent pas.<\/li><li>Le bouton Avanc\u00e9 affiche les configurations personnalis\u00e9es pour le pilote de base de donn\u00e9es s\u00e9lectionn\u00e9. La base de donn\u00e9es utilis\u00e9e d\u00e9terminera si les informations suppl\u00e9mentaires sont requises.<\/li><li>Cliquez sur OK dans la fen\u00eatre \u00ab\u00a0Propri\u00e9t\u00e9s de la connexion\u00a0\u00bb, puis nommez la connexion et s\u00e9lectionnez si les tables seront ou non cr\u00e9\u00e9es avec le suffixe par d\u00e9faut. Le suffixe par d\u00e9faut est le nom du projet\u00a0:<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-550ca42 elementor-widget elementor-widget-image\" data-id=\"550ca42\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"272\" height=\"147\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-5-1.png\" class=\"attachment-large size-large\" alt=\"\" \/>\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<div class=\"elementor-element elementor-element-e975126 elementor-widget elementor-widget-text-editor\" data-id=\"e975126\" data-element_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<ul><li>Si l&rsquo;utilisateur souhaite modifier le suffixe, d\u00e9cochez la case Suffixe par d\u00e9faut et saisissez le nouveau suffixe\u00a0:<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eecee6a elementor-widget elementor-widget-image\" data-id=\"eecee6a\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"272\" height=\"147\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-6-1.png\" class=\"attachment-large size-large\" alt=\"\" \/>\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<div class=\"elementor-element elementor-element-582bc4b elementor-widget elementor-widget-text-editor\" data-id=\"582bc4b\" data-element_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<ul><li>Voir l&rsquo;exemple de deux tables cr\u00e9\u00e9es, la premi\u00e8re avec un suffixe personnalis\u00e9 et la seconde avec le suffixe par d\u00e9faut qui est le nom du projet. Dans cet exemple, le nom du projet est \u00ab databaseproject \u00bb :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-26b9a32 elementor-widget elementor-widget-image\" data-id=\"26b9a32\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"272\" height=\"57\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-7-1.png\" class=\"attachment-large size-large\" alt=\"\" \/>\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<div class=\"elementor-element elementor-element-2713b2b elementor-widget elementor-widget-text-editor\" data-id=\"2713b2b\" data-element_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<ul><li>L&rsquo;utilisateur devrait voir la connexion se cr\u00e9er.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7ac884f elementor-widget elementor-widget-image\" data-id=\"7ac884f\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"351\" height=\"247\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-8-1.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-8-1.png 351w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-8-1-300x211.png 300w\" sizes=\"auto, (max-width: 351px) 100vw, 351px\" \/>\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<div class=\"elementor-element elementor-element-7c0e1a4 elementor-widget elementor-widget-text-editor\" data-id=\"7c0e1a4\" data-element_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<ul><li>Diff\u00e9rentes bases de donn\u00e9es auront diff\u00e9rentes options dans la fen\u00eatre \u00ab Propri\u00e9t\u00e9s de la connexion \u00bb. L&rsquo;utilisateur doit le configurer en fonction de la configuration de la base de donn\u00e9es.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c4547b8 elementor-widget elementor-widget-image\" data-id=\"c4547b8\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"310\" height=\"350\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-9-1.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-9-1.png 310w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-9-1-266x300.png 266w\" sizes=\"auto, (max-width: 310px) 100vw, 310px\" \/>\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<div class=\"elementor-element elementor-element-e167a0b elementor-widget elementor-widget-text-editor\" data-id=\"e167a0b\" data-element_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<p><em>Remarque : lors de la configuration ou du renommage des connexions \u00e0 un fichier de base de donn\u00e9es Access ou \u00e0 un fichier de base de donn\u00e9es Microsoft SQL Server, il y aura une option suppl\u00e9mentaire appel\u00e9e \u00ab Chemin relatif \u00bb, si elle n&rsquo;est pas coch\u00e9e, ADISRA SmartView recherchera le fichier dans le chemin absolu du disque dur. <\/em><em>Par exemple<\/em><em> \u00ab\u00a0C:\\Users\\Documents\\AccesDB.accdb\u00a0\u00bb.<\/em><em> Il est important de comprendre que si l&rsquo;utilisateur ex\u00e9cute le projet sur une autre machine, il ne pourra pas trouver le fichier. Si l&rsquo;option \u00ab Chemin relatif \u00bb est coch\u00e9e, ADISRA SmartView recherchera le fichier dans le chemin relatif du chemin du projet. La s\u00e9lection de l&rsquo;option \u00ab Chemin relatif \u00bb facilitera l&rsquo;exportation du projet vers une autre machine.<\/em><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ab63631 elementor-widget elementor-widget-image\" data-id=\"ab63631\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"292\" height=\"158\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-10-1.png\" class=\"attachment-large size-large\" alt=\"\" \/>\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<div class=\"elementor-element elementor-element-07965c9 elementor-widget elementor-widget-heading\" data-id=\"07965c9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Supprimer une connection<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a0f8dc elementor-widget elementor-widget-text-editor\" data-id=\"4a0f8dc\" data-element_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<p><i>Pour supprimer la connexion \u00e0 une base de donn\u00e9es, suivez les \u00e9tapes suivantes :\u00a0<\/i><\/p><ul><li>Dans le ruban ADISRA SmartView, allez \u00e0 \u00ab\u00a0Connexions Base de Donn\u00e9es\u00a0\u00bb, cliquez sur le bouton \u00ab\u00a0Connexions Base de Donn\u00e9es\u00a0\u00bb, et la fen\u00eatre \u00ab\u00a0Connexions Base de Donn\u00e9es\u00a0\u00bb appara\u00eetra\u00a0<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-563bba3 elementor-widget elementor-widget-image\" data-id=\"563bba3\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"442\" height=\"280\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-11-1.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-11-1.png 442w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-11-1-300x190.png 300w\" sizes=\"auto, (max-width: 442px) 100vw, 442px\" \/>\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<div class=\"elementor-element elementor-element-26df5a7 elementor-widget elementor-widget-text-editor\" data-id=\"26df5a7\" data-element_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<ul><li>S\u00e9lectionnez la connexion que l&rsquo;utilisateur veut supprimer et cliquez sur le bouton \u00ab\u00a0&#8211;\u00a0\u00bb montr\u00e9 dans l&rsquo;encadrant rouge ci-dessous.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fda3531 elementor-widget elementor-widget-image\" data-id=\"fda3531\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"346\" height=\"244\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-12-1.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-12-1.png 346w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-12-1-300x212.png 300w\" sizes=\"auto, (max-width: 346px) 100vw, 346px\" \/>\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<div class=\"elementor-element elementor-element-0c22dda elementor-widget elementor-widget-text-editor\" data-id=\"0c22dda\" data-element_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<ul><li>Confirmez que l&rsquo;utilisateur veut supprimer l&rsquo;\u00e9l\u00e9ment de connexion.\u00a0<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d90b825 elementor-widget elementor-widget-image\" data-id=\"d90b825\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"186\" height=\"108\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-13-1.png\" class=\"attachment-large size-large\" alt=\"\" \/>\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<div class=\"elementor-element elementor-element-438f9f2 elementor-widget elementor-widget-heading\" data-id=\"438f9f2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">\u00c9diter une connexion<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8624f63 elementor-widget elementor-widget-text-editor\" data-id=\"8624f63\" data-element_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<p>Pour \u00e9diter la connexion \u00e0 une base de donn\u00e9es, suivez les \u00e9tapes ci-dessous :<\/p><ul><li>Dans le ruban ADISRA SmartView, allez \u00e0 \u00ab\u00a0Connexions Base de Donn\u00e9es\u00a0\u00bb, cliquez sur le bouton \u00ab\u00a0Connexions Base de Donn\u00e9es\u00a0\u00bb, et la fen\u00eatre \u00ab\u00a0Connexions Base de Donn\u00e9es\u00a0\u00bb appara\u00eetra .<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-65d2214 elementor-widget elementor-widget-image\" data-id=\"65d2214\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"444\" height=\"282\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-14-1.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-14-1.png 444w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-14-1-300x191.png 300w\" sizes=\"auto, (max-width: 444px) 100vw, 444px\" \/>\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<div class=\"elementor-element elementor-element-933888e elementor-widget elementor-widget-text-editor\" data-id=\"933888e\" data-element_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<ul><li>S\u00e9lectionner la connexion que l&rsquo;utilisateur veut \u00e9diter et cliquer sur le bouton \u00ab\u00a0Symbole Crayon\u00a0\u00bb affich\u00e9 dans l&rsquo;encart rouge ci-dessous.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-74c0fb0 elementor-widget elementor-widget-image\" data-id=\"74c0fb0\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"334\" height=\"235\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-15-1.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-15-1.png 334w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-15-1-300x211.png 300w\" sizes=\"auto, (max-width: 334px) 100vw, 334px\" \/>\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<div class=\"elementor-element elementor-element-0d8dd9d elementor-widget elementor-widget-text-editor\" data-id=\"0d8dd9d\" data-element_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<ul><li>Cela va ouvrir la fen\u00eatre des \u00ab\u00a0Propri\u00e9t\u00e9s de Connexion\u00a0\u00bb pour que l&rsquo;utilisateur puissent \u00e9diter la connexion.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6698883 elementor-widget elementor-widget-image\" data-id=\"6698883\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"334\" height=\"235\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-15-1.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-15-1.png 334w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-15-1-300x211.png 300w\" sizes=\"auto, (max-width: 334px) 100vw, 334px\" \/>\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<div class=\"elementor-element elementor-element-132024f elementor-widget elementor-widget-heading\" data-id=\"132024f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Renommer une connexion<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b829c19 elementor-widget elementor-widget-text-editor\" data-id=\"b829c19\" data-element_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<p>Pour renommer la connexion \u00e0 une base de donn\u00e9es, suivez les \u00e9tapes ci-dessous.<\/p><ul><li>Dans le ruban ADISRA SmartView, allez \u00e0 \u00ab\u00a0Connexions Base de Donn\u00e9es\u00a0\u00bb, cliquez sur le bouton \u00ab\u00a0Connexions Base de Donn\u00e9es\u00a0\u00bb, et la fen\u00eatre \u00ab\u00a0Connexions Base de Donn\u00e9es\u00a0\u00bb appara\u00eetra.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-631e6f9 elementor-widget elementor-widget-image\" data-id=\"631e6f9\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"513\" height=\"325\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-18.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-18.png 513w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-18-300x190.png 300w\" sizes=\"auto, (max-width: 513px) 100vw, 513px\" \/>\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<div class=\"elementor-element elementor-element-8da3a4a elementor-widget elementor-widget-text-editor\" data-id=\"8da3a4a\" data-element_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<ul><li>S\u00e9lectionnez la connexion que l&rsquo;utilisateur veut renommer et cliquez sur le bouton \u00ab\u00a0Renommer la Connexion\u00a0\u00bb montr\u00e9 dans l&rsquo;encadrant rouge ci-dessous.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a85be08 elementor-widget elementor-widget-image\" data-id=\"a85be08\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"377\" height=\"264\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-19.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-19.png 377w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-19-300x210.png 300w\" sizes=\"auto, (max-width: 377px) 100vw, 377px\" \/>\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<div class=\"elementor-element elementor-element-7949acb elementor-widget elementor-widget-text-editor\" data-id=\"7949acb\" data-element_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<ul><li>La fen\u00eatre \u00ab\u00a0Renommer la Connexion\u00a0\u00bb va appara\u00eetre et l&rsquo;utilisateur pourra renommer la connexion. S\u00e9lectionnez \u00ab\u00a0OK\u00a0\u00bb pour compl\u00e9ter le renommage.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-77fedf4 elementor-widget elementor-widget-image\" data-id=\"77fedf4\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"377\" height=\"264\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-19-1.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-19-1.png 377w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-19-1-300x210.png 300w\" sizes=\"auto, (max-width: 377px) 100vw, 377px\" \/>\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<div class=\"elementor-element elementor-element-2c2ec24 elementor-widget elementor-widget-heading\" data-id=\"2c2ec24\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Importer et exporter des Connexions de Base de donn\u00e9es<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f9a95f4 elementor-widget elementor-widget-text-editor\" data-id=\"f9a95f4\" data-element_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<p>Pour importer et exporter les connexions de base de donn\u00e9es configur\u00e9es, suivez les \u00e9tapes ci-dessous :<\/p><ul><li>Dans le ruban ADISRA SmartView, allez \u00e0 \u00ab\u00a0Connexions Base de Donn\u00e9es\u00a0\u00bb, cliquez sur le bouton \u00ab\u00a0Connexions Base de Donn\u00e9es\u00a0\u00bb, et la fen\u00eatre \u00ab\u00a0Connexions Base de Donn\u00e9es\u00a0\u00bb appara\u00eetra .<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f9803a5 elementor-widget elementor-widget-image\" data-id=\"f9803a5\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"507\" height=\"322\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-16-1.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-16-1.png 507w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-16-1-300x191.png 300w\" sizes=\"auto, (max-width: 507px) 100vw, 507px\" \/>\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<div class=\"elementor-element elementor-element-feee4df elementor-widget elementor-widget-heading\" data-id=\"feee4df\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\">Exporter les connexions \u00e0 une Base de Donn\u00e9es <\/h5>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d9c053b elementor-widget elementor-widget-text-editor\" data-id=\"d9c053b\" data-element_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<ul><li>Cliquez sur le bouton \u00ab\u00a0Exporter les Connexions\u00a0\u00bb affich\u00e9 dans l&rsquo;encadrant rouge ci-dessous.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-754830a elementor-widget elementor-widget-image\" data-id=\"754830a\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"373\" height=\"262\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-17-1.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-17-1.png 373w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-17-1-300x211.png 300w\" sizes=\"auto, (max-width: 373px) 100vw, 373px\" \/>\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<div class=\"elementor-element elementor-element-7721f9b elementor-widget elementor-widget-text-editor\" data-id=\"7721f9b\" data-element_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<ul><li>Pendant l&rsquo;export des connexions, une nouvelle bo\u00eete de dialogue va s&rsquo;afficher. L&rsquo;utilisateur \u00e0 l&rsquo;option de s\u00e9lectionner un fichier et d&rsquo;ins\u00e9rer un nom pour le fichier export\u00e9. Cliquez sur le bouton \u00ab\u00a0Sauvegarder\u00a0\u00bb et le fichier sera g\u00e9n\u00e9r\u00e9.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0b44c81 elementor-widget elementor-widget-image\" data-id=\"0b44c81\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"387\" height=\"322\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-20.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-20.png 387w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-20-300x250.png 300w\" sizes=\"auto, (max-width: 387px) 100vw, 387px\" \/>\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<div class=\"elementor-element elementor-element-f3b27f1 elementor-widget elementor-widget-heading\" data-id=\"f3b27f1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Importer les connexions \u00e0 la Base de Donn\u00e9es <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b285a69 elementor-widget elementor-widget-text-editor\" data-id=\"b285a69\" data-element_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<ul><li>Cliquez sur le bouton \u00ab\u00a0Importer les connexions\u00a0\u00bb affich\u00e9 dans l&rsquo;encadrant rouge ci-dessous.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9eff9fb elementor-widget elementor-widget-image\" data-id=\"9eff9fb\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"275\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-21.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-21.png 392w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-21-300x210.png 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/>\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<div class=\"elementor-element elementor-element-da2e1be elementor-widget elementor-widget-text-editor\" data-id=\"da2e1be\" data-element_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<ul><li>Apr\u00e8s avoir cliqu\u00e9 sur le bouton \u00ab\u00a0Importer les Connexions\u00a0\u00bb, une bo\u00eete de dialogue va s&rsquo;afficher pour permettre \u00e0 l&rsquo;utilisateur de s\u00e9lectionner un fichier csv pr\u00e9c\u00e9demment g\u00e9n\u00e9r\u00e9 par ADISRA SmartView.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7fd6347 elementor-widget elementor-widget-image\" data-id=\"7fd6347\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"395\" height=\"329\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-22.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-22.png 395w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-22-300x250.png 300w\" sizes=\"auto, (max-width: 395px) 100vw, 395px\" \/>\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<div class=\"elementor-element elementor-element-20ad830 elementor-widget elementor-widget-text-editor\" data-id=\"20ad830\" data-element_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<ul><li>S\u00e9lectionner le fichier export\u00e9, nommer le fichier et cliquer sur le bouton \u00ab\u00a0Ouvrir\u00a0\u00bb pour importer le fichier dans le projet en cours. La fonctionnalit\u00e9 \u00ab\u00a0Importer la connexion\u00a0\u00bb permet \u00e0 l&rsquo;utilisateur d&rsquo;importer un fichier pr\u00e9c\u00e9demment export\u00e9.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-275f36f elementor-widget elementor-widget-heading\" data-id=\"275f36f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Connexion \u00e0 une base de donn\u00e9es globale<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-056a820 elementor-widget elementor-widget-image\" data-id=\"056a820\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"558\" height=\"49\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-23.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-23.png 558w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-23-300x26.png 300w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/>\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<div class=\"elementor-element elementor-element-3018142 elementor-widget elementor-widget-text-editor\" data-id=\"3018142\" data-element_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<p>L&rsquo;option \u00ab\u00a0Connexion Base de Donn\u00e9es Globale\u00a0\u00bb mise en avant dans l&rsquo;encadrant rouge ci-dessus, peut-\u00eatre utilis\u00e9 pour stocker les valeurs des Balises (Tag) et les alarmes dans la base de donn\u00e9es. L&rsquo;option peut-\u00eatre utilis\u00e9 pour ex\u00e9cuter des requ\u00eates \u00e0 l&rsquo;aide la biblioth\u00e8que de fonctions SVDatabase System.\u00a0<br \/>Pour utiliser les connexions de base de donn\u00e9es globales configur\u00e9es, suivez les \u00e9tapes ci-dessous.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5ab02ed elementor-widget elementor-widget-heading\" data-id=\"5ab02ed\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Utilisation des connexions de base de donn\u00e9es avec l'historique des alarmes<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b5d6b7b elementor-widget elementor-widget-text-editor\" data-id=\"b5d6b7b\" data-element_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<p>D\u00e8s que le runtime est lanc\u00e9, le tableau de l&rsquo;historique des alarmes sera cr\u00e9\u00e9 par ADISRA SmartView avec toutes les colonnes n\u00e9cessaires. Chaque document d&rsquo;historique d&rsquo;alarme g\u00e9n\u00e9rera une table dans la base de donn\u00e9es. La table d&rsquo;historique de la base de donn\u00e9es cr\u00e9\u00e9e sera une table par document avec toutes les balises configur\u00e9es. En revanche, dans l&rsquo;option Historique des balises, chacune des balises \u00e0 l&rsquo;int\u00e9rieur du document g\u00e9n\u00e9rera un nouveau tableau.<\/p><ul><li>L&rsquo;historique des alarmes peut \u00eatre enregistr\u00e9 dans une base de donn\u00e9es configur\u00e9e. Ouvrez le document d&rsquo;historique des alarmes que l&rsquo;utilisateur souhaite configurer dans la zone de liste d\u00e9roulante \u00ab Enregistrer le type \u00bb, s\u00e9lectionnez \u00ab Base de donn\u00e9es \u00bb et dans la zone de liste d\u00e9roulante \u00ab \u00c9l\u00e9ment de connexion \u00bb, s\u00e9lectionnez une \u00ab Connexion \u00e0 la base de donn\u00e9es \u00bb configur\u00e9e.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-227bdd9 elementor-widget elementor-widget-image\" data-id=\"227bdd9\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"332\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-24.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-24.png 500w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-24-300x199.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/>\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<div class=\"elementor-element elementor-element-5b2daf9 elementor-widget elementor-widget-text-editor\" data-id=\"5b2daf9\" data-element_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<ul><li>D\u00e8s que le runtime est ex\u00e9cut\u00e9, les alarmes configur\u00e9es dans le document Historique des alarmes sont enregistr\u00e9es dans la base de donn\u00e9es. Les valeurs enregistr\u00e9es dans la base de donn\u00e9es peuvent \u00eatre charg\u00e9es par l&rsquo;objet Alarme comme illustr\u00e9 dans l&rsquo;exemple ci-dessous.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-860069f elementor-widget elementor-widget-image\" data-id=\"860069f\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"156\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-25.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-25.png 601w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-25-300x78.png 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/>\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<div class=\"elementor-element elementor-element-a44678f elementor-widget elementor-widget-text-editor\" data-id=\"a44678f\" data-element_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<ul><li>L&rsquo;image suivante montre la table de base de donn\u00e9es cr\u00e9\u00e9e. Le tableau est cr\u00e9\u00e9 par document configur\u00e9. Il contiendra donc chaque balise configur\u00e9e dans le document et ses informations d&rsquo;alarme pertinentes.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d23af9e elementor-widget elementor-widget-image\" data-id=\"d23af9e\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"57\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-26.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-26.png 601w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-26-300x28.png 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/>\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<div class=\"elementor-element elementor-element-19ef4ad elementor-widget elementor-widget-heading\" data-id=\"19ef4ad\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Utilisation des connexions de base de donn\u00e9es avec l'historique des balises (Tag)<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f6f1027 elementor-widget elementor-widget-text-editor\" data-id=\"f6f1027\" data-element_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<p>D\u00e8s que le runtime est lanc\u00e9, la table d&rsquo;historique des balises sera cr\u00e9\u00e9e par ADISRA SmartView avec toutes les colonnes n\u00e9cessaires. Ce sera une table par tag.<\/p><ul><li>L&rsquo;historique des balises peut \u00eatre enregistr\u00e9 dans une base de donn\u00e9es configur\u00e9e. Ouvrez le document Historique des balises que l&rsquo;utilisateur souhaite configurer. Dans la zone \u00ab\u00a0Type d&rsquo;historique\u00a0\u00bb de la zone de liste d\u00e9roulante \u00ab\u00a0Type\u00a0\u00bb, s\u00e9lectionnez \u00ab\u00a0Base de donn\u00e9es\u00a0\u00bb ; et dans la zone de liste d\u00e9roulante \u00ab\u00a0\u00c9l\u00e9ment de connexion\u00a0\u00bb, qui appara\u00eetra apr\u00e8s avoir s\u00e9lectionn\u00e9 le \u00ab\u00a0Type\u00a0\u00bb comme \u00ab\u00a0Base de donn\u00e9es\u00a0\u00bb, s\u00e9lectionnez une \u00ab\u00a0Connexion \u00e0 la base de donn\u00e9es\u00a0\u00bb configur\u00e9e.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8d82bec elementor-widget elementor-widget-image\" data-id=\"8d82bec\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"544\" height=\"361\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-27.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-27.png 544w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-27-300x199.png 300w\" sizes=\"auto, (max-width: 544px) 100vw, 544px\" \/>\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<div class=\"elementor-element elementor-element-02234af elementor-widget elementor-widget-text-editor\" data-id=\"02234af\" data-element_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<ul><li>D\u00e8s que le runtime est ex\u00e9cut\u00e9, les balises configur\u00e9es dans le document Historique des balises sont enregistr\u00e9es dans la base de donn\u00e9es. Les valeurs enregistr\u00e9es dans la base de donn\u00e9es peuvent \u00eatre charg\u00e9es par l&rsquo;objet Tendance (Historique) comme illustr\u00e9 dans l&rsquo;exemple ci-dessous.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-289b294 elementor-widget elementor-widget-image\" data-id=\"289b294\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"545\" height=\"261\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-28.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-28.png 545w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-28-300x144.png 300w\" sizes=\"auto, (max-width: 545px) 100vw, 545px\" \/>\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<div class=\"elementor-element elementor-element-2d7ef80 elementor-widget elementor-widget-text-editor\" data-id=\"2d7ef80\" data-element_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<ul><li>L&rsquo;image suivante montre la table de base de donn\u00e9es cr\u00e9\u00e9e. Il contient la valeur, la qualit\u00e9 et l&rsquo;horodatage de la balise.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-99c55ec elementor-widget elementor-widget-image\" data-id=\"99c55ec\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"437\" height=\"268\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-29.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-29.png 437w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-29-300x184.png 300w\" sizes=\"auto, (max-width: 437px) 100vw, 437px\" \/>\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<div class=\"elementor-element elementor-element-5f5a80a elementor-widget elementor-widget-heading\" data-id=\"5f5a80a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Utilisation des connexions de base de donn\u00e9es avec des \u00e9v\u00e8nements.<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b77d0ce elementor-widget elementor-widget-text-editor\" data-id=\"b77d0ce\" data-element_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<p>Il est possible de sauvegarder les \u00e9v\u00e9nements dans la base de donn\u00e9es. Veuillez suivre les \u00e9tapes ci-dessous pour le configurer.<\/p><ul><li>Les \u00e9v\u00e9nements peuvent \u00eatre enregistr\u00e9s dans une base de donn\u00e9es configur\u00e9e. S\u00e9lectionnez \u00c9v\u00e9nements dans le ruban Param\u00e8tres ; dans la zone de liste d\u00e9roulante \u00ab\u00a0Enregistrer le type\u00a0\u00bb, s\u00e9lectionnez \u00ab\u00a0Base de donn\u00e9es\u00a0\u00bb et dans la zone de liste d\u00e9roulante \u00ab\u00a0\u00c9l\u00e9ment de connexion\u00a0\u00bb, s\u00e9lectionnez une \u00ab\u00a0Connexion de base de donn\u00e9es\u00a0\u00bb configur\u00e9e.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-df1e946 elementor-widget elementor-widget-image\" data-id=\"df1e946\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"299\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-30.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-30.png 485w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-30-300x185.png 300w\" sizes=\"auto, (max-width: 485px) 100vw, 485px\" \/>\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<div class=\"elementor-element elementor-element-fde3c12 elementor-widget elementor-widget-text-editor\" data-id=\"fde3c12\" data-element_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<ul><li>Vous trouverez ci-dessous un exemple de table cr\u00e9\u00e9e dans la base de donn\u00e9es :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7dc7fcb elementor-widget elementor-widget-image\" data-id=\"7dc7fcb\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"75\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-31.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-31.png 601w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-31-300x37.png 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/>\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<div class=\"elementor-element elementor-element-0db0f11 elementor-widget elementor-widget-heading\" data-id=\"0db0f11\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Utilisation des connexions de base de donn\u00e9es avec le pilote (Driver) de base de donn\u00e9es<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-06a4b8e elementor-widget elementor-widget-text-editor\" data-id=\"06a4b8e\" data-element_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<p>L&rsquo;utilisateur peut \u00e9galement configurer une connexion \u00e0 la base de donn\u00e9es similaire \u00e0 une communication de pilote. Dans cette section, l&rsquo;utilisateur apprendra \u00e0 lier une balise \u00e0 un enregistrement de base de donn\u00e9es.<\/p><ul><li>Avec le document Base de donn\u00e9es dans ADISRA SmartView, l&rsquo;utilisateur peut configurer une communication entre une ou plusieurs balises vers une base de donn\u00e9es s\u00e9lectionn\u00e9e.<\/li><li>Cr\u00e9ez un document de base de donn\u00e9es en cliquant avec le bouton gauche sur le n\u0153ud \u00ab\u00a0Divers\u00a0\u00bb et en cliquant avec le bouton droit sur l&rsquo;option \u00ab\u00a0Base de donn\u00e9es\u00a0\u00bb dans le \u00ab\u00a0Nouveau dossier\u00a0\u00bb comme indiqu\u00e9 dans la case rouge ci-dessous.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e2e3c5d elementor-widget elementor-widget-image\" data-id=\"e2e3c5d\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"457\" height=\"282\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-32.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-32.png 457w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-32-300x185.png 300w\" sizes=\"auto, (max-width: 457px) 100vw, 457px\" \/>\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<div class=\"elementor-element elementor-element-ea5efa1 elementor-widget elementor-widget-text-editor\" data-id=\"ea5efa1\" data-element_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<ul><li>Cliquez avec le bouton gauche sur le dossier \u00ab\u00a0Base de donn\u00e9es\u00a0\u00bb nouvellement cr\u00e9\u00e9, puis cliquez avec le bouton droit sur l&rsquo;option \u00ab\u00a0Nouveau document\u00a0\u00bb. Une fen\u00eatre de base de donn\u00e9es s&rsquo;ouvre.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4d92728 elementor-widget elementor-widget-image\" data-id=\"4d92728\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"458\" height=\"283\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-33.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-33.png 458w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-33-300x185.png 300w\" sizes=\"auto, (max-width: 458px) 100vw, 458px\" \/>\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<div class=\"elementor-element elementor-element-5e37f1f elementor-widget elementor-widget-text-editor\" data-id=\"5e37f1f\" data-element_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<ul><li>Dans la case \u00ab \u00c9l\u00e9ment de connexion \u00bb, s\u00e9lectionnez une connexion configur\u00e9e et dans la case \u00ab Actions \u00bb, s\u00e9lectionnez le flux directionnel des donn\u00e9es.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-166b780 elementor-widget elementor-widget-text-editor\" data-id=\"166b780\" data-element_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<p>Lire : Les donn\u00e9es circulent uniquement du serveur de base de donn\u00e9es vers le client de base de donn\u00e9es. Le client de base de donn\u00e9es ne peut lire que les donn\u00e9es du serveur de base de donn\u00e9es<\/p><p>Lire\/\u00e9crire : Les donn\u00e9es circulent dans les deux sens, du Serveur vers le Client et du Client vers le Serveur. Le client de base de donn\u00e9es peut lire et \u00e9crire des donn\u00e9es \u00e0 partir du serveur de base de donn\u00e9es<\/p><p>\u00c9crire : Les donn\u00e9es circulent uniquement du client de base de donn\u00e9es vers le serveur de base de donn\u00e9es. \u00a0Le client de base de donn\u00e9es ne peut \u00e9crire des donn\u00e9es que sur le serveur de base de donn\u00e9es<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4631ae1 elementor-widget elementor-widget-image\" data-id=\"4631ae1\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"470\" height=\"289\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-34.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-34.png 470w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-34-300x184.png 300w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/>\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<div class=\"elementor-element elementor-element-6edeb07 elementor-widget elementor-widget-text-editor\" data-id=\"6edeb07\" data-element_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<ul><li>Dans la zone \u00ab Requ\u00eates \u00bb (Queries), cliquez sur le bouton \u00ab Nouveau \u00bb, nommez la requ\u00eate et cliquez sur \u00ab OK \u00bb.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-592952e elementor-widget elementor-widget-image\" data-id=\"592952e\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"469\" height=\"289\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-35.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-35.png 469w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-35-300x185.png 300w\" sizes=\"auto, (max-width: 469px) 100vw, 469px\" \/>\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<div class=\"elementor-element elementor-element-9a66195 elementor-widget elementor-widget-text-editor\" data-id=\"9a66195\" data-element_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<ul><li>Dans la zone de liste d\u00e9roulante \u00ab Table \u00bb, s\u00e9lectionnez la table configur\u00e9e dans la base de donn\u00e9es. Dans les cases \u00ab\u00a0Champ cl\u00e9\u00a0\u00bb, \u00ab\u00a0Champ de valeur\u00a0\u00bb, \u00ab\u00a0Champ d&rsquo;horodatage\u00a0\u00bb et \u00ab\u00a0Champ de qualit\u00e9\u00a0\u00bb, s\u00e9lectionnez les colonnes configur\u00e9es \u00e0 partir du tableau pr\u00e9c\u00e9demment s\u00e9lectionn\u00e9.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1d6f5fb elementor-widget elementor-widget-image\" data-id=\"1d6f5fb\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"495\" height=\"305\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-36.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-36.png 495w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-36-300x185.png 300w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/>\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<div class=\"elementor-element elementor-element-8f20e21 elementor-widget elementor-widget-text-editor\" data-id=\"8f20e21\" data-element_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<ul><li>Dans la zone \u00ab\u00a0Liste des balises\u00a0\u00bb, double-cliquez sur la cellule de la colonne Balise (comme indiqu\u00e9 par la case rouge dans l&rsquo;image ci-dessous), puis cliquez sur le bouton \u00ab\u00a0&#8230;\u00a0\u00bb ; cette action ouvrira la fen\u00eatre \u00ab TagBrowser \u00bb pour que l&rsquo;utilisateur choisisse une balise.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9bf6101 elementor-widget elementor-widget-image\" data-id=\"9bf6101\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"498\" height=\"306\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-37.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-37.png 498w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-37-300x184.png 300w\" sizes=\"auto, (max-width: 498px) 100vw, 498px\" \/>\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<div class=\"elementor-element elementor-element-01582a2 elementor-widget elementor-widget-text-editor\" data-id=\"01582a2\" data-element_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<ul><li>Dans la zone Liste des balises, double-cliquez sur la cellule de la colonne \u00c9l\u00e9ment (comme indiqu\u00e9 par la case rouge dans l&rsquo;image ci-dessous), puis cliquez sur le bouton \u00ab &#8230; \u00bb ; cette action ouvrira la fen\u00eatre \u00ab Navigateur d&rsquo;\u00e9l\u00e9ments de base de donn\u00e9es \u00bb pour que l&rsquo;utilisateur choisisse un \u00e9l\u00e9ment de la base de donn\u00e9es \u00e0 associer \u00e0 la balise s\u00e9lectionn\u00e9e. S\u00e9lectionnez une \u00ab requ\u00eate \u00bb cr\u00e9\u00e9e et une \u00ab cl\u00e9 \u00bb dans la table de la base de donn\u00e9es, cliquez sur \u00ab OK \u00bb pour enregistrer le document.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-00931f3 elementor-widget elementor-widget-image\" data-id=\"00931f3\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"474\" height=\"291\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-38.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-38.png 474w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-38-300x184.png 300w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/>\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<div class=\"elementor-element elementor-element-4bab529 elementor-widget elementor-widget-heading\" data-id=\"4bab529\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Utilisation des fonctions de connexion SVDB<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-236dc6d elementor-widget elementor-widget-image\" data-id=\"236dc6d\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"142\" height=\"190\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-39.png\" class=\"attachment-large size-large\" alt=\"\" \/>\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<div class=\"elementor-element elementor-element-2649da9 elementor-widget elementor-widget-text-editor\" data-id=\"2649da9\" data-element_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<ul><li>Comment interroger une base de donn\u00e9es \u00e0 l&rsquo;aide de la \u00ab Connexion globale \u00e0 la base de donn\u00e9es \u00bb et de la \u00ab SVDBConnection \u00bb qui se trouve dans la \u00ab Biblioth\u00e8que de fonctions syst\u00e8me \u00bb. Les exemples suivants aideront l&rsquo;utilisateur \u00e0 comprendre comment la connexion \u00e0 la base de donn\u00e9es globale peut \u00eatre utilis\u00e9e avec la \u00ab\u00a0SVDBConnection\u00a0\u00bb situ\u00e9e dans la \u00ab\u00a0Biblioth\u00e8que de fonctions syst\u00e8me\u00a0\u00bb pour interroger la base de donn\u00e9es. Un chapitre s\u00e9par\u00e9 d\u00e9crira diff\u00e9rentes mani\u00e8res d&rsquo;utiliser la \u00ab SVDBConnection \u00bb pour interroger la base de donn\u00e9es sans utiliser la \u00ab Connexion globale \u00e0 la base de donn\u00e9es \u00bb. L&rsquo;utilisation de l&rsquo;approche \u00ab Connexion \u00e0 la base de donn\u00e9es \u00bb est une approche plus simple et plus directe de la requ\u00eate de base de donn\u00e9es.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-24efc44 elementor-widget elementor-widget-image\" data-id=\"24efc44\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"319\" height=\"376\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-40.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-40.png 319w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-40-255x300.png 255w\" sizes=\"auto, (max-width: 319px) 100vw, 319px\" \/>\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<div class=\"elementor-element elementor-element-00cf260 elementor-widget elementor-widget-text-editor\" data-id=\"00cf260\" data-element_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<p><em>REMARQUE : Les fonctions mises en \u00e9vidence ci-dessus contiennent un param\u00e8tre d&rsquo;entr\u00e9e appel\u00e9 \u00ab connParameter \u00bb qui est le nom de la connexion \u00e0 la base de donn\u00e9es globale.<\/em><\/p><p><strong> Utilisation de la fonction SVDBConnection.Select()<\/strong><\/p><ul><li>L&rsquo;exemple ci-dessous montre un script qui lira les valeurs d&rsquo;une table dans la base de donn\u00e9es et \u00e9crira ces valeurs sur une balise de type de donn\u00e9es refl\u00e8te ce qui peut \u00eatre fait avec la fonction ()<\/li><li>Le type de donn\u00e9es configur\u00e9 :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-04c6624 elementor-widget elementor-widget-image\" data-id=\"04c6624\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"524\" height=\"165\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-41.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-41.png 524w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-41-300x94.png 300w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/>\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<div class=\"elementor-element elementor-element-dab8b1b elementor-widget elementor-widget-text-editor\" data-id=\"dab8b1b\" data-element_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<ul><li>La balise (Tag) configur\u00e9e<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e142f27 elementor-widget elementor-widget-image\" data-id=\"e142f27\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"553\" height=\"100\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-42.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-42.png 553w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-42-300x54.png 300w\" sizes=\"auto, (max-width: 553px) 100vw, 553px\" \/>\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<div class=\"elementor-element elementor-element-68d238a elementor-widget elementor-widget-text-editor\" data-id=\"68d238a\" data-element_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<ul><li>La table dans la base de donn\u00e9es<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-582a23a elementor-widget elementor-widget-image\" data-id=\"582a23a\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"532\" height=\"77\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-43.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-43.png 532w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-43-300x43.png 300w\" sizes=\"auto, (max-width: 532px) 100vw, 532px\" \/>\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<div class=\"elementor-element elementor-element-dc0057d elementor-widget elementor-widget-text-editor\" data-id=\"dc0057d\" data-element_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<ul><li>Le script configur\u00e9. Le script ex\u00e9cutera une requ\u00eate de s\u00e9lection \u00e0 l&rsquo;aide de la \u00ab Connexion \u00e0 la base de donn\u00e9es globale \u2013 PostgresSQL001 \u00bb et tous les enregistrements r\u00e9cup\u00e9r\u00e9s seront enregistr\u00e9s dans la balise de tableau dynamique. Si une exception se produit, le r\u00e9sultat sera nul et le script enregistre une erreur.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-49db539 elementor-widget elementor-widget-image\" data-id=\"49db539\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"256\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-44.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-44.png 601w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-44-300x128.png 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/>\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<div class=\"elementor-element elementor-element-f028bac elementor-widget elementor-widget-text-editor\" data-id=\"f028bac\" data-element_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<p><em>REMARQUE : le premier param\u00e8tre de SVDBConnection.Select est le nom global de la base de donn\u00e9es, dans cet exemple, \u00ab PostgresSQL001 \u00bb.<\/em><\/p><p><strong> Utilisation de la fonction SVDBConnection.Insert()<\/strong><\/p><ul><li>L&rsquo;exemple ci-dessous montre comment cr\u00e9er un script qui ins\u00e9rera une nouvelle entr\u00e9e de table dans la base de donn\u00e9es.<\/li><li>Ci-dessous, la table dans la base de donn\u00e9es avant l&rsquo;ex\u00e9cution du script.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bfb3d60 elementor-widget elementor-widget-image\" data-id=\"bfb3d60\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"501\" height=\"72\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-45.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-45.png 501w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-45-300x43.png 300w\" sizes=\"auto, (max-width: 501px) 100vw, 501px\" \/>\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<div class=\"elementor-element elementor-element-efb5ef4 elementor-widget elementor-widget-text-editor\" data-id=\"efb5ef4\" data-element_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<ul><li>Le script configur\u00e9 :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6705366 elementor-widget elementor-widget-image\" data-id=\"6705366\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"17\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-46.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-46.png 601w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-46-300x8.png 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/>\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<div class=\"elementor-element elementor-element-1c83a32 elementor-widget elementor-widget-text-editor\" data-id=\"1c83a32\" data-element_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<p><em>REMARQUE : le premier param\u00e8tre de SVDBConnection.Insert est le nom global de la base de donn\u00e9es, dans cet exemple, \u00ab PostgresSQL001 \u00bb.<\/em><\/p><ul><li>Le tableau ci-dessous pr\u00e9sente les enregistrements de la base de donn\u00e9es apr\u00e8s l&rsquo;ex\u00e9cution du script :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e45fa53 elementor-widget elementor-widget-image\" data-id=\"e45fa53\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"412\" height=\"85\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-47.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-47.png 412w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-47-300x62.png 300w\" sizes=\"auto, (max-width: 412px) 100vw, 412px\" \/>\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<div class=\"elementor-element elementor-element-6987ed2 elementor-widget elementor-widget-text-editor\" data-id=\"6987ed2\" data-element_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<p><strong>Utilisation de la fonction SVDBConnection.Update()<\/strong><\/p><ul><li>L&rsquo;exemple ci-dessous montre comment cr\u00e9er un script qui modifiera les valeurs d&rsquo;une table de la base de donn\u00e9es.<\/li><li>Ci-dessous, la table dans la base de donn\u00e9es avant l&rsquo;ex\u00e9cution du script :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-29c2534 elementor-widget elementor-widget-image\" data-id=\"29c2534\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"470\" height=\"98\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-48.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-48.png 470w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-48-300x63.png 300w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/>\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<div class=\"elementor-element elementor-element-72d38e6 elementor-widget elementor-widget-text-editor\" data-id=\"72d38e6\" data-element_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<ul><li>Le script configur\u00e9 :\u00a0<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-094e22a elementor-widget elementor-widget-image\" data-id=\"094e22a\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"21\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-58.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-58.png 601w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-58-300x10.png 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/>\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<div class=\"elementor-element elementor-element-6b3e942 elementor-widget elementor-widget-text-editor\" data-id=\"6b3e942\" data-element_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<p><em>REMARQUE : le premier param\u00e8tre de SVDBConnection.Update est le nom global de la base de donn\u00e9es, dans cet exemple, \u00ab PostgresSQL001 \u00bb.<\/em><\/p><ul><li>La table dans la base de donn\u00e9es apr\u00e8s l&rsquo;ex\u00e9cution du script :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-85b7abc elementor-widget elementor-widget-image\" data-id=\"85b7abc\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"470\" height=\"98\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-48-1.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-48-1.png 470w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-48-1-300x63.png 300w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/>\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<div class=\"elementor-element elementor-element-d594767 elementor-widget elementor-widget-text-editor\" data-id=\"d594767\" data-element_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<p><strong>Utilisation de la fonction SVDBConnection.Delete()<\/strong><\/p><ul><li>L&rsquo;exemple ci-dessous montre un script qui supprimera des lignes de la table dans la base de donn\u00e9es.<\/li><li>La table dans la base de donn\u00e9es avant l&rsquo;ex\u00e9cution du script :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-164b4e8 elementor-widget elementor-widget-image\" data-id=\"164b4e8\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"470\" height=\"98\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-48-1.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-48-1.png 470w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-48-1-300x63.png 300w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/>\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<div class=\"elementor-element elementor-element-4fb2711 elementor-widget elementor-widget-text-editor\" data-id=\"4fb2711\" data-element_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<ul><li>Le script configur\u00e9 :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-14f9909 elementor-widget elementor-widget-image\" data-id=\"14f9909\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"601\" height=\"25\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-49.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-49.png 601w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-49-300x12.png 300w\" sizes=\"auto, (max-width: 601px) 100vw, 601px\" \/>\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<div class=\"elementor-element elementor-element-f73e1d5 elementor-widget elementor-widget-text-editor\" data-id=\"f73e1d5\" data-element_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<p><em>REMARQUE : le premier param\u00e8tre de SVDBConnection.Delete est le nom global de la base de donn\u00e9es, dans cet exemple, \u00ab PostgresSQL001 \u00bb.<\/em><\/p><ul><li>La table dans la base de donn\u00e9es apr\u00e8s l&rsquo;ex\u00e9cution du script :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ee82aa1 elementor-widget elementor-widget-image\" data-id=\"ee82aa1\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"501\" height=\"72\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-45.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-45.png 501w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-45-300x43.png 300w\" sizes=\"auto, (max-width: 501px) 100vw, 501px\" \/>\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<div class=\"elementor-element elementor-element-2608407 elementor-widget elementor-widget-heading\" data-id=\"2608407\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Script connexion base de donn\u00e9es<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1076e1b elementor-widget elementor-widget-text-editor\" data-id=\"1076e1b\" data-element_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<p>Dans ce chapitre, l&rsquo;utilisateur verra diff\u00e9rentes mani\u00e8res d&rsquo;interroger la base de donn\u00e9es sans utiliser la \u00ab Connexion globale \u00e0 la base de donn\u00e9es \u00bb.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cda10ff elementor-widget elementor-widget-heading\" data-id=\"cda10ff\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Utilisation du fournisseur de donn\u00e9es .NET<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fd749c4 elementor-widget elementor-widget-text-editor\" data-id=\"fd749c4\" data-element_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<p>The scripts can be written inside a button, user function, service, and trigger. Depending on the database, a different class object will be used. The examples below can only be used to connect to a PostgreSQL database.<\/p><ul><li>The following example creates a table called inside the PostgreSQL database.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-87a2096 elementor-widget elementor-widget-image\" data-id=\"87a2096\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"537\" height=\"335\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-51.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-51.png 537w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-51-300x187.png 300w\" sizes=\"auto, (max-width: 537px) 100vw, 537px\" \/>\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<div class=\"elementor-element elementor-element-5510ae5 elementor-widget elementor-widget-text-editor\" data-id=\"5510ae5\" data-element_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<ul><li>L&rsquo;exemple ci-dessus est une \u00ab\u00a0UserFunction\u00a0\u00bb. Le premier param\u00e8tre de cette fonction est utilis\u00e9 pour cr\u00e9er le nom de la table et le deuxi\u00e8me param\u00e8tre, s&rsquo;il est vrai, supprimera la table avant sa cr\u00e9ation.<\/li><li>Le code suivant ins\u00e8re des valeurs dans une table PostgreSQL.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fa62005 elementor-widget elementor-widget-image\" data-id=\"fa62005\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"577\" height=\"264\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-52-1.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-52-1.png 577w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-52-1-300x137.png 300w\" sizes=\"auto, (max-width: 577px) 100vw, 577px\" \/>\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<div class=\"elementor-element elementor-element-5c8a93e elementor-widget elementor-widget-heading\" data-id=\"5c8a93e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Utiliser la SVDBConnexion<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-710283a elementor-widget elementor-widget-text-editor\" data-id=\"710283a\" data-element_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<p>L&rsquo;utilisateur peut \u00e9galement utiliser la \u00ab SVDBConnection \u00bb dans la biblioth\u00e8que de fonctions syst\u00e8me pour ex\u00e9cuter des requ\u00eates. Il est similaire \u00e0 l&rsquo;exemple de la section \u00ab Utilisation des fonctions de connexion SVDB \u00bb, mais dans cet exemple actuel, l&rsquo;utilisateur devra fournir la cha\u00eene de connexion et le fournisseur. S&rsquo;il vous pla\u00eet jeter un oeil \u00e0 l&rsquo;exemple ci-dessous. Il s\u00e9lectionnera des valeurs dans une table Microsoft SQL Server et ajoutera ces valeurs \u00e0 une balise de tableau dynamique. Il s&rsquo;agit d&rsquo;une approche alternative de requ\u00eate de base de donn\u00e9es.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d9cedbe elementor-widget elementor-widget-image\" data-id=\"d9cedbe\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"481\" height=\"77\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-53.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-53.png 481w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-53-300x48.png 300w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/>\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<div class=\"elementor-element elementor-element-f9540ca elementor-widget elementor-widget-text-editor\" data-id=\"f9540ca\" data-element_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<ul><li>Le type de donn\u00e9es SHIFTS contient les balises suivantes :<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-81f3954 elementor-widget elementor-widget-image\" data-id=\"81f3954\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"481\" height=\"278\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-54.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-54.png 481w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-54-300x173.png 300w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/>\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<div class=\"elementor-element elementor-element-5a92911 elementor-widget elementor-widget-text-editor\" data-id=\"5a92911\" data-element_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<ul><li>Le script suivant a \u00e9t\u00e9 ins\u00e9r\u00e9 dans un service. Comme il a d\u00e9j\u00e0 \u00e9t\u00e9 d\u00e9taill\u00e9, il se connectera \u00e0 une table Microsoft SQL Server, s\u00e9lectionnera toutes les valeurs et cr\u00e9era de nouvelles entr\u00e9es dans la balise de tableau dynamique.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cc22c58 elementor-widget elementor-widget-image\" data-id=\"cc22c58\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"481\" height=\"401\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-55.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-55.png 481w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-55-300x250.png 300w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/>\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<div class=\"elementor-element elementor-element-08a0173 elementor-widget elementor-widget-text-editor\" data-id=\"08a0173\" data-element_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<ul><li>La balise de tableau dynamique \u00e0 associer \u00e0 un objet MultiTagViewer affichera les valeurs de la base de donn\u00e9es lors de l&rsquo;ex\u00e9cution.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-176509a elementor-widget elementor-widget-image\" data-id=\"176509a\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"481\" height=\"210\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-56.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-56.png 481w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-56-300x131.png 300w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/>\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<div class=\"elementor-element elementor-element-60451ef elementor-widget elementor-widget-text-editor\" data-id=\"60451ef\" data-element_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<ul><li>Ex\u00e9cutons l&rsquo;application pour v\u00e9rifier les valeurs s\u00e9lectionn\u00e9es.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-80124de elementor-widget elementor-widget-image\" data-id=\"80124de\" data-element_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 loading=\"lazy\" decoding=\"async\" width=\"481\" height=\"319\" src=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-57.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-57.png 481w, https:\/\/www.adisra.fr\/wp-content\/uploads\/2021\/06\/telechargement-57-300x199.png 300w\" sizes=\"auto, (max-width: 481px) 100vw, 481px\" \/>\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<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Introduction Architecture Conditions Installation d\u2019ADISRA SmartView License ADISRA SmartView Interface Intuitive d\u2019Ing\u00e9nierie Script Obtenir de l&rsquo;aide Modules Ing\u00e9nierie Dur\u00e9e Viewer Sujets d\u2019Actualit\u00e9s Base de donn\u00e9es Documentation MultiTagViewer Remote Viewer S\u00e9curit\u00e9 Biblioth\u00e8que de Fonctions Syst\u00e8me Web ADISRA SmartView .NET Framework 4.8 Base de donn\u00e9es R\u00e9sum\u00e9 Ce document d\u00e9taille les diff\u00e9rentes mani\u00e8res de cr\u00e9er des connexions entre &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.adisra.fr\/?page_id=1381\"> <span class=\"screen-reader-text\">Base de donn\u00e9es<\/span> Lire la suite\u00a0\u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"class_list":["post-1381","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.adisra.fr\/index.php?rest_route=\/wp\/v2\/pages\/1381","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.adisra.fr\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.adisra.fr\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.adisra.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.adisra.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1381"}],"version-history":[{"count":7,"href":"https:\/\/www.adisra.fr\/index.php?rest_route=\/wp\/v2\/pages\/1381\/revisions"}],"predecessor-version":[{"id":7563,"href":"https:\/\/www.adisra.fr\/index.php?rest_route=\/wp\/v2\/pages\/1381\/revisions\/7563"}],"wp:attachment":[{"href":"https:\/\/www.adisra.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}