The Challenge
SAS data pipelines needed to be migrated to GCP before license expiration.
- Outdated technology and unnecessary costs: Legacy SAS-coded pipelines required migration to the cloud to unify all data management tasks on a single platform and to eliminate unnecessary costs.
- Orchestration design needs: time-based orchestration, insufficient documentation of data dependencies, and limited expertise within the technical team in cloud orchestration.
- Differences in data source structure: The data model and sources in the SAS platform differed from those in GCP.
- Uncertainty about business relevance: There was a lack of clarity regarding the business relevance of all data pipeline outcomes.
Our Solution
Leverage GenAI for Automated SAS Code Translation/migration
- We developed a GenAI-powered automated tool to extract all data sources and outputs from SAS code, enabling the creation of a data dependencies chart and proper orchestration of data processes.
- The GenAI tool also assisted in translating the SAS Base code into the appropriate cloud-based programming language, adapting it to fit the new data model and optimizing for cost and effective performance.
- Manual assessment of business relevance was necessary to identify which data processes truly needed to be migrated.
KEY Benefits
Process migration completed in 4 months
Eliminated unnecessary costs.
Successfully finished process migration within 4 months, meeting a tight deadline.
$200K/year SAS license
$150K/year Opex Savings
Results
Performance improvement of +30%
Unifying all data pipelines for this team onto a single platform, improving governance and simplifying maintenance.
