Best ETL Tool Survey Nov 2016 Results

Please find below the results of the best ETL tool from a developer's perspective survey carried out between 1st Nov 2016 till 16th Dec 2016. Survey link was shared on LinkedIn and on this site. 

Thanks to all those DWH/BI developers who took part in this survey. Also thanks to all the members in LinkedIn groups like Data Warehousing (Business Intelligence, ETL) Professional's Group who provided their inputs via comments.

Results from the Survey 

Which is the best ETL tool?


Which ETL tools have you used?

Which is the best ETL tool?


Which is the best ETL tool?

Results based on comments in LinkedIn, as of 18th Dec 2016 is given below 


Which is the best ETL tool?

Survey Result Analysis

  • 425 responses were collected through the survey between 1st Nov 2016 and 16th Dec 2016.
  • Informatica is the most popular and the best ETL Tool from a developer's perspective based on the survey results.
  • Out of those respondents who have experience in multiple tools including both DataStage and Informatica, 20% consider DataStage as the best and 46% consider Informatica as the best ETL tool.
  • Out of those respondents who have experience in multiple tools including  Abinitio, Datastage and Informatica, 18% consider Abinitio as the best, 18% consider Datastage as the best and 40% consider Informatica as the best.
  • Out of those respondents who have experience in multiple tools including  Datastage, Informatica and SSIS,  15.6% consider DataStage as the best, 41% consider Informatica as the best and 12.5% consider SSIS as the best ETL tool.
  • Out of those respondents who have experience in multiple tools including both PDI and Talend, 17% consider PDI as the best and 23% consider Talend as the best ETL tool.
  • Those who selected the option "other" have mentioned these tools 
            Clover ETL  14 responses
            AWS EMR-Hive,Pig ,Spark . AWS Data pipeline,AWS dms
            Matillion for Amazon Redshift
            Wherescape RED  2 responses
            Ko
            Code. They're all significantly worse than code.
            Denodo
            Stambia  2 responses
            Rivery.io
            Datawa.re
            Alteryx
            Rapid ETL from CamArch
            QlikView
            Xpert BI

  • Below chart provides a view of the % of respondents who have experience in a particular tool among other tools and have selected that tool as the best ETL tool. 
                            Best ETL tool in the market

                            Hope these Survey results and analysis are useful to the BI community. If you need a specific comparison that is not listed above let me know through comments so that I can analyze the data and add it to the list. 

                            Currently there are two more BI related surveys open, please take part and also share it with your BI connections. It shouldn't take more than 5 minutes to participate in both the surveys.

                            DWH Development related Survey

                            BI Jobs related Survey


                            Comments

                            1. This is really just a survey of what tools are being used, not really which tool is 'best'. Note that the pattern of 'best' tool exactly follows the pattern of usage.

                              ReplyDelete
                              Replies
                              1. Thanks for the comment, Please check the Survey Result Analysis part too just in case you missed it. If possible, See if you can talk to people who have used multiple ETL Tools and ask them which one they consider is the best from a developer's perspective and if possible share the results. All of us in DWBI will benefit. I don't consider myself as an authority on these topics to say something is best or not, I am just sharing the results without any bias. Remember its an independent survey with no sponsors.

                                Delete

                            2. Interesting blog, here a lot of valuable information is available, it is very useful information informatica online training

                              ReplyDelete

                            Post a Comment

                            Thanks for your comment. It will be posted after checks.

                            Popular posts from this blog

                            ETL developer vs Data engineer

                            KABI - The new Agile Methodology for BI Projects - Implement BI projects quicker happily

                            BI Architect course and BI Tool question