Database Systems Journal (Jul 2013)

A comparative Review of Extraction, Transformation and Loading Tools

  • Amanpartap Singh PALL,
  • Jaiteg Singh KHAIRA

Journal volume & issue
Vol. IV, no. 2
pp. 42 – 51

Abstract

Read online

Business today forces the enterprises to run different but coexisting information systems. However, data warehousing enterprises have a dilemma of choosing the right ETL process and the right ETL tool for their organization as one wrong step or choice may lead to a series of losses both monetarily and by time, not to mention the amount of laborious work that the workers would put in. The organization can choose from a variety of ETL tools but without exploring or the knowledge of their features this would again result in a bad decision making process. In this paper, we have tried to present a comparative review of some of the leading ETL tools just to acquaint the users with its features and drawbacks.

Keywords