This page provides users with information about accessing data in CommCare for the pre-built COVID-19 tools and links to additional information about data in CommCare. Please see the Data Security overview for more informationa about how data is stored in CommCare.


Video on Accessing Data from CommCare (please click image below)

Accessing Your CommCare Data

After collecting data with a COVID-19 application, you can access the data in many ways:

  1. View pre-built supervision reports.

  2. Download your form data.

  3. Download your case data.

  4. Create your own reports using CommCare’s Report Builder.

The video above provides further information on accessing data for your CommCare app, using the example of the COVID-19 WHO FFX Protocol Template app. 

CommCare Integrations Options

In order to fully take action on your data, you may be interested in integrating CommCare with an external health information or business intelligence system. This section describes some of those integration options. For a full overview fo supported integrations, please visit this the Integrations site.

  • Configuring, debugging, and maintaining software integrations requires a certain level of technical expertise. We highly recommend you work with someone with this expertise in integrating your applications.
  • Please note that CommCare’s integrations features require a paid software plan. Please submit this form to request a pro bono plan that meets your data and integration needs.

Table: List of All Integration Options

Tool

Method to integrate with CommCare

Details

Excel Dashboard

CommCare's Excel Dashboards feature

Connection with CommCareHQ data to download information in an Excel Spreadsheet. This solution is limited by the number of rows Excel can handle, usually around 200,000 items.

Power BI

Odata feed

Designed for M&E advisors and program teams, the integration built atop the Odata feed creates a seamless data connection between CommCare and both Tableau and PowerBI. Without any IT support, everyone can now use and refresh their CommCare data in either of these popular business intelligence tools. The Odata feed integration is appropriate for up to 500,000 items.

commcare-export tool to SQL server

For data sets over 500,000 cases or forms, use the commcare-export tool to automatically pull your form and case data from CommCare HQ and save it to a local database that feeds into your Power BI dashboard.

Tableau

Odata feed

The Odata feed integration works exactly the same for Power BI as it does for Tableau. Check out our demo video for setting up an integration with Tableau.

commcare-export tool to SQL server

For data sets over 500,000 cases or forms, use the commcare-export tool to automatically pull your form and case data from CommCare HQ and save it to a local database that feeds into your Tableau dashboard.

DHIS2

MOTECH

The MOTECH Platform is an open source enterprise software package that connects popular eHealth technologies. MOTECH currently supports two ways of integrating CommCare with DHSI2: Forwarding aggregated data as DHIS2 DataSets; and forwarding form question values as DHIS2 Anonymous Events.

Self-hosted open source BI tools like Superset and Metabase

commcare-export tool to SQL server

Use the commcare-export tool to automatically pull your form and case data from CommCare HQ and save it to a local database, then connect your favorite BI tool to that database.

Other systems

APIs

See the full list of APIs available for accessing various parts of CommCare HQ.

Data Forwarding

Event-based solution in which CommCare forwards data (forms, cases, locations, users) to a Webhook

commcare-export tool to SQL server

commcare-export is a command line tool that will automatically pull your form and case data from CommCare HQ and save it locally, typically to either an Excel spreadsheet or to a local database (like MySQL). You can configure it to pull data on a schedule to automatically keep your data up to date, or run it as a one-time data dump.

Zapier

Zapier can be used with CommCare to trigger 100s of actions based on incoming CommCare form submissions or case modifications.

OpenFN

OpenFn is an integration platform designed specifically for the social sector. The platform is ideal for non-tech teams. Check out this OpenFN demo video on Getting started with your integration.

You can find our full range of integration options and links to their documentation on our CommCare Ecosystem page.

CommCare + Microsoft Excel / PowerBI / Tableau

Dimagi is developing template dashboards across our partners’ most common BI tools to ensure you get the most out of your COVID-19 CommCare app data. Please find documentation for each template along with instructions to set up your integration: 

Check out our blog post about our New Template BI Tools to Support COVID-19 Response.

CommCare + DHIS2

Dimagi’s MOTECH platform allows CommCare and DHIS2 to work together to provide an end-to-end solution for mobile data collection, aggregation, storage, and reporting at any scale. Learn more about how CommCare and DHIS2 work together to create an end-to-end data pipeline on our CommCare + DHIS2 Digital Health Systems page.

MOTECH can be leveraged to connect your CommCare COVID-19 template application data to the DHIS2 COVID-19 Surveillance Digital Data Package - a digital data package to accelerate case detection, situation reporting, active surveillance and response for COVID-19.

  • No labels