{"id":3805,"date":"2020-03-15T21:04:26","date_gmt":"2020-03-15T20:04:26","guid":{"rendered":"http:\/\/gpmfactory.com\/?p=3805"},"modified":"2020-03-18T18:14:14","modified_gmt":"2020-03-18T17:14:14","slug":"chatbot-realise-avec-oracle-apex","status":"publish","type":"post","link":"https:\/\/gpmfactory.com\/index.php\/2020\/03\/15\/chatbot-realise-avec-oracle-apex\/","title":{"rendered":"ChatBot Builder r\u00e9alis\u00e9 avec Oracle APEX"},"content":{"rendered":"\n\n\n<h2 class=\"wp-block-heading\">Objet<\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><img loading=\"lazy\" decoding=\"async\" width=\"169\" height=\"300\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114446-169x300.png\" alt=\"\" class=\"wp-image-3774\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114446-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114446-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114446-576x1024.png 576w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114446.png 1080w\" sizes=\"auto, (max-width: 169px) 100vw, 169px\" \/><\/figure><\/div>\n\n\n\n<p>Ce post d\u00e9crit un prototype de <strong>ChatBot builder<\/strong> qui a \u00e9t\u00e9 r\u00e9alis\u00e9 avec Oracle Application Express (Apex) et qui est destin\u00e9 \u00e0 Facebook Messenger. Pour illustration, j&rsquo;ai cr\u00e9\u00e9 un bot sp\u00e9cialis\u00e9 pour un syndic immobilier qui illustre la plupart des possibilit\u00e9s que peut offrir un agent conversationnel de type Facebook Messenger. <br>On peut \u00e9galement imaginer des bots simplifi\u00e9s pour des collectivit\u00e9s locales r\u00e9pondant \u00e0 des question usuelles relatives \u00e0 la vie locale, ou bien des bots sp\u00e9cialis\u00e9s pour naviguer dans un catalogue d&rsquo;objets.<\/p>\n\n\n\n<p>La solution retenue repose sur un mod\u00e8le de donn\u00e9es qui contient les diff\u00e9rentes \u00ab\u00a0routes\u00a0\u00bb de r\u00e9ponse ainsi que les mod\u00e8les de message. Ce genre de ChatBot est \u00e0 privil\u00e9gier pour un ensemble fini de r\u00e9ponse. Il n&rsquo;y a aucune intelligence ni moteur NLP. En revanche, aucune programmation n&rsquo;est n\u00e9cessaire: On se contente de remplir les diff\u00e9rentes r\u00e9ponses en r\u00e9action \u00e0 des messages.<br>Ce chatbot tire \u00e9galement parti du moteur de recherche textuel fourni par la Database Oracle et cela offre \u00e0 l&rsquo;utilisateur beaucoup de flexibilit\u00e9 dans la formulation des questions (insensibilit\u00e9 aux voyelles accentu\u00e9es, par exemple, et <em>stemming<\/em> sur les formes conjugu\u00e9es).&nbsp; Il est possible de rajouter un th\u00e9saurus avec des synonymes, ou bien une nomenclature.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Ce prototype inclut la r\u00e9cup\u00e9ration de la g\u00e9olocalisation issue de Facebook Messenger, la r\u00e9cup\u00e9ration des photos \u00e9ventuellement envoy\u00e9es et l&rsquo;authentification sur un site tiers (<em>Account Linking<\/em>).<\/p>\n\n\n\n<p>Plusieurs Chatbots peuvent \u00eatre g\u00e9r\u00e9s par le m\u00eame moteur et peuvent \u00eatre servis par une seule application Facebook.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><b>Pr\u00e9requis<\/b><\/h2>\n\n\n\n<p>Soit on utilise une instance APEX en cloud pr\u00eate \u00e0 l&#8217;emploi soit une installation manuelle on-premise ou en cloud.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Installation APEX on-premise ou Cloud<ul><li>Apex 19.2.x<\/li><li>Database Oracle parmi les variantes suivantes:<ul><li>Standard <\/li><li>Enterprise ou <\/li><li>Express 18c<br>(la variante <a href=\"https:\/\/www.oracle.com\/fr\/database\/technologies\/appdev\/xe.html\">Express Edition<\/a> de la database ne peut fonctionner qu&rsquo;\u00e0 partir de la version 18c car des appels en HTTPS doivent \u00eatre pass\u00e9s depuis le code PL\/SQL, et il faut donc la pr\u00e9sence d&rsquo;un <em>wallet <\/em>pour enregistrer les certificats de Facebook)<\/li><li>Database Service en cloud<\/li><\/ul><\/li><\/ul><\/li><li>Service APEX en cloud<ul><li>Autonomous Transaction processing (ATP)<\/li><li>Always Free Tiers (qui comprend ATP)<\/li><\/ul><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Architecture simplifi\u00e9e<\/h2>\n\n\n\n<p>Le serveur  Chatbot se pr\u00e9sente sous la forme d&rsquo;un package PL\/SQL qui effectue des actions en r\u00e9ponse aux <em>payloads <\/em>JSON envoy\u00e9s par Facebook Messenger. Les \u00e9changes avec Facebook s&rsquo;effectuent en appels REST via un module REST (<a href=\"https:\/\/developers.facebook.com\/docs\/messenger-platform\/webhook\">webhook <\/a>dans la terminologie FB) avec deux <em>endpoints<\/em> :<br>l&rsquo;un en GET pour l&rsquo;enregistrement du chatbot  et l&rsquo;autre en POST pour la r\u00e9ception des messages envoy\u00e9s par FB Messenger.<br>Ces \u00e9changes se font obligatoirement en SSL. Le r\u00f4le du package bot_engine est, in fine, de <a href=\"https:\/\/developers.facebook.com\/docs\/messenger-platform\/send-messages\/templates\">formater des r\u00e9ponses<\/a> au format JSON et de maintenir un contexte par utilisateur. <\/p>\n\n\n\n<p>Un <em>backoffice<\/em>, d\u00e9crit plus bas, permet \u00e0 un administrateur fonctionnel de cr\u00e9er des chatbots,  d\u00e9clarativement . Cela revient \u00e0 d\u00e9finir les r\u00e9ponses sous la forme de widgets visuels tels que carrousels, boutons, <em>quick answers<\/em> etc.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00c9chantillons pour un chatbot de type Syndic immobilier<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Description fonctionnelle<\/h3>\n\n\n\n<p>Ce chatbot est destin\u00e9 aux copropri\u00e9taires d&rsquo;une r\u00e9sidence g\u00e9r\u00e9e par un syndic immobilier. Le but est de faciliter les demandes d&rsquo;informations relatives \u00e0 la copropri\u00e9t\u00e9. Ici, il y aura autant de pages Facebook et de Bots que de r\u00e9sidences, mais c&rsquo;est le m\u00eame moteur APEX qui traitera les diff\u00e9rents chatbots. Dans l&rsquo;exemple qui suit, une int\u00e9gration est effectu\u00e9e avec un service documentaire. C&rsquo;est celui d&rsquo;Oracle qui a \u00e9t\u00e9 utilis\u00e9 (<em>Oracle Content &amp; Experience Cloud<\/em>).<\/p>\n\n\n\n<p>Lors de l&rsquo;interaction avec le Bot, il est affich\u00e9 un menu g\u00e9n\u00e9ral (\u00ab\u00a0<em>call to actions<\/em>\u00ab\u00a0) ce qui facilite le d\u00e9marrage de l&rsquo;\u00e9change avec l&rsquo;utilisateur qui n&rsquo;a plus qu&rsquo;\u00e0 cliquer sur une des grandes cat\u00e9gories propos\u00e9es (<em>Ma Copropri\u00e9t\u00e9<\/em>, <em>Mon syndic<\/em>, <em>Signaler un incident<\/em>, <em>Gestion courante<\/em>).<br>La suite du dialogue est majoritairement bas\u00e9e sur l&#8217;emploi de boutons et de r\u00e9ponses rapides.<\/p>\n\n\n\n<ul class=\"wp-block-gallery columns-3 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114446.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114446.png\" alt=\"\" data-id=\"3774\" class=\"wp-image-3774\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114446.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114446-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114446-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114446-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114505.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114505.png\" alt=\"\" data-id=\"3773\" class=\"wp-image-3773\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114505.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114505-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114505-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114505-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114525.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114525.png\" alt=\"\" data-id=\"3772\" class=\"wp-image-3772\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114525.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114525-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114525-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114525-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>R\u00e9ponses simples<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114604.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114604.png\" alt=\"\" data-id=\"3771\" class=\"wp-image-3771\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114604.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114604-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114604-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114604-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>Call to actions<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114621.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114621.png\" alt=\"\" data-id=\"3770\" class=\"wp-image-3770\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114621.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114621-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114621-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114621-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>Carrousel<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114652.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114652.png\" alt=\"\" data-id=\"3768\" class=\"wp-image-3768\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114652.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114652-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114652-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114652-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>R\u00e9ponse simple<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114709.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114709.png\" alt=\"\" data-id=\"3767\" class=\"wp-image-3767\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114709.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114709-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114709-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114709-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114725.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114725.png\" alt=\"\" data-id=\"3804\" class=\"wp-image-3804\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114725.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114725-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114725-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114725-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114748.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114748.png\" alt=\"\" data-id=\"3803\" class=\"wp-image-3803\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114748.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114748-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114748-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114748-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>Int\u00e9gration Documents<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114820.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114820.png\" alt=\"\" data-id=\"3801\" class=\"wp-image-3801\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114820.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114820-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114820-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114820-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123302.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123302.png\" alt=\"\" data-id=\"3779\" class=\"wp-image-3779\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123302.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123302-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123302-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123302-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114635.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114635.png\" alt=\"\" data-id=\"3769\" class=\"wp-image-3769\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114635.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114635-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114635-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-114635-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123321.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123321.png\" alt=\"\" data-id=\"3778\" class=\"wp-image-3778\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123321.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123321-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123321-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123321-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>Account Linking<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123347.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123347.png\" alt=\"\" data-id=\"3777\" class=\"wp-image-3777\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123347.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123347-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123347-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123347-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>Account Linking<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123424.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123424.png\" alt=\"\" data-id=\"3775\" class=\"wp-image-3775\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123424.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123424-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123424-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-123424-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>D\u00e9blocage d&rsquo;une option<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-121456.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-121456.png\" alt=\"\" data-id=\"3784\" class=\"wp-image-3784\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-121456.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-121456-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-121456-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-121456-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115033.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115033.png\" alt=\"\" data-id=\"3797\" class=\"wp-image-3797\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115033.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115033-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115033-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115033-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>Int\u00e9gration Documents <\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115059.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115059.png\" alt=\"\" data-id=\"3796\" class=\"wp-image-3796\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115059.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115059-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115059-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115059-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>Int\u00e9gration Documents<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115138.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115138.png\" alt=\"\" data-id=\"3794\" class=\"wp-image-3794\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115138.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115138-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115138-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115138-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>Quick answers<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115511.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115511.png\" alt=\"\" data-id=\"3793\" class=\"wp-image-3793\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115511.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115511-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115511-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115511-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>Quick answers<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115900.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115900.png\" alt=\"\" data-id=\"3788\" class=\"wp-image-3788\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115900.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115900-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115900-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115900-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>Remont\u00e9e d&rsquo;une image<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115523.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115523.png\" alt=\"\" data-id=\"3792\" class=\"wp-image-3792\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115523.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115523-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115523-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115523-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115605.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115605.png\" alt=\"\" data-id=\"3791\" class=\"wp-image-3791\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115605.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115605-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115605-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115605-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115830.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115830.png\" alt=\"\" data-id=\"3789\" class=\"wp-image-3789\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115830.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115830-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115830-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115830-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115912.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115912.png\" alt=\"\" data-id=\"3787\" class=\"wp-image-3787\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115912.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115912-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115912-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115912-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>Remont\u00e9e localisation<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115935.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115935.png\" alt=\"\" data-id=\"3786\" class=\"wp-image-3786\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115935.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115935-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115935-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115935-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115958.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1920\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115958.png\" alt=\"\" data-id=\"3785\" class=\"wp-image-3785\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115958.png 1080w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115958-169x300.png 169w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115958-768x1365.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Screenshot_20170720-115958-576x1024.png 576w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><figcaption>Remont\u00e9e localisation<\/figcaption><\/figure><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Backoffice r\u00e9alis\u00e9 avec Oracle Apex<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Principes de construction<\/h3>\n\n\n\n<p>Un mod\u00e8le relationnel a \u00e9t\u00e9 con\u00e7u \u00e0 partir de la signature des APIs de Facebook et ce mod\u00e8le a \u00e9t\u00e9 impl\u00e9ment\u00e9 dans une database Oracle. <br>Pour des raisons de commodit\u00e9s, j&rsquo;ai utilis\u00e9 Oracle APEX pour la r\u00e9alisation d&rsquo;un backoffice \u00e0 partir duquel on peut d\u00e9clarer les diff\u00e9rents chatbots et les questions auxquelles ceux-ci pourront r\u00e9pondre.<\/p>\n\n\n\n<p>A ce stade, il ne s&rsquo;agit que d&rsquo;un prototype et le mod\u00e8le de donn\u00e9es aurait certainement besoin d&rsquo;\u00eatre revisit\u00e9 (v\u00e9rifier les cardinalit\u00e9s, les r\u00e8gles de gestion &#8230;) pour bien correspondre au mod\u00e8le objet de Facebook Messenger.<\/p>\n\n\n\n<ul class=\"wp-block-gallery columns-1 is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-14-1024x576.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-14-1024x576.png\" alt=\"\" data-id=\"4784\" data-link=\"http:\/\/gpmfactory.com\/index.php\/2017\/11\/22\/chatbot-realise-avec-oracle-apex\/2020-03-17-14\/\" class=\"wp-image-4784\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-14-1024x576.png 1024w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-14-300x169.png 300w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-14-768x432.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-14.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><\/li><\/ul>\n\n\n\n<ul class=\"wp-block-gallery columns-1 is-cropped wp-block-gallery-3 is-layout-flex wp-block-gallery-is-layout-flex\"><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-15-1024x576.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-15-1024x576.png\" alt=\"\" data-id=\"4786\" data-link=\"http:\/\/gpmfactory.com\/index.php\/2017\/11\/22\/chatbot-realise-avec-oracle-apex\/2020-03-17-15\/\" class=\"wp-image-4786\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-15-1024x576.png 1024w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-15-300x169.png 300w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-15-768x432.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-15.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Galerie des bots<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-19-1024x576.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-19-1024x576.png\" alt=\"\" data-id=\"4785\" data-link=\"http:\/\/gpmfactory.com\/index.php\/2017\/11\/22\/chatbot-realise-avec-oracle-apex\/2020-03-17-19\/\" class=\"wp-image-4785\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-19-1024x576.png 1024w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-19-300x169.png 300w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-19-768x432.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-19.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Arborescence du dialogue<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture74-1024x576.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture74-1024x576.png\" alt=\"\" data-id=\"3807\" data-link=\"http:\/\/gpmfactory.com\/index.php\/2017\/11\/22\/chatbot-realise-avec-oracle-apex\/capture74\/\" class=\"wp-image-3807\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture74-1024x576.png 1024w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture74-300x169.png 300w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture74-768x432.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture74.png 1339w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture77-1024x561.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"561\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture77-1024x561.png\" alt=\"\" data-id=\"3809\" data-link=\"http:\/\/gpmfactory.com\/index.php\/2017\/11\/22\/chatbot-realise-avec-oracle-apex\/capture77\/\" class=\"wp-image-3809\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture77-1024x561.png 1024w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture77-300x164.png 300w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture77-768x421.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture77.png 1341w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture84-1024x565.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"565\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture84-1024x565.png\" alt=\"\" data-id=\"3810\" data-link=\"http:\/\/gpmfactory.com\/index.php\/2017\/11\/22\/chatbot-realise-avec-oracle-apex\/capture84\/\" class=\"wp-image-3810\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture84-1024x565.png 1024w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture84-300x165.png 300w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture84-768x423.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2017\/11\/Capture84.png 1355w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-18-6-1024x576.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-18-6-1024x576.png\" alt=\"\" data-id=\"4790\" data-link=\"http:\/\/gpmfactory.com\/index.php\/2017\/11\/22\/chatbot-realise-avec-oracle-apex\/2020-03-18-6\/\" class=\"wp-image-4790\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-18-6-1024x576.png 1024w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-18-6-300x169.png 300w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-18-6-768x432.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-18-6.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Log des images renvoy\u00e9es par les utilisateurs<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-21-1024x576.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"http:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-21-1024x576.png\" alt=\"\" data-id=\"4791\" data-link=\"http:\/\/gpmfactory.com\/index.php\/2017\/11\/22\/chatbot-realise-avec-oracle-apex\/2020-03-17-21\/\" class=\"wp-image-4791\" srcset=\"https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-21-1024x576.png 1024w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-21-300x169.png 300w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-21-768x432.png 768w, https:\/\/gpmfactory.com\/wp-content\/uploads\/2020\/03\/2020-03-17-21.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>Ce prototype de chatbot Builder est un bon point de d\u00e9marrage pour tester la validit\u00e9 et\/ou la pertinence d&rsquo;un agent conversationnel  par rapport \u00e0 une situation donn\u00e9e.<\/p>\n\n\n\n<p>Une fois test\u00e9, le chatbot peut \u00eatre d\u00e9ploy\u00e9 en production en utilisant le m\u00eame type de plateforme Oracle APEX. Comme on sollicite essentiellement le moteur PLSQL et que l&rsquo;usage du stockage DB est tr\u00e8s r\u00e9duit, la variante DB Express 18c (qui est gratuite) peut tr\u00e8s bien faire l&rsquo;affaire pour une configuration modeste. <br>Si les contraintes de performances sont \u00e9lev\u00e9es, on pourra augmenter la puissance allou\u00e9e \u00e0 l&rsquo;instance DB  ou transposer le chatbot (aux prix d&rsquo;une r\u00e9-\u00e9criture, il est vrai) sur une plateforme adapt\u00e9e au traitement asynchrone, comme Node.js par exemple.<br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Objet Ce post d\u00e9crit un prototype de ChatBot builder qui a \u00e9t\u00e9 r\u00e9alis\u00e9 avec Oracle Application Express (Apex) et qui est destin\u00e9 \u00e0 Facebook&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"image","meta":{"footnotes":""},"categories":[6],"tags":[],"ppma_author":[150],"class_list":["post-3805","post","type-post","status-publish","format-image","hentry","category-demo-2","post_format-post-format-image"],"authors":[{"term_id":150,"user_id":1,"is_guest":0,"slug":"admin8700","display_name":"Patrick","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/209d5ed69b74d288390621ab4c1d3773?s=96&d=mm&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/3805","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/comments?post=3805"}],"version-history":[{"count":34,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/3805\/revisions"}],"predecessor-version":[{"id":4818,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/3805\/revisions\/4818"}],"wp:attachment":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/media?parent=3805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/categories?post=3805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/tags?post=3805"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/ppma_author?post=3805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}