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: . To better understand Bahmni Mart please read:

Environment Configurations:

Variable Name

Description

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:

  1. A pre-configured Admin user.

  2. Pre-connected to OpenMRS DB and MART DB.

  3. Few sample reports.

To start Metabase in local follow the below commands.

 

  1. We need OpenMRS DB to be up and running before starting Metabase else the Sample reports will not be generated.

  2. Start metabase profile from docker-compose.yaml

# Edit the profile to "bahmni-mart" to bring up all services incl metabase # (or to "metabase" if you ONLY want metabase) COMPOSE_PROFILES=bahmni-mart # Then execute the command docker compose up -d

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.

 

Running Bahmni on Docker

 

The Bahmni documentation is licensed under Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)