Pentaho Review

​We were able to configure our data warehouse and implement more than eight data cubes in a very short period of time.


What is most valuable?

Pentaho Data Integration - Even though this is the community edition it is very powerful compared to other expensive products like MS SQL, SSIS, or Informatica.

How has it helped my organization?

We were able to configure our data warehouse and implement more than eight data cubes in a very short period of time.

What needs improvement?

It needs to improve scheduling for the integration aspect. Pentaho Mondrian (cubes) should allow snowflake schemas

For how long have I used the solution?

We've been using the follow tools within Pentaho for two years.

Pentaho Data Integration - 5.3.0.0-213
Pentaho Aggregation Designer 2008-2012
Pentaho Schema Workbench 3.6.1
Pentaho User Console (Mondrian) 5.4.0.1.130

What was my experience with deployment of the solution?

We had no deployment issues.

What do I think about the stability of the solution?

We had no issues with the stability.

What do I think about the scalability of the solution?

We have had no issues scaling it.

How are customer service and technical support?

We haven't used tech support, but the forums are an excellent source of help.

Which solution did I use previously and why did I switch?

I have used Microsoft and Informatica. We chose Pentaho because it is an open source.

How was the initial setup?

I believe the software installation (client or server) is very straightforward.
However, complexity occurs when tuning properties for the Mondrian cubes.

What about the implementation team?

We did an in-house implementation, as it was fully customized.

What other advice do I have?

Pentaho is a good choice for Unix/Linux environments. The integration tool is quite good. The configuration for cubes is quite simple (XML) and it is very simple to configure dimensions, factual and calculated data. although, we use a Mondrian emulator (Sinatra) for our solution implementation.


Disclosure: I am a real user, and this review is based on my own experience and opinions.

Add a Comment
Guest