This paper showcases the results of the Extract-Transform-Load process mapping the Electronic Health Record of Papageorgiou General Hospital in Thessaloniki, Greece, to the Observational Medical Outcomes Partnership Common Data Model. We describe the staged process utilized to account for the intricate structure of the database, along with some general findings from the mapping. Finally, we investigate potential directions for future research.
Keywords: ETL; OMOP-CDM; mapping; observational data; real world data.