This pattern walks you through the steps for migrating a Teradata database, used as a data warehouse in an on-premises data center, to an Amazon Redshift database. The pattern uses AWS Schema Conversion Tool (AWS SCT) data extraction agents. An agent is an external program that is integrated with AWS SCT but performs data transformation elsewhere and interacts with other AWS services on your behalf.  

Prerequisites and limitations

Prerequisites

• An active AWS account

• A Teradata source database in an on-premises data center

Product versions

• Teradata version 13 and later. For the latest list of supported versions, see the AWS SCT documentation.

Architecture

Source technology stack

• On-premises Teradata database

Target technology stack

• Amazon Redshift cluster

Data migration architecture

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-a-teradata-database-to-amazon-redshift-using-aws-sct-data-extraction-agents.html?did=pg_card&trk=pg_card