ETL tools for data warehousing : an empirical study of open source Talend Studio versus Microsoft SSIS
Loading...
Supplementary material
Other Title
Authors
Katragadda, Ranjith
Tirumala, Sreenivas Sremath
Nandigam, David
Tirumala, Sreenivas Sremath
Nandigam, David
Author ORCID Profiles (clickable)
Degree
Grantor
Date
2015-01
Supervisors
Type
Conference Contribution - Paper in Published Proceedings
Ngā Upoko Tukutuku (Māori subject headings)
Keyword
Extract, Transform and Load (ETL)
Talend Studio (Software)
MicrosoftSQL Server Integration Services (SSIS)
data warehouses
open source ETL
Talend Studio (Software)
MicrosoftSQL Server Integration Services (SSIS)
data warehouses
open source ETL
ANZSRC Field of Research Code (2020)
Citation
Katragadda, R., Tirumala, S.S., & Nandigam, D. (2015). ETL tools for Data Warehousing: An empirical study of Open Source Talend Studio versus Microsoft SSIS. IEEE (Ed.), CWISCE'2015 International Conference on Web Information System and Computing Education, The 2nd World Congress on Computer Applications and Information Systems (WCCAIS'2015)
Abstract
Relational databases are bound to follow various database integrity rules and constraints that makes the reporting a time consuming process. Data Warehousing has evolved out of the desperate need for easy access to structured storage of quality data that can be used for effective decision making. Data are turned into knowledge and knowledge into plans which are instrumental in profitable business decision making. To serve this purpose, data need to be extracted from various sources, transformed and loaded into the data warehouse which constitute the process of ETL (Extract, Transform and Load). ETL process can be accomplished using various tools both open source and proprietary. In this paper, we provide an empirical study of two ETL tools, an open source Talend Studio and Microsoft SSIS. In spite of the dominance among a vast majority of computer software solutions, open source technologies, as the comparative analysis that this study has undertaken, concludes that open sources tools are yet to evolve in order to be sustainable
Publisher
Institute of Electrical and Electronics Engineers (IEEE)
Permanent link
Link to ePress publication
DOI
Copyright holder
Institute of Electrical and Electronics Engineers (IEEE)
Copyright notice
All rights reserved