Cover Image

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

Saved in:
Bibliographic Details
Main Authors: Jamaluddin, M. S., Azmi, N. F. M.
Format: Article
Language:English
Published: Penerbit UTM Press 2016
Subjects:
QA75 Electronic computers. Computer science
Online Access:http://eprints.utm.my/id/eprint/71663/1/MimiSafinazJamaluddin2016_ExtractionTransformationLoad%20ETLSolution.pdf
http://eprints.utm.my/id/eprint/71663/
https://www.scopus.com/inward/record.uri?eid=2-s2.0-84952360924&doi=10.11113%2fjt.v78.4061&partnerID=40&md5=58544148b2ac5ea99fff83e43fe5fb1e
Tags: Add Tag
No Tags, Be the first to tag this record!
id my.utm.71663
record_format eprints
spelling my.utm.716632017-11-21T03:28:06Z http://eprints.utm.my/id/eprint/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/id/eprint/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
institution Universiti Teknologi Malaysia
building UTM Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Teknologi Malaysia
content_source UTM Institutional Repository
url_provider http://eprints.utm.my/
language English
topic QA75 Electronic computers. Computer science
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
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.
format Article
author Jamaluddin, M. S.
Azmi, N. F. M.
author_facet Jamaluddin, M. S.
Azmi, N. F. M.
author_sort Jamaluddin, M. S.
title 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_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_sort extraction transformation load (etl) solution for data integration: a case study of rubber import and export information
publisher Penerbit UTM Press
publishDate 2016
url http://eprints.utm.my/id/eprint/71663/1/MimiSafinazJamaluddin2016_ExtractionTransformationLoad%20ETLSolution.pdf
http://eprints.utm.my/id/eprint/71663/
https://www.scopus.com/inward/record.uri?eid=2-s2.0-84952360924&doi=10.11113%2fjt.v78.4061&partnerID=40&md5=58544148b2ac5ea99fff83e43fe5fb1e
_version_ 1643656246020014080
score 13.211869

Similar Items