{"id":567,"date":"2024-05-11T09:28:31","date_gmt":"2024-05-11T07:28:31","guid":{"rendered":"https:\/\/www.nicedata.fr\/?p=567"},"modified":"2024-11-04T15:28:13","modified_gmt":"2024-11-04T14:28:13","slug":"wide-world-importers-bdd-sql","status":"publish","type":"post","link":"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/","title":{"rendered":"Wide World Importers &#8211; BDD source du projet"},"content":{"rendered":"\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\/2024\/05\/11\/wide-world-importers-bdd-sql\/#Introduction\" >Introduction<\/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\/2024\/05\/11\/wide-world-importers-bdd-sql\/#Les_mains_dedans\" >Les mains dedans !<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#Installation_restauration_du_backup_de_la_base_WWI\" >Installation \/ restauration du backup de la base WWI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#Exploration_de_Wide_World_Importers\" >Exploration de Wide World Importers<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Introduction\"><\/span>Introduction<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Dans tout projet d&rsquo;entreprise, nous allons nous connecter \u00e0 nos bases de donn\u00e9es internes (et \u00e9ventuellement des sources externes pour augmenter les n\u00f4tres), mais celles-ci comportent toutes des particularit\u00e9s et sont g\u00e9n\u00e9ralement priv\u00e9es. Afin que vous puissiez suivre le projet \u00ab\u00a0a la lettre\u00a0\u00bb, nous allons utiliser une base de donn\u00e9es publique, mise \u00e0 disposition par Microsoft pour faire la d\u00e9monstration de SQL Serveur.<\/p>\n\n\n\n<p>Nous utiliserons la base Wide Word Importer qui est la base d&rsquo;exemple la plus r\u00e9cente de Microsoft. Nous utiliserons la base Wide Word Importer qui est la base d&rsquo;exemple la plus r\u00e9cente de Microsoft. La documentation est disponible ici : <a href=\"https:\/\/learn.microsoft.com\/fr-fr\/sql\/samples\/wide-world-importers-what-is?view=sql-server-ver16\">Wide World Importers &#8211; Exemple de base de donn\u00e9es pour SQL &#8211; SQL Server | Microsoft Learn<\/a><\/p>\n\n\n\n<p>Nous allons dans cet article \u00ab\u00a0installer\u00a0\u00bb notre base d&rsquo;exemple, la pr\u00e9parer et l&rsquo;inspecter un minimum pour pouvoir d\u00e9buter nos travaux de datalake.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Les_mains_dedans\"><\/span>Les mains dedans !<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><em>Je pars du principe que vous avez d\u00e9j\u00e0 acc\u00e8s \u00e0 un serveur SQL (au moins 2016), que vous pouvez trouver directement sur le site de Microsoft en utilisant la licence \u00ab\u00a0d\u00e9veloppeur\u00a0\u00bb qui vous permettra de l&rsquo;installer en toute l\u00e9galit\u00e9 &#8211;&gt; <a href=\"https:\/\/www.microsoft.com\/fr-fr\/sql-server\/sql-server-downloads\">T\u00e9l\u00e9chargements SQL Server | Microsoft<\/a>. J&rsquo;utilise personnellement la version 2022 (\u00e0 l&rsquo;heure de l&rsquo;\u00e9criture de ce post).<\/em> Si vous choisissez d&rsquo;installer un nouveau serveur, je vous conseille de l&rsquo;installer en langue anglaise. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Installation_restauration_du_backup_de_la_base_WWI\"><\/span>Installation \/ restauration du backup de la base WWI<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Nous allons commencer par t\u00e9l\u00e9charger le backup mis \u00e0 disposition par Microsoft : <a href=\"https:\/\/github.com\/Microsoft\/sql-server-samples\/releases\/download\/wide-world-importers-v1.0\/WideWorldImporters-Full.bak\">WideWorldImporters-Full.bak (github.com)<\/a><\/p>\n\n\n\n<p>Nous allons dans notre exemple utiliser SSMS, l&rsquo;outil standard pour travailler avec un serveur SQL Serveur. Une fois connect\u00e9es \u00e0 notre instance SQL, nous allons proc\u00e9der \u00e0 la restauration du backup pr\u00e9c\u00e9demment t\u00e9l\u00e9charg\u00e9. Pour ce faire, il suffit de faire un clic droit dans l&rsquo;arborescence de notre serveur au niveau \u00ab\u00a0Base de donn\u00e9es\u00a0\u00bb \/ \u00ab\u00a0Databases\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=\"502\" height=\"476\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image.png?resize=502%2C476&#038;ssl=1\" alt=\"\" class=\"wp-image-569\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image.png?w=502&amp;ssl=1 502w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image.png?resize=300%2C284&amp;ssl=1 300w\" sizes=\"auto, (max-width: 502px) 100vw, 502px\" \/><figcaption class=\"wp-element-caption\">Acc\u00e9der au wizard de restauration du backup d&rsquo;une BDD SQL Serveur<\/figcaption><\/figure>\n\n\n\n<p>Nous allons maintenant devoir choisir le backup \u00e0 utiliser. Globalement, nous allons dire dans les diff\u00e9rentes fen\u00eatres que notre source de backup est un fichier, et qu&rsquo;il se trouve \u00e0 un endroit pr\u00e9cis sur notre disque local.<\/p>\n\n\n\n<p><em><strong>Attention<\/strong> : c&rsquo;est l&rsquo;utilisateur qui fait tourner SQL Server qui va effectuer l&rsquo;action et qu&rsquo;il faut donc que cet utilisateur ait acc\u00e8s \u00e0 ce r\u00e9pertoire. Si vous n&rsquo;avez rien configur\u00e9 sp\u00e9cifiquement sur votre serveur, il est probable qu&rsquo;il n&rsquo;ait pas acc\u00e8s \u00e0 votre r\u00e9pertoire \u00ab\u00a0T\u00e9l\u00e9chargements\u00a0\u00bb. Pour des raisons de facilit\u00e9, vous pouvez cr\u00e9er un r\u00e9pertoire dans \u00ab\u00a0C:\u00a0\u00bb et y d\u00e9poser le fichier .bak t\u00e9l\u00e9charg\u00e9.<\/em><\/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=\"591\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-2.png?resize=1024%2C591&#038;ssl=1\" alt=\"\" class=\"wp-image-571\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-2.png?resize=1024%2C591&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-2.png?resize=300%2C173&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-2.png?resize=768%2C443&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-2.png?w=1498&amp;ssl=1 1498w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption class=\"wp-element-caption\">S\u00e9lection de notre fichier de backup<\/figcaption><\/figure>\n\n\n\n<p>Une fois valid\u00e9e, la partie \u00ab\u00a0Destination\u00a0\u00bb du wizard est maintenant configur\u00e9e, et il suffit de valider en cliquant sur \u00ab\u00a0OK\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=\"966\" height=\"504\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-3.png?resize=966%2C504&#038;ssl=1\" alt=\"\" class=\"wp-image-572\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-3.png?w=966&amp;ssl=1 966w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-3.png?resize=300%2C157&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-3.png?resize=768%2C401&amp;ssl=1 768w\" sizes=\"auto, (max-width: 966px) 100vw, 966px\" \/><figcaption class=\"wp-element-caption\">Validation de la restauration du backup<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"964\" height=\"26\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-4.png?resize=964%2C26&#038;ssl=1\" alt=\"\" class=\"wp-image-573\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-4.png?w=964&amp;ssl=1 964w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-4.png?resize=300%2C8&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-4.png?resize=768%2C21&amp;ssl=1 768w\" sizes=\"auto, (max-width: 964px) 100vw, 964px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"371\" height=\"152\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-5.png?resize=371%2C152&#038;ssl=1\" alt=\"\" class=\"wp-image-574\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-5.png?w=371&amp;ssl=1 371w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-5.png?resize=300%2C123&amp;ssl=1 300w\" sizes=\"auto, (max-width: 371px) 100vw, 371px\" \/><\/figure>\n\n\n\n<p>Notre base de donn\u00e9es est maintenant restaur\u00e9e et est accessible sur notre serveur : <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"317\" height=\"298\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-6.png?resize=317%2C298&#038;ssl=1\" alt=\"\" class=\"wp-image-575\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-6.png?w=317&amp;ssl=1 317w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-6.png?resize=300%2C282&amp;ssl=1 300w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><figcaption class=\"wp-element-caption\">WWI est disponible sur notre serveur SQL<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Exploration_de_Wide_World_Importers\"><\/span>Exploration de Wide World Importers<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>En explorant les tables, nous pouvons rapidement voir que notre base contient diff\u00e9rents sch\u00e9mas de donn\u00e9es qui regroupent les donn\u00e9es de diff\u00e9rentes parties de notre entreprise, ainsi que certaines tables sont marqu\u00e9es comme \u00ab\u00a0System-Versioned\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=\"394\" height=\"706\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-7.png?resize=394%2C706&#038;ssl=1\" alt=\"\" class=\"wp-image-576\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-7.png?w=394&amp;ssl=1 394w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-7.png?resize=167%2C300&amp;ssl=1 167w\" sizes=\"auto, (max-width: 394px) 100vw, 394px\" \/><figcaption class=\"wp-element-caption\">Les tables de WWI<\/figcaption><\/figure>\n\n\n\n<p>Ces tables \u00ab\u00a0versionn\u00e9es\u00a0\u00bb utilisent une fonctionnalit\u00e9 SQL Server tr\u00e8s int\u00e9ressante que l&rsquo;on tentera de recr\u00e9er dans notre Datalake. Mais ce que cela nous indique c&rsquo;est que cette base de donn\u00e9es contient un historique et cela sera tr\u00e8s int\u00e9ressant et utile pour notre projet de Datalake. Nous allons pouvoir travailler \u00e0 la cr\u00e9ation d&rsquo;historiques et l&rsquo;utilisation de celui-ci ! <\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Donn\u00e9es d&rsquo;historique<\/h4>\n\n\n\n<p>Prenons l&rsquo;exemple des clients. Une donn\u00e9e qui n\u00e9cessite souvent d&rsquo;\u00eatre trait\u00e9 en \u00ab\u00a0SCD\u00a0\u00bb (pour Slow Changing Dimension, et si vous n&rsquo;\u00eates pas familier avec ce terme je vous invite sur cette page : <a href=\"https:\/\/fr.wikipedia.org\/wiki\/Dimension_%C3%A0_%C3%A9volution_lente\">Dimension \u00e0 \u00e9volution lente \u2014 Wikip\u00e9dia (wikipedia.org)<\/a>). Dans notre base d&rsquo;exemple qui utilise la fonctionnalit\u00e9 d\u00e9di\u00e9e de SQL Serveur, nous pouvons voir que notre table est en faite constitu\u00e9e de deux tables :<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"318\" height=\"146\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-10.png?resize=318%2C146&#038;ssl=1\" alt=\"\" class=\"wp-image-581\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-10.png?w=318&amp;ssl=1 318w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-10.png?resize=300%2C138&amp;ssl=1 300w\" sizes=\"auto, (max-width: 318px) 100vw, 318px\" \/><figcaption class=\"wp-element-caption\">deux tables \u00ab\u00a0Customers\u00a0\u00bb pour le versionning<\/figcaption><\/figure>\n\n\n\n<p>Il est possible de requ\u00eater ces deux tables de fa\u00e7on totalement ind\u00e9pendante : <\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT TOP (1000) *\n  FROM &#x5B;WideWorldImporters].&#x5B;Sales].&#x5B;Customers]\n\nSELECT TOP (1000) *\n  FROM &#x5B;WideWorldImporters].&#x5B;Sales].&#x5B;Customers_Archive]\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"845\" height=\"456\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-11.png?resize=845%2C456&#038;ssl=1\" alt=\"\" class=\"wp-image-582\" style=\"width:845px;height:auto\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-11.png?w=845&amp;ssl=1 845w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-11.png?resize=300%2C162&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-11.png?resize=768%2C414&amp;ssl=1 768w\" sizes=\"auto, (max-width: 845px) 100vw, 845px\" \/><figcaption class=\"wp-element-caption\">Select courant et historique<\/figcaption><\/figure>\n\n\n\n<p>Si cette fonctionnalit\u00e9 propre \u00e0 SQL Server peut \u00eatre int\u00e9ressante, elle ne nous int\u00e9ressera pas particuli\u00e8rement dans nos travaux. Elle nous permettra cependant de travailler sur deux cas de figure diff\u00e9rents que l&rsquo;on pourrait rencontrer dans nos projets de \u00ab\u00a0Prod\u00a0\u00bb : <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Une table non historis\u00e9e qui pr\u00e9sente simplement la valeur courante des donn\u00e9es<\/li>\n\n\n\n<li>Une table historis\u00e9e en mode SCD type 2<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"DonneesMortes\">Donn\u00e9es mortes ?<\/h4>\n\n\n\n<p>Cependant, si nous voyons qu&rsquo;il existe d\u00e9j\u00e0 un historique. A l&rsquo;instant nous avons une base de donn\u00e9es \u00ab\u00a0morte\u00a0\u00bb. C&rsquo;est \u00e0 dire que nous avons restaur\u00e9 un backup mais que celui-ci est fig\u00e9 \u00e0 l&rsquo;instant du backup.<\/p>\n\n\n\n<p>Il suffit d&rsquo;une simple requ\u00eate pour comprendre qu&rsquo;en l&rsquo;\u00e9tat pour travailler sur un datalake qui lui vivra au jour le jour avec des alimentations incr\u00e9mentales, nous allons avoir un probl\u00e8me !<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT max(&#x5B;OrderDate]) FROM &#x5B;WideWorldImporters].&#x5B;Sales].&#x5B;Orders];\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"521\" height=\"162\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-8.png?resize=521%2C162&#038;ssl=1\" alt=\"\" class=\"wp-image-578\" style=\"width:521px;height:auto\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-8.png?w=521&amp;ssl=1 521w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-8.png?resize=300%2C93&amp;ssl=1 300w\" sizes=\"auto, (max-width: 521px) 100vw, 521px\" \/><figcaption class=\"wp-element-caption\">Nos derni\u00e8res commandes datent du 31\/05\/2016 !!<\/figcaption><\/figure>\n\n\n\n<p>Heureusement, Microsoft a pens\u00e9 \u00e0 nous et en continuant notre observation, nous allons trouver des proc\u00e9dures stock\u00e9es tr\u00e8s int\u00e9ressantes :<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"519\" height=\"543\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-9.png?resize=519%2C543&#038;ssl=1\" alt=\"\" class=\"wp-image-580\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-9.png?w=519&amp;ssl=1 519w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-9.png?resize=287%2C300&amp;ssl=1 287w\" sizes=\"auto, (max-width: 519px) 100vw, 519px\" \/><figcaption class=\"wp-element-caption\">Simulation de chargement de donn\u00e9es<\/figcaption><\/figure>\n\n\n\n<p>Grace \u00e0 la proc\u00e9dure \u00ab\u00a0DataLoadSimulation.PopulateDataToCurrentDate\u00a0\u00bb, nous allons pouvoir charger de nouvelles donn\u00e9es dans notre base et la rendre vivante ! La documentation est disponible ici : <a href=\"https:\/\/learn.microsoft.com\/fr-fr\/sql\/samples\/wide-world-importers-generate-data?view=sql-server-ver16\">G\u00e9n\u00e9rer des donn\u00e9es dans les exemples SQL WideWorldImporters &#8211; SQL Server | Microsoft Learn<\/a><\/p>\n\n\n\n<p>Nous allons donc tout de suite combler le vide dans nos donn\u00e9es en utilisant cette proc\u00e9dure. En utilisant le code ci-dessous, vous allez v\u00e9rifier la diff\u00e9rence de date de la commande la plus r\u00e9cente avant et apr\u00e8s la proc\u00e9dure :<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT max(&#x5B;OrderDate]) FROM &#x5B;WideWorldImporters].&#x5B;Sales].&#x5B;Orders];\n\nEXECUTE DataLoadSimulation.PopulateDataToCurrentDate\n    @AverageNumberOfCustomerOrdersPerDay = 60,\n    @SaturdayPercentageOfNormalWorkDay = 50,\n    @SundayPercentageOfNormalWorkDay = 0,\n    @IsSilentMode = 1,\n    @AreDatesPrinted = 1;\n\nSELECT max(&#x5B;OrderDate]) FROM &#x5B;WideWorldImporters].&#x5B;Sales].&#x5B;Orders];\n<\/pre><\/div>\n\n\n<p>Attention, cette instruction peut \u00eatre particuli\u00e8rement longue !!! Chez moi, cela \u00e0 dur\u00e9 6h45 pour charger de juin 2016 \u00e0 aout 2024 !!!<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"705\" height=\"422\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-12.png?resize=705%2C422&#038;ssl=1\" alt=\"\" class=\"wp-image-583\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-12.png?w=705&amp;ssl=1 705w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-12.png?resize=300%2C180&amp;ssl=1 300w\" sizes=\"auto, (max-width: 705px) 100vw, 705px\" \/><figcaption class=\"wp-element-caption\">Chargement des donn\u00e9es jusqu&rsquo;\u00e0 aujourd&rsquo;hui<\/figcaption><\/figure>\n\n\n\n<p>Cela est d\u00fb au fait que cette proc\u00e9dure effectue une boucle pour chaque jour et g\u00e9n\u00e8re la vie d&rsquo;une journ\u00e9e dans notre entreprise. Si l&rsquo;on change les derniers param\u00e8tres par \u00ab\u00a0@IsSilentMode = 0, @AreDatesPrinted = 0\u00a0\u00bb, nous pourrons observer les \u00ab\u00a0messages\u00a0\u00bb d&rsquo;ex\u00e9cution de notre proc\u00e9dure et nous voyons ce qu&rsquo;il se passe : <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"361\" height=\"659\" src=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-13.png?resize=361%2C659&#038;ssl=1\" alt=\"\" class=\"wp-image-584\" srcset=\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-13.png?w=361&amp;ssl=1 361w, https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/08\/image-13.png?resize=164%2C300&amp;ssl=1 164w\" sizes=\"auto, (max-width: 361px) 100vw, 361px\" \/><figcaption class=\"wp-element-caption\">Notre entreprise au jour le jour<\/figcaption><\/figure>\n\n\n\n<p>Nous pouvons sauvegarder ce fichier de log et faire le compte rendu \u00e0 nos clients d\u00e8s maintenant ! Cependant, nous allons plut\u00f4t charger tout cela dans notre Datalake et l&rsquo;exploiter dans PowerBI ! Nous pourrons cependant aller v\u00e9rifier si notre historique de nombre de commandes aper\u00e7u dans PowerBI est bien le m\u00eame que celui g\u00e9n\u00e9r\u00e9 lors de cette proc\u00e9dure.<\/p>\n\n\n\n<p>Une fois ce grand chargement, ce qui nous int\u00e9ressera sera plut\u00f4t de g\u00e9n\u00e9rer \u00ab\u00a0une journ\u00e9e\u00a0\u00bb de donn\u00e9e et cela se fera tr\u00e8s rapidement en r\u00e9utilisant la m\u00eame proc\u00e9dure. A savoir que la proc\u00e9dure g\u00e9n\u00e8re les donn\u00e9es \u00ab\u00a0depuis la derni\u00e8re date de nos donn\u00e9es, jusqu&rsquo;\u00e0 hier\u00a0\u00bb. Nous n&rsquo;aurons donc jamais de donn\u00e9es \u00ab\u00a0du jour\u00a0\u00bb en utilisant cette proc\u00e9dure.<\/p>\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 donc maintenant \u00e0 notre disposition une base de donn\u00e9es op\u00e9rationnelle \/ transactionnelle (OLTP) d&rsquo;entreprise avec des donn\u00e9es d&rsquo;exemple coh\u00e9rente que nous pouvons faire vivre au quotidien.<\/p>\n\n\n\n<p>De plus, Microsoft fournit d&rsquo;autres packages de d\u00e9veloppements et de bases de donn\u00e9es pour montrer l&rsquo;ensemble des fonctionnalit\u00e9s SQL Serveur. En utilisant notamment SSIS pour cr\u00e9er un Data Warehouse. La documentation li\u00e9e est disponible ici : <a href=\"https:\/\/learn.microsoft.com\/fr-fr\/sql\/samples\/wide-world-importers-perform-etl?view=sql-server-ver16\">WideWorldImportersDW &#8211; Workflow ETL &#8211; SQL Server | Microsoft Learn<\/a><\/p>\n\n\n\n<p>Nous pourrons donc nous inspirer de ce qui est fait dans ce workflow \u00ab\u00a0\u00e0 l&rsquo;ancienne \/ OnPrem\u00a0\u00bb, pour cr\u00e9er notre version dans Synapse en utilisant les principes BigData \/ Cloud \/ DataLakeHouse<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nous allons dans cette article \u00ab\u00a0installer\u00a0\u00bb la base d&rsquo;exemple Wide Word Importer de Microsoft, la pr\u00e9parer et l&rsquo;inspecter un minimum pour pouvoir d\u00e9buter nos travaux de Datalake.<\/p>\n","protected":false},"author":2,"featured_media":648,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[76],"tags":[8,77],"class_list":["post-567","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-synapsedatalake","tag-microsoft","tag-sql-serveur"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Wide World Importers - BDD source du projet - NiceData<\/title>\n<meta name=\"description\" content=\"Nous allons &quot;installer&quot; la base sql d&#039;exemple Wide Word Importers de Microsoft pour pouvoir d\u00e9buter nos travaux de Datalake.\" \/>\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\/2024\/05\/11\/wide-world-importers-bdd-sql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wide World Importers - BDD source du projet - NiceData\" \/>\n<meta property=\"og:description\" content=\"Nous allons &quot;installer&quot; la base sql d&#039;exemple Wide Word Importers de Microsoft pour pouvoir d\u00e9buter nos travaux de Datalake.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"NiceData\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-11T07:28:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-04T14:28:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.nicedata.fr\/wp-content\/uploads\/2024\/09\/wide-world-importers-logo-small-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"491\" \/>\n\t<meta property=\"og:image:height\" content=\"212\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"9 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\/2024\/05\/11\/wide-world-importers-bdd-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/\"},\"author\":{\"name\":\"Jean-Laurent Ferralis\",\"@id\":\"https:\/\/www.nicedata.fr\/#\/schema\/person\/8d1ad38004d3b0cf6bff7c200c795e19\"},\"headline\":\"Wide World Importers &#8211; BDD source du projet\",\"datePublished\":\"2024-05-11T07:28:31+00:00\",\"dateModified\":\"2024-11-04T14:28:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/\"},\"wordCount\":1355,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.nicedata.fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/09\/wide-world-importers-logo-small-1.png?fit=491%2C212&ssl=1\",\"keywords\":[\"Microsoft\",\"SQL Serveur\"],\"articleSection\":[\"Azure Synapse - Datalake\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/\",\"url\":\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/\",\"name\":\"Wide World Importers - BDD source du projet - NiceData\",\"isPartOf\":{\"@id\":\"https:\/\/www.nicedata.fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/09\/wide-world-importers-logo-small-1.png?fit=491%2C212&ssl=1\",\"datePublished\":\"2024-05-11T07:28:31+00:00\",\"dateModified\":\"2024-11-04T14:28:13+00:00\",\"description\":\"Nous allons \\\"installer\\\" la base sql d'exemple Wide Word Importers de Microsoft pour pouvoir d\u00e9buter nos travaux de Datalake.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/09\/wide-world-importers-logo-small-1.png?fit=491%2C212&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/09\/wide-world-importers-logo-small-1.png?fit=491%2C212&ssl=1\",\"width\":491,\"height\":212,\"caption\":\"Wide World Importers\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.nicedata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wide World Importers &#8211; BDD source du projet\"}]},{\"@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":"Wide World Importers - BDD source du projet - NiceData","description":"Nous allons \"installer\" la base sql d'exemple Wide Word Importers de Microsoft pour pouvoir d\u00e9buter nos travaux de Datalake.","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\/2024\/05\/11\/wide-world-importers-bdd-sql\/","og_locale":"fr_FR","og_type":"article","og_title":"Wide World Importers - BDD source du projet - NiceData","og_description":"Nous allons \"installer\" la base sql d'exemple Wide Word Importers de Microsoft pour pouvoir d\u00e9buter nos travaux de Datalake.","og_url":"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/","og_site_name":"NiceData","article_published_time":"2024-05-11T07:28:31+00:00","article_modified_time":"2024-11-04T14:28:13+00:00","og_image":[{"width":491,"height":212,"url":"https:\/\/www.nicedata.fr\/wp-content\/uploads\/2024\/09\/wide-world-importers-logo-small-1.png","type":"image\/png"}],"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":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#article","isPartOf":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/"},"author":{"name":"Jean-Laurent Ferralis","@id":"https:\/\/www.nicedata.fr\/#\/schema\/person\/8d1ad38004d3b0cf6bff7c200c795e19"},"headline":"Wide World Importers &#8211; BDD source du projet","datePublished":"2024-05-11T07:28:31+00:00","dateModified":"2024-11-04T14:28:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/"},"wordCount":1355,"commentCount":1,"publisher":{"@id":"https:\/\/www.nicedata.fr\/#organization"},"image":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/09\/wide-world-importers-logo-small-1.png?fit=491%2C212&ssl=1","keywords":["Microsoft","SQL Serveur"],"articleSection":["Azure Synapse - Datalake"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/","url":"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/","name":"Wide World Importers - BDD source du projet - NiceData","isPartOf":{"@id":"https:\/\/www.nicedata.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#primaryimage"},"image":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/09\/wide-world-importers-logo-small-1.png?fit=491%2C212&ssl=1","datePublished":"2024-05-11T07:28:31+00:00","dateModified":"2024-11-04T14:28:13+00:00","description":"Nous allons \"installer\" la base sql d'exemple Wide Word Importers de Microsoft pour pouvoir d\u00e9buter nos travaux de Datalake.","breadcrumb":{"@id":"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#primaryimage","url":"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/09\/wide-world-importers-logo-small-1.png?fit=491%2C212&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/09\/wide-world-importers-logo-small-1.png?fit=491%2C212&ssl=1","width":491,"height":212,"caption":"Wide World Importers"},{"@type":"BreadcrumbList","@id":"https:\/\/www.nicedata.fr\/index.php\/2024\/05\/11\/wide-world-importers-bdd-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.nicedata.fr\/"},{"@type":"ListItem","position":2,"name":"Wide World Importers &#8211; BDD source du projet"}]},{"@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:\/\/i0.wp.com\/www.nicedata.fr\/wp-content\/uploads\/2024\/09\/wide-world-importers-logo-small-1.png?fit=491%2C212&ssl=1","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts\/567","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=567"}],"version-history":[{"count":9,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts\/567\/revisions"}],"predecessor-version":[{"id":808,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/posts\/567\/revisions\/808"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/media\/648"}],"wp:attachment":[{"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nicedata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}