Friday, 4 July 2014

Talend vs Pentaho (ETL) review

Informatica happens to be the current leader in the ETL stack, but as a result of rapid business change, the demaqnd of light weight tools for the Small and medium size industry has increased exponentially.This sector is very particular on cost and would need a tool to address its data migration activities across different environments.High end tools like Informatica have thus released their thinner version i.e. Informatica Powercenter express to address such clients, which generally have data migration requirements. It is one time, across heterogeneous sources and very tight on cost.
We shall be reviewing Talend and Pentaho ETL tools which belong to the same space.

Talend

I installed the latest version for talend 5.5.1 and tried exploring the same. My reviews are as follows:

Pros
1. 30 day free trial version available.
2. Server - 2 GB
3. Free and comprehensive documentation.
4. Exceptional tool for people coming from Java coding background. The ETL concept is partially GUI based (unlike Informatica) and uses a lot of Java code to implement data transformations. Good tool for coders who want to learn ETL.
5. No database required for repository metadata.
6. Integration with a wide variety of storage systems including-Amazon Web Services' RDS, Big Data,WSDL etc.

Cons
1. Bit complicated to adopt for people who have worked on complete GUI based ETL tools like Informatica
2. The help center is available for 4 countries only, so your server should reside in one of these countries for you to access the same. India is not one of those countries :D

Pentaho

After my tryst with Talend, I decided to explore the data Integration suite of Pentaho.Reviews are as follows:

Pros
1. Very easy to install and use
2. Comprehensive documentation (better than talend)
3. Less coding more of GUI.
4. No database required for repository metadata.
5. Custom output that can be used by the Reporting tool of Pentaho.

Cons
1. No direct integration with WSDL.

 

5 comments:

  1. As I am fresher I have an interest in new technology.so,now I am planning to learn Informatica in your blog i had some interesting concepts, it was crystal clear to read keep sharing thanks from Informatica training in chennai

    ReplyDelete
  2. Hi Akshat,
    I am following your blog from the beginning, it was so distinct & I had a chance to collect conglomeration of information that helps me a lot to improvise myself.
    Thanks,
    Web design training in Chennai

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. Hey guys, wonderful to read your comments :) thanks for all the encouragement.Feel free to reach me out on the mail provided in the about me section.

    ReplyDelete
  5. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing.
    Regards,
    sas training chennai | sas course in Chennai

    ReplyDelete