Modul Extract, Transform, Load (ETL) untuk Data Warehouse Akademik Departemen Ilmu Komputer IPB Menggunakan Kettle

Abstract

Extraction, transformation, and loading (ETL) are processes which have important role to determine data warehouse quality. ETL is bridging between data source and data warehouse. Activities such as cleaning, integration, and data loading at data were done in this process. Making ETL manually is inefficient, because data that will grow and data with different sources become problematic in data integration. This research performs ETL using special tools that are expected to simplified the ETL process and consistently of data output. ETL tool which used are Kettle, while designing a data warehouse using Pentaho Schema Workbench and result are visualized in OLAP in Mondrian to test the ETL process. The result in this research is a data warehouse having integrated and dynamic ETL.