{"id":2068,"date":"2015-06-29T16:52:40","date_gmt":"2015-06-29T16:52:40","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=2068"},"modified":"2023-06-27T10:18:45","modified_gmt":"2023-06-27T17:18:45","slug":"using-the-couchbase-odbc-driver-with-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/es\/using-the-couchbase-odbc-driver-with-microsoft-excel\/","title":{"rendered":"Uso del controlador ODBC de Couchbase con Microsoft Excel"},"content":{"rendered":"<p style=\"text-align: left\">Hace un mes,\u00a0<a href=\"https:\/\/www.simba.com\/couchbase\/couchbase-odbc-jdbc-connectivity-solutions-developer-previews-now-available\">Simba Technologies ha anunciado que ha publicado avances para desarrolladores<\/a>\u00a0de los controladores ODBC y JDBC. El a\u00f1o pasado anunciamos que\u00a0<a href=\"https:\/\/www.couchbase.com\/blog\/es\/press-releases\/couchbase-chooses-simba-technologies-to-deliver-odbc-and-jdbc-connectivity\/\">Simba Technologies ha creado estos controladores ODBC y JDBC<\/a>\u00a0para su uso con Couchbase.  Estos controladores permiten a los analistas de datos que utilizan herramientas como Microsoft Excel y Tableau acceder r\u00e1pidamente a los datos de Couchbase Server.<\/p>\n<p style=\"text-align: left\">\u00bfC\u00f3mo se utilizan exactamente estos controladores?  Vamos a ver espec\u00edficamente c\u00f3mo consultar datos utilizando el controlador ODBC con Microsoft Excel para Mac y Windows.<\/p>\n<h2>Requisitos previos<\/h2>\n<ul>\n<li>Servidor Couchbase 4.0+<\/li>\n<li>Microsoft Excel 2011+<\/li>\n<li>Un cubo con datos<\/li>\n<\/ul>\n<h2>Uso con Mac OS X<\/h2>\n<p>Comience descargando e instalando el \u00faltimo archivo DMG del controlador ODBC de Simba para Mac OS.  En este art\u00edculo, utilizaremos la versi\u00f3n 1.0.0.0002 para Mac.<\/p>\n<p>Si utilizas una versi\u00f3n reciente de Mac OS, tendr\u00e1s que descargar otro programa para configurar el controlador reci\u00e9n instalado. \u00a0<a href=\"https:\/\/www.odbcmanager.net\/\">Gestor ODBC<\/a>\u00a0para Mac detectar\u00e1 el controlador instalado y le permitir\u00e1 configurar a qu\u00e9 servidor y puerto conectarse a trav\u00e9s de Microsoft Excel.<\/p>\n<h3>Creaci\u00f3n de \u00edndices de cubos<\/h3>\n<p>Antes de conectarnos a Couchbase Server a trav\u00e9s de Excel, debemos crear \u00edndices de bucket para permitir la ejecuci\u00f3n de consultas N1QL. Con Couchbase Server ejecut\u00e1ndose, desde el Terminal Mac, ejecuta el siguiente comando:<\/p>\n<pre>.\/Applications\/Couchbase Server.app\/Contents\/Resources\/couchbase-core\/bin\/cbq<\/pre>\n<p>Lo anterior lanzar\u00e1 el cliente de consultas de Couchbase. Para los prop\u00f3sitos de este ejemplo, vamos a crear un \u00fanico \u00edndice primario. Con CBQ en ejecuci\u00f3n, introduzca lo siguiente:<\/p>\n<pre>CREATE PRIMARY INDEX def_primary ON `travel-sample` USING gsi;<\/pre>\n<p>\u00a1El cubo ya est\u00e1 listo para N1QL!<\/p>\n<h3>Conexi\u00f3n con Microsoft Excel<\/h3>\n<p>Inicie ODBC Manager y seleccione <strong>Sistema DNS<\/strong>\u00a0o <strong>Usuario DNS<\/strong>\u00a0pesta\u00f1as.  B\u00e1sicamente, lo que se ajuste a sus necesidades.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/original-assets\/using-the-couchbase-odbc-driver-with-microsoft-excel\/1.png\" alt=\"ODBC Manager - Mac\" \/><\/p>\n<p>Cuando est\u00e9 listo, pulse el bot\u00f3n <strong>A\u00f1adir<\/strong>\u00a0y el controlador de Simba Technologies deber\u00eda aparecer en la lista para elegir.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/original-assets\/using-the-couchbase-odbc-driver-with-microsoft-excel\/2.png\" alt=\"ODBC Manager Simba Couchbase - Mac\" \/><\/p>\n<p>D\u00e9 un nombre a la fuente de datos y a\u00f1ada dos pares clave-valor muy importantes:<\/p>\n<pre>host=127.0.0.1\r\nport=8093<\/pre>\n<p>Por supuesto, el host debe coincidir con el host real en el que reside tu Couchbase Server.  En el ejemplo anterior, Couchbase Server se estar\u00eda ejecutando en tu m\u00e1quina local.<\/p>\n<p>Cree una nueva hoja de c\u00e1lculo de Microsoft Excel y haga clic en <strong>Base de datos<\/strong> del <strong>Datos<\/strong> pesta\u00f1a.  Lo mismo se puede conseguir haciendo <strong>Datos -&gt; Obtener datos externos -&gt; Nueva consulta a la base de datos<\/strong> de la barra de herramientas.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/original-assets\/using-the-couchbase-odbc-driver-with-microsoft-excel\/3.png\" alt=\"ODBC Excel Add Database - Mac\" \/><\/p>\n<p>Una vez hecho esto, aparecer\u00e1 una ventana similar a la que hemos visto en el software ODBC Manager.  Si por alguna raz\u00f3n no aparece la entrada del controlador creada anteriormente, sigue adelante y cr\u00e9ala de nuevo.  Haga clic en el bot\u00f3n <strong>Prueba<\/strong> y se te pedir\u00e1 que introduzcas un nombre de usuario y una contrase\u00f1a.  Este es el mismo nombre de usuario y contrase\u00f1a utilizado para conectarse a su servidor Couchbase.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/original-assets\/using-the-couchbase-odbc-driver-with-microsoft-excel\/4.png\" alt=\"ODBC Excel Simba Login - Mac\" \/><\/p>\n<p>Si la prueba se realiza correctamente, pulse el bot\u00f3n <strong>Ok<\/strong> para conectarse y empezar a analizar los datos.<\/p>\n<p>Una vez conectado, deber\u00edas ver una lista de buckets encontrados en tu Couchbase Server.  Ahora tienes dos opciones para consultar los datos.<\/p>\n<h3>Consulta mediante una consulta N1QL<\/h3>\n<p>Haga clic en el bot\u00f3n <strong>Vista SQL<\/strong> tab and enter a query of your choosing. Be aware that the more data you plan on returning, the longer it will take to execute. Assuming the `travel-sample` bucket is installed and has the appropriate indexing configured, enter the following query:<\/p>\n<pre>select * from `travel-sample` limit 30;<\/pre>\n<p>Si existen treinta documentos, se devolver\u00e1n.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/original-assets\/using-the-couchbase-odbc-driver-with-microsoft-excel\/5.png\" alt=\"ODBC Excel Query - Mac\" \/><\/p>\n<p>Haga clic en el bot\u00f3n <strong>Prueba<\/strong> y, a continuaci\u00f3n, pulse <strong>Devolver datos<\/strong> cuando la consulta haya finalizado.<\/p>\n<h3>Consultas con Microsoft Excel Builder<\/h3>\n<p>Assuming the `travel-sample` bucket is installed and has the appropriate indexing configured, select the `travel-sample` bucket and click <strong>A\u00f1adir tabla<\/strong>.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/original-assets\/using-the-couchbase-odbc-driver-with-microsoft-excel\/6.png\" alt=\"ODBC Excel Query Builder - Mac\" \/><\/p>\n<p>Una vez a\u00f1adido, juega con los campos y haz clic en <strong>Devolver datos<\/strong> cuando est\u00e9 listo.<\/p>\n<h2>Uso con Microsoft Windows<\/h2>\n<p>Empiece descargando e instalando el \u00faltimo archivo MSI del controlador ODBC de Simba para Microsoft Windows.<\/p>\n<h3>Creaci\u00f3n de \u00edndices de cubos<\/h3>\n<p>Antes de conectarnos a Couchbase Server a trav\u00e9s de Excel, debemos crear \u00edndices de bucket para permitir la ejecuci\u00f3n de consultas N1QL. Con Couchbase Server en ejecuci\u00f3n, desde el s\u00edmbolo del sistema de Windows, ejecute el siguiente comando:<\/p>\n<pre>C:\/Archivos de programa\/Couchbase\/Server\/bin\/cbq.exe<\/pre>\n<p>Lo anterior lanzar\u00e1 el cliente de consultas de Couchbase. Para los prop\u00f3sitos de este ejemplo, vamos a crear un \u00fanico \u00edndice primario. Con CBQ en ejecuci\u00f3n, introduzca lo siguiente:<\/p>\n<pre>CREATE PRIMARY INDEX def_primary ON `travel-sample` USING gsi;<\/pre>\n<p>\u00a1El cubo ya est\u00e1 listo para N1QL!<\/p>\n<p>Cree una nueva hoja de c\u00e1lculo de Microsoft Excel y haga clic en <strong>De otras fuentes<\/strong> del <strong>Datos<\/strong> ficha. Si su fuente de datos a\u00fan no se ha a\u00f1adido, elija la opci\u00f3n y se le pedir\u00e1 que rellene cuatro elementos.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/original-assets\/using-the-couchbase-odbc-driver-with-microsoft-excel\/7.png\" alt=\"ODBC Excel Create Datasource - Windows\" \/><\/p>\n<ol>\n<li>Name your connection something like `Simba Couchbase`<\/li>\n<li>Elija el <strong>Controlador ODBC de Simba Couchbase<\/strong><\/li>\n<li>If Couchbase Server is running locally, use `127.0.0.1` otherwise enter the IP of your remotely running server. The defaults for everything else is fine<\/li>\n<li>Elija una tabla por defecto para la fuente de datos si la prueba de la conexi\u00f3n se realiza correctamente<\/li>\n<\/ol>\n<p>En este punto, puede seguir con el asistente de creaci\u00f3n de consultas o hacer clic en Cancelar para hacer las cosas por su cuenta.<\/p>\n<h3>Consulta con el Asistente<\/h3>\n<p>Con el asistente iniciado, a\u00f1ada primero las columnas deseadas a su consulta, o todas ellas y haga clic en <strong>Siguiente<\/strong>.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/original-assets\/using-the-couchbase-odbc-driver-with-microsoft-excel\/8.png\" alt=\"ODBC Excel All Columns - Windows\" \/><\/p>\n<p>La siguiente pantalla del asistente le permitir\u00e1 a\u00f1adir cualquier l\u00f3gica de consulta. Si desea devolver todas las filas, simplemente deje el valor por defecto y haga clic en <strong>Siguiente<\/strong>.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/original-assets\/using-the-couchbase-odbc-driver-with-microsoft-excel\/9.png\" alt=\"ODBC Excel Filter Data - Windows\" \/><\/p>\n<p>La siguiente pantalla del asistente le permitir\u00e1 elegir c\u00f3mo ordenar los datos por defecto. Puede elegir el valor por defecto y hacer clic en <strong>Siguiente<\/strong> o especificar alguna clasificaci\u00f3n.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/original-assets\/using-the-couchbase-odbc-driver-with-microsoft-excel\/10.png\" alt=\"ODBC Excel Sort Data - Windows\" \/><\/p>\n<p>Elija <strong>Devolver datos a Microsoft Excel<\/strong> y haga clic en <strong>Terminado<\/strong>.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/original-assets\/using-the-couchbase-odbc-driver-with-microsoft-excel\/11.png\" alt=\"ODBC Excel Return Data - Windows\" \/><\/p>\n<p>Todos los datos basados en los criterios introducidos se introducir\u00e1n en la hoja de c\u00e1lculo.<\/p>\n<h3>Consulta mediante una consulta N1QL<\/h3>\n<p>Haga clic en el bot\u00f3n <strong>SQL<\/strong> button and enter a query of your choosing. Be aware that the more data you plan on returning, the longer it will take to execute. Assuming the `travel-sample` bucket is installed and has the appropriate indexing configured, enter the following query:<\/p>\n<pre>select * from `travel-sample` limit 30;<\/pre>\n<p>Si existen treinta documentos, se devolver\u00e1n.<\/p>\n<p><img decoding=\"async\" src=\"\/wp-content\/original-assets\/using-the-couchbase-odbc-driver-with-microsoft-excel\/12.png\" alt=\"ODBC Excel Query Data - Windows\" \/><\/p>\n<p>Haga clic en <strong>Archivo -&gt; Devolver datos a Microsoft Excel<\/strong> cuando la consulta haya finalizado para devolver los datos a tu hoja de c\u00e1lculo.<\/p>","protected":false},"excerpt":{"rendered":"<p>About a month ago,\u00a0Simba Technologies announced that it had released developer previews\u00a0of the ODBC and JDBC drivers. Last year we announced that\u00a0Simba Technologies was buiding these ODBC and JDBC drivers\u00a0for use with Couchbase. \u00a0These drivers make it possible for data [&hellip;]<\/p>\n","protected":false},"author":63,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[1480,1490],"ppma_author":[9032],"class_list":["post-2068","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-odbc","tag-simba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Using the Couchbase ODBC Driver with Microsoft Excel - The Couchbase Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/es\/using-the-couchbase-odbc-driver-with-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using the Couchbase ODBC Driver with Microsoft Excel\" \/>\n<meta property=\"og:description\" content=\"About a month ago,\u00a0Simba Technologies announced that it had released developer previews\u00a0of the ODBC and JDBC drivers. Last year we announced that\u00a0Simba Technologies was buiding these ODBC and JDBC drivers\u00a0for use with Couchbase. \u00a0These drivers make it possible for data [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/es\/using-the-couchbase-odbc-driver-with-microsoft-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/thepolyglotdeveloper\" \/>\n<meta property=\"article:published_time\" content=\"2015-06-29T16:52:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-27T17:18:45+00:00\" \/>\n<meta name=\"author\" content=\"Nic Raboy, Developer Advocate, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@nraboy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nic Raboy, Developer Advocate, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/\"},\"author\":{\"name\":\"Nic Raboy, Developer Advocate, Couchbase\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/person\\\/bb545ebe83bb2d12f91095811d0a72e1\"},\"headline\":\"Using the Couchbase ODBC Driver with Microsoft Excel\",\"datePublished\":\"2015-06-29T16:52:40+00:00\",\"dateModified\":\"2023-06-27T17:18:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/\"},\"wordCount\":973,\"commentCount\":19,\"publisher\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2022\\\/11\\\/couchbase-nosql-dbaas.png\",\"keywords\":[\"ODBC\",\"SIMBA\"],\"articleSection\":[\"Uncategorized\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/\",\"name\":\"Using the Couchbase ODBC Driver with Microsoft Excel - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2022\\\/11\\\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2015-06-29T16:52:40+00:00\",\"dateModified\":\"2023-06-27T17:18:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2022\\\/11\\\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/1\\\/2022\\\/11\\\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using the Couchbase ODBC Driver with Microsoft Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/admin-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/person\\\/bb545ebe83bb2d12f91095811d0a72e1\",\"name\":\"Nic Raboy, Developer Advocate, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bedeb68368d4681aca4c74fe5f697f0c423b80d498ec50fd915ba018b72c101f?s=96&d=mm&r=g8863514d8bed0cf6080f23db40e00354\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bedeb68368d4681aca4c74fe5f697f0c423b80d498ec50fd915ba018b72c101f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bedeb68368d4681aca4c74fe5f697f0c423b80d498ec50fd915ba018b72c101f?s=96&d=mm&r=g\",\"caption\":\"Nic Raboy, Developer Advocate, Couchbase\"},\"description\":\"Nic Raboy is an advocate of modern web and mobile development technologies. He has experience in Java, JavaScript, Golang and a variety of frameworks such as Angular, NativeScript, and Apache Cordova. Nic writes about his development experiences related to making web and mobile development easier to understand.\",\"sameAs\":[\"https:\\\/\\\/www.thepolyglotdeveloper.com\",\"https:\\\/\\\/www.facebook.com\\\/thepolyglotdeveloper\",\"https:\\\/\\\/x.com\\\/nraboy\"],\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/es\\\/author\\\/nic-raboy-2\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Using the Couchbase ODBC Driver with Microsoft Excel - The Couchbase Blog","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.couchbase.com\/blog\/es\/using-the-couchbase-odbc-driver-with-microsoft-excel\/","og_locale":"es_MX","og_type":"article","og_title":"Using the Couchbase ODBC Driver with Microsoft Excel","og_description":"About a month ago,\u00a0Simba Technologies announced that it had released developer previews\u00a0of the ODBC and JDBC drivers. Last year we announced that\u00a0Simba Technologies was buiding these ODBC and JDBC drivers\u00a0for use with Couchbase. \u00a0These drivers make it possible for data [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/es\/using-the-couchbase-odbc-driver-with-microsoft-excel\/","og_site_name":"The Couchbase Blog","article_author":"https:\/\/www.facebook.com\/thepolyglotdeveloper","article_published_time":"2015-06-29T16:52:40+00:00","article_modified_time":"2023-06-27T17:18:45+00:00","author":"Nic Raboy, Developer Advocate, Couchbase","twitter_card":"summary_large_image","twitter_creator":"@nraboy","twitter_misc":{"Written by":"Nic Raboy, Developer Advocate, Couchbase","Est. reading time":"7 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/"},"author":{"name":"Nic Raboy, Developer Advocate, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/bb545ebe83bb2d12f91095811d0a72e1"},"headline":"Using the Couchbase ODBC Driver with Microsoft Excel","datePublished":"2015-06-29T16:52:40+00:00","dateModified":"2023-06-27T17:18:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/"},"wordCount":973,"commentCount":19,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","keywords":["ODBC","SIMBA"],"articleSection":["Uncategorized"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/","url":"https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/","name":"Using the Couchbase ODBC Driver with Microsoft Excel - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2015-06-29T16:52:40+00:00","dateModified":"2023-06-27T17:18:45+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Using the Couchbase ODBC Driver with Microsoft Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"El blog de Couchbase","description":"Couchbase, la base de datos NoSQL","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"El blog de Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/bb545ebe83bb2d12f91095811d0a72e1","name":"Nic Raboy, Defensor del Desarrollador, Couchbase","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/bedeb68368d4681aca4c74fe5f697f0c423b80d498ec50fd915ba018b72c101f?s=96&d=mm&r=g8863514d8bed0cf6080f23db40e00354","url":"https:\/\/secure.gravatar.com\/avatar\/bedeb68368d4681aca4c74fe5f697f0c423b80d498ec50fd915ba018b72c101f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bedeb68368d4681aca4c74fe5f697f0c423b80d498ec50fd915ba018b72c101f?s=96&d=mm&r=g","caption":"Nic Raboy, Developer Advocate, Couchbase"},"description":"Nic Raboy es un defensor de las tecnolog\u00edas modernas de desarrollo web y m\u00f3vil. Tiene experiencia en Java, JavaScript, Golang y una variedad de frameworks como Angular, NativeScript y Apache Cordova. Nic escribe sobre sus experiencias de desarrollo relacionadas con hacer el desarrollo web y m\u00f3vil m\u00e1s f\u00e1cil de entender.","sameAs":["https:\/\/www.thepolyglotdeveloper.com","https:\/\/www.facebook.com\/thepolyglotdeveloper","https:\/\/x.com\/nraboy"],"url":"https:\/\/www.couchbase.com\/blog\/es\/author\/nic-raboy-2\/"}]}},"acf":[],"authors":[{"term_id":9032,"user_id":63,"is_guest":0,"slug":"nic-raboy-2","display_name":"Nic Raboy, Developer Advocate, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/bedeb68368d4681aca4c74fe5f697f0c423b80d498ec50fd915ba018b72c101f?s=96&d=mm&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/2068","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/users\/63"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/comments?post=2068"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/2068\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media?parent=2068"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/categories?post=2068"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/tags?post=2068"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/ppma_author?post=2068"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}