Title: INTEGRATION OF HETEROGENEOUS DATABASES IN ACADEMIC ENVIRONMENT USING OPEN SOURCE ETL TOOLS

Year of Publication: Jun - 2012
Page Numbers: 433-439
Authors: Azwa A. Aziz, Abdul Hafiz Abdul Wahid, Nazirah Abd. Hamid, Azilawati Rozaimee
Conference Name: The International Conference on Informatics and Applications (ICIA2012)
- Malaysia

Abstract:


Data warehouse (DW) can be considered as the most significant tool for strategic decision making. However, in academic environment, the components of data warehouse still have not been completely utilized. The aim of this paper is to design and implement ETL processes through the data integration of heterogeneous databases using TOS in academic environment. The usage of TOS for designing and semi automatically implementing ETL tasks in Java enables a fast way of adapting to new data sources. We already manage to integrate various sources of heterogeneous academic data sample and populate them in one central repository using TOS. It is important to ensure the capabilities of open source ETL are equal to any commercial products. Consequently, it will help in implementing DW projects with lower cost.