This community innovation has been accepted at the 2026 DHIS2 Annual Conference as a physical poster.
DHIS2–ETL Integration for National TB Reporting
Background Under Global Fund Grant Cycle 6 (GC6), Nigeria’s TB PPM program reporting in 23 states and ~3,000 PPM hub facilities used multiple Excel tools, leading to fragmented data, delays, and poor quality. For Grant Cycle 7 (GC7), the program scaled to all 36+1 states, covering >20,000 organizational units, including PPM hubs and community TB screening spokes. This expansion demanded a scalable, interoperable digital system for timely TB Monthly Summary Form submission across a dispersed hub-and-spoke network, while ensuring data governance and quality. Methods The Principal Recipient, Institute of Human Virology Nigeria (IHVN), migrated TB reporting to DHIS2, consolidating four legacy forms, migrating >450 indicators, and adding enhanced disaggregation and validation rules. DHIS2 was configured for ~4,000 PPM hubs and >10,000 community spokes. To overcome direct access limitations and high entry volumes, a metadata-driven ETL architecture was developed. Standardized Excel templates aligned with DHIS2 metadata (data elements, category options, periods, hierarchies) included embedded first-level validation. State users uploaded files to a secure ETL portal, where data were transformed into JSON and batch-synced to DHIS2 via API. DHIS2 enforced second-level completeness and consistency checks. Over 1,000 users were trained through virtual sessions and clustered in in-person workshops. Results The DHIS2-ETL system dramatically improved TB reporting. Report generation time fell from 16 hours to < 5 minutes, and full-state reporting from 5–7 days to 20–60 minutes. Timeliness rose from 20% to >90% of states submitting on schedule, data inconsistencies dropped 70%, and accuracy improved from 40% to >90% via layered validation. Over 80% of trained users gained independent proficiency in DHIS2 analytics and dashboards, reducing workload and burnout.
Primary Author: Joshua Odoma
Keywords:
TB program Nigeria, Global Fund GC6 GC7, PPM hubs, Community TB screening spokes, DHIS2 migration, ETL architecture, Excel templates, Metadata-driven, API batch processing, Validation rules, Data quality, Reporting timeliness, Scale-up 36+1 states, IHVN Principal Recipient, Capacity building, Analytics dashboards, Reduced reporting time, Data inconsistencies decline