Comparison of Different Extraction Transformation and Loading Tools for Data Warehousing

Abstract

Data Warehouses (DW) are database implementations that support the storage and analysis of historical data. The key components of DWs are known as Extraction, Transformation, and Loading (ETL). Since wrong or misleading data may deliver the wrong results. Suitable ETL Tools are necessary for a DW to enhance data quality. The choice of ETL tools is difficult as well as important issue in data warehousing. This paper first describes the ETL procedure in brief and compare the features of the ETL tools. In this paper, we have compared the existing ETL tools to choose the best option in different situations. From a current industrial market, we collected feedback from the industry professional and documented it to establish the relevance of the data warehouse. We have implemented the available popular ETL tools to compare their strengths and weaknesses to choose the best among them for National Health Data Warehouse of Bangladesh.