Comparative Study of ETL Tools for Transforming Healthcare Data to the OMOP Common Data Model (CDM)
Studies in Health Technology and Informatics · 2025
DOI: 10.3233/shti250590 ↗Kurz gefasst
Vergleichsstudie in der Zeitschrift Studies in Health Technology and Informatics, 2025. Verfasst von Adnan Jouned und 4 weiteren Autor:innen. Beteiligte Einrichtung: Institute of Medical Information Management, Center for Medical Data Science, Medical University of Vienna, Vienna, Austria. Hauptthemen laut MEDLINE: Electronic Health Records, Software, Information Storage and Retrieval. Der Volltext ist frei zugänglich (Open Access, CC BY-NC 4.0).
Abstract (Originalsprache)
Healthcare data is often complex, sparse, and frequently updated, which makes standardization essential. The OMOP Common Data Model (CDM) is gaining increasing attention because of its ability to standardize healthcare data and enable consistent and reproducible research outputs. This paper evaluates three ETL (Extract, Transform, Load) tools: Pentaho, Apache NiFi, and a custom-built tool to transform healthcare data into the OMOP CDM. The evaluation criteria, based on a literature review, include connectivity and interoperability, user interface and ease of use, performance, and technical flexibility. Results indicate that while minor differences in the tools’ features exist, all tools are adequate for basic transformation tasks. Pentaho is noted for its ease of use, particularly helpful for non-expert users, while Apache NiFi is better suited for more advanced users. A custom-built tool, though often offering user-friendly interfaces and more flexibility, comes at the cost of additional development efforts.
Schlagwörter
MeSH-Schlagwörter (MEDLINE)
Stichwörter der Autor:innen
Autor:innen und Institutionen
- Institute of Medical Information Management, Center for Medical Data Science, Medical University of Vienna, Vienna, Austria.
- Ludwig Boltzmann Institute for Digital Health and Prevention, Salzburg, Austria.
Zitieren
APA
Jouned, A., Düsseldorf, H., Katsch, F., Jafarpour, M., & Duftschmid, G. (2025). Comparative Study of ETL Tools for Transforming Healthcare Data to the OMOP Common Data Model (CDM). Studies in Health Technology and Informatics. https://doi.org/10.3233/shti250590
Vancouver
Jouned A, Düsseldorf H, Katsch F, Jafarpour M, Duftschmid G. Comparative Study of ETL Tools for Transforming Healthcare Data to the OMOP Common Data Model (CDM). Studies in Health Technology and Informatics. 2025. doi:10.3233/shti250590
BibTeX
@article{Jouned2025,
author = {Jouned, Adnan and Düsseldorf, Heike and Katsch, Florian and Jafarpour, Maryam and Duftschmid, Georg},
title = {Comparative Study of ETL Tools for Transforming Healthcare Data to the OMOP Common Data Model (CDM)},
journal = {Studies in Health Technology and Informatics},
year = {2025},
doi = {10.3233/shti250590}
}
EUVIMED