![case study](https://cdn.quantiphi.com/2024/03/6c4f8776-teradata-to-redshift-migration.png)
Teradata to Redshift Migration
InsuranceBusiness Impacts
70%
Improvement in Performance & Efficiency
Customer Key Facts
- Location : North America
- Industry : Insurance
Problem Context
The client, a large insurance company, had an on-premises Teradata warehouse for data storage. They wanted to migrate their on-premise Teradata warehouse to AWS for better performance and efficiency.
Challenges
- Structuring large amount of unstructured data
- Handling data from multiple sources
![](https://cdn.quantiphi.com/2024/03/f0ac81cb-challenges_teradata-to-redshift-migration-02.png)
Technologies
![Amazon Redshift](https://cdn.quantiphi.com/2024/02/Amazon-Redshift_light-bg@4x-1.png)
Amazon Redshift
![Amazon S3](https://cdn.quantiphi.com/2024/02/9c40e5d8-amazon-s3.png)
Amazon S3
![Amazon EC2](https://cdn.quantiphi.com/2024/02/Amazon-EC2_light-bg@4x.png)
Amazon EC2
![AWS IAM](https://cdn.quantiphi.com/2024/02/AWS-Identity-and-Access-Management_IAM_light-bg@4x.png)
AWS IAM
![AWS Cloudformation](https://cdn.quantiphi.com/2024/02/AWS-CloudFormation@4x.png)
AWS Cloudformation
![Teradata](https://cdn.quantiphi.com/2024/02/teradata.jpg)
Teradata
Migrated data from an on-premise Teradata warehouse to Amazon Redshift
Solution
Quantiphi leveraged AWS SCT that assists heterogeneous database migration by automatically converting the source database schema and other database code objects to a format compatible with the target database. Once schema conversion is complete, SCT also migrates data from a range of data warehouses (Teradata included) to Amazon Redshift using in-built data migration agents.
Results
- Migrated data from an on-premise Teradata warehouse to Amazon Redshift leading to a seamless data operation experience and improved performance efficiency
- Minimized cost and downtime
- Reduced manual efforts
- Ensured higher scalability