Pentaho Review

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


Valuable Features

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.

Improvements to My Organization

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

Room for Improvement

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

Use of 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

Deployment Issues

We had no deployment issues.

Stability Issues

We had no issues with the stability.

Scalability Issues

We have had no issues scaling it.

Customer Service and Technical Support

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

Previous Solutions

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

Initial Setup

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

Implementation Team

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

Other Advice

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

Sign Up with Email