Mamba ETL Technical Roadmap

[kajambiya]

Feature Work

• Move MambaETL DB flattening Task scheduler to base module.
• Support for flattening concepts rendered as both questions and answers.
• A configurable toggle between storing ETL output in the OpenMRS database or in External database.
• Ensure that reports data is available while ETL is running.
• Incremental update of ETL based on underlying data changes.
• Automate addition of Make Scripts in MambaETL.
• Service/API layer data pagination support in MambaETL.
• Automate column naming in the ETL flattened Tables.
• ObsGroups support for MambaETL.
• Publish Version 2.0 of MambaETL.
• Develop Mamba Report for Total number of Pregnant women attending first ANC.
• Develop Mamba Report for Total number of Deliveries.
• Develop Mamba Report for Total number of HIV exposed children enrolled in followup care.

Bugs

• Fix build failure when reports.json configuration file is missing.
• Concepts with multi-select values (e.g. key population) failing to flatten.

House Keeping

• Test report on MambaETL running on MySQL 8.
• MambaETL documentation - v1.0.0.
• Performance improvement during the flattening process.
• Robust Error Handling in MambaETL.
• Code cleanups and Refactors in MambaETL.