{"id":7844,"date":"2019-11-13T10:09:27","date_gmt":"2019-11-13T18:09:27","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=7844"},"modified":"2025-06-13T18:21:28","modified_gmt":"2025-06-14T01:21:28","slug":"extend-couchbase-analytics-with-sql-server-using-cdata","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/","title":{"rendered":"Extend Couchbase Analytics with SQL Server using CData"},"content":{"rendered":"\r\n<h2>Extend Couchbase Analytics with SQL Server using CData.<\/h2>\r\n<p>This article will guide you through the steps needed to setup the connection from Couchbase Analytics to SQL Server using the CData ODBC driver for Couchbase. More details regarding this driver can be <a href=\"https:\/\/www.cdata.com\/kb\/tech\/couchbase-odbc-linked-server.rst\">found here<\/a>.\u00a0 The download comes with a second driver, CData SQL Gateway and its information can be <a href=\"https:\/\/www.cdata.com\/kb\/articles\/sqlgateway-overview.rst#setup\">found here<\/a>.<\/p>\r\n<p>**Note &#8211; for the CData SQL Gateway, this setup requires the enterprise license.<\/p>\r\n<h3>Prerequisites<\/h3>\r\n<h4>Couchbase<\/h4>\r\n<p>You will first need a Couchbase Server Enterprise Edition (EE) 6.x cluster with the Data and Analytic services enabled. I am using a single node local install of Couchbase Server EE but the information in this article applies to any Couchbase Server EE cluster.<\/p>\r\n<p>If you do not have an existing Couchbase Server EE cluster, the following links will get you up and running quickly:<\/p>\r\n<ol>\r\n<li><a href=\"https:\/\/www.couchbase.com\/downloads\/\">Download Couchbase Server EE<\/a><\/li>\r\n<li>Install Couchbase Server EE\r\n<ul>\r\n<li><a href=\"https:\/\/docs.couchbase.com\/server\/6.0\/install\/macos-install.html\">Mac OS X<\/a><\/li>\r\n<li><a href=\"https:\/\/docs.couchbase.com\/server\/6.0\/install\/install-linux.html\">Linux<\/a><\/li>\r\n<li><a href=\"https:\/\/docs.couchbase.com\/server\/6.0\/install\/install-package-windows.html\">Windows<\/a><\/li>\r\n<\/ul>\r\n<\/li>\r\n<li><a href=\"https:\/\/docs.couchbase.com\/server\/6.0\/manage\/manage-nodes\/create-cluster.html#provision-a-node-with-the-ui\">Provision a single-node cluster<\/a>\u00a0(NOTE: use the default values for cluster configuration)<\/li>\r\n<\/ol>\r\n<h4>SQL Server<\/h4>\r\n<p>Using a windows based platform with the following details:<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-7845\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/11\/Screen-Shot-2019-11-13-at-12.27.30-PM.png\" alt=\"\" width=\"371\" height=\"348\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.27.30-PM.png 650w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.27.30-PM-300x282.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.27.30-PM-20x20.png 20w\" sizes=\"auto, (max-width: 371px) 100vw, 371px\" \/><\/p>\r\n<h3>Couchbase Setup<\/h3>\r\n<p>In Couchbase click on <em>Settings\u00a0<\/em><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-7460\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/Settings-282x300.png\" alt=\"\" width=\"282\" height=\"300\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Settings-282x300.png 282w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Settings-300x319.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Settings-20x20.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Settings.png 317w\" sizes=\"auto, (max-width: 282px) 100vw, 282px\" \/><\/p>\r\n<p>Then <em>Sample Buckets<\/em><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-7459\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/Sample-300x99.png\" alt=\"\" width=\"300\" height=\"99\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Sample-300x99.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Sample-20x7.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Sample.png 386w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\r\n<p>The select the beer-sample checkbox and select <em>Load Sample Data.\u00a0 <\/em>You can then navigate back to your<em> Buckets<\/em> and see <em>beer-sample.<\/em><\/p>\r\n<p>Once this is complete, we will need to setup Analytics.<\/p>\r\n<p>Select\u00a0<em>Analytics, <\/em>then create the shadow dataset of <em>beers <\/em>from the bucket of <em>beer-sample.<\/em><\/p>\r\n<div id=\"attachment_7463\" style=\"width: 754px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7463\" class=\"wp-image-7463 size-full\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/analytics-2.png\" alt=\"Create Dataset in Couchbase Analytics\" width=\"744\" height=\"564\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/analytics-2.png 744w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/analytics-2-300x227.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/analytics-2-20x15.png 20w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><p id=\"caption-attachment-7463\" class=\"wp-caption-text\">Create Dataset in Couchbase Analytics<\/p><\/div>\r\n<pre class=\"lang:default decode:true\">CREATE DATASET beers ON `beer-sample` WHERE `type` = \"beer\";<\/pre>\r\n<p>Click\u00a0<em>Execute,\u00a0<\/em>this will crate the shadow dataset definition.<\/p>\r\n<p>I want to repeat this step by creating a second shadow dataset with the following definition.<\/p>\r\n<pre class=\"lang:default decode:true\">CREATE DATASET breweries ON `beer-sample` WHERE `type` = \"brewery\";<\/pre>\r\n<p>Next you will want to initialize it by activating the dataset with the following.<\/p>\r\n<pre class=\"lang:default decode:true \">CONNECT LINK Local;<\/pre>\r\n<p>Click Execute.<\/p>\r\n<p>You can now test this out within the Analytics dashboard by running something like the following.<\/p>\r\n<pre class=\"lang:default decode:true\">SELECT COUNT(*) FROM beers\r\nUNION ALL\r\nSELECT COUNT(*) FROM breweries;<\/pre>\r\n<p>More about Couchbase Analytics can be <a href=\"https:\/\/docs.couchbase.com\/server\/current\/learn\/services-and-indexes\/services\/analytics-service.html\">found here.<\/a><\/p>\r\n<p>Your setup for Couchbase is complete!<\/p>\r\n<h3>SQL Server Setup<\/h3>\r\n<p>I installed SQL Server Express with all the defaults which can be <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-editions-express\">found here<\/a>.<\/p>\r\n<p><span style=\"font-weight: 400\">Install CData ODBC Driver for Couchbase (Enterprise Edition) to enable SQL Server Linked Server<\/span><\/p>\r\n<p><span style=\"font-weight: 400\">Setup the ODBC Driver<\/span><\/p>\r\n<ul>\r\n<li style=\"list-style-type: none\">\r\n<ul>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">I set the following parameters<\/span>\r\n<ul>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Data Source Name: CData Couchbase Source<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">User: Administrator<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Password:password<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Server: 13.92.234.252<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Analytics Port: 8095<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Verbosity: 5<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Dataverse: Default<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Flatten Arrays: 4<\/span><\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ul>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-7847\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/11\/Screen-Shot-2019-11-13-at-12.34.29-PM.png\" alt=\"\" width=\"396\" height=\"395\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.34.29-PM.png 546w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.34.29-PM-300x299.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.34.29-PM-150x150.png 150w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.34.29-PM-65x65.png 65w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.34.29-PM-50x50.png 50w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.34.29-PM-20x20.png 20w\" sizes=\"auto, (max-width: 396px) 100vw, 396px\" \/><\/p>\r\n<p>Setup SQL Gateway ODBC driver to configure the TDS Remoting Service<\/p>\r\n<p>Select run as a service<\/p>\r\n<p>Configure the service with the following settings:<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-7848\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/11\/Screen-Shot-2019-11-13-at-12.37.16-PM.png\" alt=\"\" width=\"581\" height=\"440\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.37.16-PM.png 789w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.37.16-PM-300x227.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.37.16-PM-768x581.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.37.16-PM-20x15.png 20w\" sizes=\"auto, (max-width: 581px) 100vw, 581px\" \/><\/p>\r\n<p>Configure the Users tab with the following settings:<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-7850\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/11\/Screen-Shot-2019-11-13-at-12.39.22-PM.png\" alt=\"\" width=\"583\" height=\"401\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.39.22-PM.png 789w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.39.22-PM-300x206.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.39.22-PM-768x529.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.39.22-PM-20x14.png 20w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><\/p>\r\n<p>Now we will want to create a linked server to Couchbase<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7859\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/11\/Screen-Shot-2019-11-13-at-12.56.20-PM.png\" alt=\"\" width=\"407\" height=\"484\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.56.20-PM.png 407w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.56.20-PM-252x300.png 252w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.56.20-PM-300x357.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.56.20-PM-17x20.png 17w\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" \/><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-7853\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/11\/Screen-Shot-2019-11-13-at-12.43.13-PM.png\" alt=\"\" width=\"550\" height=\"501\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.43.13-PM.png 687w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.43.13-PM-300x273.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.43.13-PM-20x18.png 20w\" sizes=\"auto, (max-width: 550px) 100vw, 550px\" \/><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-7854\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/11\/Screen-Shot-2019-11-13-at-12.43.56-PM.png\" alt=\"\" width=\"552\" height=\"503\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.43.56-PM.png 687w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.43.56-PM-300x273.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.43.56-PM-20x18.png 20w\" sizes=\"auto, (max-width: 552px) 100vw, 552px\" \/><\/p>\r\n<p>Now that we have successfully setup the connection between SQL Server and Couchbase, lets try a simple SQL statement written in SQL Server Management Studio that will execute against Couchbase Analytics<\/p>\r\n<pre class=\"lang:default decode:true \">SELECT *\r\nFROM CB_DEMO.[CData Couchbase Sys].[Couchbase].[beers]<\/pre>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7860\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/11\/Screen-Shot-2019-11-13-at-12.58.57-PM.png\" alt=\"\" width=\"827\" height=\"404\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.58.57-PM.png 827w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.58.57-PM-300x147.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.58.57-PM-768x375.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.58.57-PM-20x10.png 20w\" sizes=\"auto, (max-width: 827px) 100vw, 827px\" \/><\/p>\r\n<h3>Next Steps<\/h3>\r\n<p>Try creating a table on SQL Server and inserting data from Couchbase.<\/p>\r\n<p><a href=\"https:\/\/docs.couchbase.com\/server\/current\/getting-started\/do-a-quick-install.html\">Download Couchbase<\/a>, setup <a href=\"https:\/\/docs.couchbase.com\/server\/current\/learn\/services-and-indexes\/services\/analytics-service.html\">Analytics<\/a>, and start using SQL Server with your data and see what insights you can gleam.\u00a0 Extend Analytics with other tools using the many <a href=\"https:\/\/www.cdata.com\/drivers\/couchbase\/\">Couchbase CData drivers<\/a> that are at your fingertips.<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Extend Couchbase Analytics with SQL Server using CData. This article will guide you through the steps needed to setup the connection from Couchbase Analytics to SQL Server using the CData ODBC driver for Couchbase. More details regarding this driver can [&hellip;]<\/p>\n","protected":false},"author":42713,"featured_media":7475,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1815,2294,1812],"tags":[2369,1556],"ppma_author":[9087],"class_list":["post-7844","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-best-practices-and-tutorials","category-analytics","category-n1ql-query","tag-cdata","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.8 (Yoast SEO v25.8) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Extend Couchbase Analytics with SQL Server using CData -<\/title>\n<meta name=\"description\" content=\"This article will guide you through the steps needed to setup the connection from Couchbase Analytics to SQL Server using the CData 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\/extend-couchbase-analytics-with-sql-server-using-cdata\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Extend Couchbase Analytics with SQL Server using CData\" \/>\n<meta property=\"og:description\" content=\"This article will guide you through the steps needed to setup the connection from Couchbase Analytics to SQL Server using the CData drivers.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-13T18:09:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T01:21:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png\" \/>\n\t<meta property=\"og:image:width\" content=\"893\" \/>\n\t<meta property=\"og:image:height\" content=\"332\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Justin Simpson, Solutions Engineer, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Justin Simpson, Solutions Engineer, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/\"},\"author\":{\"name\":\"Justin Simpson, Solutions Engineer, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/a0f07ddb4bcf033d9bab0edbfcd26291\"},\"headline\":\"Extend Couchbase Analytics with SQL Server using CData\",\"datePublished\":\"2019-11-13T18:09:27+00:00\",\"dateModified\":\"2025-06-14T01:21:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/\"},\"wordCount\":502,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png\",\"keywords\":[\"CData\",\"SQL Server\"],\"articleSection\":[\"Best Practices and Tutorials\",\"Couchbase Analytics\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/\",\"name\":\"Extend Couchbase Analytics with SQL Server using CData -\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png\",\"datePublished\":\"2019-11-13T18:09:27+00:00\",\"dateModified\":\"2025-06-14T01:21:28+00:00\",\"description\":\"This article will guide you through the steps needed to setup the connection from Couchbase Analytics to SQL Server using the CData drivers.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png\",\"width\":893,\"height\":332},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extend Couchbase Analytics with SQL Server using CData\"}]},{\"@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\/a0f07ddb4bcf033d9bab0edbfcd26291\",\"name\":\"Justin Simpson, Solutions Engineer, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/bd98e55f5b73d759274a5de5f96c5095\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a25a380db8c128c63a22d40823fdc256c1ebfbd630d7f36716268bde406dfddd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a25a380db8c128c63a22d40823fdc256c1ebfbd630d7f36716268bde406dfddd?s=96&d=mm&r=g\",\"caption\":\"Justin Simpson, Solutions Engineer, Couchbase\"},\"description\":\"Justin Simpson is a Solutions Engineer at Couchbase and has been working in IT and technology since 2004. He is based in the Cincinnati, Ohio area.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/justin-simpson-158ba44\/\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/author\/justin-simpson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Extend Couchbase Analytics with SQL Server using CData -","description":"This article will guide you through the steps needed to setup the connection from Couchbase Analytics to SQL Server using the CData 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\/extend-couchbase-analytics-with-sql-server-using-cdata\/","og_locale":"en_US","og_type":"article","og_title":"Extend Couchbase Analytics with SQL Server using CData","og_description":"This article will guide you through the steps needed to setup the connection from Couchbase Analytics to SQL Server using the CData drivers.","og_url":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/","og_site_name":"The Couchbase Blog","article_published_time":"2019-11-13T18:09:27+00:00","article_modified_time":"2025-06-14T01:21:28+00:00","og_image":[{"width":893,"height":332,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png","type":"image\/png"}],"author":"Justin Simpson, Solutions Engineer, Couchbase","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Justin Simpson, Solutions Engineer, Couchbase","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/"},"author":{"name":"Justin Simpson, Solutions Engineer, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/a0f07ddb4bcf033d9bab0edbfcd26291"},"headline":"Extend Couchbase Analytics with SQL Server using CData","datePublished":"2019-11-13T18:09:27+00:00","dateModified":"2025-06-14T01:21:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/"},"wordCount":502,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png","keywords":["CData","SQL Server"],"articleSection":["Best Practices and Tutorials","Couchbase Analytics","SQL++ \/ N1QL Query"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/","url":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/","name":"Extend Couchbase Analytics with SQL Server using CData -","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png","datePublished":"2019-11-13T18:09:27+00:00","dateModified":"2025-06-14T01:21:28+00:00","description":"This article will guide you through the steps needed to setup the connection from Couchbase Analytics to SQL Server using the CData drivers.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png","width":893,"height":332},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Extend Couchbase Analytics with SQL Server using CData"}]},{"@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\/a0f07ddb4bcf033d9bab0edbfcd26291","name":"Justin Simpson, Solutions Engineer, Couchbase","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/bd98e55f5b73d759274a5de5f96c5095","url":"https:\/\/secure.gravatar.com\/avatar\/a25a380db8c128c63a22d40823fdc256c1ebfbd630d7f36716268bde406dfddd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a25a380db8c128c63a22d40823fdc256c1ebfbd630d7f36716268bde406dfddd?s=96&d=mm&r=g","caption":"Justin Simpson, Solutions Engineer, Couchbase"},"description":"Justin Simpson is a Solutions Engineer at Couchbase and has been working in IT and technology since 2004. He is based in the Cincinnati, Ohio area.","sameAs":["https:\/\/www.linkedin.com\/in\/justin-simpson-158ba44\/"],"url":"https:\/\/www.couchbase.com\/blog\/author\/justin-simpson\/"}]}},"authors":[{"term_id":9087,"user_id":42713,"is_guest":0,"slug":"justin-simpson","display_name":"Justin Simpson, Solutions Engineer, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/a25a380db8c128c63a22d40823fdc256c1ebfbd630d7f36716268bde406dfddd?s=96&d=mm&r=g","author_category":"","last_name":"Simpson, Solutions Engineer, Couchbase","first_name":"Justin","job_title":"","user_url":"","description":"Justin Simpson is a Solutions Engineer at Couchbase and has been working in IT and technology since 2004. He is based in the Cincinnati, Ohio area."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/7844","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\/42713"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/comments?post=7844"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/7844\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media\/7475"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media?parent=7844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/categories?post=7844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/tags?post=7844"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=7844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}