- Technical Note
- Open Access
Experience of using an open source clinical trials data management software system in Kenya
BMC Research Notes volume 7, Article number: 845 (2014)
Clinical trials data management (CTDM) remains one of the many challenges in running state of the art trials in resource-poor settings since most trials do not allocate, or have available, sufficient resources for CTDM and because of poor internet connectivity. Open-source software like OpenClinica could be a solution in such scenarios.
In 2007, the KEMRI-Wellcome Trust Research Programme (KWTRP) adopted OpenClinica (OC) community edition, an open-source software system and we share our experience and lessons learnt since its adoption. We have used OC in three different modes; direct remote data entry from sites through Global System for Mobile Communications (GSM) modems, a centralized data centre approach where all data from paper records were entered at a central location and an off-line approach where data entry was done from a copy of database hosted on a field-site server laptop, then data uploaded to a centralized server later. We have used OC in eleven trials/studies with a cumulative number of participants in excess of 6000. These include large and complex trials, with multiple sites recruiting in different regions of East Africa. In the process, we have developed substantial local capacity through hands-on training and mentorship, which we have now begun to share with other institutions in the region.
Our experience demonstrates that an open source data management system to manage trials’ data can be utilized to international industry standards in resource-poor countries.
Introduction-the need for open-source software
Clinical trials are primarily set up to answer specific research questions; answering these research questions entails gathering, storing and processing data. There is a need to develop stringent strategies of collecting, managing and producing high quality trial data . Data management is a complex process that involves investigators collecting data directly from the trial participants, laboratory technician running trial samples, data entry by data entry clerks, data monitoring, system administrators maintaining the data within the database and communicating with trial managers, and analysis by statisticians and study Investigators. Given this complexity, few trials go exactly as initially planned; in the course of the trial, case report forms (CRF) may need updating, a new trial site may be added and new technology may emerge. With many clinical trials going global , managing all these issues and stakeholders to yield data of high quality needs a well thought-out plan. All these complexities notwithstanding, an investigator has to worry about the cost of acquiring, installing and maintaining a data management system and compliance with set guidelines and standards .
Historically, trials’ data have been captured on paper and investigators had to handle large volumes of paper. However, electronic data capture (EDC) and use of electronic case report forms (eCRF) are becoming more utilized and have revolutionized the way trial data are managed [4–6]. The advent of EDC and eCRF has reduced the burden of organizing paper CRFs, greatly reducing the time to avail data in electronic formats and improved the efficiency in running clinical trials . However, these benefits come with some challenges. The whole process of clinical trial data management using EDC and eCRF requires substantial capital investment and utilizing sophisticated technology requiring highly trained professionals [8, 9]. Industry regulations require EDCs that are validated to ensure trial data reliability, accuracy, security and electronic audit trails that document every action on the EDC . In the rapidly changing information technology environment, careful consideration is needed before investing in new hardware or software. And, any EDC system comes with the additional challenges of installation, customization, configuration or/and integrating with existing systems such as laboratory or clinical surveillance systems. For academic institutions, small-size research institutions, individual investigators and poorly funded research institutions, particularly from developing countries, traditional paper based approaches with data entry at a central location may be the most feasible considering all these factors.
The demand to make clinical trials management affordable whilst still complying with industry standards, regulatory requirements and best practices continues to grow. There is need to build conducive environments that supports flexible trial design, configuration and quick deployment of robust EDC, real-time data capture, extraction, analysis and reporting of trials’ findings . This has led to adoption of EDC and e-clinical systems in clinical trial data management in various research environments with varying degree of success . We have previously argued  that an open source clinical trial data-management system could help in achieving the above targets. Within a short time, the usage of open source EDC has grown rapidly and, a good example is OpenClinica (OC) . Adoption of OpenClinica as a clinical trials’ EDC has grown tremendously since its release in 2005, currently boasting of over 15,000 community members with a presence in over 100 countries . Open source EDCs are becoming common because they are free to download and use, come with low/free cost of maintenance and are easy to install and use. They can be customized to the requirements of the end-users since their codes are available freely, can be configured to the security standards of the user and are interoperable with existing systems. Open source EDCs have the potential of increasing and improving public health research activities and raising academic standards because of their availability (they are inexpensive/free) and have a community of users and developers, where experience and ideas are freely exchanged [13–15]. Such exchanges enrich and reify the source code, improving the EDC’s quality and leading to additional useful features to the users.
In this article we describe our experience with OpenClinica, an open-source EDC in managing clinical trials data in Kenya and the surrounding region.
How we started
A Clinical Trials Facility (CTF) was setup within KWTRP because there was a need to have a coordinating centre for multiple trials and develop capacity to manage trials to standards used in the developed world. For the last 25 years, KWTRP has conducted clinical, laboratory and epidemiologic research within Kilifi County and its environs . There was a wide difference between academic and pharmaceutical or product development trials, and so the aim was to ensure that all studies had access to monitoring, good data management and trial coordination. The CTF was set up to provide a centralized resource of study support functions in order that skills and best practice could be shared between different studies and disease areas. This worked very well, especially for data management where a dedicated data management office was set up. After careful consideration of resources needed, time, human capital and international good clinical practice (GCP) standards, we chose OC as our Clinical Trial Data management System (CTDMS) . This decision was followed by a one week on-site training by the developers of OC, Akaza Research LLC, in mid 2007. No external system validation was done, however, we internally validated the initial version to meet the GCP requirements, and have continuously validated all updated versions before use. Later an in-house ‘OC group’ was set up to champion and oversee implementation of the system. The group comprised the heads of CTF and Statistics department, data managers, a system administrator and other stakeholder (lead PI). The group held regular meetings through which targets were set, learning tasks appointed, experiences shared and progress reviewed.
Up to the present date, we have maintained a system administrator offering technical support to the users while individual trial instances are designed and managed by specific data managers. The initial system administrator had a Bachelors level degree in Computer Science with skills in programming and databases and worked within the ICT department spending no more than 5% of their time on OC. The data managers come from a diverse range of academic backgrounds (Statistics, IT, Biological Sciences) and are hired directly for specific trial teams but sit as a pool within CTF allowing for sharing of ideas and experience, thus fostering consistency in how KWTRP runs trials.
Our computing environment
We configured OC on a server running Windows Server 2003 operating system and using an Apache Tomcat application server and a PostgreSQL database. In line with KWTRP IT standards, the software and database have been installed on separate servers to ensure greater security, manageability, and flexibility. To add further data security the OpenClinica software and PostgreSQL database were integrated with the Programme’s Microsoft Active Directory based, central user access and management system.
These systems were installed within the Programme’s ‘private cloud’ infrastructure that is based on Microsoft Hyper-V virtualisation, HP Blade hardware, NetApp storage, and within our Internet Service Provider (ISP)’s wide area network. Implementing the solution within this environment provides the following features; database backup every 15 minutes, ability to deliver the service from either Kilifi or Nairobi office, ability to recover the service anywhere in the cloud within 30 minutes. However, one is able to run OC on a much smaller specified environment, which meets the following criteria as specified by the developers, Akaza Research LLC in Table 1.
Security in OC is ensured through use of usernames and passwords to authenticate users and provision of different privilege levels to users based on their roles that are specified by a system administrator. For example clinical monitors and data specialists (statisticians/data analyst) have read only rights; they cannot edit data in the database. Additionally the system requires the investigator or designated member to electronically sign the participants’ records data before database lock. Such electronically signatures are legally binding and make the investigators take full responsibility of ensuring the electronic data are complete and accurate.
Within KWTRP, we implemented additional security by installing the database and the application on different servers. A demilitarized zone (DMZ) was created for further security since the OpenClinica server was required to be publicly accessible. The DMZ is a logical sub-network in which publicly accessible servers are placed. This ensures that in case the publicly accessible server is compromised, the attacker is not able to reach other servers in the internal network. We also implemented SSL (Secure Socket Layer), a security protocol that ensures data submitted on the internet is encrypted and secure from eavesdropping.
Our successful implementation of different OC modes
For the last five years that we have been using OpenClinica, we have run eleven clinical trials ranging from phase I-III, involving in excess of 6000 study participants. We have used it in three different modes; direct remote data entry from sites using GSM modems, a centralized data centre approach where facsimiles of all paper records were sent and data entered and an off-line approach where data entry was done from a copy of database hosted on a field-site server installed on a laptop and the data uploaded on the live, data centre located server later, at the end of each day.
Technically, we have been able to install and run OC within our computing environment without having to incur extra expense of new software. Being a web-based system, we have used it extensively to run our multisite studies with the database hosted at our centre in Kilifi and being accessed for data entry, monitoring and extraction from our various sites or collaborators’ centres. Internet access in Kenya is readily available via GSM modems supported by telecommunication companies either through post-paid or pre-paid tariffs. We have managed a near real-time data entry from the sites of one large multisite study (case study 2) making data available to researchers promptly. The study sites used GSM modems to access the system, meaning we used the internet only during data entry keeping the cost of running the study minimal. Data from one of the study (case study 1) was extracted by a study statistician at the UK’s Medical Research Councils’ Clinical Trials Unit (MRC-CTU) in London. At CTF, we have a pool of clinical monitors electronically monitoring various studies using OC, these include studies from East Africa region that we offer clinical monitoring services. Most of these studies’ data are accessed remotely at CTF by the clinical monitors. This way, we have been able to manage near real-time data entry from remote sites, made data available to a statistician remotely from distant parts of the world and offer electronic clinical monitoring to many studies within the region.
Where we conducted trials in areas with erratic power supply or internet connectivity, we adopted an offline strategy as had been done by others in such settings . A replica of the main OC database running on the server at Kilifi centre was installed on one laptop which acted as a “field server”. The field server was configured to create a wireless network to connect with two data entry client laptops in the field. Data entry was then done from the client laptops with the data being saved on the field server. Automatic backups to an external hard disk, was set to run after every two hours. At the pre-set timepoints, a database dump script was ran on the field server to produce a database file which was then copied to the live server at KWTRP data centre.
Table 2 details the studies that we have carried out using the OC platform. The way these have been implemented using this system varied given limitations or constraints of available technology, staff and connectivity in the sites where we implemented these studies. We highlight three use cases based on studies that used different modes of using OC as shown in Table 3.
Case study 1: FEAST (Fliud Expansion as a Supportive Therapy)
FEAST was a randomised, open-label clinical trial that tested the safety and efficacy of giving rapid fluid resuscitation compared with no bolus (control) in severely ill hospitalized children (ISRCTN: 69856593). The trial was conducted in six hospitals in East Africa: four hospitals in Uganda and one hospital in each of Kenya and Tanzania, running from January 2009 to April 2011. Paper CRF elements were transcribed from source documents and 100% study monitoring/verification done for a subset of selected data items. Due to limited internet connectivity at some of the sites, data entry could not be done directly, thus paper CRFs were sent by courier service to the central data centre in Kilifi from where data entry was done. Data queries were resolved through data query forms sent by the data manager to the study sites through email. The data was later extracted for analysis by a statistician based at the UK’s Medical Research Councils’ Clinical Trials Unit (MRC-CTU) in London. The study result was published in 2011 .
Case study 2: CTX (Cotrimoxazole prophylaxis)
CTX was a randomised, double blind, placebo-controlled trial with the primary objective of determining the efficacy of cotrimoxazole prophylaxis in reducing post-discharge mortality among hospitalized, HIV-uninfected but severely malnourished children (NCT00934492). The trial recruited participants from four district hospitals distributed across Kenya with three sites at the Coast and one in Nairobi. OC was setup and managed at the Kilifi data centre. At least two field workers (field staff with secondary education) were trained to enter the data at each site and the application was accessed directly from sites using GSM modems connected to the internet. Each site only had access to their respective data and data entry was done at near real time once the paper CRFs had been completed. Study data was automatically extracted once a week, and imported into Stata (Stata Corp, College Station, TX USA). Data quality was ensured through resolution of queries raised by electronic monitoring, having 100% source data verification, validation checks set in the database and checks run on the extracted data. The study completed data collection at the end of March 2014 but is yet to publish results (expected late 2014).
Case study 3: TRAPVAC 046 (Thrombospondin-related adhesion protein vaccine 46th trial)
TRAPVAC 046 was the locally used acronym for a single blinded controlled phase IIb trial that assessed the efficacy of a heterologous prime-boost vaccine strategy with ChAd63 ME-TRAP and MVA ME-TRAP in healthy adults in Kenya (NCT01666925). This small study, with a sample size of 120 participants, recruited healthy men, 18–50 years old, residing within Kilifi county where KWTRP has its’ headquarters. Data entry was done from paper CRFs directly at the field site by both clinicians and data entry staff on laptops connected to the field server. A wireless local area network connected the additional laptops to the field server. At the end of each day, a copy of the database on the field server was uploaded to the main OC server in the data centre. Electronic monitoring and data extraction were done from this main/centralized OC server by the study monitors and statistician respectively. The study completed data collection but is yet to publish its results.
We have held training within and outside Kenya and hosted a number of data managers from other institutions interested in learning and using OC as shown in Table 4. Most recently we have been consulted by investigators of an Ethiopian intervention study against Podoconiosis  starting in 2014 for trial management, statistics, data monitoring and management using OC. We have participated in several workshops and conferences presenting our experience using OC, including the OpenClinica Global Conference of 2010 and sixth European & Developing Countries Clinical Trials Partnership (EDCTP) Forum in Addis Ababa, Ethiopia. The data management group in KWTRP actively participates in the Global Health Trials (http://www.globalhealthtrials.org) which is a free resource to support clinical trials conducted in resource limited settings. Through this we have supported and advised many diverse groups in the use of OC and other data management queries. Amongst other things, we provided training to fellow researchers from the East African region working at Amnauer Hansen Research Institute, Ethiopia, Uganda Viral Research Institute, Uganda and Mwanza Intervention Trials Unit, Tanzania (Table 4).
Challenges and future plans
Due to the web-based nature of OC, remote access to the database requires a network connection. This poses a challenge for real time data entry as some study sites are located in areas with limited or non-existent internet connectivity; however we have found modalities to work around this as discussed in one of the case studies above.
Initial problems of sluggish response times and system timeouts were ameliorated through adjustment of memory allocation to Tomcat (See http://tomcat.apache.org/) and reducing the application logging levels. XML rules were found to adversely affect the application’s response time and therefore other options for data quality assurance such as post data-entry validation using statistical packages and CRF based validation were explored and used. Help and insights to solve such problems was found by referral to OpenClinica online wikibooks-based user manual  and other online information shared by the user community, such as the electronic discussions forums.
As technology evolves, we will link OC with other existing system such as the laboratory and clinical data systems at KWTRP. We will extend the “Extract Data” module to be available directly for other statistical packages such as Stata which is the statistical lingua franca at KWTRP. We are also keen on using phones and tablet devices for direct data capture. We are yet to discard paper based primary CRFs and do direct data capture at trial sites but aim to do this in future trials.
Our five years’ experience shows it’s possible to use OC successfully in different trials employing different EDC infrastructures in resource-poor environments. Working as a team involving investigators, trial managers, clinical monitors, data managers, system administrators and statisticians from the onset of the system selection, installation, training and use was a key driver to successful implementation of the OC system in our institution. Adoption of an open-source CTDM system remains a promising solution to data management of multisite trials, especially in low resource settings.
Availability and requirements
Project name: OpenClinica.
Project home page: https://www.openclinica.com/
Operating system(s): Linux, Windows.
Programming language: Java, PostgreSQL/Oracle.
Other requirements: Apache Tomcat, Web browser for example Internet Explorer or Mozilla Firefox.
Any restrictions to use by non-academics: None (GNU Lesser General Public License).
MN is a data manager working with OC system since 2009 at KWTRP CTF and was responsible for the data management of the CTX study. NW has worked as a data manager and systems programmer at KWTRP since 2008 and was responsible for the data management of FEAST. RC and PN have both been former Heads of the CTF. TL initiated the CTF at Kilifi and was its first Head; she is a thought leader in the issues surrounding the running of clinical trials in resource poor areas. GF has been the Programme Statistician at KWTRP since 2003, he first investigated the possibility of using OC in 2007.
Kenya Medical Research Institute
KEMRI-Wellcome Trust Research Programme
Clinical trials data management system
Case report form
Electronic case report form
Information and communications technology
Eletronic Data Capture
Clinical Trials Facility
Good clinical practice
Medical Research Council clinical trials unit
Europen & Developing Countries Clinical Trials Partnership
Extensible Markup Language.
Gerritsen MG, Sartorius OE, VD Veen FM, Meester GT: Data management in multi-center clinical trials and the role of a nation-wide computer network. A 5 year evaluation. Proc Annu Symp Comput Appl Med Care. 1993, 659-662. [PMCID: PMC2850658] [PubMed: 8130557]
Lang T, Siribaddana S: Clinical trials have gone global: Is this a good thing?. PLoS Med. 2012, 9 (6): e1001228-10.1371/journal.pmed.1001228.
Ene-Iordache B, Carminati S, Antiga L, Rubis N, Ruggenenti P, Remuzzi G, Remuzzi A: Developing regulatory-compliant electronic case report forms for clinical trials: experience with the demand trial. J Am Med Inform Assoc. 2009, 16: 404-408. 10.1197/jamia.M2787.
Pavlovic I, Kern T, Miklavcic D: Comparison of paper-based and electronic data collection process in clinical trials: costs simulation study. Contemp Clin Trials. 2009, 30: 300-316. 10.1016/j.cct.2009.03.008.
Lu ZW: Information technology in pharmacovigilance: benefits, challenges, and future directions from industry perspectives. Drug Healthcare Patient Safety. 2009, 1: 35-45.
EI Emam K, Jonker E, Sampson M, Krleza-Jeric K, Neisa A: The use of electronic data capture tools in clinical trials: Web-survey of 259 Canadian trials. J Med Internet Res. 2009, 11: e8-10.2196/jmir.1120.
Litchfield J, Freeman J, Schou H, Elsley M, Fuller R, Chubb B: Is the future for clinical trials internet-based? A cluster randomized clinical trial. Clin Trials. 2005, 2 (1): 72-79. 10.1191/1740774505cn069oa.
Rondel RK, Varley SA, Webb CF: Clinical Data Management. 2000, John Wiley and Sons Ltd: West Sussex, UK, 2
Fegan GW, Lang TA: Could an open-source clinical trial data-management system be what we have been looking for?. PLoS Med. 2008, 5: e6-e6. 10.1371/journal.pmed.0050006.
CFR: Code of federal regulations title 21 [internet]: food and drug administration. [Updated 04 January 2012; Accessed 09 July 2013]. Available from: http://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfcfr/cfrsearch.cfm
Lu ZW: Technical challenges in designing post-marketing eCRFs to address clinical safety and pharmacovigilance needs. Contemp Clin Trials. 2010, 31: 108-118. 10.1016/j.cct.2009.11.004.
OpenClinica, open source for clinical research. [Internet, accessed on 09July2013] https://www.openclinica.com/about
Anderson NR, Lee ES, Brockenbrough JS, Minie ME, Fuller S, Brinkley J, Tarczy-Hornoch P: Issues in biomedical research data management and analysis: needs and barriers. J Am Med Inform Assoc. 2007, 14: 478-488. 10.1197/jamia.M2114.
Raptis DA, Mettler T, Fischer MA, Patak M, Lesurtel M, Eshmuminov D, de Rougemont O, Graf R, Clavien PA, Breitenstein S: Managing multicenter clinical trials with open source. Inform Health Soc Care. 2014, 39 (2): 67-80. 10.3109/17538157.2013.812647. doi:10.3109/17538157.2013.812647
Baumann B: Overcoming obstacles to successful clinical trials through open source. 2011, available online: http://www.appliedclinicaltrialsonline.com/appliedclinicaltrials/article/articleDetail.jsp?id=743711 accessed September 15th 2014
KEMRI/Wellcome Research Programme. 2014, Available from: http://www.kemri-wellcome.org/
Omollo R, Ochieng M, Mutinda B, Omollo T, Owiti R, Okeyo S, Wasunna M, Edwards T: Innovative approaches to clinical data management in resource limited settings using open-source technologies. PLoS Negl Trop Dis. 2014, 8 (9): e3134-10.1371/journal.pntd.0003134. doi:10.1371/journal.pntd.0003134
Molla YB, Tomczyk S, Amberbir T, Tamiru A, Davey G: Podoconiosis in East and West Gojam Zones, Northern Ethiopia. Negl Trop Dis. 2012, 6 (7): e1744-10.1371/journal.pntd.0001744.
OpenClinica User Manual: [Internet, accessed on 28February2014].http://en.wikibooks.org/wiki/OpenClinica_User_Manual,
Chilengi R, Juma R, Abdallah AM, Bashraheil M, Lodenyo H, Nyakundi P, Anabwani E, Salim A, Mwambingu G, Wenwa E, Jemutai J, Kipkeu C, Oyoo GO, Muchohi SN, Kokwaro G, Niehues T, Lang T, Nzila A: A phase I trial to evaluate the safety and pharmacokinetics of low-dose methotrexate as an anti-malarial drug in Kenyan adult healthy volunteers. Malar J. 2011, 10: 63-10.1186/1475-2875-10-63.
Maitland K, Kiguli S, Opoka , Engoru C, Olupot-Olupot P, Akech SO, Nyeko R, Mtove G, Reyburn H, Lang T, Brent B, Evans JA, Tibenderana JK, Crawley J, Russell EC, Levin M, Babiker AG, Gibb DM, FEAST Trial Group: Mortality after fluid bolus in African children with severe infection. N Engl J Med. 2011, 364 (26): 2483-2495. 10.1056/NEJMoa1101549.
Ogwang C, Afolabi M, Kimani D, Jagne YJ, Sheehy SH, Bliss CM, Duncan CJ, Collins KA, Garcia Knight MA, Kimani E, Anagnostou NA, Berrie E, Moyle S, Gilbert SC, Spencer AJ, Soipei P, Mueller J, Okebe J, Colloca S, Cortese R, Viebig NK, Roberts R, Gantlett K, Lawrie AM, Nicosia A, Imoukhuede EB, Bejon P, Urban BC, Flanagan KL, Ewer KJ, Chilengi R, Hill AV, Bojang K: Safety and Immunogenicity of Heterologous Prime-Boost Immunisation with Plasmodium falciparum Malaria Candidate Vaccines, ChAd63 ME-TRAP and MVA ME-TRAP, in Healthy Gambian and Kenyan Adults. PLoS ONE. 2013, 8 (3): e57726-10.1371/journal.pone.0057726. doi:10.1371/journal.pone.0057726
Jones Kelsey D, Hünten-Kirsch B, Laving Ahmed MR, Munyi Caroline W, Ngari M, Mikusa J, Mulongo MM, Odera D, Nassir HS, Timbwa M, Owino M, Fegan G, Murch SH, Sullivan PB, Warner JO, Berkley JA: Mesalazine in the initial management of severely acutely malnourished children with environmental enteric dysfunction: a pilot randomized controlled trial. BMC Med. 2014, 12: 133-10.1186/s12916-014-0133-2.
The authors wish to acknowledge the PIs of the three case-study trials (FEAST, CTX and TRAP VAC). Work on TRAPVAC046 was funded by the European and Developing Countries Clinical Trials Partnership, grant number IP.2008.31100.001 to the Malaria Vectored Vaccines Consortium (MVVC), and coordinated by the European Vaccine Initiative. We are also grateful for the description of our IT setup provided by the KWTRP Head of IT, Michael Moulsdale. This paper is published with the authority of the director of KEMRI.
The authors declare that they have no competing interests.
MN and NW drafted the initial manuscript. RC, PN and TL reviewed the draft manuscript; they were also previous Heads of the KWTRP CTF. GF conceived the study, and helped to draft the manuscript. All authors read and approved the final manuscript.
Moses M Ngari, Naomi Waithira contributed equally to this work.
Authors’ original submitted files for images
Below are the links to the authors’ original submitted files for images.
Rights and permissions
This article is published under license to BioMed Central Ltd. This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly credited. The Creative Commons Public Domain Dedication waiver (http://creativecommons.org/publicdomain/zero/1.0/) applies to the data made available in this article, unless otherwise stated.
About this article
Cite this article
Ngari, M.M., Waithira, N., Chilengi, R. et al. Experience of using an open source clinical trials data management software system in Kenya. BMC Res Notes 7, 845 (2014). https://doi.org/10.1186/1756-0500-7-845
- Clinical trials
- Data management
- Open-source systems