OpenMRS Interoperability and Integration Updates

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

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

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