{"id":2297,"date":"2016-06-15T09:11:22","date_gmt":"2016-06-15T09:11:21","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=2297"},"modified":"2024-09-12T01:25:09","modified_gmt":"2024-09-12T08:25:09","slug":"cdatas-drivers-provide-sql-access-to-your-couchbase-data","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/","title":{"rendered":"CData&#8217;s Drivers Provide SQL Access to Your Couchbase Data"},"content":{"rendered":"<h2 style=\"text-align: center\">Standards-Based Access to Couchbase Data<\/h2>\n<p>So you&#8217;ve chosen Couchbase to house your data and now you&#8217;d like to be able to access that data however and wherever you&#8217;d like. If you\u2019re building your own web, desktop, or mobile application, you can use the excellent SDKs from Couchbase. Sometimes, the SDKs won\u2019t work if you\u2019re trying to work with your Couchbase data in a third-party tool, like Microsoft Excel, Tableau, and any number of other BI\/reporting\/ETL tools. This is where CData Software can help: by giving you standards-based drivers to connect your Couchbase data to the BI, reporting, and ETL tools that you&#8217;re already using. We\u2019ve built drivers that adhere to time- and industry-proven standards, like JDBC, ODBC, and ADO.NET, freeing users to quickly connect with their Couchbase data in their favorite tools, saving them the time and hassle of managing the data integration.<\/p>\n<table style=\"text-align: left;width: 777px\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 543px\"><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">At this point, you may be asking yourself, &#8220;how do we connect to our Couchbase data (which is decidedly NoSQL) in BI tools that expect relational data?&#8221; With CData&#8217;s drivers, your SQL queries are processed and translated into N1QL, simultaneously granting you access to your data in tools you already use and leveraging the utility of Couchbase&#8217;s data storage and querying technology. We\u2019ll manage the query interpretation, ask Couchbase for your data, and process the results into a table with rows and columns that modern BI tools expect, allowing Couchbase to manage the query processing and return the appropriate results.<\/span><\/p>\n<p><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">For example, you may have a bucket labelled \u201cbusiness\u201d which has some documents similar to the following:<\/span><\/td>\n<td style=\"width: 232px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/june\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/image06.png\" align=\"right\" \/><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<pre><code class=\"language-json\">        {\r\n             \u201cname\u201d : \u201cCompany XYZ\u201d,\r\n             \u201caddress\u201d : {\r\n                  \u201cstreet\u201d : \u201c123 Main Street\u201d,\r\n                  \u201ccity\u201d : \u201cNew York\u201d,\r\n                  \u201cstate\u201d : \u201cNY\u201d, \r\n                  \u201czip\u201d : 27516\r\n             },\r\n             \u201ccontact\u201d : {\r\n                  \u201cname\u201d : \u201cJohn Doe\u201d,\r\n                  \u201cemail\u201d : \u201cjdoe@xyz.com\u201d,\r\n                  \u201cphone\u201d : \u201c555-555-5555\u201d\r\n             }\r\n        }<\/code><\/pre>\n<p>and you want to chart the number of businesses in a given State. Given a bucket with documents like this, you could use any of the CData drivers and submit a query like the following:<\/p>\n<pre><code class=\"language-sql\">           SELECT business.address.state AS state, COUNT(*) \r\n           FROM business \r\n           GROUP BY business.address.state;<\/code><\/pre>\n<p>CData\u2019s drivers are able to properly interpret this query and translate it to the equivalent N1QL query to drill down into the <strong>address<\/strong> object within the document to pull the <strong>state<\/strong> field, allowing you to chart, graph, or otherwise creatively visualize exactly the data that you want.<\/p>\n<p>When it comes to many 3rd party applications, though, you aren\u2019t able to control the SQL query that is being created. In these instances, you can rely on the different schema interpretation methods that <a href=\"https:\/\/www.couchbase.com\/blog\/cdata-connect-cloud-for-couchbase-capella\/\">CData<\/a> has put in place to help extract your Couchbase data, whether that\u2019s defining the schema yourself, allowing the driver to scan a bucket and determine the schema, or configuring the driver to flatten objects and arrays. No matter how you configure the driver to extract your Couchbase data, you can rest assured that, with CData\u2019s drivers, you will be able to get to the data that you want, when you want, and where you want.<\/p>\n<h2>Connecting with CData\u2019s Products<\/h2>\n<table style=\"text-align: left;width: 792px\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 274px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/june\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/image05.png\" \/><\/td>\n<td style=\"width: 514px\">\n<p style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">In order to connect to your Couchbase data using a CData driver, you&#8217;ll first need to configure the connection, setting the Server, Username, Password, Web Console Port (defaults to the standard 8091), and N1QL Port (defaults to the standard 8093). This configuration will take many forms, from configuring a DSN for the ODBC Driver, using the Connection Wizard for the Excel Add-In (see the screenshot to the left), or creating a connection string for our ADO.NET Provider or JDBC Driver. No matter where you want your Couchbase data, the initial configuration is simple and straightforward. For advanced users or server administrators, there are other settings that can be configured to help work with proxies and firewalls, manage data caching, and many other options. All of the drivers&#8217; connection properties are outlined in their respective help files.<\/p>\n<p style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\"><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">To help Couchbase customers best connect to their data, CData has created an entire suite of drivers. I&#8217;ve provided a little more information for each of our Couchbase drivers (along with links for even MORE information) below:<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Microsoft Excel<\/h2>\n<table style=\"text-align: left;width: 787px\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 95px\">\n<p style=\"margin-left: 40px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/june\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/image01.png\" \/><\/p>\n<\/td>\n<td style=\"width: 688px\"><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">Our\u00a0<\/span><a style=\"line-height: 20.799999237060547px;text-align: left\" href=\"https:\/\/www.cdata.com\/drivers\/couchbase\/excel\">Excel Add-In<\/a><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">\u00a0creates a live connection to your Couchbase data in Excel, allowing you to read from and write to your data instead of being stuck with a static data dump. You can utilize the powerful and familiar features of Excel to see your Couchbase data the way that you want.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>BI &amp; Reporting Tools<\/h2>\n<table style=\"text-align: left;width: 785px\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 97px\">\n<p style=\"margin-left: 40px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/june\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/image04.png\" \/><\/p>\n<\/td>\n<td style=\"width: 684px\"><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">The\u00a0<\/span><a style=\"line-height: 20.799999237060547px;text-align: left\" href=\"https:\/\/www.cdata.com\/drivers\/couchbase\/odbc\">ODBC Driver<\/a><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">\u00a0for Couchbase allows you to connect your Couchbase data to any number of BI Tools, including, but not limited to: Cognos BI, Crystal Reports, FileMaker Pro, Microsoft Access, QlikView, and Tableau.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Couchbase as OData<\/h2>\n<table style=\"text-align: left;width: 785px\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 98px\">\n<p style=\"margin-left: 40px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/june\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/image03.png\" \/><\/p>\n<\/td>\n<td style=\"width: 684px\"><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">The\u00a0<\/span><a style=\"line-height: 20.799999237060547px;text-align: left\" href=\"https:\/\/www.cdata.com\/drivers\/couchbase\/cloud\/\">CData Cloud Driver<\/a><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">\u00a0is a lightweight server-side application that proxies live Couchbase data, making it easily accessible across platforms and devices. With the Cloud Driver, you can expose Couchbase data through many standards based interfaces, like OData, SOAP, REST, HTML, RSS, ATOM, JSON, XML, and CSV.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Java-Based Tools &amp; Development<\/h2>\n<table style=\"text-align: left;width: 786px\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 97px\">\n<p style=\"margin-left: 40px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/june\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/image02.png\" \/><\/p>\n<\/td>\n<td style=\"width: 685px\"><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">The\u00a0<\/span><a style=\"line-height: 20.799999237060547px;text-align: left\" href=\"https:\/\/www.cdata.com\/drivers\/couchbase\/jdbc\">JDBC Driver<\/a><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">\u00a0will allows you to connect to many BI tools (such as Cisco Information Server, ColdFusion, DbVisualizer, Informatica, and Pentaho) or create your own custom Java applications to work with your Couchbase data.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>.NET Tools &amp; Development<\/h2>\n<table style=\"text-align: left;width: 790px\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 98px\">\n<p style=\"margin-left: 40px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/june\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/image07.png\" \/><\/p>\n<\/td>\n<td style=\"width: 689px\"><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">The\u00a0<\/span><a style=\"line-height: 20.799999237060547px;text-align: left\" href=\"https:\/\/www.cdata.com\/drivers\/couchbase\/ado\">ADO.NET Provider<\/a><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">\u00a0gives those of you who are .NET developers the opportunity to connect their applications to Couchbase data. We do this by granting access to the data as if it were a set of SQL tables, allowing you to simply DataBind to the data, just like using Relational Databases.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Mobile Development<\/h2>\n<table style=\"width: 798px\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 97px\">\n<p style=\"margin-left: 40px\"><img decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/june\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/image00.png\" \/><\/p>\n<\/td>\n<td style=\"width: 697px\"><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">If you are interested in developing mobile applications that consume social media data, then the\u00a0<\/span><a style=\"line-height: 20.799999237060547px;text-align: left\" href=\"https:\/\/www.cdata.com\/drivers\/couchbase\/mobile\">ADO.NET Providers for Xamarin<\/a><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">\u00a0are just the products for you. With our provider, you connect to real-time data using standard Xamarin data access, meaning you can easily create iOS and Android apps that consume Couchbase data!<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Looking Forward &amp; Free Trials<\/h2>\n<p>We\u2019re excited to embark on this partnership with Couchbase and look forward to helping Couchbase customers connect with their data. You can rest assured that as Couchbase updates and improves their product and APIs, CData Software will be there, every step of the way, implementing any changes and improvements so that you never have a lapse in production.<\/p>\n<p>You can download a free, <a href=\"https:\/\/www.cdata.com\/drivers\/couchbase\/download\/\">30-day trial<\/a> of any of CData\u2019s drivers and start working with your Couchbase data in all of your favorite BI, ETL, reporting, and custom applications today!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Standards-Based Access to Couchbase Data So you&#8217;ve chosen Couchbase to house your data and now you&#8217;d like to be able to access that data however and wherever you&#8217;d like. If you\u2019re building your own web, desktop, or mobile application, you [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1816,1812],"tags":[],"ppma_author":[9044],"class_list":["post-2297","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-couchbase-server","category-n1ql-query"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.7.1 (Yoast SEO v25.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>CData&#039;s Drivers Provide SQL Access to Your Couchbase Data<\/title>\n<meta name=\"description\" content=\"The post focuses on CData has created an entire suite of drivers to help Couchbase customers best connect to their data. Learn more about Couchbase drivers.\" \/>\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\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CData&#039;s Drivers Provide SQL Access to Your Couchbase Data\" \/>\n<meta property=\"og:description\" content=\"The post focuses on CData has created an entire suite of drivers to help Couchbase customers best connect to their data. Learn more about Couchbase drivers.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-15T09:11:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-12T08:25:09+00:00\" \/>\n<meta name=\"author\" content=\"Jerod Johnson, Technology Evangelist, CData Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jerod Johnson, Technology Evangelist, CData Software\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/\"},\"author\":{\"name\":\"Jerod Johnson, Technical Marketing Engineer, Cdata Software\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/8322e699075d7b3dc0d9898f8414dd42\"},\"headline\":\"CData&#8217;s Drivers Provide SQL Access to Your Couchbase Data\",\"datePublished\":\"2016-06-15T09:11:21+00:00\",\"dateModified\":\"2024-09-12T08:25:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/\"},\"wordCount\":1049,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"articleSection\":[\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/\",\"name\":\"CData's Drivers Provide SQL Access to Your Couchbase Data\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2016-06-15T09:11:21+00:00\",\"dateModified\":\"2024-09-12T08:25:09+00:00\",\"description\":\"The post focuses on CData has created an entire suite of drivers to help Couchbase customers best connect to their data. Learn more about Couchbase drivers.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#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\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CData&#8217;s Drivers Provide SQL Access to Your Couchbase Data\"}]},{\"@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\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@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\/8322e699075d7b3dc0d9898f8414dd42\",\"name\":\"Jerod Johnson, Technical Marketing Engineer, Cdata Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/69a22fd2ad042401f8941b3a1e8171cd\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/06\/image_2022-06-14_113540504.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/06\/image_2022-06-14_113540504.png\",\"caption\":\"Jerod Johnson, Technical Marketing Engineer, Cdata Software\"},\"description\":\"Jerod Johnson is a Technology Evangelist at CData Software. A big thank you for his contribution to the blog post.\",\"sameAs\":[\"https:\/\/cdata.com\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/author\/jerod-johnson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"CData's Drivers Provide SQL Access to Your Couchbase Data","description":"The post focuses on CData has created an entire suite of drivers to help Couchbase customers best connect to their data. Learn more about Couchbase drivers.","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\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/","og_locale":"en_US","og_type":"article","og_title":"CData's Drivers Provide SQL Access to Your Couchbase Data","og_description":"The post focuses on CData has created an entire suite of drivers to help Couchbase customers best connect to their data. Learn more about Couchbase drivers.","og_url":"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/","og_site_name":"The Couchbase Blog","article_published_time":"2016-06-15T09:11:21+00:00","article_modified_time":"2024-09-12T08:25:09+00:00","author":"Jerod Johnson, Technology Evangelist, CData Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jerod Johnson, Technology Evangelist, CData Software","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/"},"author":{"name":"Jerod Johnson, Technical Marketing Engineer, Cdata Software","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/8322e699075d7b3dc0d9898f8414dd42"},"headline":"CData&#8217;s Drivers Provide SQL Access to Your Couchbase Data","datePublished":"2016-06-15T09:11:21+00:00","dateModified":"2024-09-12T08:25:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/"},"wordCount":1049,"commentCount":1,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","articleSection":["Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/","url":"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/","name":"CData's Drivers Provide SQL Access to Your Couchbase Data","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2016-06-15T09:11:21+00:00","dateModified":"2024-09-12T08:25:09+00:00","description":"The post focuses on CData has created an entire suite of drivers to help Couchbase customers best connect to their data. Learn more about Couchbase drivers.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#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\/cdatas-drivers-provide-sql-access-to-your-couchbase-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"CData&#8217;s Drivers Provide SQL Access to Your Couchbase Data"}]},{"@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":"en-US"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"The Couchbase Blog","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@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\/8322e699075d7b3dc0d9898f8414dd42","name":"Jerod Johnson, Technical Marketing Engineer, Cdata Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/69a22fd2ad042401f8941b3a1e8171cd","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/06\/image_2022-06-14_113540504.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/06\/image_2022-06-14_113540504.png","caption":"Jerod Johnson, Technical Marketing Engineer, Cdata Software"},"description":"Jerod Johnson is a Technology Evangelist at CData Software. A big thank you for his contribution to the blog post.","sameAs":["https:\/\/cdata.com"],"url":"https:\/\/www.couchbase.com\/blog\/author\/jerod-johnson\/"}]}},"authors":[{"term_id":9044,"user_id":75,"is_guest":0,"slug":"jerod-johnson","display_name":"Jerod Johnson, Technology Evangelist, CData Software","avatar_url":{"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/06\/image_2022-06-14_113540504.png","url2x":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/06\/image_2022-06-14_113540504.png"},"author_category":"","last_name":"Johnson","first_name":"Jerod","job_title":"","user_url":"https:\/\/www.cdata.com\/","description":"Jerod Johnson is a Technology Evangelist at Cdata Software. A big thank you for his contribution to the blog post."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/2297","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/comments?post=2297"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/2297\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media?parent=2297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/categories?post=2297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/tags?post=2297"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=2297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}