OMOP harmonization and integration of surgical procedure data base into EHDEN

Executive summary

Real-world data (RWD) offers valuable insights into healthcare patterns and outcomes, serving as a cornerstone for evidence-based decision-making in healthcare. As an EHDEN certified SME and a global leader in building data networks for the life sciences industry, we offer OMOP harmonization services. In this case, we provided the OMOP solutions for a data partner, who wanted to harmonize the clinical data of +750,000 patients collected between 2014 and 2022.

Discussion

• Understanding the raw data are required careful before implementing the harmonization solution
• Manual curation and translation to English were needed for free-text mapping to OMOP vocabularies
• Relationships between OMOP tables required manual adjustments to address issues related to the raw data

Results

1. Encompassing the raw data, OMOP solutions with tables across multiple domains, and the development of ETL documents together with source code to facilitate the ETL of data into the final OMOP database
2. Facilitating seamless synchronization with OMOP data, empowering DPs to make informed decisions while ensuring compliance with privacy regulations
3. Enabling the seamless integration of surgical databases into healthcare research initiatives across Europe, fostering collaboration and facilitating evidence-based decision-making in the healthcare domain