The maximum number of points awarded in our ETL tools & Data Integration Survey to an ETL tool for its ease-of-use was eleven. A maximum of two points was awarded for each of the four attributes, indicated by one or more plus (+) signs, and points were allocated depending on the number of days of training suggested by the vendors (less training required – more points for Ease of Use).
If the verdict was negative indicated by one or more minus (-) signs, points were deducted. If, for example, ease of use, WYSIWYG, and logical order earned a plus sign and screen design a minus sign, the tool was awarded two points (one point for each plus sign, minus one point for the minus sign). Since it can take considerable time to improve the usability of a product we have compared the product (where possible) over a three year period. The maximum number of points was 11.
Difference between ETL tools
There is a difference between an ETL tool offering various options and features, and making them user-friendly. A number of ETL tools offer certain features that can only be implemented by programming, either from inside the tool or from outside the tool. In these cases it was decided not to include the functionality in the final score, because the difference with regard to ‘normal programming’ was too small.
Ease of use is fairly subjective
We assumed that for a feature to be usable for a broad range of users, it had, to be implemented in an easy-to-use graphical interface, at least to some extent. Ease of use is fairly subjective and often dependent on the type of user. Several of the products with the most functionality are intended for use by BI-consultants who have a totally different vision of what is easy to use than, for example, the business user.
Business user will become important in the data integration market
Recently, we have talked to several vendors, particularly SAP, Oracle, and Pervasive, who believe that the business user will become important in the data integration market. Many of these products are now offered in a SaaS (Cloud) environment where the business user writes and maintains these processes themselves. Possibly a lesson for the more technical products who believe that their customers come from the IT department and will continue to do so.