{"id":22454,"date":"2014-11-20T09:03:24","date_gmt":"2014-11-20T09:03:24","guid":{"rendered":"http:\/\/www.labeljoy.com\/aide\/loading-data-from-a-professional-database\/"},"modified":"2015-02-03T14:52:14","modified_gmt":"2015-02-03T14:52:14","slug":"importer-les-donnees-depuis-une-base-de-donnees-professionnelle","status":"publish","type":"page","link":"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/","title":{"rendered":"Importer les donn\u00e9es depuis une base de donn\u00e9es professionnelle"},"content":{"rendered":"<div data-partent=\"19635\" class=\"callout callout-warning\">\n<h4>Cette page fait r\u00e9f\u00e9rence \u00e0 Labeljoy 5, qui n&rsquo;est pas notre derni\u00e8re version.<\/h4>\n<p>Effectuez une <a href=\"\/fr\/achat\/\">mise \u00e0 niveau vers Labeljoy 6<\/a> pour obtenir la derni\u00e8re version du logiciel avec toutes ses fonctionnalit\u00e9s \u00e9tonnantes ou, si vous l\u2019utilisez d\u00e9j\u00e0, visitez le <a href=\"\/help-lj6\/\">guide de l\u2019utilisateur de Labeljoy 6<\/a>.<\/p>\n<\/div>\n<div id=\"help-guide\">\n\r\n<p class=\"title\">importer les donn\u00e9es depuis une base de donn\u00e9es professionnelle<\/p>\r\n<p class=\"body\">Labeljoy permet de <strong>se connecter \u00e0 une base de donn\u00e9es professionnelle<\/strong> et charger les donn\u00e9es \u00e0 \u00eatre utilis\u00e9s sur les \u00e9tiquettes. <br\/>\r\n  Les bases de donn\u00e9es support\u00e9es sont les suivantes:<\/p>\r\n<ul>\r\n  <li class=\"body\"><strong>MySql<\/strong><\/li>\r\n  <li class=\"body\"><strong>Oracle<\/strong><\/li>\r\n  <li class=\"body\"><strong>SQL Server<\/strong><\/li>\r\n<\/ul>\r\n<p class=\"body\">Dans les propri\u00e9t\u00e9s du groupe (onglet <em>Donn\u00e9es Source<\/em>), selon le type de base de donn\u00e9es s\u00e9lectionn\u00e9e, vous verrez les <strong>champs n\u00e9cessaires \u00e0 se connecter<\/strong>. <br\/>\r\n  Remplissez les champs, en ins\u00e9rant les <strong>param\u00e8tres de connexion<\/strong>, puis cliquez sur le bouton <em>Charger sch\u00e9ma <\/em>(ou <em>Charger feuilles<\/em>) pour charger la liste des tables dans la base de donn\u00e9es que vous avez s\u00e9lectionn\u00e9. <\/p>\r\n<p class=\"note\"><strong>Note<\/strong>:<br>\r\n  Nous conseillons d'utiliser la <a href=\"http:\/\/www.labeljoy.com\/fr\/aide\/procedure-guidee-pour-la-connexion-a-une-source-de-donnees\/\">procedure guid\u00e9e <\/a>pour se connecter \u00e0 une source de donn\u00e9es de ce type. <\/p>\r\n<p class=\"body\">Une fois charg\u00e9 la liste des tables, vous pouvez s\u00e9lectionner celle qui contient les donn\u00e9es que vous souhaitez voir appara\u00eetre sur les \u00e9tiquettes. <br\/>\r\n  Vous pouvez \u00e9galement s\u00e9lectionner le dernier \u00e9l\u00e9ment <em>Requ\u00eate SQL <\/em>pour taper une instruction SQL sp\u00e9cifie \u00e0 fin de charger les donn\u00e9es. <\/p>\r\n<p class=\"note\"><strong>Note<\/strong>:<br>\r\n  Sur <strong>internet<\/strong>, il y a des <strong>nombreuses ressources <\/strong>qui vous permettent d'apprendre le fonctionnement de base du langage SQL.\r\n  Par exemple:<br>\r\n  <br>\r\n  <a href=\"http:\/\/fr.wikipedia.org\/wiki\/Structured_Query_Language\">http:\/\/fr.wikipedia.org\/wiki\/Structured_Query_Language<\/a><br>\r\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Cette page fait r\u00e9f\u00e9rence \u00e0 Labeljoy 5, qui n&rsquo;est pas notre derni\u00e8re version. Effectuez une mise \u00e0 niveau vers Labeljoy 6 pour obtenir la derni\u00e8re version du logiciel avec toutes ses fonctionnalit\u00e9s \u00e9tonnantes ou, si vous l\u2019utilisez d\u00e9j\u00e0, visitez le guide de l\u2019utilisateur de Labeljoy 6.<\/p>\n","protected":false},"author":8,"featured_media":0,"parent":22289,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"page-template-left-sidebar.php","meta":{"inline_featured_image":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":{"0":"post-22454","1":"page","2":"type-page","3":"status-publish","5":"infinite-scroll-item"},"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Labeljoy | Logiciel d\u2019impression d\u2019\u00e9tiquettes et Cr\u00e9ateur d\u2019\u00e9tiquettes code-barres | Lable software | Barcode and QR code generation program\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Importer les donn\u00e9es depuis une base de donn\u00e9es professionnelle\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.labeljoy.com\/wp-content\/uploads\/2022\/01\/logo.svg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.labeljoy.com\/wp-content\/uploads\/2022\/01\/logo.svg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2014-11-20T09:03:24+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2015-02-03T14:52:14+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Importer les donn\u00e9es depuis une base de donn\u00e9es professionnelle\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.labeljoy.com\/wp-content\/uploads\/2022\/01\/logo.svg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/aide\\\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/aide\\\/#listItem\",\"name\":\"Aide\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/aide\\\/#listItem\",\"position\":2,\"name\":\"Aide\",\"item\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/aide\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/aide\\\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\\\/#listItem\",\"name\":\"Importer les donn\\u00e9es depuis une base de donn\\u00e9es professionnelle\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/aide\\\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\\\/#listItem\",\"position\":3,\"name\":\"Importer les donn\\u00e9es depuis une base de donn\\u00e9es professionnelle\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/aide\\\/#listItem\",\"name\":\"Aide\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/#organization\",\"name\":\"Labeljoy | Logiciel d\\u2019impression d\\u2019\\u00e9tiquettes et Cr\\u00e9ateur d\\u2019\\u00e9tiquettes code-barres\",\"description\":\"Lable software | Barcode and QR code generation program\",\"url\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.labeljoy.com\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/logo.svg\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/aide\\\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\\\/#organizationLogo\",\"width\":236,\"height\":60},\"image\":{\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/aide\\\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\\\/#organizationLogo\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/aide\\\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\\\/#webpage\",\"url\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/aide\\\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\\\/\",\"name\":\"Importer les donn\\u00e9es depuis une base de donn\\u00e9es professionnelle\",\"inLanguage\":\"fr-FR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/aide\\\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\\\/#breadcrumblist\"},\"datePublished\":\"2014-11-20T09:03:24+00:00\",\"dateModified\":\"2015-02-03T14:52:14+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/#website\",\"url\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/\",\"name\":\"Labeljoy | Best Barcode Label Printing software, EAN Barcode Design & Generator\",\"description\":\"Lable software | Barcode and QR code generation program\",\"inLanguage\":\"fr-FR\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Importer les donn\u00e9es depuis une base de donn\u00e9es professionnelle","description":"","canonical_url":"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/fr\/#listItem","position":1,"name":"Home","item":"https:\/\/www.labeljoy.com\/fr\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/fr\/aide\/#listItem","name":"Aide"}},{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/fr\/aide\/#listItem","position":2,"name":"Aide","item":"https:\/\/www.labeljoy.com\/fr\/aide\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/#listItem","name":"Importer les donn\u00e9es depuis une base de donn\u00e9es professionnelle"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/fr\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/#listItem","position":3,"name":"Importer les donn\u00e9es depuis une base de donn\u00e9es professionnelle","previousItem":{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/fr\/aide\/#listItem","name":"Aide"}}]},{"@type":"Organization","@id":"https:\/\/www.labeljoy.com\/fr\/#organization","name":"Labeljoy | Logiciel d\u2019impression d\u2019\u00e9tiquettes et Cr\u00e9ateur d\u2019\u00e9tiquettes code-barres","description":"Lable software | Barcode and QR code generation program","url":"https:\/\/www.labeljoy.com\/fr\/","logo":{"@type":"ImageObject","url":"https:\/\/www.labeljoy.com\/wp-content\/uploads\/2022\/01\/logo.svg","@id":"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/#organizationLogo","width":236,"height":60},"image":{"@id":"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/#organizationLogo"}},{"@type":"WebPage","@id":"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/#webpage","url":"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/","name":"Importer les donn\u00e9es depuis une base de donn\u00e9es professionnelle","inLanguage":"fr-FR","isPartOf":{"@id":"https:\/\/www.labeljoy.com\/fr\/#website"},"breadcrumb":{"@id":"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/#breadcrumblist"},"datePublished":"2014-11-20T09:03:24+00:00","dateModified":"2015-02-03T14:52:14+00:00"},{"@type":"WebSite","@id":"https:\/\/www.labeljoy.com\/fr\/#website","url":"https:\/\/www.labeljoy.com\/fr\/","name":"Labeljoy | Best Barcode Label Printing software, EAN Barcode Design & Generator","description":"Lable software | Barcode and QR code generation program","inLanguage":"fr-FR","publisher":{"@id":"https:\/\/www.labeljoy.com\/fr\/#organization"}}]},"og:locale":"fr_FR","og:site_name":"Labeljoy | Logiciel d\u2019impression d\u2019\u00e9tiquettes et Cr\u00e9ateur d\u2019\u00e9tiquettes code-barres | Lable software | Barcode and QR code generation program","og:type":"article","og:title":"Importer les donn\u00e9es depuis une base de donn\u00e9es professionnelle","og:url":"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/","og:image":"https:\/\/www.labeljoy.com\/wp-content\/uploads\/2022\/01\/logo.svg","og:image:secure_url":"https:\/\/www.labeljoy.com\/wp-content\/uploads\/2022\/01\/logo.svg","article:published_time":"2014-11-20T09:03:24+00:00","article:modified_time":"2015-02-03T14:52:14+00:00","twitter:card":"summary","twitter:title":"Importer les donn\u00e9es depuis une base de donn\u00e9es professionnelle","twitter:image":"https:\/\/www.labeljoy.com\/wp-content\/uploads\/2022\/01\/logo.svg"},"aioseo_meta_data":{"post_id":"22454","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2022-01-14 10:32:34","updated":"2026-05-23 12:10:18","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.labeljoy.com\/fr\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.labeljoy.com\/fr\/aide\/\" title=\"Aide\">Aide<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tImporter les donn\u00e9es depuis une base de donn\u00e9es professionnelle\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.labeljoy.com\/fr\/"},{"label":"Aide","link":"https:\/\/www.labeljoy.com\/fr\/aide\/"},{"label":"Importer les donn\u00e9es depuis une base de donn\u00e9es professionnelle","link":"https:\/\/www.labeljoy.com\/fr\/aide\/importer-les-donnees-depuis-une-base-de-donnees-professionnelle\/"}],"_links":{"self":[{"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages\/22454","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/comments?post=22454"}],"version-history":[{"count":3,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages\/22454\/revisions"}],"predecessor-version":[{"id":22583,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages\/22454\/revisions\/22583"}],"up":[{"embeddable":true,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages\/22289"}],"wp:attachment":[{"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/media?parent=22454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}