PointClickCare Integration
Access your complete PointClickCare reporting database in your own data warehouse. Care DataLake handles the RRDB Data Relay feed — no partner program, no SQL Server setup, no manual restores.
The Problem with PointClickCare Data Access
Partner Program Barrier
To use PointClickCare's official API, you must go through their partner program — build an app, get PointClickCare approval, and publish through their marketplace. This process takes months and requires ongoing compliance.
Limited API Coverage
Even with API access, PointClickCare's standard API covers a fraction of the data available in the reporting database. Critical fields for billing, clinical workflows, and compliance reporting are often missing.
RRDB Complexity
PointClickCare's Data Relay (RRDB) provides incremental backup copies of the reporting database, but handling the feed requires SQL Server expertise, proper restore procedures, and infrastructure management.
Manual Process
Setting up and maintaining the RRDB pipeline is a manual, error-prone process. Missed restores mean stale data, and schema changes can break your setup without warning.
How Care DataLake Solves It
We handle the entire RRDB pipeline — from receiving the Data Relay feed to automated SQL Server restores to continuous sync into your data warehouse.
Ingest RRDB Feed
We receive your PointClickCare Data Relay backup files automatically. No setup on your end — just authorize the connection.
Automated Restore
Incremental backups are automatically restored to maintain a live, queryable copy of your PointClickCare reporting database.
Warehouse Sync
Data is continuously synced to your chosen warehouse — Snowflake, Microsoft Fabric, or PostgreSQL.
Data Available
The RRDB reporting database provides significantly more data than PointClickCare's standard API. Here's what you can access through Care DataLake:
API Compatibility
Our API mirrors PointClickCare's official API structure — applications built for PointClickCare's partner program can migrate to Care DataLake with minimal changes. Plus, you get access to data endpoints that PointClickCare's API doesn't expose.
PointClickCare Official API
- ~ Limited endpoint coverage
- ~ Requires partner program approval
- ~ Rate limited
- ~ Standard fields only
Care DataLake API
- Full RRDB data coverage
- No partner program needed
- REST + GraphQL + MCP
- All fields including custom
Your Data, Where You Want It
Choose the data destination that fits your infrastructure and workflow.
Snowflake
Cloud data warehouse with full SQL access, automatic scaling, and enterprise-grade security.
Microsoft Fabric
Unified analytics platform combining data engineering, data science, and business intelligence.
PostgreSQL
Open-source, self-hosted option. Full control over your infrastructure and data.
Get Started with PointClickCare
Join our early access program and start mirroring your PointClickCare data today.