Earlier today, @Meghan-Gilroy shared this amazing article from @SimonKihara on their experience using OpenFn to build a workflow that fetches data from CommCare, transforms the data, and pushes the output to a PostgreSQL database to support advanced reporting and analytics.
This article provides a great reference for anyone looking to learn more about connecting CommCare to another external platform like a PostgreSQL database.
To read more about Simon’s work, check this medium post: Data Engineering Boots on the Ground — Pulling Data from CommCare to PostgreSQL via OpenFN Lightning | by Simon kihara | Jan, 2025 | Medium