Today we are excited to announce  a new Extension for IBM SPSS Modeler to import data from a IBM Cloudant Databases.

SPSS&Cloudant

IBM Cloudant is a NoSQL database-as-a-service (DBaaS). It is a fully managed NoSQL JSON data layer that’s always on. This service is available on Bluemix too. Some weeks ago we released an extension to read JSON files for IBM SPSS Modeler and now we have direct connection to NoSQL JSON data layers. The extension is designed to work with Bluemix. You can download the extension here: https://github.com/IBMPredictiveAnalytics/Cloudant

cloudant1

This extension will appear in your ‘Data Sources’ palette. You will need to fill the values of the host/port/username/password and database name provided automatically in by the Bluemix environment.

cloudant2

 

We have created a sample based on an IoT use case. We used the IBM Internet Of Things sensor simulator to send Temperature & Humidity every second and store all this data on IBM Cloudant. Then we use the new IBM SPSS Cloudant Extension to import the data and to do some exploratory analysis. You can find a step by step tutorial here: tutorial

SPSS19

3 comments on"New Cloudant Extension for SPSS Modeler"

  1. Very nice extension!
    I could get data from clouding DB on “Retrieve the hole database” option.
    But I cannot get data when using “Query a view” option.
    Could you give me any advice?

    My setting is as follows:

    – I made view and can get data using next URL
    https://:@-bluemix.cloudant.com/sensordata/_design/view/_view/filter

    – My Cloundant panel settings ar as follow:
    Design document: view
    View: filter
    Additional Query Parameters: (blank)

    • Thanks! I developed this extension some time ago and the Query a view it is broken….I am hoping someone to contribute and fix it, now I don’t have the bandwith.

      • In the source code,
        queryView part is as follow:

        #########################
        } else if (operation == “queryView”) {
        # executing a view
        cdb$design <- "%%design_doc%%"
        cdb$view <- "%%view%%"
        cdb$queryParams <- "%%query_params%%"
        cdb <- cdbGetView(cdb)
        modelerData <- rbind.fill(
        llply(cdb$res[[3]], function(x) data.frame(id=x$id, key=x$key, as.vector(flattenList(x$value))))
        )
        }
        ###################

        But in R4CouchDB document, a keyword of "query_params" is not "queryParams" but "queryParam".
        Is this the reason?
        Or can I see cdb$error after cdbGetView call error occurred.

        https://cran.r-project.org/web/packages/R4CouchDB/R4CouchDB.pdf

Join The Discussion

Your email address will not be published. Required fields are marked *