Metabase Configuration (docker)
Metabase is an opensource, popular, analytics and reporting tool, which can be used to connect to Mart DB, OpenMRS DB, etc. to create visualisation, dashboards, reports, etc in data stored in Bahmni. Bahmni comes pre-packaged with metabase and mart, in docker compose (for both bahmni-lite and bahmni-standard). Before you use Metabase for production data, please ensure you have setup correct permissions/groups for users, so they don’t get access to ALL the data. Read more on that here: Securing Metabase & Bahmni Mart Analytics Tool . To better understand Bahmni Mart please read: Bahmni Mart
Environment Configurations:
| Variable Name | Description |
|---|---|
| METABASE_IMAGE_TAG | This value tells which image version to be used for Metabase. A list of tags can be found at bahmni/Metabase image - Tags. |
| METABASE_POSTGRES_IMAGE_TAG | This value tells which image version to be used for Postgres image. A list of tags can be found at postgres - Tags. |
| METABASE_DB_HOST | Host of the Metabase application database. |
| METABASE_DB_PORT | Port of the Metabase application database. |
| METABASE_DB_NAME | Name of the Metabase application database. |
| METABASE_DB_USER | Username of the Metabase application database. |
| METABASE_DB_PASSWORD | Password of the Metabase application database. |
| MB_ADMIN_EMAIL | Email-Id of the Metabase application Admin user. |
| MB_ADMIN_FIRST_NAME | First name of the Metabase application Admin user. |
| MB_ADMIN_PASSWORD | Password of the Metabase application Admin user. |
| OPENMRS_DB_HOST | Host of the OpenMRS database. |
| OPENMRS_DB_NAME | Name of the OpenMRS database. |
| OPENMRS_DB_USERNAME | Username of the OpenMRS database. |
| OPENMRS_DB_PASSWORD | Password of the OpenMRS database. |
| OPENMRS_DB_TYPE | Type of the OpenMRS database. |
Starting Metabase from Bahmni Docker Metabase will start with below details:A pre-configured Admin user.
Pre-connected to OpenMRS DB and MART DB.
Few sample reports.
To start Metabase in local follow the below commands.
We need OpenMRS DB to be up and running before starting Metabase else the Sample reports will not be generated.
Start metabase profile from docker-compose.yaml
3. Metabase should be running on https://<IP>/metabase
4. To Login, use the same credentials as mentioned in the .env file for variables: METABASE_ADMIN_EMAIL and METABASE_ADMIN_PASSWORD.
Once you have logged in as Admin user to Metabase you can go to DATA -> Browse data -> OUR DATA to see all the connected Databases and to visualize the predefined reports the user needs to go to COLLECTIONS -> Bahmni Analytics
Note: Automatic report generation and DB integration will happen in Metabase during start-up only if no prior user exists in Metabase. If Metabase DB already has an user then DB integration and report generation will be skipped.
Short Demo video on Youtube of Metabase & Mart: https://www.youtube.com/watch?v=IHZR-W7EdNg
1
Bahmni Wiki · CC BY-SA 4.0