PointClickCare Integration
Access your complete PCC reporting database in your own data warehouse. EHR DataLake handles the RRDB Data Relay feed — no partner program, no SQL Server setup, no manual restores.
The Problem with PCC Data Access
Partner Program Barrier
To use PCC's official API, you must go through their partner program — build an app, get PCC approval, and publish through their marketplace. This process takes months and requires ongoing compliance.
Limited API Coverage
Even with API access, PCC'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
PCC'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 EHR 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 PCC 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 PCC 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 PCC's standard API. Here's what you can access through EHR DataLake:
API Compatibility
Our API mirrors PCC's official API structure — applications built for PCC's partner program can migrate to EHR DataLake with minimal changes. Plus, you get access to data endpoints that PCC's API doesn't expose.
PCC Official API
- ~ Limited endpoint coverage
- ~ Requires partner program approval
- ~ Rate limited
- ~ Standard fields only
EHR 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 PCC data today.