A leading global consumer lending company headquartered in Australia aimed to modernize its legacy on-premises data warehouse ecosystem. The key business imperatives were improved performance efficiencies and moving from a CAPEX to an OPEX model.
Hexaware’s team of experts proposed an automated data warehouse modernization solution leveraging their AMAZE® for Data & AI platform. The roadmap to modernization was comprehensive and involved a best-fit best-practices methodology to migrate SQL Server to Azure Synapse.
The on-premises SQL Server data warehouse comprises 1000+ tables, 500+ views, 200+ procedures, 60+ functions, and 1.3 TB of data. The first milestone in the SQL Server to Azure Synapse migration journey was an automated assessment that looked at the viability of automated migration to Azure Synapse within 2 weeks. Post the assessment, a structured migration plan was framed that detailed the transformation timeline and implementation details. AMAZE® for Data & AI leveraged automation to seamlessly replatform SSIS ETL jobs to the Azure Data Factory (ADF).
The migration of the data warehouse ecosystem from SQL Server to Azure Synapse and SSIS to ADF enabled the following business benefits.
- 60% Faster time to Market
- 35-40% Reduction in Total Cost of Ownership (TCO)
- 50% Better with the factory model for ETL code migration and testing ensuring consistency and reducing risk
