Data utilization has effectively contributed for institutions
growth by providing insights for managerial purposes. In Information
Technology (IT) Department of Politeknik Caltex Riau, there’s a
business intelligence system developed to each head of study
programs in IT Department with sufficient knowledge. Unfortunately,
information systems were built separately, and the BI system hasn’t
considered with data integration. To solve this problem, this research
proposes 2 different academic near-real time data integration model
and benchmarkes the implementation to obtain best data integration
model. This research uses WSO2 ESB as the MOM tools in ServiceOriented Architecture that use NuSOAP library for generating web
service WSDL and uses Enterprise Application Integration approach.
The testing is conducted based on ISO 9126 aspects: functionality,
efficiency, and reliability. Based on the testing results, both
integration models meet the functionality aspect by having
functionality score equal to 1. For reliability aspect, the integration
models meet the requirement by scored 0. For the efficiency aspect,
the 2nd pattern yielded faster response time than 1st pattern (10 out of
11 test cases). It can be concluded that both integration models fulfill
the functionality and reliability aspects, but the 2nd pattern is more
efficient because of the distinction of message channel and store for
each dimension and fact table.
Keywords: Data Integration, Near-Real Time ETL, Message-Oriented
Middleware, Service-Oriented Architecture