Extraction transformation load (ETL) solution for data integration: a case study of rubber import and export information

Data integration is important in consolidating all the data in the organization or outside the organization to provide a unified view of the organization's information. Extraction Transformation Load (ETL) solution is the back-end process of data integration which involves collecting data from...

Full description

Bibliographic Details
Main Authors: Jamaluddin, M. S., Azmi, N. F. M.
Format: Article
Language:English
Published: Penerbit UTM Press 2016
Subjects:
Online Access:http://eprints.utm.my/71663/1/MimiSafinazJamaluddin2016_ExtractionTransformationLoad%20ETLSolution.pdf
_version_ 1796861805138542592
author Jamaluddin, M. S.
Azmi, N. F. M.
author_facet Jamaluddin, M. S.
Azmi, N. F. M.
author_sort Jamaluddin, M. S.
collection ePrints
description Data integration is important in consolidating all the data in the organization or outside the organization to provide a unified view of the organization's information. Extraction Transformation Load (ETL) solution is the back-end process of data integration which involves collecting data from various data sources, preparing and transforming the data according to business requirements and loading them into a Data Warehouse (DW). This paper explains the integration of the rubber import and export data between Malaysian Rubber Board (MRB) and Royal Malaysian Customs Department (Customs) using the ETL solution. Microsoft SQL Server Integration Services (SSIS) and Microsoft SQL Server Agent Jobs have been used as the ETL tool and ETL scheduling.
first_indexed 2024-03-05T20:01:58Z
format Article
id utm.eprints-71663
institution Universiti Teknologi Malaysia - ePrints
language English
last_indexed 2024-03-05T20:01:58Z
publishDate 2016
publisher Penerbit UTM Press
record_format dspace
spelling utm.eprints-716632017-11-21T03:28:06Z http://eprints.utm.my/71663/ Extraction transformation load (ETL) solution for data integration: a case study of rubber import and export information Jamaluddin, M. S. Azmi, N. F. M. QA75 Electronic computers. Computer science Data integration is important in consolidating all the data in the organization or outside the organization to provide a unified view of the organization's information. Extraction Transformation Load (ETL) solution is the back-end process of data integration which involves collecting data from various data sources, preparing and transforming the data according to business requirements and loading them into a Data Warehouse (DW). This paper explains the integration of the rubber import and export data between Malaysian Rubber Board (MRB) and Royal Malaysian Customs Department (Customs) using the ETL solution. Microsoft SQL Server Integration Services (SSIS) and Microsoft SQL Server Agent Jobs have been used as the ETL tool and ETL scheduling. Penerbit UTM Press 2016 Article PeerReviewed application/pdf en http://eprints.utm.my/71663/1/MimiSafinazJamaluddin2016_ExtractionTransformationLoad%20ETLSolution.pdf Jamaluddin, M. S. and Azmi, N. F. M. (2016) Extraction transformation load (ETL) solution for data integration: a case study of rubber import and export information. Jurnal Teknologi, 78 (1). pp. 79-84. ISSN 0127-9696 https://www.scopus.com/inward/record.uri?eid=2-s2.0-84952360924&doi=10.11113%2fjt.v78.4061&partnerID=40&md5=58544148b2ac5ea99fff83e43fe5fb1e
spellingShingle QA75 Electronic computers. Computer science
Jamaluddin, M. S.
Azmi, N. F. M.
Extraction transformation load (ETL) solution for data integration: a case study of rubber import and export information
title Extraction transformation load (ETL) solution for data integration: a case study of rubber import and export information
title_full Extraction transformation load (ETL) solution for data integration: a case study of rubber import and export information
title_fullStr Extraction transformation load (ETL) solution for data integration: a case study of rubber import and export information
title_full_unstemmed Extraction transformation load (ETL) solution for data integration: a case study of rubber import and export information
title_short Extraction transformation load (ETL) solution for data integration: a case study of rubber import and export information
title_sort extraction transformation load etl solution for data integration a case study of rubber import and export information
topic QA75 Electronic computers. Computer science
url http://eprints.utm.my/71663/1/MimiSafinazJamaluddin2016_ExtractionTransformationLoad%20ETLSolution.pdf
work_keys_str_mv AT jamaluddinms extractiontransformationloadetlsolutionfordataintegrationacasestudyofrubberimportandexportinformation
AT azminfm extractiontransformationloadetlsolutionfordataintegrationacasestudyofrubberimportandexportinformation