{"id":470,"date":"2015-06-29T16:52:40","date_gmt":"2015-06-29T16:52:40","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/"},"modified":"2015-06-29T16:52:40","modified_gmt":"2015-06-29T16:52:40","slug":"using-the-couchbase-odbc-driver-with-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/pt\/using-the-couchbase-odbc-driver-with-microsoft-excel\/","title":{"rendered":"Using the Couchbase ODBC Driver with Microsoft Excel"},"content":{"rendered":"<p class=\"wp-block-paragraph\">About a month ago,\u00a0<a href=\"https:\/\/www.simba.com\/couchbase\/couchbase-odbc-jdbc-connectivity-solutions-developer-previews-now-available\">Simba Technologies announced that it had released developer previews<\/a>\u00a0of the ODBC and JDBC drivers. Last year we announced that\u00a0<a href=\"https:\/\/www.couchbase.com\/blog\/pt\/press-releases\/couchbase-chooses-simba-technologies-to-deliver-odbc-and-jdbc-connectivity\/\">Simba Technologies was buiding these ODBC and JDBC drivers<\/a>\u00a0for use with Couchbase. \u00a0These drivers make it possible for data analysts using tools like Microsoft Excel and Tableau to quickly access data on Couchbase Server.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">How exactly do you use these drivers? \u00a0We&#8217;re going to look specifically at how to query data using the ODBC driver with Microsoft Excel for Mac and Windows.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prerequisites<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Couchbase Server 4.0+<\/li>\n\n\n<li>Microsoft Excel 2011+<\/li>\n\n\n<li>A bucket with data<\/li>\n\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Using with Mac OS X<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Start by downloading and installing the latest Simba ODBC driver DMG file for Mac OS. \u00a0In this article, we&#8217;ll be using version 1.0.0.0002 for Mac.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you&#8217;re using a recent version of Mac OS, you&#8217;ll need to download another piece of software to configure the just-installed driver. \u00a0<a href=\"https:\/\/www.odbcmanager.net\/\">ODBC Manager<\/a>\u00a0for Mac will detect the installed driver and allow you to configure what server and port to connect to via Microsoft Excel.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Creating Bucket Indices<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Before we connect to Couchbase Server via Excel, we must first create bucket indices to allow for running N1QL queries. With Couchbase Server running, from the Mac Terminal, run the following command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>.\/Applications\/Couchbase Server.app\/Contents\/Resources\/couchbase-core\/bin\/cbq<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The above will launch the Couchbase query client. For the purposes of this example, we&#8217;re going to create a single primary index. With CBQ running, enter the following:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE PRIMARY INDEX def_primary ON `travel-sample` USING gsi;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The bucket is now ready for N1QL!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Connecting with Microsoft Excel<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Launch ODBC Manager and choose either the <strong>System DNS<\/strong>\u00a0or <strong>User DNS<\/strong>\u00a0tabs. \u00a0Basically whatever meets your needs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/1.png\" alt=\"ODBC Manager - Mac\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When ready, click the <strong>Add<\/strong>\u00a0button and the Simba Technologies driver should appear in the list to choose from.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/2.png\" alt=\"ODBC Manager Simba Couchbase - Mac\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Give the data source a name and add two very important key value pairs:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>host=127.0.0.1\r\nport=8093<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Of course, the host should match the actual host that your Couchbase Server resides on. \u00a0In the above example, Couchbase Server would be running on your local machine.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Create a new Microsoft Excel spreadsheet and click <strong>Database<\/strong> from the <strong>Data<\/strong> tab. \u00a0The same can be accomplished by doing <strong>Data -&gt; Get External Data -&gt; New Database Query<\/strong> from the toolbar.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/3.png\" alt=\"ODBC Excel Add Database - Mac\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When this is done, you&#8217;ll get a window that looks similar to what we&#8217;ve seen in the ODBC Manager software. \u00a0If for some reason the previously created driver entry doesn&#8217;t show up, go ahead and create it again. \u00a0Click the <strong>Test<\/strong> button and you&#8217;ll be prompted to enter a username and password. \u00a0This is the same username and password used to connect to your Couchbase Server.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/4.png\" alt=\"ODBC Excel Simba Login - Mac\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If testing is successful, go ahead and click the <strong>Ok<\/strong> button to connect and start analyzing data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When connected, you should see a list of buckets found on your Couchbase Server. \u00a0You now have two options for querying data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Querying Using a N1QL Query<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Click the <strong>SQL View<\/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\n\n\n<pre class=\"wp-block-code\"><code>select * from `travel-sample` limit 30;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If thirty documents exist, they will be returned.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/5.png\" alt=\"ODBC Excel Query - Mac\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Click the <strong>Test<\/strong> button and then click <strong>Return Data<\/strong> when the query has finished.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Querying Using the Microsoft Excel Builder<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Assuming the `travel-sample` bucket is installed and has the appropriate indexing configured, select the `travel-sample` bucket and click <strong>Add Table<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/6.png\" alt=\"ODBC Excel Query Builder - Mac\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When added, play around with the fields and click <strong>Return Data<\/strong> when ready.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Using with Microsoft Windows<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Start by downloading and installing the latest Simba ODBC driver MSI file for Microsoft Windows.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Creating Bucket Indices<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Before we connect to Couchbase Server via Excel, we must first create bucket indices to allow for running N1QL queries. With Couchbase Server running, from the Windows Command Prompt, run the following command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>C:\/Program Files\/Couchbase\/Server\/bin\/cbq.exe<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The above will launch the Couchbase query client. For the purposes of this example, we&#8217;re going to create a single primary index. With CBQ running, enter the following:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE PRIMARY INDEX def_primary ON `travel-sample` USING gsi;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The bucket is now ready for N1QL!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Create a new Microsoft Excel spreadsheet and click <strong>From Other Sources<\/strong> from the <strong>Data<\/strong> tab. If your datasource hasn&#8217;t already been added, choose the option and you&#8217;ll be required to fill out four items.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/7.png\" alt=\"ODBC Excel Create Datasource - Windows\"><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Name your connection something like `Simba Couchbase`<\/li>\n\n\n<li>Choose the <strong>Simba Couchbase ODBC Driver<\/strong><\/li>\n\n\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\n\n<li>Choose a default table for the datasource if testing the connection is successful<\/li>\n\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">At this point you can proceed to following the query building wizard or click cancel to do things on your own.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Querying with the Wizard<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">With the wizard started, first add the desired columns to your query, or all of them and click <strong>Next<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/8.png\" alt=\"ODBC Excel All Columns - Windows\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The next screen of the wizard will let you add any query logic. If you want to return all rows, just leave the default and click <strong>Next<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/9.png\" alt=\"ODBC Excel Filter Data - Windows\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The next screen of the wizard will let you choose how to sort the data by default. You can choose the default and click <strong>Next<\/strong> or specify some sorting.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/10.png\" alt=\"ODBC Excel Sort Data - Windows\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Choose <strong>Return Data to Microsoft Excel<\/strong> and click <strong>Finished<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/11.png\" alt=\"ODBC Excel Return Data - Windows\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">All data based on the criteria entered will be pulled into the spreadsheet.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Querying Using a N1QL Query<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Click the <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\n\n\n<pre class=\"wp-block-code\"><code>select * from `travel-sample` limit 30;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">If thirty documents exist, they will be returned.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/wp-content\/uploads\/sites\/5\/2026\/05\/12.png\" alt=\"ODBC Excel Query Data - Windows\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Click <strong>File -&gt; Return Data to Microsoft Excel<\/strong> when the query has finished to return the data into your spreadsheet.<\/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 analysts using tools like Microsoft Excel and Tableau to quickly access data on Couchbase Server. [&hellip;]<\/p>\n","protected":false},"author":63,"featured_media":18,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"_acf":"","footnotes":""},"categories":[1],"tags":[156,157],"ppma_author":[148],"class_list":["post-470","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.6 (Yoast SEO v27.6) - 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\/pt\/using-the-couchbase-odbc-driver-with-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\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 analysts using tools like Microsoft Excel and Tableau to quickly access data on Couchbase Server. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/pt\/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=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/5\/2026\/05\/couchbase-nosql-dbaas.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1800\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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\",\"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\\\/5\\\/2026\\\/05\\\/couchbase-nosql-dbaas.png\",\"keywords\":[\"ODBC\",\"SIMBA\"],\"articleSection\":[\"Uncategorized\"],\"inLanguage\":\"pt-BR\",\"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\\\/5\\\/2026\\\/05\\\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2015-06-29T16:52:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/using-the-couchbase-odbc-driver-with-microsoft-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@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\\\/5\\\/2026\\\/05\\\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2026\\\/05\\\/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\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2026\\\/06\\\/logo.svg\",\"contentUrl\":\"https:\\\/\\\/www.couchbase.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/5\\\/2026\\\/06\\\/logo.svg\",\"width\":\"1024\",\"height\":\"1024\",\"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\":\"pt-BR\",\"@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\\\/pt\\\/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\/pt\/using-the-couchbase-odbc-driver-with-microsoft-excel\/","og_locale":"pt_BR","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 analysts using tools like Microsoft Excel and Tableau to quickly access data on Couchbase Server. [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/pt\/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","og_image":[{"width":1800,"height":630,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/5\/2026\/05\/couchbase-nosql-dbaas.png","type":"image\/png"}],"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","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\/5\/2026\/05\/couchbase-nosql-dbaas.png","keywords":["ODBC","SIMBA"],"articleSection":["Uncategorized"],"inLanguage":"pt-BR","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\/5\/2026\/05\/couchbase-nosql-dbaas.png","datePublished":"2015-06-29T16:52:40+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/using-the-couchbase-odbc-driver-with-microsoft-excel\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@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\/5\/2026\/05\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/5\/2026\/05\/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":"O Blog da Couchbase","description":"Couchbase, o Banco de Dados 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":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"O Blog da Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/5\/2026\/06\/logo.svg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/5\/2026\/06\/logo.svg","width":"1024","height":"1024","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":"pt-BR","@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\/pt\/author\/nic-raboy-2\/"}]}},"acf":[],"authors":[{"term_id":148,"user_id":63,"is_guest":0,"slug":"nic-raboy-2","display_name":"Nic Raboy, Developer Advocate, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","author_category":"","first_name":"Nic","last_name":"Raboy","user_url":"","job_title":"","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."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/users\/63"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/comments?post=470"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/470\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media\/18"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media?parent=470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/categories?post=470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/tags?post=470"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/ppma_author?post=470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}