A COMPARATIVE STUDY OF ETL TOOLS

Article Sidebar

PDF
Published: Jul 12, 2022
DOI: https://doi.org/10.26483/ijarcs.v9i4.6849
Keywords:
ETL tools, data integration, data warehouse, business intelligence

Main Article Content

Deepti Durgawat
Manish Shrimali

Abstract

ETLstands for Extract, Transform and Load.It is an integral component of data warehouse application.Efficiency of any data warehouse application is mainly depended upon the effective implementation of this ETL process for acquiring strategic information. ETL tool combines theses three database functions to automate the process of retrieving data from one or more databases, then processes and place it in a target database. So, it is important to choose right ETL tool for organizations according to the requirements.In this study, a comparative review of some of the leading ETL tools has been discussed just to acquaint with their features and utility.

Downloads

Download data is not yet available.

Article Details

Issue
Vol. 9 No. 4 (2018): July – August 2018
Section
Articles

COPYRIGHT

Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.

Authors who publish with this journal agree to the following terms:

  • Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
  • Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
  • Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
  • The journal allows the author(s) to retain publishing rights without restrictions.
  • The journal allows the author(s) to hold the copyright without restrictions.
Author Biography

Deepti Durgawat

Research Scholar,

JRN Rajasthan Vidyapeeth University, Udaipur (Rajasthan), India

References

Madsen, M. (October, 2004). “Criteria for ETL Product Selectionâ€. InfoManagement.

Larson, B. (2008). “Delivering BusinessIntelligence with Microsoft SQLServerâ€. New York:McGraw-HillOsborne Media.

Levin Jonathan (2008),“Open SourceETL tools vsCommercial ETL toolsâ€. Retrievedfrom http://www.jonathanlevin.co.uk/2008/03/open-source-etl-tools-vs-commerical-etl.html

Mark A. Beyer, Eric Thoo, EhtishamZaidi, Rick Greenwald (2016), Magic Quadrant for Data Integration Tools, Retrived from https://www. gartner.com/doc/reprints

Nils Schmidt, Mario Rosa, Rick Garcia, Efrain Molina, Ricardo Reyna and John Gonzale, “ETL Tool Evaluation – A Criteria Frameworkâ€, In Proceedings of the SWDSI (Southwest Decision Sciences Institute) 2011 conference.

Zode, M. (2007), “The Evolution of ETL – From Hand-coded ETL to Tool-based ETLâ€.Cognizant Technology Solutions.

Talend (2017), “Talend Open Studio for Data Integration User Guideâ€, Adapted for v6.5.0M1

T. A. Majchrzak, T. Jansen and H. Kuchen (March, 2011), “Efficiency evaluation of open source ETL toolsâ€, In Proceedings of the ACM Symposium on Applied Computing, pp. 287-294.