Case Study: Oldcastle Infrastructure achieves cloud migration, $360,000 savings, and company-wide analytics with Fivetran

Oldcastle Infrastructure Sees $25M ROI With The Modern Data Stack

Oldcastle Infrastructure, a CRH company and maker of engineered building solutions, needed to migrate the majority of its on‑premise SQL Server data plus NetSuite cloud data into a single cloud warehouse to enable company‑wide analytics. After an eight‑month internal warehousing effort stalled—complicated by limited SQL Server expertise and NetSuite’s shifting API—they engaged InterWorks and chose Fivetran to build automated pipelines into Snowflake and surface insights in Tableau.

Fivetran replicated every table and field from Oldcastle’s on‑prem and cloud ERPs in 10 business days, reliably handling the NetSuite API and loading data into Snowflake; this approach is projected to save about $360,000 over three years. Using Fivetran connectors (SQL Server, NetSuite, Salesforce) alongside Snowflake and Tableau, Oldcastle now has transaction‑level data updating every three hours (configurable to 15 minutes), a single source of truth, and up‑to‑date global Tableau reports that replaced stale, ten‑day monthly rollups.

Oldcastle Infrastructure

Nick Heigerick

IT Manager of BI