Service-Oriented Business Intelligence (SoBI) for Academic and Financial Data Integration in University

Previously, data integration in Business Intelligence (BI) is done by ETL process (Extract, Transform, and Loading). Service-oriented Business Intelligence (SoBI) offers data integration process in a simpler way when compared to the ETL process in BI. In this study, the SoBI will be implemented to integrate academic and financial data at Satya Wacana Christian University (SWCU) into Data Warehouse. The Data Warehouse was developed with Galaxy scheme and implemented with SQL Server 2012. The results of the study show that to apply SoBI, dashboard application must be made that serves to manage data integration process. Data integration on SoBi is done with the help of Web Service by building Service Provider at location of data source and Service Requestor on dashboard application. The Service Provider can be called by the dashboard application to perform the data retrieval process from the data source and transfer data into the Data Warehouse, so that the ETL process is done entirely by the Web Service. In addition, the dashboard application also serves to synchronize data from data sources through Web Service so that the data to be integrated is also more consistent.