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
Technologies
Amazon Redshift
Amazon S3
Amazon EC2
AWS IAM
AWS Cloudformation
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
