21 Mar 2008

Pentaho Kettle vs Informatica PowerCenter

After having a successful presentation to a major car manufacturer in China, I have decided to upload my presentation so that other people may benefit and recommend it to their bosses.

In the presentation I research Talend, Pentaho, Informatica and Inaport(CRM data importer).

So the presentation is biased to Pentaho (and the Use Cases inside the presentation are from the Pentaho website).

My Presentation

Please enjoy and distribute.

8 comments:

  1. One thing that nobody is talking about is the level of support and the kind of project success. Come on Folks let's be practical with Open source software the kind of support that even a medium size company could get would certainly scare the hell out of a project manager i.e. you are integrating 50 Million rows every night and imagine a product bug coming up suddenly with the open source software.

    When we talk abt project success, commercial s/w have a case to prove and when you talk abt the cost of development you can get an ETL developer for as low as 15$/Hr (Ofcourse Outsourcing which the organizations would use anyways and local developer 55-75$/hr). Also all the features provided by the so called Open source ETL are hardly free. anyways just my thought no offence to anybody here

    ReplyDelete
  2. The link does not seem to point to the comparison between Informatica / Pentaho / Talend. Could you please fix it ?

    ReplyDelete
  3. Regarding what "Anonymous" said, Jonathan clearly states the presentation is biased to Pentaho.

    I took a look at it. When I saw that risk on Informatica was RED and on Pentaho was yellow I laughed out loud. Informatica should be green. If I was risking my job on the decision, I would choose Informatica. If I was risking my boss's job, I might choose Pentaho. :-)

    Of course, like I said, Jonathan was clear about the purpose of the presentation.

    Cheers!

    ReplyDelete
  4. I wouldn't take a presentation from anyone who has not used a tool. Take PDI (aka Kettle from Pentaho) for example.

    Just try to "Generate Rows" then check an Integer is on range using "Data Validator". It should be common sense, but I bet you are going to have a rough time with things like "During validation of field 'age' we found that value [Integer(2)] contains non-numeric information". Just really, try it, and time how much does it takes for you to generate a freaking integer that the tool recognizes as that.

    I already realized we are going to need training, but that should be needed for complex tasks, not for silly stuff. It's a long time before you learn the tricks and quirks of the tool, and that time is going to cost a lot of money.

    You can also execute a sample transformation and look at the source code of the involved classes. 25 constructors on the same class? logger instances as parameters of constructors? jesus, my eyes!

    ReplyDelete
  5. Anonymous said...
    "Come on Folks let's be practical with Open source software..."
    Thanks Anonymous, I'll be completely practical. Pentaho Data Integration (Kettle) is commercially backed by Pentaho Corporation. You can purchase support contracts just as you would for proprietary software.

    On top of that, you get all the freedoms associated with open source software, and from experience I can say that Pentaho Support will try and help you through customisations that you might want to make.

    "When we talk abt project success, commercial s/w have a case to prove and when you talk abt the cost of development you can get an ETL developer for as low as 15$/Hr (Ofcourse Outsourcing which the organizations would use anyways and local developer 55-75$/hr)"You can probably hire a Java developer for a similar amount. Through being open source, Kettle gives you the opportunity to alter the product to suit your business, so you are not forced to alter your business to suit the product.

    "Also all the features provided by the so called Open source ETL are hardly free."How so? Kettle is a free download. You also have the option to pay for commercial enterprise-level support should you need it. However, you are not forced to do this as you would be with proprietary software - it's your choice.

    As a disclaimer I'll state that I do work for a company that sells Pentaho support and services, but I stand by my words one hundred per cent.

    ReplyDelete
  6. Michael Grecol26 July 2012 at 16:06

    Hi All,
    I wrote a white paper on SSIS vs Pentaho.
    SSIS vs Pentaho

    I hope someone finds it useful.

    Mike

    ReplyDelete