- contact@verticalserve.com
A leading financial firm moved its on-premise SQL Server enterprise data warehouse to a Databricks Lakehouse on Azure, with historical and incremental pipelines and the controls its regulators expect.
The client is a leading financial firm with a strong presence in investment banking, wealth management and retail banking. It relies on its data warehouse for risk management, fraud detection and regulatory reporting.
The on-premise SQL Server EDW was struggling to scale with growing data volumes and performance demands. The firm wanted a more scalable, efficient and cost-effective platform.
Three constraints shaped the migration: keep downtime and business disruption to a minimum, move large volumes of historical data through pipelines that process it efficiently, and meet strict regulatory requirements while keeping data secure.
VerticalServe designed a Databricks Lakehouse on Azure and the pipelines that fill it.
Flow: the on-premise SQL Server EDW is loaded through Azure Data Factory historical and incremental pipelines into a Databricks Lakehouse on Azure, with validation, encryption, access controls and monitoring.
Databricks Lakehouse Azure Azure Data Factory Databricks Delta SQL Server (source)
VerticalServe ran the migration in phases:
The original write-up reports these outcomes without figures.
This case study was first published on our Medium publication. Original article
Tell us the outcome you want and your constraints. We will reply with a discovery proposal.
Talk to us