Case Study: Health Data Compass achieves automated Salesforce-to-BigQuery integration and saves ~40 hours per quarter with Fivetran

Delivering Valuable Data to Medical Researchers

Health Data Compass, part of the Colorado Center for Personalized Medicine at the University of Colorado Anschutz Medical Campus, needed a low‑maintenance, cloud‑native way to bring researcher request data from Salesforce into their Google BigQuery analytics platform. They sought an automated connector that met strict security and scalability requirements so researchers could track requests and support clinical discoveries without heavy engineering overhead. Fivetran was chosen for its cloud‑native, automated data pipeline capabilities.

Fivetran implemented its Salesforce connector to sync over 117 Salesforce tables into Google BigQuery every 15 minutes, feeding Tableau dashboards and the Compass data warehouse for combined clinical and genomics analytics. As a result, Health Data Compass gained real‑time visibility into request status and usage patterns, improved internal efficiency, supported grant work and personalized medicine efforts, and saved roughly 40 hours of work per quarter thanks to Fivetran’s automation.

Health Data Compass

Jue Wang

Lead BI Developer