{"id":21867,"date":"2014-11-20T09:03:24","date_gmt":"2014-11-20T09:03:24","guid":{"rendered":"http:\/\/www.labeljoy.com\/ayuda\/loading-data-from-a-professional-database\/"},"modified":"2015-01-20T17:24:49","modified_gmt":"2015-01-20T17:24:49","slug":"importar-datos-desde-una-base-de-datos-profesional","status":"publish","type":"page","link":"https:\/\/www.labeljoy.com\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/","title":{"rendered":"Importar datos desde una base de datos profesional"},"content":{"rendered":"<div data-partent=\"19635\" class=\"callout callout-warning\">\n<h4>Esta p\u00e1gina hace referencia a Labeljoy 5, que no es nuestra \u00faltima versi\u00f3n.<\/h4>\n<p><a href=\"\/es\/comprar\/\">Actualice a Labeljoy 6<\/a> para obtener la \u00faltima versi\u00f3n del software con todas sus incre\u00edbles caracter\u00edsticas, o si ya es usuario, visite la <a href=\"\/es\/ayuda-lj6\/\">gu\u00eda del usuario de Labeljoy 6<\/a>.<\/p>\n<\/div>\n<div id=\"help-guide\">\n\r\n<p class=\"title\">importar datos desde una base de datos profesional<\/p>\r\n<p class=\"body\">Labeljoy permite <strong>conectarse a una base de datos profesional<\/strong> y cargar datos que se utilizar\u00e1n en las etiquetas.<br>\r\n  Las bases de datos soportados son:<\/p>\r\n<ul type=disc>\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\">En la ventana de propiedades del grupo (ficha <i>Origen de datos<\/i>), dependiendo del tipo de base de datos seleccionada, se ver\u00e1n los <strong>campos que se deben conectar<\/strong>.<br>\r\n  Rellene los campos, ingresando los <strong>par\u00e1metros de conexi\u00f3n<\/strong> y luego haga clic en el bot\u00f3n <i>Cargar esquema<\/i> (o <i>Carga hojas<\/i>) para cargar la lista de tablas en la base de datos que ha seleccionado.<\/p>\r\n<p class=\"note\"><strong>Nota<\/strong><br>\r\n  Se recomienda utilizar el <a href=\"http:\/\/www.labeljoy.com\/es\/ayuda\/asistente-para-la-conexion-a-una-fuente-de-datos\/\">asistente<\/a> para conectarse a una fuente de datos de este tipo.<\/p>\r\n<p class=\"body\">Una vez cargada la lista de tablas, se puede seleccionar la que contiene los datos que se desea ver en las etiquetas.<br>\r\n  Tambi\u00e9n se puede seleccionar el \u00faltimo elemento de consulta SQL para escribir una sentencia SQL espec\u00edfica para cargar los datos.<\/p>\r\n<p class=\"note\"><strong>Nota<\/strong><br>\r\n  En <strong>Internet<\/strong> hay muchos recursos que permiten aprender el funcionamiento b\u00e1sico del lenguaje SQL. A continuaci\u00f3n se presentan algunos enlaces \u00fatiles:<br>\r\n  <br>\r\n  <a href=\"http:\/\/es.wikipedia.org\/wiki\/SQL\">http:\/\/es.wikipedia.org\/wiki\/SQL<\/a><br>\r\n  <br>\r\n<\/p>\r\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Esta p\u00e1gina hace referencia a Labeljoy 5, que no es nuestra \u00faltima versi\u00f3n. Actualice a Labeljoy 6 para obtener la \u00faltima versi\u00f3n del software con todas sus incre\u00edbles caracter\u00edsticas, o si ya es usuario, visite la gu\u00eda del usuario de Labeljoy 6.<\/p>\n","protected":false},"author":8,"featured_media":0,"parent":21680,"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-21867","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\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"es_ES\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Labeljoy | Software de Impresi\u00f3n de Etiquetas y Generador de C\u00f3digos de Barras | 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=\"Importar datos desde una base de datos profesional\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.labeljoy.com\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/\" \/>\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-01-20T17:24:49+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Importar datos desde una base de datos profesional\" \/>\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\\\/es\\\/ayuda\\\/importar-datos-desde-una-base-de-datos-profesional\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/ayuda\\\/#listItem\",\"name\":\"Ayuda\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/ayuda\\\/#listItem\",\"position\":2,\"name\":\"Ayuda\",\"item\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/ayuda\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/ayuda\\\/importar-datos-desde-una-base-de-datos-profesional\\\/#listItem\",\"name\":\"Importar datos desde una base de datos profesional\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/ayuda\\\/importar-datos-desde-una-base-de-datos-profesional\\\/#listItem\",\"position\":3,\"name\":\"Importar datos desde una base de datos profesional\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/ayuda\\\/#listItem\",\"name\":\"Ayuda\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/#organization\",\"name\":\"Labeljoy | Software de Impresi\\u00f3n de Etiquetas y Generador de C\\u00f3digos de Barras\",\"description\":\"Lable software | Barcode and QR code generation program\",\"url\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.labeljoy.com\\\/wp-content\\\/uploads\\\/2022\\\/01\\\/logo.svg\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/ayuda\\\/importar-datos-desde-una-base-de-datos-profesional\\\/#organizationLogo\",\"width\":236,\"height\":60},\"image\":{\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/ayuda\\\/importar-datos-desde-una-base-de-datos-profesional\\\/#organizationLogo\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/ayuda\\\/importar-datos-desde-una-base-de-datos-profesional\\\/#webpage\",\"url\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/ayuda\\\/importar-datos-desde-una-base-de-datos-profesional\\\/\",\"name\":\"Importar datos desde una base de datos profesional\",\"inLanguage\":\"es-ES\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/ayuda\\\/importar-datos-desde-una-base-de-datos-profesional\\\/#breadcrumblist\"},\"datePublished\":\"2014-11-20T09:03:24+00:00\",\"dateModified\":\"2015-01-20T17:24:49+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/#website\",\"url\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/\",\"name\":\"Labeljoy | Best Barcode Label Printing software, EAN Barcode Design & Generator\",\"description\":\"Lable software | Barcode and QR code generation program\",\"inLanguage\":\"es-ES\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.labeljoy.com\\\/es\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Importar datos desde una base de datos profesional","description":"","canonical_url":"https:\/\/www.labeljoy.com\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/www.labeljoy.com\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/es\/#listItem","position":1,"name":"Home","item":"https:\/\/www.labeljoy.com\/es\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/es\/ayuda\/#listItem","name":"Ayuda"}},{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/es\/ayuda\/#listItem","position":2,"name":"Ayuda","item":"https:\/\/www.labeljoy.com\/es\/ayuda\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/#listItem","name":"Importar datos desde una base de datos profesional"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/es\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/#listItem","position":3,"name":"Importar datos desde una base de datos profesional","previousItem":{"@type":"ListItem","@id":"https:\/\/www.labeljoy.com\/es\/ayuda\/#listItem","name":"Ayuda"}}]},{"@type":"Organization","@id":"https:\/\/www.labeljoy.com\/es\/#organization","name":"Labeljoy | Software de Impresi\u00f3n de Etiquetas y Generador de C\u00f3digos de Barras","description":"Lable software | Barcode and QR code generation program","url":"https:\/\/www.labeljoy.com\/es\/","logo":{"@type":"ImageObject","url":"https:\/\/www.labeljoy.com\/wp-content\/uploads\/2022\/01\/logo.svg","@id":"https:\/\/www.labeljoy.com\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/#organizationLogo","width":236,"height":60},"image":{"@id":"https:\/\/www.labeljoy.com\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/#organizationLogo"}},{"@type":"WebPage","@id":"https:\/\/www.labeljoy.com\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/#webpage","url":"https:\/\/www.labeljoy.com\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/","name":"Importar datos desde una base de datos profesional","inLanguage":"es-ES","isPartOf":{"@id":"https:\/\/www.labeljoy.com\/es\/#website"},"breadcrumb":{"@id":"https:\/\/www.labeljoy.com\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/#breadcrumblist"},"datePublished":"2014-11-20T09:03:24+00:00","dateModified":"2015-01-20T17:24:49+00:00"},{"@type":"WebSite","@id":"https:\/\/www.labeljoy.com\/es\/#website","url":"https:\/\/www.labeljoy.com\/es\/","name":"Labeljoy | Best Barcode Label Printing software, EAN Barcode Design & Generator","description":"Lable software | Barcode and QR code generation program","inLanguage":"es-ES","publisher":{"@id":"https:\/\/www.labeljoy.com\/es\/#organization"}}]},"og:locale":"es_ES","og:site_name":"Labeljoy | Software de Impresi\u00f3n de Etiquetas y Generador de C\u00f3digos de Barras | Lable software | Barcode and QR code generation program","og:type":"article","og:title":"Importar datos desde una base de datos profesional","og:url":"https:\/\/www.labeljoy.com\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/","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-01-20T17:24:49+00:00","twitter:card":"summary","twitter:title":"Importar datos desde una base de datos profesional","twitter:image":"https:\/\/www.labeljoy.com\/wp-content\/uploads\/2022\/01\/logo.svg"},"aioseo_meta_data":{"post_id":"21867","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-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\/es\/\" 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\/es\/ayuda\/\" title=\"Ayuda\">Ayuda<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tImportar datos desde una base de datos profesional\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.labeljoy.com\/es\/"},{"label":"Ayuda","link":"https:\/\/www.labeljoy.com\/es\/ayuda\/"},{"label":"Importar datos desde una base de datos profesional","link":"https:\/\/www.labeljoy.com\/es\/ayuda\/importar-datos-desde-una-base-de-datos-profesional\/"}],"_links":{"self":[{"href":"https:\/\/www.labeljoy.com\/es\/wp-json\/wp\/v2\/pages\/21867","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.labeljoy.com\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.labeljoy.com\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.labeljoy.com\/es\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.labeljoy.com\/es\/wp-json\/wp\/v2\/comments?post=21867"}],"version-history":[{"count":3,"href":"https:\/\/www.labeljoy.com\/es\/wp-json\/wp\/v2\/pages\/21867\/revisions"}],"predecessor-version":[{"id":21933,"href":"https:\/\/www.labeljoy.com\/es\/wp-json\/wp\/v2\/pages\/21867\/revisions\/21933"}],"up":[{"embeddable":true,"href":"https:\/\/www.labeljoy.com\/es\/wp-json\/wp\/v2\/pages\/21680"}],"wp:attachment":[{"href":"https:\/\/www.labeljoy.com\/es\/wp-json\/wp\/v2\/media?parent=21867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}