« February 2013 | Main | July 2014 »

September 10, 2013

Integrating R with Pentaho

RPentaho - R integration for Pentaho based on community tools.

Recently, I've been involved in a project that has implemented Pentaho for an Analytics solution for Moodle . This is a large (and probably will be very large) Moodle implementation, so standard Moodle reporting is just not up to it.
One of the requirements was to be able to export student interaction and activity completion data. This can quickly become huge, and the standard Pentaho CSV exporting interfaces can't cope, but there is a good solution to this based on the WebDetails CDA and CDB work. What WebDetails have done, is provide an excellent authenticated JSON API for common Pentaho queries, whether they be Saiku Analytics or Saiku Adhoc queries. With this, a user can use the familiar tools to design a query, and then bookmark it.

To complete the loop, I've written a library for R that uses the JSON interface to access these stored queries, and import the data as a standard data.frame object - RPentaho.

Posted by PiersHarding at 9:02 AM