Page Comparison

It's appropriate to note some challenges faced by reporting on the OpenMRS transactional data model. The OpenMRS data model was built to allow for quick retrieval of data in the patient-provider interaction. It stores all patient information in a fixed set of tables that are excellent for extracting one record at a time, but not optimized for reporting at national scale. Due to this, a number of OpenMRS implementations have created reporting solutions that extract, transform and load (ETL) the data into a different database structure or a third-party reporting tool. A number of OpenSRP implementations are working on ETL-based solutions at this time and we expect to have a set of standard solutions for OpenSRP implementers in the future.