« February 2009 | Main | April 2009 »

March 23, 2009

OpenERP and Pentaho

As part of some ongoing investigation work of the potential use of OpenERP, I have had a look into connecting OpenERP with Pentaho. At other times, I have implemented a limited form of Pentaho BI reporting for previous employers, but had mostly confined my activities to using the Metadata reporting object designer, which gives users the ability to create their own simple reports which they can generate as html, pdf, or spreadsheet. This time, I wanted to get to grips with the far more powerful forms of interactive reporting, which meant Mondrian.

It's not easy getting it up and running (need to setup datasources, build Modrian schemas, design MDX queries, and then implement the xaction), but once you are there, there is so much potential. The ability to tune the queries interactively using the Pivot reporting engine, and the drill down features are excellent.

Posted by PiersHarding at 1:36 PM

March 2, 2009


As part of my job at Catalyst I've been part of a process of evaluating Open Source ERP systems. The first one up is OpenERP and I have to say that I'm pleasantly surprised. Having come from a long term SAP background, I'm appreciating the thought that has gone into usability, and intuitiveness of the user experience. Also - big bonus - it's NOT written in Java, but Python!

Having just finished the Order to Cash cycle, and then followed it through on the Financial reporting. and cost account side, I'm finding that there is nothing missing that I would have expected to find from SAP - I'm excited, as I feel that OpenSource may have finally reached prime time in the ERP world.

Next up will be Compiere, which will have to go a long way to win me over I think.

Note: on reflection, I should add that this is in the context of SMB.

Posted by PiersHarding at 8:06 PM