OpenMRS Interoperability and Integration Updates
- Gilbert Muthee
- Romain Buisson
- Michael Bontyes
Focus on OpenMRS interoperability & integrations at facility-level
Mondays at 9 AM EST, 4 PM EAT - Link: meet.google.com/ksh-mdae-rtw
Represented organizations: UCSF, UgandaEMR, Palladium, Mekom, MSF/Madiro
Examples: Laboratory, billing, stock management, etc.
Objectives
Share knowledge and use cases about data exchange use cases
Align on practices, tools, and architectures
Deliverables
Map ecosystem of existing solutions and challenges to address them as a group
Framework for integration
Sets of routes
Documentation about how to integrate OpenMRS with other health systems
Calls and notes
Analytics in OpenMRS Distro HIS: Ozone Analytics + Mamba ETL
3 tickets to be worked on:
Planned a demo session of Mamba ETL w/ support of incremental changes lead by UCSF. (to be scheduled to next week)
OEG integration in progress:
Notion board: https://www.notion.so/mekom/OpenMRS-disto-HIS-integrated-with-OpenELIS-Global-597eea5b1d6e4305b0dc472b9682d505?pvs=4
EDD mid/end-aug
Deployment of dev-his.openmrs.org server:
Will be looked at next week.
FHIR specs for ERP Processes completed. Link:
Designs for Price + Stock upon ordering will be added in Zeplin today.
Need some architecture call with Brandon regarding the ability for O3 to query multiple backends.
Need some architecture call with Wyclif regarding exposing the FHIR API of the ERP (and authenticating to it)
Custom systems integration:
Ethiori being integrated with a custom LIMS.
Used as an example to add more integrations.
The week after next, prepare a demo/call to run through the Ethiori LIMS integration compared to say, SENAITE integration).
Enabling SENAITE in OpenMRS distro HIS:
@Stephen Senkomago Musoke starting evaluation of SENAITE integration. Will provide more updates on #ozone channel by EOD.
DHIS2 integration by @Michael Bontyes . Interested in looking UgandaEMR existing DHIS2 integration.
Analytics in OpenMRS Distro HIS: Ozone Analytics + Mamba ETL
3 tickets to be worked on:
We can assume that MambaETL is supporting incremental changes.
OEG integration in progress: Exact extent of the work is identified. Mekom to outline a timeline and provide regular updates on this call.
Deployment of dev-his.openmrs.org server in progress: Mekom and OpenMRS devops have met: Need to modify Ozone so that it provides Docker images with the configs+binaries embedded in the image. Work should be started around next week.
FHIR specs for ERP Processes completed. Link:
Focus on the common parts of ERP processes:
Stock levels displayed upon ordering.
Product price displayed upon ordering.
Comparison between FHIR spec vs OpenMRS designs in progress. Done by Kevin.
Analytics in OpenMRS Distro HIS: Ozone Analytics + Mamba ETL
Possible to only send to Ozone Analytics some tables from Mamba: the ones for which we know the model.
Creating
OEG integration in progress: Define exact extent of the work needed. Mekom to outline a timeline and project manage.
Deployment of dev-his.openmrs.org server in progress: Mekom and OpenMRS devops have met: Need to modify Ozone so that it provides Docker images with the configs+binaries embedded in the image.
FHIR specs for ERP Processes complete. Link:
Focus on the common parts of ERP processes:
Stock levels displayed upon ordering.
Product price displayed upon ordering.
OEG integration in progress: Define exact extent of the work needed. Mekom to outline a timeline and project manage.
Testing of OpenMRS Distro HIS in progress.
ERPNext processes confirmed to be working.
Documenting how Implementers can adopt OpenMRS Distro HIS-> to be reviewed by @Stephen Senkomago Musoke
Investigate how OpenMRS Distro HIS can be adopted
Direct inheritance from Ozone.
Inheritance of OpenMRS Distro HIS.
@Stephen Senkomago Musoke to try both options.
Deployment of dev-his.openmrs.org server in progress: Mekom and OpenMRS devops to meet tomorrow.
FHIR specs for ERP processes progressed. Almost ready to be shared.
@Stephen Senkomago Musoke is looking into trying Superset within Ozone.
Mamba ETL flattened encounters tables must be forwarded to the PostgreSQL analytics table (from Ozone Analytics) as to be available as 1 single datasource in Superset.
Not so straightforward as the table columns is dynamic.
Need to find a way to identify a source data model and create the corresponding target database
→ Set to the agenda next week. Invite @Wyclif Luyima @Emmanuel Nyachoke @Arthur D. Mugume @Laureen Omare .
OEG integration in progress: See Slack conversation between Mekom and UW.
Testing of OpenMRS Distro HIS in progress.
No demo patients created when running start-demo.sh. Further testing needed. Might need some documentation improvement → @Stephen Senkomago Musoke confirms that demo patient are created.
Testing of the actual integration between OpenMRS and ERPNext in progress. Should be done by mid-week by @Stephen Senkomago Musoke .
Create patient in OpenMRS
Create an order for that patient
See the patient in ERPNext
See the quotation opened in ERPNext
Documenting how Implementers can adopt OpenMRS Distro HIS → redirect to Ozone docs here:
Example of Ozone LIME:
Example of KenyaHMIS:
Investigate how OpenMRS Distro HIS can be adopted
Direct inheritance from Ozone.
Inheritance of OpenMRS Distro HIS.
Deployment of dev-his.openmrs.org server in progress: host is ready on OpenMRS infrastructure. Next step is to actually deploy OpenMRS Distro HIS (need to identify how can do so).
No progress on FHIR specs for ERP processes. @Romain Buisson will provide updates in next call.
@Stephen Senkomago Musoke is looking into trying Superset within Ozone.
Discuss how we could leverage on Mamba ETL flattening in Ozone Analytics.
Superset alone (in Ozone FOSS) is decommissioned for now in favor of running it with Ozone Analytics.
Needs to find ways to have Mamba ETL tables available in Superset as part of Distro HIS (via Ozone Analytics?)
Links and references
April 2024: Map ecosystem of existing solutions - Work in progress
April 2024: Editable Generic OpenHIE diagram
Febr 2023: Talk post about Interoperability layer of OpenMRS
Archives