A comparative Review of Extraction, Transformation and Loading Tools

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 a...

Full description

Bibliographic Details
Main Authors: Amanpartap Singh PALL, Jaiteg Singh KHAIRA
Format: Article
Language:English
Published: Bucharest University of Economic Studies 2013-07-01
Series:Database Systems Journal
Subjects:
Online Access:http://www.dbjournal.ro/archive/12/12_5.pdf
Description
Summary: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.
ISSN:2069-3230