{"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\/es\/extend-couchbase-analytics-with-sql-server-using-cdata\/","title":{"rendered":"Extender Couchbase Analytics con SQL Server usando CData"},"content":{"rendered":"<h2>Extender Couchbase Analytics con SQL Server usando CData.<\/h2>\r\n<p>Este art\u00edculo te guiar\u00e1 a trav\u00e9s de los pasos necesarios para configurar la conexi\u00f3n de Couchbase Analytics a SQL Server utilizando el driver ODBC de CData para Couchbase. M\u00e1s detalles sobre este driver en <a href=\"https:\/\/www.cdata.com\/kb\/tech\/couchbase-odbc-linked-server.rst\">aqu\u00ed<\/a>.  La descarga viene con un segundo controlador, CData SQL Gateway y su informaci\u00f3n puede ser <a href=\"https:\/\/www.cdata.com\/kb\/articles\/sqlgateway-overview.rst#setup\">aqu\u00ed<\/a>.<\/p>\r\n<p>**Nota: para CData SQL Gateway, esta configuraci\u00f3n requiere la licencia de empresa.<\/p>\r\n<h3>Requisitos previos<\/h3>\r\n<h4>Couchbase<\/h4>\r\n<p>Primero necesitar\u00e1s un cluster de Couchbase Server Enterprise Edition (EE) 6.x con los servicios Data y Analytic habilitados. Estoy usando una instalaci\u00f3n local de un solo nodo de Couchbase Server EE, pero la informaci\u00f3n de este art\u00edculo se aplica a cualquier cl\u00faster de Couchbase Server EE.<\/p>\r\n<p>Si no dispone de un cl\u00faster de Couchbase Server EE, los siguientes enlaces le ayudar\u00e1n a ponerlo en marcha r\u00e1pidamente:<\/p>\r\n<ol>\r\n<li><a href=\"https:\/\/www.couchbase.com\/blog\/es\/downloads\/\">Descargar Couchbase Server EE<\/a><\/li>\r\n<li>Instalar 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\">Aprovisionar un cl\u00faster de un solo nodo<\/a>\u00a0(NOTA: utilice los valores predeterminados para la configuraci\u00f3n del cl\u00faster)<\/li>\r\n<\/ol>\r\n<h4>Servidor SQL<\/h4>\r\n<p>Utilizando una plataforma basada en Windows con los siguientes detalles:<\/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>Configuraci\u00f3n de Couchbase<\/h3>\r\n<p>En Couchbase, haga clic en <em>Ajustes\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>Entonces <em>Cubos de muestra<\/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>La casilla de verificaci\u00f3n de la muestra de cerveza y seleccione <em>Cargar datos de muestra.\u00a0 <\/em>A continuaci\u00f3n, puede navegar de nuevo a su<em> Cubos<\/em> y ver <em>muestra de cerveza.<\/em><\/p>\r\n<p>Una vez completado esto, tendremos que configurar Analytics.<\/p>\r\n<p>Seleccione\u00a0<em>Anal\u00edtica, <\/em>a continuaci\u00f3n, cree el conjunto de datos sombra de <em>cervezas <\/em>del cubo de <em>muestra de cerveza.<\/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\">Crear un conjunto de datos en 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>Haga clic en\u00a0<em>Ejecutar,\u00a0<\/em>esto crear\u00e1 la definici\u00f3n del conjunto de datos sombra.<\/p>\r\n<p>Quiero repetir este paso creando un segundo conjunto de datos sombra con la siguiente definici\u00f3n.<\/p>\r\n<pre class=\"lang:default decode:true\">CREATE DATASET breweries ON `beer-sample` WHERE `type` = \"brewery\";<\/pre>\r\n<p>A continuaci\u00f3n querr\u00e1s inicializarlo activando el conjunto de datos con lo siguiente.<\/p>\r\n<pre class=\"lang:default decode:true\">CONNECT LINK Local;<\/pre>\r\n<p>Haga clic en Ejecutar.<\/p>\r\n<p>Ahora puede probarlo en el panel de control de Analytics ejecutando algo como lo siguiente.<\/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>M\u00e1s informaci\u00f3n sobre Couchbase Analytics <a href=\"https:\/\/docs.couchbase.com\/server\/current\/learn\/services-and-indexes\/services\/analytics-service.html\">aqu\u00ed.<\/a><\/p>\r\n<p>La configuraci\u00f3n de Couchbase est\u00e1 completa.<\/p>\r\n<h3>Configuraci\u00f3n de SQL Server<\/h3>\r\n<p>He instalado SQL Server Express con todos los valores predeterminados que se pueden <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-editions-express\">aqu\u00ed<\/a>.<\/p>\r\n<p><span style=\"font-weight: 400\">Instalar CData ODBC Driver para Couchbase (Enterprise Edition) para habilitar SQL Server Linked Server<\/span><\/p>\r\n<p><span style=\"font-weight: 400\">Configurar el controlador 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\">He establecido los siguientes par\u00e1metros<\/span>\r\n<ul>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Nombre de la fuente de datos: Fuente CData Couchbase<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Usuario: Administrador<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Contrase\u00f1a:contrase\u00f1a<\/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\">Analytics Puerto: 8095<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Verbosidad: 5<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Dataverse: Por defecto<\/span><\/li>\r\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Aplanar matrices: 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>Instale el controlador ODBC de SQL Gateway para configurar el servicio TDS Remoting.<\/p>\r\n<p>Seleccione ejecutar como servicio<\/p>\r\n<p>Configure el servicio con los siguientes par\u00e1metros:<\/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 la pesta\u00f1a Usuarios con los siguientes par\u00e1metros:<\/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>Ahora vamos a querer crear un servidor vinculado a 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>Ahora que hemos configurado con \u00e9xito la conexi\u00f3n entre SQL Server y Couchbase, vamos a probar una simple sentencia SQL escrita en SQL Server Management Studio que se ejecutar\u00e1 contra 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\u00f3ximos pasos<\/h3>\r\n<p>Intenta crear una tabla en SQL Server e insertar datos desde Couchbase.<\/p>\r\n<p><a href=\"https:\/\/docs.couchbase.com\/server\/current\/getting-started\/do-a-quick-install.html\">Descargar Couchbase<\/a>configuraci\u00f3n <a href=\"https:\/\/docs.couchbase.com\/server\/current\/learn\/services-and-indexes\/services\/analytics-service.html\">Anal\u00edtica<\/a>y comience a utilizar SQL Server con sus datos para ver qu\u00e9 informaci\u00f3n puede obtener.  Ampl\u00ede Analytics con otras herramientas utilizando las numerosas <a href=\"https:\/\/www.cdata.com\/drivers\/couchbase\/\">Controladores CData de Couchbase<\/a> que est\u00e1n a tu alcance.<\/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 v26.2 (Yoast SEO v26.2) - 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\/es\/extend-couchbase-analytics-with-sql-server-using-cdata\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\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\/es\/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\":\"es\",\"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\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/a0f07ddb4bcf033d9bab0edbfcd26291\",\"name\":\"Justin Simpson, Solutions Engineer, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/es\/author\/justin-simpson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Extend Couchbase Analytics with SQL Server using CData -","description":"Este art\u00edculo te guiar\u00e1 a trav\u00e9s de los pasos necesarios para configurar la conexi\u00f3n de Couchbase Analytics a SQL Server utilizando los drivers de 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\/es\/extend-couchbase-analytics-with-sql-server-using-cdata\/","og_locale":"es_MX","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\/es\/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":"es","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 art\u00edculo te guiar\u00e1 a trav\u00e9s de los pasos necesarios para configurar la conexi\u00f3n de Couchbase Analytics a SQL Server utilizando los drivers de CData.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-sql-server-using-cdata\/"]}]},{"@type":"ImageObject","inLanguage":"es","@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":"El blog de Couchbase","description":"Couchbase, la base de datos NoSQL","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"El blog de Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/a0f07ddb4bcf033d9bab0edbfcd26291","name":"Justin Simpson, Ingeniero de soluciones, Couchbase","image":{"@type":"ImageObject","inLanguage":"es","@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 es ingeniero de soluciones en Couchbase y lleva trabajando en TI y tecnolog\u00eda desde 2004. Reside en el \u00e1rea de Cincinnati, Ohio.","sameAs":["https:\/\/www.linkedin.com\/in\/justin-simpson-158ba44\/"],"url":"https:\/\/www.couchbase.com\/blog\/es\/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 es ingeniero de soluciones en Couchbase y lleva trabajando en TI y tecnolog\u00eda desde 2004. Reside en el \u00e1rea de Cincinnati, Ohio."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/7844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/users\/42713"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/comments?post=7844"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/7844\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media\/7475"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media?parent=7844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/categories?post=7844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/tags?post=7844"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/ppma_author?post=7844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}