{"id":434,"date":"2022-12-30T10:43:28","date_gmt":"2022-12-30T09:43:28","guid":{"rendered":"https:\/\/www.nicedata.fr\/?p=434"},"modified":"2024-09-30T11:51:29","modified_gmt":"2024-09-30T09:51:29","slug":"configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem","status":"publish","type":"post","link":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/","title":{"rendered":"Configurer un runtime dans Synapse pour la connexion \u00e0 une base de donn\u00e9es On-Prem"},"content":{"rendered":"\n<p>Notre DataLakeHouse n&rsquo;a d&rsquo;utilit\u00e9 que lorsqu&rsquo;on l&rsquo;alimente \u00e0 partir des donn\u00e9es de notre entreprise. Si de plus en plus de sources proviennent maintenant directement du cloud, il reste souvent des donn\u00e9es On-Prem. Dans cet article, nous allons configurer le composant, le runtime, permettant de faire communiquer Azure Synapse Analytics avec nos bases de donn\u00e9es On-Prem.<\/p>\n\n\n\n<p>Pour faire le lien avec notre projet global, nous parlons du chapitre \u00ab\u00a0La \u00ab\u00a0passerelle\u00a0\u00bb vers notre lake\u00a0\u00bb.<\/p>\n\n\n\n<p>La documentation officielle se trouve \u00e0 cette adresse : <a href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/data-factory\/create-self-hosted-integration-runtime?tabs=data-factory\">Create a self-hosted integration runtime &#8211; Azure Data Factory &amp; Azure Synapse | Microsoft Learn<\/a><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Sommaire<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#Quelques_considerations\" >Quelques consid\u00e9rations<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#Configuration_et_installation\" >Configuration et installation<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Quelques_considerations\"><\/span>Quelques consid\u00e9rations<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Dans cet article, je vais proc\u00e9der \u00e0 l&rsquo;installation d&rsquo;un runtime d&rsquo;int\u00e9gration \u00ab\u00a0simple\u00a0\u00bb pour Synapse, il n&rsquo;y a pas de scalabilit\u00e9 ni de haute dispo comme il pourrait \u00eatre n\u00e9cessaire en production pour des applications critiques.<\/p>\n\n\n\n<p>Cependant, cette installation reste parfaitement fonctionnelle et exploitable en production s&rsquo;il n&rsquo;y a rien de critique derri\u00e8re et que vous \u00eates alerte pour une intervention en cas de p\u00e9pin.<\/p>\n\n\n\n<p>D&rsquo;autre part, en suivant cette installation, un runtime sera li\u00e9 \u00e0 un seul environnement Synapse et il vous faudra donc autant de runtime que d&rsquo;environnement.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Configuration_et_installation\"><\/span>Configuration et installation<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La configuration commence directement depuis le studio. Rendez-vous dans \u00ab\u00a0Manage\u00a0\u00bb \/ Integration Runtime\u00a0\u00bb puis de cliquer sur \u00ab\u00a0+ New\u00a0\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"874\" height=\"778\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image.png?resize=874%2C778&#038;ssl=1\" alt=\"\" class=\"wp-image-435\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image.png?w=874&amp;ssl=1 874w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image.png?resize=300%2C267&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image.png?resize=768%2C684&amp;ssl=1 768w\" sizes=\"auto, (max-width: 874px) 100vw, 874px\" \/><figcaption class=\"wp-element-caption\">Cr\u00e9ation d&rsquo;un nouveau RunTime<\/figcaption><\/figure>\n\n\n\n<p>Il existe deux types de runtime. L&rsquo;un qui permet de faire tourner directement nos flux SSIS existants dans le cloud (Lift-and-Shift) et le \u00ab\u00a0Azure Self-Hosted\u00a0\u00bb runtime qui nous permettra d&rsquo;ex\u00e9cuter nos dataflows sur un runtime install\u00e9 sur n&rsquo;importe quelle machine.<br>Nous choisissons donc le \u00ab\u00a0Azure, Self-Hosted\u00a0\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"631\" height=\"504\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-1.png?resize=631%2C504&#038;ssl=1\" alt=\"\" class=\"wp-image-436\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-1.png?w=631&amp;ssl=1 631w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-1.png?resize=300%2C240&amp;ssl=1 300w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><figcaption class=\"wp-element-caption\">Configuration d&rsquo;un Runtime<\/figcaption><\/figure>\n\n\n\n<p>Le Runtime en question peut \u00eatre install\u00e9 sur n&rsquo;importe quelle machine et peux m\u00eame \u00eatre install\u00e9 en mode \u00ab\u00a0Serverless\u00a0\u00bb dans Azure. Dans notre cas, nous allons l&rsquo;installer sur un Serveur OnPrem (Self-Hosted) afin de justement faire la passerelle entre nos bases On-Prem et notre Synapse dans le cloud.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"631\" height=\"506\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-2.png?resize=631%2C506&#038;ssl=1\" alt=\"\" class=\"wp-image-437\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-2.png?w=631&amp;ssl=1 631w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-2.png?resize=300%2C241&amp;ssl=1 300w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><figcaption class=\"wp-element-caption\">Choix Self Hosted<\/figcaption><\/figure>\n\n\n\n<p>La configuration commence par donner un nom \u00e0 notre runtime et \u00e9ventuellement une description. (Etant sur un environnement, je vais installer celui-ci sur ma machine. Je l&rsquo;identifie donc comme tel).<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"659\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-3.png?resize=632%2C659&#038;ssl=1\" alt=\"\" class=\"wp-image-438\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-3.png?w=632&amp;ssl=1 632w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-3.png?resize=288%2C300&amp;ssl=1 288w\" sizes=\"auto, (max-width: 632px) 100vw, 632px\" \/><figcaption class=\"wp-element-caption\">Choix du nom du Runtime<\/figcaption><\/figure>\n\n\n\n<p>Plusieurs m\u00e9thodes d&rsquo;installation s&rsquo;offrent \u00e0 nous, mais auront exactement le m\u00eame r\u00e9sultat. La premi\u00e8re option est utile si l&rsquo;on installe le runtime sur la machine depuis laquelle nous sommes actuellement connect\u00e9s. Ceci est mon cas, car je travaille depuis mon portable et que je vais install\u00e9 pour mon environnement de dev le runtime sur celui-ci.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"634\" height=\"487\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-15.png?resize=634%2C487&#038;ssl=1\" alt=\"\" class=\"wp-image-456\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-15.png?w=634&amp;ssl=1 634w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-15.png?resize=300%2C230&amp;ssl=1 300w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><figcaption class=\"wp-element-caption\">Choix de la m\u00e9thode d&rsquo;installation<\/figcaption><\/figure>\n\n\n\n<p>Nous allons continuer la proc\u00e9dure avec cette option mais avant un petit mot sur la deuxi\u00e8me option.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Option 2: Installation manuelle<\/h4>\n\n\n\n<p>L&rsquo;installation manuelle s&rsquo;effectue en deux \u00e9tapes:<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"635\" height=\"480\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-14.png?resize=635%2C480&#038;ssl=1\" alt=\"\" class=\"wp-image-455\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-14.png?w=635&amp;ssl=1 635w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-14.png?resize=300%2C227&amp;ssl=1 300w\" sizes=\"auto, (max-width: 635px) 100vw, 635px\" \/><figcaption class=\"wp-element-caption\">Installation manuelle<\/figcaption><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li>le t\u00e9l\u00e9chargement et l&rsquo;installation de l&rsquo;ex\u00e9cutable<\/li>\n\n\n\n<li>Enregistrement du runtime en utilisant les clefs d&rsquo;authentification<\/li>\n<\/ol>\n\n\n\n<p>Nous sommes dans un environnement Microsoft donc il n&rsquo;y a rien de bien compliqu\u00e9, tout ce d\u00e9roule en cliquant sur \u00ab\u00a0suivant \/ suivant \/ suivant \/ &#8230;\u00a0\u00bb.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Option 1: Installation automatique<\/h4>\n\n\n\n<p>Le plus ais\u00e9, si nous avons la main sur notre serveur, est encore de lancer l&rsquo;installation directement depuis celui-ci et de choisir l&rsquo;option 1. <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"657\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-4.png?resize=632%2C657&#038;ssl=1\" alt=\"\" class=\"wp-image-439\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-4.png?w=632&amp;ssl=1 632w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-4.png?resize=289%2C300&amp;ssl=1 289w\" sizes=\"auto, (max-width: 632px) 100vw, 632px\" \/><\/figure>\n\n\n\n<p>L&rsquo;installeur se t\u00e9l\u00e9charge et il suffit ensuite de l&rsquo;ex\u00e9cuter.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"362\" height=\"91\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-5.png?resize=362%2C91&#038;ssl=1\" alt=\"\" class=\"wp-image-440\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-5.png?w=362&amp;ssl=1 362w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-5.png?resize=300%2C75&amp;ssl=1 300w\" sizes=\"auto, (max-width: 362px) 100vw, 362px\" \/><figcaption class=\"wp-element-caption\">T\u00e9l\u00e9chargement de l&rsquo;installeur<\/figcaption><\/figure>\n\n\n\n<p>L&rsquo;installation est ensuite enti\u00e8rement automatis\u00e9e.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"786\" height=\"543\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-6.png?resize=786%2C543&#038;ssl=1\" alt=\"\" class=\"wp-image-441\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-6.png?w=786&amp;ssl=1 786w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-6.png?resize=300%2C207&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-6.png?resize=768%2C531&amp;ssl=1 768w\" sizes=\"auto, (max-width: 786px) 100vw, 786px\" \/><figcaption class=\"wp-element-caption\">Installation automatis\u00e9e<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"786\" height=\"544\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-7.png?resize=786%2C544&#038;ssl=1\" alt=\"\" class=\"wp-image-442\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-7.png?w=786&amp;ssl=1 786w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-7.png?resize=300%2C208&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-7.png?resize=768%2C532&amp;ssl=1 768w\" sizes=\"auto, (max-width: 786px) 100vw, 786px\" \/><figcaption class=\"wp-element-caption\">Installation finie<\/figcaption><\/figure>\n\n\n\n<p>Une fois l&rsquo;installation termin\u00e9e, on peut fermer la fen\u00eatre d&rsquo;installation et revenir sur l&rsquo;interface de Synapse pour fermer la fen\u00eatre de configuration de l&rsquo;Integration Runtime.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"615\" height=\"646\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-8.png?resize=615%2C646&#038;ssl=1\" alt=\"\" class=\"wp-image-443\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-8.png?w=615&amp;ssl=1 615w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-8.png?resize=286%2C300&amp;ssl=1 286w\" sizes=\"auto, (max-width: 615px) 100vw, 615px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Options avanc\u00e9es<\/h4>\n\n\n\n<p>Nous ne l&rsquo;utilisons pas dans notre premi\u00e8re installation principalement, car nous sommes sur un environnement de d\u00e9veloppement, mais il est possible de faire de la haute disponibilit\u00e9 et de rendre scalable  notre IR en cr\u00e9ant des n\u0153uds d&rsquo;IR. Globalement, ce sont plusieurs Integration Runtime qui sont regroup\u00e9s pour ne former qu&rsquo;un ! &#8211;> Un Cluster d&rsquo;IR.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"631\" height=\"635\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-10.png?resize=631%2C635&#038;ssl=1\" alt=\"\" class=\"wp-image-445\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-10.png?w=631&amp;ssl=1 631w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-10.png?resize=298%2C300&amp;ssl=1 298w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-10.png?resize=150%2C150&amp;ssl=1 150w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/figure>\n\n\n\n<p>Il est ensuite possible de configurer la mani\u00e8re dont les IR vont s&rsquo;updater directement depuis l&rsquo;interface synapse en utilisant l&rsquo;onglet \u00ab\u00a0Auto update\u00a0\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-9.png?resize=631%2C635&#038;ssl=1\" alt=\"\" class=\"wp-image-444\" width=\"631\" height=\"635\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-9.png?w=631&amp;ssl=1 631w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-9.png?resize=298%2C300&amp;ssl=1 298w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-9.png?resize=150%2C150&amp;ssl=1 150w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/figure>\n\n\n\n<p>A la suite de cette manipulation, nous devons maintenant voir dans la page des runtimes, notre \u00ab\u00a0Self-Hosted\u00a0\u00bb en statut \u00ab\u00a0running\u00a0\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"278\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-11.png?resize=1024%2C278&#038;ssl=1\" alt=\"\" class=\"wp-image-446\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-11.png?resize=1024%2C278&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-11.png?resize=300%2C82&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-11.png?resize=768%2C209&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-11.png?w=1211&amp;ssl=1 1211w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p>Sur le poste de travail \/ serveur, une ic\u00f4ne de notification apparait pour indiquer le statut du runtime.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"288\" height=\"197\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-13.png?resize=288%2C197&#038;ssl=1\" alt=\"\" class=\"wp-image-449\"\/><figcaption class=\"wp-element-caption\">IR d\u00e9marr\u00e9 sur le poste de travail<\/figcaption><\/figure>\n\n\n\n<p>Il est possible de configurer certains param\u00e8tres et d&rsquo;interagir sur notre runtime en double cliquant sur l&rsquo;ic\u00f4ne pour ouvrir sont interface de gestion.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"786\" height=\"558\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-12.png?resize=786%2C558&#038;ssl=1\" alt=\"\" class=\"wp-image-448\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-12.png?w=786&amp;ssl=1 786w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-12.png?resize=300%2C213&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2022\/12\/image-12.png?resize=768%2C545&amp;ssl=1 768w\" sizes=\"auto, (max-width: 786px) 100vw, 786px\" \/><figcaption class=\"wp-element-caption\">Page principale de l&rsquo;IR<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Nous avons maintenant une IR op\u00e9rationnelle qui nous permettra plus tard d&rsquo;importer des donn\u00e9es depuis une base de donn\u00e9es locale (ou autre source).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dans cet article, je vais proc\u00e9der \u00e0 l&rsquo;installation d&rsquo;un runtime d&rsquo;int\u00e9gration \u00ab\u00a0simple\u00a0\u00bb pour Synapse, il n&rsquo;y a pas de scalabilit\u00e9 ni de haute dispo comme il pourrait \u00eatre n\u00e9cessaire en production pour des applications critiques.<\/p>\n","protected":false},"author":2,"featured_media":462,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[76],"tags":[10,9,37,36],"class_list":["post-434","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-synapsedatalake","tag-azure","tag-azure-synapse-analytics","tag-configuration","tag-on-prem"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Configurer un runtime dans Synapse pour la connexion \u00e0 une base de donn\u00e9es On-Prem - NiceData<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Configurer un runtime dans Synapse pour la connexion \u00e0 une base de donn\u00e9es On-Prem - NiceData\" \/>\n<meta property=\"og:description\" content=\"Dans cet article, je vais proc\u00e9der \u00e0 l&#039;installation d&#039;un runtime d&#039;int\u00e9gration &quot;simple&quot; pour Synapse, il n&#039;y a pas de scalabilit\u00e9 ni de haute dispo comme il pourrait \u00eatre n\u00e9cessaire en production pour des applications critiques.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/\" \/>\n<meta property=\"og:site_name\" content=\"NiceData\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-30T09:43:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-30T09:51:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/images.unsplash.com\/photo-1429041966141-44d228a42775?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzIzOTMzMTI&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2500&h=1667\" \/>\n\t<meta property=\"og:image:width\" content=\"2500\" \/>\n\t<meta property=\"og:image:height\" content=\"1667\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jean-Laurent Ferralis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@JLFerralis\" \/>\n<meta name=\"twitter:site\" content=\"@JLFerralis\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jean-Laurent Ferralis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/\"},\"author\":{\"name\":\"Jean-Laurent Ferralis\",\"@id\":\"https:\/\/www.nicedata.fr\/#\/schema\/person\/8d1ad38004d3b0cf6bff7c200c795e19\"},\"headline\":\"Configurer un runtime dans Synapse pour la connexion \u00e0 une base de donn\u00e9es On-Prem\",\"datePublished\":\"2022-12-30T09:43:28+00:00\",\"dateModified\":\"2024-09-30T09:51:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/\"},\"wordCount\":823,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.nicedata.fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/images.unsplash.com\/photo-1429041966141-44d228a42775?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzIzOTMzMTI&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2500&h=1667\",\"keywords\":[\"Azure\",\"Azure Synapse Analytics\",\"Configuration\",\"On-Prem\"],\"articleSection\":[\"Azure Synapse - Datalake\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/\",\"url\":\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/\",\"name\":\"Configurer un runtime dans Synapse pour la connexion \u00e0 une base de donn\u00e9es On-Prem - NiceData\",\"isPartOf\":{\"@id\":\"https:\/\/www.nicedata.fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/images.unsplash.com\/photo-1429041966141-44d228a42775?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzIzOTMzMTI&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2500&h=1667\",\"datePublished\":\"2022-12-30T09:43:28+00:00\",\"dateModified\":\"2024-09-30T09:51:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#primaryimage\",\"url\":\"https:\/\/images.unsplash.com\/photo-1429041966141-44d228a42775?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzIzOTMzMTI&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2500&h=1667\",\"contentUrl\":\"https:\/\/images.unsplash.com\/photo-1429041966141-44d228a42775?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzIzOTMzMTI&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2500&h=1667\",\"width\":2500,\"height\":1667,\"caption\":\"Photo par Modestas Urbonas sur Unsplash\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.nicedata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Configurer un runtime dans Synapse pour la connexion \u00e0 une base de donn\u00e9es On-Prem\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.nicedata.fr\/#website\",\"url\":\"https:\/\/www.nicedata.fr\/\",\"name\":\"NiceData\",\"description\":\"L&#039;expertise Data du sud\",\"publisher\":{\"@id\":\"https:\/\/www.nicedata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.nicedata.fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.nicedata.fr\/#organization\",\"name\":\"NiceData\",\"url\":\"https:\/\/www.nicedata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.nicedata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/11\/NICE-DATA_JLFMod.webp?fit=2493%2C1249&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/11\/NICE-DATA_JLFMod.webp?fit=2493%2C1249&ssl=1\",\"width\":2493,\"height\":1249,\"caption\":\"NiceData\"},\"image\":{\"@id\":\"https:\/\/www.nicedata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/JLFerralis\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.nicedata.fr\/#\/schema\/person\/8d1ad38004d3b0cf6bff7c200c795e19\",\"name\":\"Jean-Laurent Ferralis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/3cbfdae273d44fb82b902a3451eb0db37485119e34cb70c1fdd186c9b731b9f3?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cbfdae273d44fb82b902a3451eb0db37485119e34cb70c1fdd186c9b731b9f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cbfdae273d44fb82b902a3451eb0db37485119e34cb70c1fdd186c9b731b9f3?s=96&d=mm&r=g\",\"caption\":\"Jean-Laurent Ferralis\"},\"description\":\"French Data Professionnal - BI consultant and #sql lover. I also #swimbikerun when possible ! Living in @villedenice\",\"sameAs\":[\"http:\/\/xp-it.com\"],\"url\":\"https:\/\/www.nicedata.fr\/index.php\/author\/jlf\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Configurer un runtime dans Synapse pour la connexion \u00e0 une base de donn\u00e9es On-Prem - NiceData","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/","og_locale":"fr_FR","og_type":"article","og_title":"Configurer un runtime dans Synapse pour la connexion \u00e0 une base de donn\u00e9es On-Prem - NiceData","og_description":"Dans cet article, je vais proc\u00e9der \u00e0 l'installation d'un runtime d'int\u00e9gration \"simple\" pour Synapse, il n'y a pas de scalabilit\u00e9 ni de haute dispo comme il pourrait \u00eatre n\u00e9cessaire en production pour des applications critiques.","og_url":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/","og_site_name":"NiceData","article_published_time":"2022-12-30T09:43:28+00:00","article_modified_time":"2024-09-30T09:51:29+00:00","og_image":[{"height":1667,"width":2500,"url":"https:\/\/images.unsplash.com\/photo-1429041966141-44d228a42775?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzIzOTMzMTI&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2500&h=1667","type":"image\/jpeg"}],"author":"Jean-Laurent Ferralis","twitter_card":"summary_large_image","twitter_creator":"@JLFerralis","twitter_site":"@JLFerralis","twitter_misc":{"\u00c9crit par":"Jean-Laurent Ferralis","Dur\u00e9e de lecture estim\u00e9e":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#article","isPartOf":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/"},"author":{"name":"Jean-Laurent Ferralis","@id":"https:\/\/www.nicedata.fr\/#\/schema\/person\/8d1ad38004d3b0cf6bff7c200c795e19"},"headline":"Configurer un runtime dans Synapse pour la connexion \u00e0 une base de donn\u00e9es On-Prem","datePublished":"2022-12-30T09:43:28+00:00","dateModified":"2024-09-30T09:51:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/"},"wordCount":823,"commentCount":1,"publisher":{"@id":"https:\/\/www.nicedata.fr\/#organization"},"image":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#primaryimage"},"thumbnailUrl":"https:\/\/images.unsplash.com\/photo-1429041966141-44d228a42775?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzIzOTMzMTI&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2500&h=1667","keywords":["Azure","Azure Synapse Analytics","Configuration","On-Prem"],"articleSection":["Azure Synapse - Datalake"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/","url":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/","name":"Configurer un runtime dans Synapse pour la connexion \u00e0 une base de donn\u00e9es On-Prem - NiceData","isPartOf":{"@id":"https:\/\/www.nicedata.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#primaryimage"},"image":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#primaryimage"},"thumbnailUrl":"https:\/\/images.unsplash.com\/photo-1429041966141-44d228a42775?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzIzOTMzMTI&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2500&h=1667","datePublished":"2022-12-30T09:43:28+00:00","dateModified":"2024-09-30T09:51:29+00:00","breadcrumb":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#primaryimage","url":"https:\/\/images.unsplash.com\/photo-1429041966141-44d228a42775?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzIzOTMzMTI&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2500&h=1667","contentUrl":"https:\/\/images.unsplash.com\/photo-1429041966141-44d228a42775?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzIzOTMzMTI&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2500&h=1667","width":2500,"height":1667,"caption":"Photo par Modestas Urbonas sur Unsplash"},{"@type":"BreadcrumbList","@id":"https:\/\/www.nicedata.fr\/index.php\/2022\/12\/30\/configurer-un-runtime-dans-synapse-pour-la-connexion-a-une-base-de-donnees-on-prem\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.nicedata.fr\/"},{"@type":"ListItem","position":2,"name":"Configurer un runtime dans Synapse pour la connexion \u00e0 une base de donn\u00e9es On-Prem"}]},{"@type":"WebSite","@id":"https:\/\/www.nicedata.fr\/#website","url":"https:\/\/www.nicedata.fr\/","name":"NiceData","description":"L&#039;expertise Data du sud","publisher":{"@id":"https:\/\/www.nicedata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.nicedata.fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/www.nicedata.fr\/#organization","name":"NiceData","url":"https:\/\/www.nicedata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.nicedata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/11\/NICE-DATA_JLFMod.webp?fit=2493%2C1249&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/11\/NICE-DATA_JLFMod.webp?fit=2493%2C1249&ssl=1","width":2493,"height":1249,"caption":"NiceData"},"image":{"@id":"https:\/\/www.nicedata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/JLFerralis"]},{"@type":"Person","@id":"https:\/\/www.nicedata.fr\/#\/schema\/person\/8d1ad38004d3b0cf6bff7c200c795e19","name":"Jean-Laurent Ferralis","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/3cbfdae273d44fb82b902a3451eb0db37485119e34cb70c1fdd186c9b731b9f3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3cbfdae273d44fb82b902a3451eb0db37485119e34cb70c1fdd186c9b731b9f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cbfdae273d44fb82b902a3451eb0db37485119e34cb70c1fdd186c9b731b9f3?s=96&d=mm&r=g","caption":"Jean-Laurent Ferralis"},"description":"French Data Professionnal - BI consultant and #sql lover. I also #swimbikerun when possible ! Living in @villedenice","sameAs":["http:\/\/xp-it.com"],"url":"https:\/\/www.nicedata.fr\/index.php\/author\/jlf\/"}]}},"jetpack_featured_media_url":"https:\/\/images.unsplash.com\/photo-1429041966141-44d228a42775?ixid=MnwzNTY4Mjl8MHwxfGFsbHx8fHx8fHx8fDE2NzIzOTMzMTI&ixlib=rb-4.0.3&fm=jpg&q=85&fit=crop&w=2500&h=1667","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts\/434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=434"}],"version-history":[{"count":9,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts\/434\/revisions"}],"predecessor-version":[{"id":704,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts\/434\/revisions\/704"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/media\/462"}],"wp:attachment":[{"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}