Migration of data for iKnow application at EURM - a case study

TL;DR

This paper discusses the challenges and solutions involved in migrating student data from an outdated system to a new application at EURM, highlighting ETL techniques used during the process.

Contribution

It presents a case study of data migration for a university application, detailing specific problems and solutions encountered during the ETL process.

Findings

Identified key data migration challenges at EURM.

Applied standard ETL solutions to resolve migration issues.

Provided practical insights for similar university data migrations.

Abstract

Software evolves. After many revisions and improvements software gets retired and replaced. When replacement takes place, one needs to migrate the data from the old database into the new database, so the new application can replace the old application. Student administration application (SAA) currently used by European University (EURM) has been outgrown by the university, and needs replacement. iKnow application developed as part of the iKnow Tempus project is scheduled to replace the existing Student Administration application at EURM. This paper describes the problems that were encountered while migrating the data from the old databases of SAA to the new database designed for the iKnow application. The problems were resolved using the well-known solutions typical for an ETL process, since data migration can be considered as a type of ETL process. In this paper we describe the solutions for the problems that we encountered while migrating the data.