Case Study: Pfizer speeds up clinical trials with real-time analytics using Fivetran

Pfizer speeds up clinical trials by unlocking real-time data

Pfizer, the global pharmaceutical leader, needed a way to support real-time analytics for complex, mission-critical workflows such as clinical trials, manufacturing, and supply chain operations. Its challenge was especially difficult because one of its core data sources was a two-decade-old legacy data warehouse that was hard to access in real time without disrupting operations or adding load.

Using Fivetran’s database replication capabilities, Pfizer replicated data from Oracle and SQL Server into modern platforms like Snowflake and Databricks, helping standardize data movement across the enterprise. With Fivetran, Pfizer reduced data processing times from hours to minutes in select use cases, improved operational efficiency, modernized legacy infrastructure, and enabled faster decision-making while maintaining strict regulatory compliance.

Pfizer

John Leone

Senior Manager of Global Platform Support Services, Artificial Intelligence, Data and Analytics Organization