Salesforce Health Cloud to PlanetScale Integration
AI-first ETL from Salesforce Health Cloud into PlanetScale. Governed entities, incremental sync, typed landing tables.
How Datrise loads Salesforce Health Cloud into PlanetScale
Datrise syncs Salesforce Health Cloud's patients, care plans, care teams, clinical encounters, cases, and consents into PlanetScale as a typed table per source entity. Flexible or custom fields land in JSON columns, and timestamps such as created, updated, and status changes are typed as DATETIME.
Sync is incremental: Datrise uses a watermark on updated-at, applied with INSERT … ON DUPLICATE KEY UPDATE, so re-runs update only what changed. Vitess sharding by tenant or entity key for very large tables. PlanetScale disallows foreign-key constraints by default, so Datrise models relationships by stable id columns rather than enforced FKs.
Ideal for horizontally scalable MySQL apps on Vitess.
Endpoints
Salesforce Health Cloud: Patient and member relationship management on Salesforce.
PlanetScale: Serverless MySQL platform with safe schema workflows.
How Salesforce Health Cloud entities map to PlanetScale
| Salesforce Health Cloud entity | PlanetScale object | Notes |
|---|---|---|
| patients | salesforce_health_cloud_patients | id PK · custom fields → JSON columns |
| care plans | salesforce_health_cloud_care_plans | id PK · linked to salesforce_health_cloud_patients |
| care teams | salesforce_health_cloud_care_teams | id PK · linked to salesforce_health_cloud_patients |
| clinical encounters | salesforce_health_cloud_clinical_encounters | id PK · linked to salesforce_health_cloud_patients |
FAQ
How does Datrise handle Salesforce Health Cloud's custom fields in PlanetScale?
Flexible values are stored as JSON columns, so new fields don't require a migration; strongly-typed fields — dates, numbers, and references — are promoted to native PlanetScale types.
How does the Salesforce Health Cloud to PlanetScale sync stay up to date?
It runs incrementally — Datrise uses a watermark on updated-at, applied with INSERT … ON DUPLICATE KEY UPDATE.
Related pipelines
More destinations for Salesforce Health Cloud
- Salesforce Health Cloud → Amazon DynamoDB
- Salesforce Health Cloud → Looker
- Salesforce Health Cloud → Looker Studio
- Salesforce Health Cloud → Microsoft Power BI
- Salesforce Health Cloud → Tableau
- Salesforce Health Cloud → Apache Superset
- Salesforce Health Cloud → Metabase
- Salesforce Health Cloud → Amazon QuickSight
- Salesforce Health Cloud → Domo
- Salesforce Health Cloud → Sisense
- Salesforce Health Cloud → ThoughtSpot
- Salesforce Health Cloud → Qlik
More sources for PlanetScale
Early access
Connect Salesforce Health Cloud to PlanetScale the easy way
Skip brittle scripts and manual exports. Join the waitlist to get a guided setup, AI-assisted mapping, and reliable incremental sync for this integration.