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...
Main Authors: | , |
---|---|
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 |