A Comparative Analysis of Extract, Transformation and Loading (ETL) Process

2nd International Conference on Innovation in Engineering and Vocational Education

工业技术;教育

Runtuwene, J.P.A.^1 ; Tangkawarow, I.R.H.T.^1 ; Manoppo, C.T.M.^1 ; Salaki, R.J.^1

Universitas Negeri Manado, Tondano Sulawesi Utara

95618, Indonesia^1

关键词: Comparative analysis;    Data and information;    Decision making process;    ETL process;    Integration process;    Integration services;    Microsoft SQL Server;    Number of datum;   

Others  :  https://iopscience.iop.org/article/10.1088/1757-899X/306/1/012066/pdf
DOI  :  10.1088/1757-899X/306/1/012066

来源: IOP

【 摘 要 】

The current growth of data and information occurs rapidly in varying amount and media. These types of development will eventually produce large number of data better known as the Big Data. Business Intelligence (BI) utilizes large number of data and information for analysis so that one can obtain important information. This type of information can be used to support decision-making process. In practice a process integrating existing data and information into data warehouse is needed. This data integration process is known as Extract, Transformation and Loading (ETL). In practice, many applications have been developed to carry out the ETL process, but selection which applications are more time, cost and power effective and efficient may become a challenge. Therefore, the objective of the study was to provide comparative analysis through comparison between the ETL process using Microsoft SQL Server Integration Service (SSIS) and one using Pentaho Data Integration (PDI).