OHDSI - and openEHR

They have a free book available at https://ohdsi.github.io/TheBookOfOhdsi/
I got a hard case copy from amazon and found it’s quite interesting to read and learn a bit more - it has exercises about data analysis and how to do it.

1 Like

Planning of openEHR + OHDSI in China seems to be on it’s way already if I understood things at http://openehr.org.cn/item_text.jsp?itemID=44 correctly via Google translate. @lvxd can you tell us a bit more or provide an update regarding plans/status?

Hi Erik,

Sorry for reply late due to the holiday.

OHDSI has become well known since last year, especially for medical informatics researchers. I was invited to have a talk in one of their workshop last year, and talked the possible collaboration with the guys in OHDSI China. I thought it’s a good thing for openEHR in China since the collaboration can encourage more people use openEHR. We discussed to kick off collaboration from some suitable project, the idea is that openEHR will be used to build the CDR in hospital, and openEHR2Ohdsi will be developed to make the data linked to the Ohdsi network so as to be shared by researchers. We planned to further discuss it after holiday, but it has been delayed due to the virus in China.

Did you have experience of working with Ohdsi? Could you also share them if possible? Let’s see how we can work together in this line.



Erik Sundvall via openEHR discourse@openehr.org 于2020年2月5日周三 下午4:56写道:


Great Xudong
I think it is reasonable to have som dataanalytics together with openehr. If ohtdsi works well it would be interesting to share some patterns on how to integrate it.

I only know it by name myself.

Yes, that’s exactly what I thought. I will keep you updated about this collaboration

Bjørn Næss via openEHR discourse@openehr.org 于2020年2月12日周三 上午12:27写道:

Thanks for the interesting response!

No, I have not worked with OHDSI but got very interested after hearing Georg Hripcsak’s keynote at the Medinfo 2019 conference. I would guess that a lot of “openEHR2OHDSI” integration can be done by designing good AQL-queries combined with some transformation/translation/formatting code. Probably some kind of two-way flow where parameters from OHDSI requests are used in the AQL etc. You have probably looked deeper into this than me, what do you think will be needed?

Right now we (Region Östergötland) are busy doing a proper openEHR procurement (see Swedish openEHR platform procurement Q1 2020) and will then install and implement that in suitable parts of our healthcare organization and tackle som prioritized development needs. So we’ll likely not be doing any serious “openEHR2OHDSI” until at earlieast Q4 2020, more likely some time in 2021. But at a “discussion” level we’d be interested in looking at this, so please keep this thread updated with thoughts and findings if possible.

1 Like

George Hripcsak, gave me permission to share the Medinfo presentation here.
EDIT: But the upload did not work, retrying…

Please try again :sunny:

I was lucky enough to watch this great presentation in Lyon, too. You can find the slides here.

In fact, OHDSI and openEHR look like a perfect couple. As a clinician, I can’t be of much help concerning implementation. But @backbord 's explanation seems to point in the right way.
I’ll keep a watchful eye on this topic, and share with you whatever I find concerning it.


We are currently on the process of certification in OHDSI.
We are also updating our tooling to fully support OMOP CDM :slight_smile:


First tentative draft of OMOP CDM as GENERIC_ENTRY classes (I have generated all 37 classes, I attach the 3 more common ones to start a discussion) :slight_smile:

openEHR-EHR-GENERIC_ENTRY.visit_detail.v0.adl (13.2 KB)
openEHR-EHR-GENERIC_ENTRY.observation_period.v0.adl (4.3 KB)
openEHR-EHR-GENERIC_ENTRY.person.v0.adl (13.6 KB)

edit: zip with all 37 archetypes


Also very interested in this topic.

I am a database solution engineer from PostgreSQL and Greenplum Community China with more than 10 years big data experience in financial, aviation and IoT industries .

I have some experiences in IoT industry platform for vast data integration and sharing among many vendors.
According to my observation, a uniformed standard will help blooming the adoption while too many standards will be a barrier for adoption, cause too many standards equal no standard.


What are the use cases when research projects would benefit most of OMOP? In Finland OMOP is used in 2 University Hospitals, and we also have national openEHR based data exchange platform. The hospitals have however mapped legacy data to OMOP, but it does not seem very efficient to do all these mappings, but rather use openEHR-OMOP mapping if it existed.

1 Like

Yes, in my opinion, a full openEHR->OMOP transformation could be achieved by annotating the archetypes/templates with the equivalent OMOP class . By getting fields from the openEHR RM it should be possible to get the minimum data. If we have other “label” terminology bindings to snomed or loinc we could do this even without the annotation to the OMOP class.
I also think that other approaches, like the one @ian.mcnicoll did for the Lab results, are more directly translated into OMOP table rows, but both are possible in my opinion.

And as for use cases, I see this as a minimum common model for research, but obviously if every place in the research network ‘understands’ openEHR (i.e. can execute AQL) you have more fine grained information at your disposal.


There might be an opportunity to get some support for this work from a university Comp. sci dept - would anyone be interested in helping me (this all pro-bono!!).

Sure, I wanted to even implement some things for the transformation :slight_smile:

1 Like

I am interested in being associated and help



Hi Ian,

I am an enthusiast of OMOP CDM and I am considering using OMOP as a persistance model for clinical applications, but would be interesting to understand about OpenEHR to OMOP transformation as an alternative.

Please let me know if you move forward with this initiative.



I’m not really leading any real effort here but good to know others are interested.

OMOP is excellent for its intended purpose but really not a good match for front-line clinical application datasets.


I was interested in this topic but I couldn’t find any active project supporting ETL from openEHR to OMOP CDM. However, I came across this recent article, (section 4.2. page 9) that there is a project in Madrid named Infobanco which aims to implement an OpenEHR repository, as well to provide support for secondary data use though OMOP CDM.

Does anyone know of other initiatives to connect openEHR with OMOP CDM?

Best regards

1 Like