Explore OSS
-
Drill allows us to have visibility over all the databases (jdbc compatibility) including Iceberg
-
Instead of using pyIceberg, I opted for pyspark because pyIceberg is not compatible with…
SETUP INFRASTRUCTURE
Using initially apache drill, can serve we have visibility on all the databases i.e
- MySQL (OpenMRS)
- PostgreSQL
Explore OSS
- Clickhouse may not be very practical because it requires structural specifications (schema)
Data Models
OpenMRS was built from source version 2.3.5. From this version I will have the data-model be extracted and rebuilt elsewhere
MPI - Master Patient Index
MZ is using MySQL 5.6 and OpenMRS 2.3.x, Need to find the corresponding version of the data-model
Refactor to accomodate 834 (and others)