ETL Tools Comparison


What are some best ETL Tools in the market available for business use? What are the matrics on which i can compare them?

Prince Kumar
11 months ago

3 answers


That depends on your purpose, budget and resources?
Informatica, SAS, Oracle Warehouse Builder are powerful but requires large infrastructure to setup and trained staff to use them.
Talend, Pentaho, and CloverETL are open source and easier to adopt and deploy to get things started. The things to look for are:
Features, Adapters ( how many DB they can connect with no customization) , Cost ( be careful as the cost structures are all different- no apple/apple comparison) users and BI support .
Homework before looking: Ho many data sources you have. Local/ global deployment- Internal resources or consultant- you MUST have your own data modeler that understand your data structure today.

Nasser Mirzai
11 months ago

Informatica is one of the best ETL tool in market. If you go by numbers of projects go live rate , informatica is way ahead than its competitors. Second best is IBM Datastage with distinctive figures, followed by Microsoft's SSIS & Oracle's ODI.
See complete rating by the most trusted vendor (Gartner) for ETL / Data Integration Tool review...

Uday Mannam
11 months ago

Hi Prince, good question! Mode has a great article comparing ETL tools. Here are the criteria they used:

  • Security
  • Data quality
  • Data completeness
  • Data usability
  • Support
  • Integrations
  • Price
  • Additional features
  • Application surface area
  • Setup

Ultimately, they chose Etleap as their primary ETL provider because it excelled in their top five evaluation dimensions (disclosure: I work with Etleap). They decided Etleap met the required security bar, provided reliable data, had the most complete data, and excellent support.
Hope that's helpful!

Greg Kogan
10 months ago

Have some input?