STRATEGY TO INTEGRATE ACADEMIC DATA USING WEB SERVICES AND PL SQL (CASE STUDY TELKOM UNIVERSITY)

STRATEGY TO INTEGRATE ACADEMIC DATA USING WEB SERVICES AND PL SQL (CASE STUDY TELKOM UNIVERSITY)

Author		: TORA FAHRUDIN 
Published on	: Journal of Theoretical and Applied Information Technology  (JATIT) (Pakistan)

Abstract

Established in 17 July 2013, Telkom University was formed from various faculties from Telkom Education Foundation, such as Faculty of Engineering (TES), Faculty of Management (TEBS), Faculty of Applied Sciences (TASS) and the Faculty of Creative Industries (TCIS). Each faculty has the Academic Information Systems. When it became a university, problems faced is how to do the integration strategy of academic data from the different data structure and data sources of academic information system at each faculty into one new scheme of University database. The challenge is the old academic system is still running for one semester, which means the data will still moving. Therefore, this study focuses on both strategic and technical concepts to integrate academic data base on that condition. A major strategy is using web services for data interchange and PL SQL Scheduler to process transaction data which still moving. Meanwhile, master data is loaded only once with flat files format. The conclusions obtained from this research are 1) to integrate academic data, logic data needed to be split into master data and transaction data, 2) the strategy for integrate master data are loaded only once with flat files format, meanwhile the transaction data is loaded many times via web services (JSON), 3) transaction data from web services will be loaded and mapping into destination database using JSON PL SQL package which run periodically.