Integration Of Heterogeneous Databases In Academic Environment Using Open Source ETL Tools

Abdul Aziz, Azwa and Abd Hamid, Nazirah and Rozaimee, Azilawati (2012) Integration Of Heterogeneous Databases In Academic Environment Using Open Source ETL Tools. In: The International Conference on Informatics & Applications (ICIA2012), 3 - 5 June 2012, Kuala Terengganu.

[img] Text
conference ICI 2012.pdf
Restricted to Registered users only

Download (2819Kb)
Official URL: http://sdiwc.net/conferences/2013/icia2013/

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.

Item Type: Conference or Workshop Item (Paper)
Keywords: Extraction, transformation, and loading(ETL), Business Intelligence (BI), Data Warehouse (DW), Heterogeneous DBMS, Talend Open Studio (TOS)
Subjects: Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Faculty / Institute: Faculty of Informatics & Computing
Depositing User: Mr. Azwa bin Aziz
Date Deposited: 20 May 2014 00:43
Last Modified: 20 May 2014 00:43
URI: http://erep.unisza.edu.my/id/eprint/1111

Actions (login required)

View Item View Item