[V0.93] Bahmni Mart provides a way of transferring data from Bahmni into a dedicated database for reporting/analytics purposes – to make it easy to perform reporting, and to avoid performance issues in a running EMR system, due to heavy SQLs. Bahmni Mart can then be connected with Metabase, an open source analytics tool, quite similar to PowerBI, Tabluea, etc. to create visualisations, dashboards and reports.
At the core, Bahmni Mart is a flattened and simplified database intended for analytics wherein hierarchical structures have been flattened and pivoted and many other entities denormalized. You may plugin data visualization tools Metabase, Superset etc on top of this database. At the same time, you may want to integrate Bahmni Reports with Bahmni mart. The following sections detail how this can be done.
For diagrams and high level feature details on Bahmni Mart, please refer to this document section in Implementor Guide: Bahmni Mart
Configure Datasource Definition for Bahmni Mart
Configure the datasource definition like in the example below.