From Heterogeneity to Uniformity: A Metadata-Driven ETL Process for Transforming FHIR Data into OMOP CDM
Open Access
- 8 April 2025
- book chapter
- Published by IOS Press
- Vol. 323, 290-291
Abstract
Heterogeneous data formats complicate unified analysis in multisite clinical studies. Standardizing data in the Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) requires Extract-Transform-Load (ETL) processes, which are complex and time-consuming to develop, especially with different source data specifications. The aim of our work is to develop a generalized, metadata-driven ETL process to transform Fast Healthcare Interoperability Resources (FHIR) into OMOP CDM. In this paper, we present first results of the developed metadata-driven ETL process on the example of two different Patient FHIR specifications.Keywords
This publication has 3 references indexed in Scilit:
- Use of Metadata-Driven Approaches for Data Harmonization in the Medical Domain: Scoping ReviewJMIR Medical Informatics, 2024
- Towards ETL Processes to OMOP CDM Using Metadata and Modularization2023
- An ETL-process design for data harmonization to participate in international research with German real-world data based on FHIR and OMOP CDMInternational Journal of Medical Informatics, 2022