Table 1 Enhancements implemented in the NDW infrastructure and functionalities to respond to the increasing number of sites and volumes uploaded in the repository between 2016 and 2020
Enhancements | 2016 | 2017 | 2018 | 2019 | 2020 |
|---|---|---|---|---|---|
Functionalities of the NDW | DWH Portal developed GIS visualization Total dashboards (5) | Transfer Hosting of DWH to NASCOP Servers Resources page developed Total dashboards (32) Basic Upload verification portal (SPOT) developed | DWH Logins disabled Training materials, Dictionaries, Reports uploaded to Resources page Total dashboards (49) SPOT Updated for program (HTS & C&T) upload verification—Different Instances Data Mart Growth (104.1 GB) | Hosting at NASCOP infrastructure for Primary services to increase ownership and adoption of resource Training & engagement of MOH for ownership Migration to Opensource dashboarding tool (HighCharts) to align with Principles of digital development SPOT enhanced as a single instance for all dockets (C&T, Prevention and PKV) Data Mart Growth (488 GB) Enhanced security of DWH data Access & Transmission processes (DWAPI, DWH and other related APIs) | Secondary Infrastructure moved to a Tier II data center to increase availability and security DTG and Palantir data extraction APIs Migration of Home page, Reporting Rates, HIV Testing and Care and Treatment Dashboards to Highcharts SPOT tool enhanced for metrics review and data upload status verification checks to increase data verification process Data Mart Growth (709.5 GB) Enhanced Security and availability of the DWH infrastructure through acquiring DWH hosting services |
Functionalities on DWAPI | (Data Upload Application-DeUAP). The tool was used to upload CSV based files that were downloaded from EMRs to the warehouse | First version of DWAPI was developed as a desktop software application Windows-based (running on Microsoft.NET Version 4.6) system that allowed transmission of Care and Treatment data only Supported database connection to KenyaEMR and IQCare EMR software systems only Other EMRs required to generate CSV file extracts to be imported into DWAPI | Migrated from windows-based desktop software application to a web-based platform Expanded support for other EMR software systems, eliminating the need for CSV file extracts Source code migrated from a Microsoft Windows-focused framework to a cross platform.NET Core 2.0 framework that supported running on Linux and MacOS Operating System environments in addition to the natively supported Microsoft Windows platform Deduplication feature was added to support facility patient matching and removal of duplicate patient records | Enhanced to collect and transmit HIV Testing Services and Linkage to care data in addition to wider Care and Treatment data coverage | Enhanced to support service delivery partners with single installation of EMR software collecting and transmitting data from multiple facilities Enhanced to support a community model setup where facilities are supported by more than one partner offering different modalities of HTS services |