ETL Tools: Functionality and Ease of Use

by Katherine VasilegaNovember 29, 2010

I continue with helping you to evaluate ETL tools. On the dawn of data integration, ETL tools were supposed to be used by IT people. Today, they have to be managed by business users. At the same time, the increasing complexity of data sets requires ETL tools to have many sophisticated functions and features. So, what is the right combination of functionality and ease of use?

Here are some core features that are a must for modern ETL tools:

    • The ability to deal with multiple data formats
    • Built-in analysis functionality allowing the examination of source data
    • Built-in data transformation functions
    • Support for data quality checking
    • Support for cleansing functionality
    • Metadata support that provides for creating business rules
    • Task scheduling functionality
    • Error tracking and logging

The following functionality is required for ETL tools to be leveraged by business users:

    • GUI interface that enables to drag and drop data elements from the source to the target
    • Intuitive interface for building data maps
    • Easy management of data maps
    • The ability to manipulate data either inside or outside the target database
    • Comprehensive user manuals and demos

In addition, it is a good idea to avoid purchasing ETL tools that are difficult to troubleshoot and maintain. Remember that you should define your master data requirements and data integration goals before selecting an ETL tool.

If you’re still looking for an ETL tool and do not know where to start, add Apatar to your evaluation list.

“I’ve used Apatar to successfully and quickly deal with several CMS data migrations now. I’m very happy with the features and ease of use. Not much else I can say except Apatar is now my Swiss Army Knife for database “stuff”—it does everything I want, and it just works!” —Brad Cook, Swordfrog Systems