The ETL Tools & Data Integration Survey 2018 contains a 100% vendor independent comparison of all significant ETL tools and data integration tools in the market. Which data integration tools will dominate the ETL market in the coming years?
The survey covers 12 categories and +90 criteria
Comparison took place on 12 categories and +90 key selection criteria. Many customers from all over the world have ordered the ETL tools comparison report and got real benefits from using the information it contains.
Our survey covers at least 90% of the market
Twenty two of the major ETL vendors in this area have contributed to the survey. Get immediate insight into which ETL tools & data integration platforms have scored well on specific categories and key selection criteria. By doing so you will ensure that your organisation gets the best ETL tool for the best price. The survey (since 2004) is updated on a regular basis.
Future prospects of ETL tools
Originally we looked at the number of features a product had and compared that with the number of years the product had been on the market to calculate a growth rate. We stopped doing that for two reasons; firstly, there were a number of relatively new products on the marketplace with a broad functionality that would score unreasonably high if we calculated this way. Secondly, many products were acquired by other vendors and given a new name, allowing the vendors to claim that they had only recently entered the market.
A newer method was used
After using this method a newer method was introduced. The growth potential, as defined within the confines of this ETL study, looked at how frequently a vendor released new, valuable features, an important indicator for innovation and the strategic importance of the product to the vendor. With a maturing market, and “softer” aspects of the software becoming more important, we once again decided to change our method.
To determine the future prospects of the ETL vendors we now base our research around four questions, that we score with plusses and minuses:
- How large is the current install base? The size of the current install base gives an indication of the financial strength of the vendor and the vested interests of the customers because of lock-in effects. Both factors contribute to a higher chance of survival in the long run.
- Have there been major developments and improvements in the past three years? By researching the new features of the software (amongst others by analysing all release notes) we can form a clear idea of the activity of the vendor on improving the software. Where improvement is lacking, chances are the product is slipping.
- What is the current maturity level? By means of our own survey results we can rank the software from least to most mature. We believe that an already proven and mature product has a better chance of prospering in the market than a less developed product.
- Is there a clear roadmap and will there be significant developments and improvements? The clear roadmap is an indicator of two things: the vendor has defined a clear point on the horizon, which allows him to efficiently direct all resources to this point. It allows the vendor to take leadership in the market. Furthermore it usually also means that the vendor has considerable “marketing muscle”. Both factors contribute to a higher chance of dominating the market.
By answering these questions we try to get a clearer image of where their future is heading. The scoring was done by awarding plusses and minuses (ranging from – to ++) on all four criteria.
Which tools will dominate the market in the coming years?
Can we look ahead and measure which of the products will still be strong and which will not. We have made an attempt to do just that.
The top contenders
The top contenders are IBM InfoSphere Information Server, SAP Data Services and SAS Data Management. IBM has three solutions in the graph, but is bringing this number back to one (Information Server). IBM InfoSphere Warehouse Edition and IBM Cognos Data Manager will be end of life and current installations will be replaced by Information Server in due time.
All three vendors have a large install base, which gives them the financial means for profound development. These three vendors also have shown a serious commitment to the development of the software and the accompanying conceptual framework and they are really pushing the envelope of ETL software. By redefining the field of Data Integration, they will probably have the best future prospects.
Open source tool Talend follows
Talend follows shortly after these three vendors and is growing rapidly. It has strong financial backing and a strong focus on Big Data. Also because it is a relatively young company (founded in 2006) it is unhindered by legacy design decisions, allowing it to fully focus on all current concepts.
ODI and PowerCenter are trailing behind
Informatica PowerCenter and Oracle Data Integrator are trailing a little behind in terms of scoring. Both have large user bases and are very mature products, but they seem to lack the strong vision and roadmap of the top contenders. Knowing that they have always been able to make a strong point we expect them to present a good vision of the future of ETL shortly. The same goes for the next three, Pervasive Data Integrator, SQL Server Integration Services and Information Builder’s DataMigrator. Oracle is also reducing its number of products, Oracle Warehouse Builder will be integrated into Oracle Data Integrator and will be end of life by 2021.
Other notable vendors
Other notable vendors are CloverETL and Syncsort DMX. Syncsort has been offering a very mature product for a long time now. CloverETL also has a well-rounded product now. Then there is a special mention for Pentaho. It is making big steps in terms of product maturity and also has a respectable user base.