{"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\/pt\/extend-couchbase-analytics-with-sql-server-using-cdata\/","title":{"rendered":"Ampliar o Couchbase Analytics com o SQL Server usando o CData"},"content":{"rendered":"<h2>Amplie o Couchbase Analytics com o SQL Server usando o CData.<\/h2>\r\n<p>Este artigo o guiar\u00e1 pelas etapas necess\u00e1rias para configurar a conex\u00e3o do Couchbase Analytics com o SQL Server usando o driver CData ODBC para o Couchbase. Mais detalhes sobre esse driver podem ser encontrados em <a href=\"https:\/\/www.cdata.com\/kb\/tech\/couchbase-odbc-linked-server.rst\">encontrado aqui<\/a>.  O download vem com um segundo driver, o CData SQL Gateway, e suas informa\u00e7\u00f5es podem ser <a href=\"https:\/\/www.cdata.com\/kb\/articles\/sqlgateway-overview.rst#setup\">encontrado aqui<\/a>.<\/p>\r\n<p>**Nota - para o CData SQL Gateway, essa configura\u00e7\u00e3o requer a licen\u00e7a corporativa.<\/p>\r\n<h3>Pr\u00e9-requisitos<\/h3>\r\n<h4>Couchbase<\/h4>\r\n<p>Primeiro, voc\u00ea precisar\u00e1 de um cluster do Couchbase Server Enterprise Edition (EE) 6.x com os servi\u00e7os Data e Analytic ativados. Estou usando uma instala\u00e7\u00e3o local de n\u00f3 \u00fanico do Couchbase Server EE, mas as informa\u00e7\u00f5es deste artigo se aplicam a qualquer cluster do Couchbase Server EE.<\/p>\r\n<p>Se voc\u00ea n\u00e3o tiver um cluster existente do Couchbase Server EE, os links a seguir o ajudar\u00e3o a come\u00e7ar a trabalhar rapidamente:<\/p>\r\n<ol>\r\n<li><a href=\"https:\/\/www.couchbase.com\/blog\/pt\/downloads\/\">Download do Couchbase Server EE<\/a><\/li>\r\n<li>Instalar o 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\">Provisione um cluster de n\u00f3 \u00fanico<\/a>\u00a0(OBSERVA\u00c7\u00c3O: use os valores padr\u00e3o para a configura\u00e7\u00e3o do cluster)<\/li>\r\n<\/ol>\r\n<h4>SQL Server<\/h4>\r\n<p>Usando uma plataforma baseada no Windows com os seguintes detalhes:<\/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>Configura\u00e7\u00e3o do Couchbase<\/h3>\r\n<p>No Couchbase, clique em <em>Configura\u00e7\u00f5es\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>Ent\u00e3o <em>Baldes de amostra<\/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>Marque a caixa de sele\u00e7\u00e3o da amostra de cerveja e selecione <em>Carregar dados de amostra.\u00a0 <\/em>Em seguida, voc\u00ea pode navegar de volta para sua<em> Baldes<\/em> e veja <em>amostra de cerveja.<\/em><\/p>\r\n<p>Quando isso for conclu\u00eddo, precisaremos configurar o Analytics.<\/p>\r\n<p>Selecione\u00a0<em>An\u00e1lises, <\/em>em seguida, crie o conjunto de dados sombra de <em>cervejas <\/em>do balde de <em>amostra de cerveja.<\/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\">Criar conjunto de dados no 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>Clique em\u00a0<em>Executar,\u00a0<\/em>isso criar\u00e1 a defini\u00e7\u00e3o do conjunto de dados shadow.<\/p>\r\n<p>Quero repetir essa etapa criando um segundo conjunto de dados shadow com a seguinte defini\u00e7\u00e3o.<\/p>\r\n<pre class=\"lang:default decode:true\">CREATE DATASET breweries ON `beer-sample` WHERE `type` = \"brewery\";<\/pre>\r\n<p>Em seguida, voc\u00ea dever\u00e1 inicializ\u00e1-lo ativando o conjunto de dados com o seguinte.<\/p>\r\n<pre class=\"lang:default decode:true\">CONNECT LINK Local;<\/pre>\r\n<p>Clique em Execute (Executar).<\/p>\r\n<p>Agora voc\u00ea pode testar isso no painel do Analytics executando algo como o seguinte.<\/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>Mais informa\u00e7\u00f5es sobre o Couchbase Analytics podem ser encontradas em <a href=\"https:\/\/docs.couchbase.com\/server\/current\/learn\/services-and-indexes\/services\/analytics-service.html\">encontrado aqui.<\/a><\/p>\r\n<p>Sua configura\u00e7\u00e3o do Couchbase est\u00e1 conclu\u00edda!<\/p>\r\n<h3>Configura\u00e7\u00e3o do SQL Server<\/h3>\r\n<p>Instalei o SQL Server Express com todos os padr\u00f5es que podem ser <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-editions-express\">encontrado aqui<\/a>.<\/p>\r\n<p><span style=\"font-weight: 400\">Instale o CData ODBC Driver for Couchbase (Enterprise Edition) para habilitar o SQL Server Linked Server<\/span><\/p>\r\n<p><span style=\"font-weight: 400\">Configurar o driver ODBC<\/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\">Eu defini os seguintes par\u00e2metros<\/span>\r\n<ul>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nome da fonte de dados: Fonte CData Couchbase<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Usu\u00e1rio: Administrador<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Senha:senha<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Servidor: 13.92.234.252<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Porta do Analytics: 8095<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Verbosidade: 5<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Dataverse: Padr\u00e3o<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Achatar matrizes: 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>Configurar o driver ODBC do SQL Gateway para configurar o TDS Remoting Service<\/p>\r\n<p>Selecione executar como um servi\u00e7o<\/p>\r\n<p>Configure o servi\u00e7o com as seguintes defini\u00e7\u00f5es:<\/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 a guia Usu\u00e1rios com as seguintes defini\u00e7\u00f5es:<\/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>Agora, queremos criar um servidor vinculado ao 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>Agora que configuramos com sucesso a conex\u00e3o entre o SQL Server e o Couchbase, vamos tentar uma instru\u00e7\u00e3o SQL simples escrita no SQL Server Management Studio que ser\u00e1 executada no 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>Pr\u00f3ximas etapas<\/h3>\r\n<p>Tente criar uma tabela no SQL Server e inserir dados do Couchbase.<\/p>\r\n<p><a href=\"https:\/\/docs.couchbase.com\/server\/current\/getting-started\/do-a-quick-install.html\">Baixar o Couchbase<\/a>, configura\u00e7\u00e3o <a href=\"https:\/\/docs.couchbase.com\/server\/current\/learn\/services-and-indexes\/services\/analytics-service.html\">An\u00e1lises<\/a>e comece a usar o SQL Server com seus dados e veja quais insights voc\u00ea pode obter.  Amplie o Analytics com outras ferramentas usando os v\u00e1rios recursos do <a href=\"https:\/\/www.cdata.com\/drivers\/couchbase\/\">Drivers CData do Couchbase<\/a> que est\u00e3o na ponta de seus dedos.<\/p>","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>","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.9 (Yoast SEO v25.9) - 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\/pt\/extend-couchbase-analytics-with-sql-server-using-cdata\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\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\/pt\/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 minutos\" \/>\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\":\"pt-BR\",\"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\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@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\":\"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\/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\":\"pt-BR\",\"@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\/pt\/author\/justin-simpson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Extend Couchbase Analytics with SQL Server using CData -","description":"Este artigo o guiar\u00e1 pelas etapas necess\u00e1rias para configurar a conex\u00e3o do Couchbase Analytics com o SQL Server usando os drivers CData.","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\/extend-couchbase-analytics-with-sql-server-using-cdata\/","og_locale":"pt_BR","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\/pt\/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 minutos"},"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":"pt-BR","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":"Este artigo o guiar\u00e1 pelas etapas necess\u00e1rias para configurar a conex\u00e3o do Couchbase Analytics com o SQL Server usando os drivers CData.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@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":"Blog do 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":"Blog do 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\/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, engenheiro de solu\u00e7\u00f5es, Couchbase","image":{"@type":"ImageObject","inLanguage":"pt-BR","@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 \u00e9 engenheiro de solu\u00e7\u00f5es da Couchbase e trabalha com TI e tecnologia desde 2004. Ele mora na regi\u00e3o de Cincinnati, Ohio.","sameAs":["https:\/\/www.linkedin.com\/in\/justin-simpson-158ba44\/"],"url":"https:\/\/www.couchbase.com\/blog\/pt\/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 \u00e9 engenheiro de solu\u00e7\u00f5es da Couchbase e trabalha com TI e tecnologia desde 2004. Ele mora na regi\u00e3o de Cincinnati, Ohio."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/7844","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\/42713"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/comments?post=7844"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/7844\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media\/7475"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media?parent=7844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/categories?post=7844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/tags?post=7844"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/ppma_author?post=7844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}