Abstract

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.

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.