The client’ SAS data warehouse was not scalable for future requirement of the business. Multiple processes on disparate systems (SAS Data Integration (DI) and SQL Server Integration Service) lacked the synergy.
Hexaware is currently helping the client in accelerating cloud data warehouse adoption, i.e. migrating SAS data warehouse to Microsoft Azure. The team has leveraged Hexaware’s AMAZE® for Data & AI platform to perform automated assessment and migration of existing 2200+ SAS DI & SQL Server Integration Service ETL jobs to Azure Data Factory (ADF).
Hexaware’s AMAZE® for Data & AI provides the following levers in cloud migration
- Azure native approach to architecture
- Automation-led migration and validation, pilot-based execution
Major benefits delivered to the client are:
- 50% reduction in the assessment timeline
- 3X improvement in the factory model to ensure consistency and reduce risk
- 40-50% increase in cost-efficiency and reduction in the total cost of ownership
