{"id":32642,"date":"2020-04-18T14:32:38","date_gmt":"2020-04-18T14:32:38","guid":{"rendered":"https:\/\/www.labeljoy.com\/?page_id=32642"},"modified":"2020-04-18T14:32:52","modified_gmt":"2020-04-18T14:32:52","slug":"chargement-de-donnes-partir-dune-base-de-donnes-professionnelle","status":"publish","type":"page","link":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\/","title":{"rendered":"Chargement de donn&eacute;es &agrave; partir d&rsquo;une base de donn&eacute;es professionnelle"},"content":{"rendered":"<div id=\"help-guide\"><!-- lj6_1870.htm -->\n<p class=\"title\">Chargement de donn&eacute;es &agrave; partir d'une base de donn&eacute;es professionnelle<\/p>\n<p>Labeljoy vous permet de vous connecter &agrave; un<strong>&nbsp;syst&egrave;me de base de donn&eacute;es professionnel<\/strong>&nbsp;et de charger les donn&eacute;es &agrave; afficher sur les &eacute;tiquettes.<br> Les syst&egrave;mes de base de donn&eacute;es pris en charge sont :<\/p>\n<ul>\n<li><strong>MySQL<\/strong><\/li>\n<li><strong>Oracle<\/strong><\/li>\n<li><strong>SQL Server<\/strong><\/li>\n<\/ul>\n<p>De plus, vous pouvez sp&eacute;cifier votre propre&nbsp;<strong>cha&icirc;ne de connexion personnalis&eacute;e<\/strong>&nbsp;pour vous connecter &agrave; tout autre type de base de donn&eacute;es professionnelle.<br> Voir&nbsp;<a href=\"https:\/\/www.labeljoy.com\/fr\/help-lj6\/custom-database-connection\/\">ici<\/a>&nbsp;pour plus d'informations.<\/p>\n<p>Dans la bo&icirc;te de dialogue <em>propri&eacute;t&eacute;s du set<\/em>&nbsp;dans l'onglet <em>Source de donn&eacute;es<\/em>&nbsp;selon le type de base de donn&eacute;es s&eacute;lectionn&eacute;, les commandes appropri&eacute;es s'affichent pour <strong>vous permettre de saisir les param&egrave;tres requis pour vous connecter &agrave; la base de donn&eacute;es s&eacute;lectionn&eacute;e<\/strong>.<br> Remplissez les champs requis, puis cliquez sur&nbsp;<em>Charger le sch&eacute;ma<\/em>&nbsp;pour charger la liste des&nbsp;<strong>tables disponibles &agrave;<\/strong>&nbsp;partir de la base de donn&eacute;es s&eacute;lectionn&eacute;e.<\/p>\n<p class=\"note\"><strong>Remarque<\/strong> : <br> Vous pouvez &eacute;galement utiliser l'assistant de <a href=\"https:\/\/www.labeljoy.com\/fr\/help-lj6\/link-data-source-wizard\/\">connexion de source de donn&eacute;es&nbsp;<\/a>pour vous connecter &agrave; une source de donn&eacute;es.<\/p>\n<p>Une fois charg&eacute;e la liste des tableaux, vous pouvez s&eacute;lectionner<strong>&nbsp;celle contenant les donn&eacute;es que vous souhaitez<\/strong>&nbsp;afficher sur les &eacute;tiquettes.<br> Alternativement, vous pouvez s&eacute;lectionner le dernier &eacute;l&eacute;ment&nbsp;<em>SQL<\/em>&nbsp;et entrer&nbsp;<strong>une requ&ecirc;te SQL<\/strong>&nbsp;pour d&eacute;finir les donn&eacute;es &agrave; charger.<\/p>\n<p class=\"note\"><strong>Remarque<\/strong> : <br> Sur le Web, de nombreux sites proposent des ressources qui peuvent vous aider &agrave; apprendre et &agrave; &eacute;crire des requ&ecirc;tes SQL de base. Voici quelques liens utiles :<br> <br> <a href=\"https:\/\/www.sqltutorial.org\/\" target=\"_blank\" rel=\"nofollow\">www.sqltutorial.org<\/a><br> <a href=\"https:\/\/beginner-sql-tutorial.com\/sql.htm\" target=\"_blank\" rel=\"nofollow\">beginner-sql-tutorial.com\/sql.htm<\/a><\/p><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":12,"featured_media":0,"parent":32494,"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-32642","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\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-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=\"Chargement de donn\u00e9es \u00e0 partir d\u2019une base de donn\u00e9es professionnelle\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-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=\"2020-04-18T14:32:38+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-04-18T14:32:52+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Chargement de donn\u00e9es \u00e0 partir d\u2019une 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\\\/guide-de-lutilisateur\\\/chargement-de-donnes-partir-dune-base-de-donnes-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\\\/guide-de-lutilisateur\\\/#listItem\",\"name\":\"Guide de l\\u2019utilisateur\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/guide-de-lutilisateur\\\/#listItem\",\"position\":2,\"name\":\"Guide de l\\u2019utilisateur\",\"item\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/guide-de-lutilisateur\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/guide-de-lutilisateur\\\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\\\/#listItem\",\"name\":\"Chargement de donn&eacute;es &agrave; partir d&rsquo;une base de donn&eacute;es professionnelle\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/guide-de-lutilisateur\\\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\\\/#listItem\",\"position\":3,\"name\":\"Chargement de donn&eacute;es &agrave; partir d&rsquo;une base de donn&eacute;es professionnelle\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/guide-de-lutilisateur\\\/#listItem\",\"name\":\"Guide de l\\u2019utilisateur\"}}]},{\"@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\\\/guide-de-lutilisateur\\\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\\\/#organizationLogo\",\"width\":236,\"height\":60},\"image\":{\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/guide-de-lutilisateur\\\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\\\/#organizationLogo\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/guide-de-lutilisateur\\\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\\\/#webpage\",\"url\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/guide-de-lutilisateur\\\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\\\/\",\"name\":\"Chargement de donn\\u00e9es \\u00e0 partir d\\u2019une base de donn\\u00e9es professionnelle\",\"inLanguage\":\"fr-FR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/fr\\\/guide-de-lutilisateur\\\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\\\/#breadcrumblist\"},\"datePublished\":\"2020-04-18T14:32:38+00:00\",\"dateModified\":\"2020-04-18T14:32:52+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":"Chargement de donn\u00e9es \u00e0 partir d\u2019une base de donn\u00e9es professionnelle","description":"","canonical_url":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-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\/guide-de-lutilisateur\/#listItem","name":"Guide de l\u2019utilisateur"}},{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/#listItem","position":2,"name":"Guide de l\u2019utilisateur","item":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\/#listItem","name":"Chargement de donn&eacute;es &agrave; partir d&rsquo;une base de donn&eacute;es professionnelle"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/fr\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\/#listItem","position":3,"name":"Chargement de donn&eacute;es &agrave; partir d&rsquo;une base de donn&eacute;es professionnelle","previousItem":{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/#listItem","name":"Guide de l\u2019utilisateur"}}]},{"@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\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\/#organizationLogo","width":236,"height":60},"image":{"@id":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\/#organizationLogo"}},{"@type":"WebPage","@id":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\/#webpage","url":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\/","name":"Chargement de donn\u00e9es \u00e0 partir d\u2019une base de donn\u00e9es professionnelle","inLanguage":"fr-FR","isPartOf":{"@id":"https:\/\/www.labeljoy.com\/fr\/#website"},"breadcrumb":{"@id":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\/#breadcrumblist"},"datePublished":"2020-04-18T14:32:38+00:00","dateModified":"2020-04-18T14:32:52+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":"Chargement de donn\u00e9es \u00e0 partir d\u2019une base de donn\u00e9es professionnelle","og:url":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-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":"2020-04-18T14:32:38+00:00","article:modified_time":"2020-04-18T14:32:52+00:00","twitter:card":"summary","twitter:title":"Chargement de donn\u00e9es \u00e0 partir d\u2019une base de donn\u00e9es professionnelle","twitter:image":"https:\/\/www.labeljoy.com\/wp-content\/uploads\/2022\/01\/logo.svg"},"aioseo_meta_data":{"post_id":"32642","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":[],"defaultGraph":"","defaultPostTypeGraph":""},"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-26 05:03:53","updated":"2024-08-19 15:53:59","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\/guide-de-lutilisateur\/\" title=\"Guide de l\u2019utilisateur\">Guide de l\u2019utilisateur<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tChargement de donn\u00e9es \u00e0 partir d\u2019une base de donn\u00e9es professionnelle\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.labeljoy.com\/fr\/"},{"label":"Guide de l\u2019utilisateur","link":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/"},{"label":"Chargement de donn&eacute;es &agrave; partir d&rsquo;une base de donn&eacute;es professionnelle","link":"https:\/\/www.labeljoy.com\/fr\/guide-de-lutilisateur\/chargement-de-donnes-partir-dune-base-de-donnes-professionnelle\/"}],"_links":{"self":[{"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages\/32642","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\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/comments?post=32642"}],"version-history":[{"count":1,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages\/32642\/revisions"}],"predecessor-version":[{"id":32643,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages\/32642\/revisions\/32643"}],"up":[{"embeddable":true,"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/pages\/32494"}],"wp:attachment":[{"href":"https:\/\/www.labeljoy.com\/fr\/wp-json\/wp\/v2\/media?parent=32642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}