EUVIMEDEUVIMED entdecken
VergleichsstudieOpen Access · CC BY-NC 4.0

Comparative Study of ETL Tools for Transforming Healthcare Data to the OMOP Common Data Model (CDM)

Adnan Jouned, Heike Düsseldorf, Florian Katsch, Maryam Jafarpour, Georg Duftschmid

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).

AbstractSchlagwörterBibliografische AngabenZitierenVerwandte Studien

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)

Electronic Health RecordsSoftwareInformation Storage and RetrievalUser-Computer Interface

Stichwörter der Autor:innen

Data TransformationETLHealthcare Data IntegrationOMOP CDM

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}
}
Kostenlos starten →