{"id":7458,"date":"2019-08-09T09:57:37","date_gmt":"2019-08-09T16:57:37","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=7458"},"modified":"2024-09-12T01:15:53","modified_gmt":"2024-09-12T08:15:53","slug":"extend-couchbase-analytics-with-rapidminer-using-cdata","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/","title":{"rendered":"Extend Couchbase Analytics with RapidMiner using CData"},"content":{"rendered":"<h2>Extend Couchbase Analytics with RapidMiner using CData<\/h2>\n<p>This article will guide you through the steps needed to setup the connection from RapidMiner to Couchbase Analytics using the CData JDBC driver for Couchbase. More details regarding this driver can be <a href=\"https:\/\/www.cdata.com\/kb\/tech\/couchbase-jdbc-rapidminer.rst\">found here<\/a>.<\/p>\n<h3>Prerequisites<\/h3>\n<h4>Couchbase<\/h4>\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>\n<p>If you do not have an existing Couchbase Server EE cluster, the following links will get you up and running quickly:<\/p>\n<ol>\n<li><a href=\"https:\/\/www.couchbase.com\/downloads\/\">Download Couchbase Server EE<\/a><\/li>\n<li>Install Couchbase Server EE\n<ul>\n<li><a href=\"https:\/\/docs.couchbase.com\/server\/6.0\/install\/macos-install.html\">Mac OS X<\/a><\/li>\n<li><a href=\"https:\/\/docs.couchbase.com\/server\/6.0\/install\/install-linux.html\">Linux<\/a><\/li>\n<li><a href=\"https:\/\/docs.couchbase.com\/server\/6.0\/install\/install-package-windows.html\">Windows<\/a><\/li>\n<\/ul>\n<\/li>\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>&nbsp;(NOTE: use the default values for cluster configuration)<\/li>\n<\/ol>\n<h4>CData JDBC driver for Couchbase<\/h4>\n<p>Next you will need to download and install the <a href=\"https:\/\/www.cdata.com\/drivers\/couchbase\/jdbc\/\">CData JDBC driver for Couchbase.<\/a><\/p>\n<p>Once downloaded and unpackaged you will want to setup the license:<\/p>\n<h5><strong>Command Line Activation<\/strong><\/h5>\n<p>The setup process should automatically install a license for your system. However, you may also install a license from the command line via cdata.jdbc.couchbase.jar. To do so execute the following command: java -jar cdata.jdbc.couchbase.jar -license. This process will create a&nbsp;<i>cdata.jdbc.couchbase.lic<\/i>&nbsp;that must reside next to the jar or in the&nbsp;<i>.cdata<\/i>&nbsp;directory under the user&#8217;s home directory.<\/p>\n<h5><strong>Trial License Installation<\/strong><\/h5>\n<p>The setup process should automatically install a trial license for your system. You may also use the method described in the &#8220;Command Line Activation&#8221; section above to install a trial license. Simply enter &#8220;TRIAL&#8221; as the product key when prompted.<\/p>\n<p><strong>Note**<\/strong> The cdata.jdbc.couchbase.lic must reside next to the jar or in the&nbsp;<i>.cdata<\/i> directory under the user&#8217;s home directory. i.e. \u201c\/Users\/justinsimpson\/.CData\/cdata.jdbc.couchbase.lic\u201d<\/p>\n<h3>Couchbase Setup<\/h3>\n<p>In Couchbase click on <em>Settings&nbsp;<\/em><\/p>\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>\n<p>Then <em>Sample Buckets<\/em><\/p>\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>\n<p>The select the beer-sample checkbox and select <em>Load Sample Data.&nbsp; <\/em>You can then navigate back to your<em> Buckets<\/em> and see <em>beer-sample.<\/em><\/p>\n<p>Once this is complete, we will need to setup Analytics.<\/p>\n<p>Select&nbsp;<em>Analytics, <\/em>then create the shadow dataset of <em>beers <\/em>from the bucket of <em>beer-sample.<\/em><\/p>\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>\n<pre class=\"lang:default decode:true\">CREATE DATASET beers ON `beer-sample` WHERE `type` = \"beer\";<\/pre>\n<p>Click&nbsp;<em>Execute,&nbsp;<\/em>this will crate the shadow dataset definition.<\/p>\n<p>I want to repeat this step by creating a second shadow dataset with the following definition.<\/p>\n<pre class=\"lang:default decode:true\">CREATE DATASET breweries ON `beer-sample` WHERE `type` = \"brewery\";<\/pre>\n<p>Next you will want to initialize it by activating the dataset with the following.<\/p>\n<pre class=\"lang:default decode:true \">CONNECT LINK Local;<\/pre>\n<p>Click Execute.<\/p>\n<p>You can now test this out within the Analytics dashboard by running something like the following.<\/p>\n<pre class=\"lang:default decode:true\">SELECT COUNT(*) FROM beers\r\nUNION ALL\r\nSELECT COUNT(*) FROM breweries;<\/pre>\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>\n<p>Your setup for Couchbase is complete!<\/p>\n<h3>Setup RapidMiner<\/h3>\n<p>To accomplish the simple task of using RapidMiner as an extension of Couchbase Analytics, there are 2 basic steps.<\/p>\n<ol>\n<li>Setup a connection<\/li>\n<li>Create a process that has an 2 operators to &#8216;Read Database&#8217;.&nbsp; You might also want to store those results locally to combine it and use some other operators and process within RapidMiner.<\/li>\n<\/ol>\n<h4>Setup a Connection<\/h4>\n<p>Within RapidMiner, I start from a Blank Process. Under connections I select&nbsp;<em>Create Connection&nbsp;<\/em>and give it a conneciton name.&nbsp; In this example I use &#8216;CBLocal&#8217;.<\/p>\n<div id=\"attachment_7464\" style=\"width: 471px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7464\" class=\"wp-image-7464\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/CreateConnection-1024x688.png\" alt=\"Setup RapidMiner Connection JDBC Connection\" width=\"461\" height=\"310\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/CreateConnection-1024x688.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/CreateConnection-300x202.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/CreateConnection-768x516.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/CreateConnection-20x13.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/CreateConnection.png 1194w\" sizes=\"auto, (max-width: 461px) 100vw, 461px\" \/><p id=\"caption-attachment-7464\" class=\"wp-caption-text\">Setup RapidMiner Connection JDBC Connection<\/p><\/div>\n<p>On the&nbsp;<em>Setup<\/em> tab, I make sure the Database system is set to &#8220;Custom (configure in Driver tab) and I select Configure URL Manually.<\/p>\n<div id=\"attachment_7465\" style=\"width: 910px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7465\" class=\"wp-image-7465 size-large\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/ConfigureConnection-1024x690.png\" alt=\"Setup RapidMiner Connection JDBC URL for Couchbase Analytics\" width=\"900\" height=\"606\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/ConfigureConnection-1024x690.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/ConfigureConnection-300x202.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/ConfigureConnection-768x518.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/ConfigureConnection-1536x1036.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/ConfigureConnection-20x13.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/ConfigureConnection-1320x890.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/ConfigureConnection.png 1658w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><p id=\"caption-attachment-7465\" class=\"wp-caption-text\">Setup RapidMiner Connection JDBC URL for Couchbase Analytics<\/p><\/div>\n<p>I populate the URL with the following:<\/p>\n<pre class=\"lang:default decode:true \">jdbc:couchbase:User=Administrator;Password=password;Server=localhost;CouchbaseService=Analytics;Dataverse=Default;QueryPassthrough=true;verbosity=5;FlattenArrays=4<\/pre>\n<p>All of the connection string options and details can be found under the <a href=\"https:\/\/cdn.cdata.com\/help\/CKB\/jdbc\/Connection.htm\">CData JDBC connection string options<\/a>.<\/p>\n<p>Next, select the&nbsp;<em>Driver<\/em> tab to finish the setup.<\/p>\n<p>In order to setup the JDBC driver Jar file, click the folder icon to browse to the location of the cdata.jdbc.couchase.jar.&nbsp; Once this is selected, you can choose &#8216;cdata.jdbc.couchbase.CouchbaseDriver&#8217; in the dropdown list.<\/p>\n<div id=\"attachment_7466\" style=\"width: 910px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7466\" class=\"wp-image-7466 size-large\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/driverconnection-1024x690.png\" alt=\"Setup RapidMiner Connection JDBC Driver for Couchbase Analytics\" width=\"900\" height=\"606\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/driverconnection-1024x690.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/driverconnection-300x202.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/driverconnection-768x518.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/driverconnection-1536x1036.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/driverconnection-20x13.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/driverconnection-1320x890.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/driverconnection.png 1658w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><p id=\"caption-attachment-7466\" class=\"wp-caption-text\">Setup RapidMiner Connection JDBC Driver for Couchbase Analytics<\/p><\/div>\n<p>You can now click Test connection to verify your setup is complete.<\/p>\n<h3>Using RapidMiner<\/h3>\n<p>Now that RapidMiner has a new connection configured, its time to load some data!<\/p>\n<p>Start from a blank process.<\/p>\n<ol>\n<li>Drag and drop the operator &#8216;Read Database&#8217; (its important to connect the output (out) to the results (res) in the Process window)<\/li>\n<li>Select the connection you just created<\/li>\n<li>Select Build SQL Query and enter the query you would like to pass to Couchbase Analytics\n<pre class=\"lang:default decode:true \">SELECT brewery_id,name,style,abv FROM beers;<\/pre>\n<\/li>\n<li>Click the &#8216;Play&#8217; Button to get the results!<\/li>\n<\/ol>\n<div id=\"attachment_7468\" style=\"width: 910px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7468\" class=\"wp-image-7468 size-large\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/RMSetup-1024x581.png\" alt=\"Setup RapidMiner Read Database Operator from Couchbase Analytics\" width=\"900\" height=\"511\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMSetup-1024x581.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMSetup-300x170.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMSetup-768x436.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMSetup-1536x872.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMSetup-20x11.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMSetup-1320x749.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMSetup.png 2048w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><p id=\"caption-attachment-7468\" class=\"wp-caption-text\">Setup RapidMiner Read Database Operator from Couchbase Analytics<\/p><\/div>\n<p>My result set looks like this&#8230;<\/p>\n<div id=\"attachment_7471\" style=\"width: 910px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7471\" class=\"wp-image-7471 size-large\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/RMResults-1024x755.png\" alt=\"RapidMiner Results from Couchbase Analytics\" width=\"900\" height=\"664\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMResults-1024x755.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMResults-300x221.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMResults-768x566.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMResults-1536x1133.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMResults-20x15.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMResults-1320x974.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMResults.png 1920w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><p id=\"caption-attachment-7471\" class=\"wp-caption-text\">RapidMiner Results from Couchbase Analytics<\/p><\/div>\n<p>If you wanted to store those results and create multiple dataset to utilize other RapidMiner tools you would simply add an additional operator by dragging the &#8216;Store&#8217; operator and setting up the location where you would like to store the data.<\/p>\n<p><strong>Note**<\/strong>&nbsp; You need to make sure that the connection from the output (out) from the &#8216;Read Database&#8217; operator to the input (inp) of Store operator is set properly.<\/p>\n<div id=\"attachment_7470\" style=\"width: 910px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7470\" class=\"wp-image-7470 size-large\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/RMStore-1024x513.png\" alt=\"Setup RapidMiner Store\" width=\"900\" height=\"451\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMStore-1024x513.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMStore-300x150.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMStore-768x385.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMStore-1536x770.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMStore-20x10.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMStore-1320x661.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMStore.png 2048w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><p id=\"caption-attachment-7470\" class=\"wp-caption-text\">Setup RapidMiner Store<\/p><\/div>\n<p>I then repeated this process for the other shadow dataset we created &#8216;breweries&#8217; as you can see above under the data section.<\/p>\n<p>More about Rapid Miner Studio can be <a href=\"https:\/\/rapidminer.com\/get-started\/\">found here.<\/a><\/p>\n<h3>Next Steps<\/h3>\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 <a href=\"https:\/\/rapidminer.com\/get-started\/\">RapidMiner<\/a> with your data and see what insights you can gleam.&nbsp; 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>\n","protected":false},"excerpt":{"rendered":"<p>Extend Couchbase Analytics with RapidMiner using CData This article will guide you through the steps needed to setup the connection from RapidMiner to Couchbase Analytics using the CData JDBC driver for Couchbase. More details regarding this driver can be found [&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,2242,2294],"tags":[2378],"ppma_author":[9087],"class_list":["post-7458","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-best-practices-and-tutorials","category-connectors","category-analytics","tag-6-5"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.7.1 (Yoast SEO v25.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Extend Couchbase Analytics with RapidMiner using CData - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"This article will guide you through the steps needed to setup the connection from RapidMiner to Couchbase Analytics using the CData JDBC driver for Couchbase.\" \/>\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-rapidminer-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 RapidMiner using CData\" \/>\n<meta property=\"og:description\" content=\"This article will guide you through the steps needed to setup the connection from RapidMiner to Couchbase Analytics using the CData JDBC driver for Couchbase.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-09T16:57:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-12T08:15:53+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=\"6 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-rapidminer-using-cdata\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/\"},\"author\":{\"name\":\"Justin Simpson, Solutions Engineer, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/a0f07ddb4bcf033d9bab0edbfcd26291\"},\"headline\":\"Extend Couchbase Analytics with RapidMiner using CData\",\"datePublished\":\"2019-08-09T16:57:37+00:00\",\"dateModified\":\"2024-09-12T08:15:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/\"},\"wordCount\":960,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png\",\"keywords\":[\"6.5\"],\"articleSection\":[\"Best Practices and Tutorials\",\"Connectors\",\"Couchbase Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/\",\"name\":\"Extend Couchbase Analytics with RapidMiner using CData - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png\",\"datePublished\":\"2019-08-09T16:57:37+00:00\",\"dateModified\":\"2024-09-12T08:15:53+00:00\",\"description\":\"This article will guide you through the steps needed to setup the connection from RapidMiner to Couchbase Analytics using the CData JDBC driver for Couchbase.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-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-rapidminer-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 RapidMiner 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 RapidMiner using CData - The Couchbase Blog","description":"This article will guide you through the steps needed to setup the connection from RapidMiner to Couchbase Analytics using the CData JDBC driver for Couchbase.","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-rapidminer-using-cdata\/","og_locale":"en_US","og_type":"article","og_title":"Extend Couchbase Analytics with RapidMiner using CData","og_description":"This article will guide you through the steps needed to setup the connection from RapidMiner to Couchbase Analytics using the CData JDBC driver for Couchbase.","og_url":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/","og_site_name":"The Couchbase Blog","article_published_time":"2019-08-09T16:57:37+00:00","article_modified_time":"2024-09-12T08:15:53+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":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/"},"author":{"name":"Justin Simpson, Solutions Engineer, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/a0f07ddb4bcf033d9bab0edbfcd26291"},"headline":"Extend Couchbase Analytics with RapidMiner using CData","datePublished":"2019-08-09T16:57:37+00:00","dateModified":"2024-09-12T08:15:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/"},"wordCount":960,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png","keywords":["6.5"],"articleSection":["Best Practices and Tutorials","Connectors","Couchbase Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/","url":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/","name":"Extend Couchbase Analytics with RapidMiner using CData - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/RMFI.png","datePublished":"2019-08-09T16:57:37+00:00","dateModified":"2024-09-12T08:15:53+00:00","description":"This article will guide you through the steps needed to setup the connection from RapidMiner to Couchbase Analytics using the CData JDBC driver for Couchbase.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-using-cdata\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-rapidminer-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-rapidminer-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 RapidMiner 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\/7458","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=7458"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/7458\/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=7458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/categories?post=7458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/tags?post=7458"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=7458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}