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. (Author), Azmi, N. F. M. (Author)
Format: Article
Language:English
Published: Penerbit UTM Press, 2016.
Subjects:
Online Access:Get fulltext
LEADER 01315 am a22001453u 4500
001 71663
042 |a dc 
100 1 0 |a Jamaluddin, M. S.  |e author 
700 1 0 |a Azmi, N. F. M.  |e author 
245 0 0 |a Extraction transformation load (ETL) solution for data integration: a case study of rubber import and export information 
260 |b Penerbit UTM Press,   |c 2016. 
856 |z Get fulltext  |u http://eprints.utm.my/id/eprint/71663/1/MimiSafinazJamaluddin2016_ExtractionTransformationLoad%20ETLSolution.pdf 
520 |a 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. 
546 |a en 
650 0 4 |a QA75 Electronic computers. Computer science