Implementing an ETL-driven Data Integration Framework for State Universities and Colleges

Abstract

State Universities and Colleges collect enormous volumes of data scattered across multiple disparate transactional systems. Integration of these data is therefore vital in order to eliminate problems in consolidating and interpreting such data. This paper aimed to develop and implement a data integration framework that employs an ETL-driven data warehousing technique for State Universities and Colleges (SUCs). Moreover, the framework was implemented and tested using heterogeneous data of the Bicol State College of Applied Sciences and Technology (BISCAST), one of the state colleges in Region 5, Philippines. Consequently, the integration framework has been found to be effective in streamlining the process of consolidating and interpreting SUC’s data thus enabling the organization to produce reliable reports and eventually can cope with submission deadlines. A reporting tool was also developed for end-users to generate and view the outcome of the integration process. Furthermore, the level of the system’s usability was determined. Based on the result, it is effective in accomplishing specific tasks, highly efficient and commendable to adopt.