Kettle turns up Xero!

Integrating to Xero.com from Pentaho Data Integration (PDI) One of the things I love about Pentaho is its great data management tool PDI, or 'Kettle' as it's known. Pentaho can load in and write out over 100 different data sources. It's the ultimate tool for data...

Mongo DB

How to set up Mongo on Pentaho

With the Pentaho 5.1 release there was a really exciting innovation - analytics directly against a Mongo DB cluster.  Mongo on Pentaho is exciting because it means that you can do advanced data discovery against Mongo collections directly. Better Together Setting...

lifebuoy, swimming ring, save

Independance from a single point of failure

Today I had to pick up from a developer who had left my team 3 months ago. This can be a challenge for any group or organisation, but it's particularly challenging when the development uses new or experimental technology. In my case, I wanted to work on a Hadoop...

woman in black shirt sitting beside black flat screen computer monitor

ETL, Excel, Data analysis: how Pentaho can help

ETL (“extract, transform, and load”) is an essential, yet inevitably complicated process when performed using the traditional method, aka using Excel. Many data analysts are, of course, accustomed to using Excel and have been trained over the years to utilise all...