Converting extract, transform, and load (ETL) processes with AWS Schema Conversion Tool
You can use the AWS Schema Conversion Tool (AWS SCT) to migrate extract, transform, and load (ETL) processes. This type of migration includes the conversion of ETL-related business logic. This logic can reside either inside your source data warehouses or in external scripts that you run separately.
Currently, AWS SCT supports the conversion of ETL scripts to objects to AWS Glue and Amazon Redshift RSQL, as shown in the following table.
| Source | Target |
|---|---|
Informatica ETL scripts |
Informatica |
Microsoft SQL Server Integration Services (SSIS) ETL packages |
AWS Glue or AWS Glue Studio |
Shell scripts with embedded commands from Teradata Basic Teradata Query (BTEQ) |
Amazon Redshift RSQL |
Teradata BTEQ ETL scripts |
AWS Glue or Amazon Redshift RSQL |
Teradata FastExport job scripts |
Amazon Redshift RSQL |
Teradata FastLoad job scripts |
Amazon Redshift RSQL |
Teradata MultiLoad job scripts |
Amazon Redshift RSQL |
Topics
- Converting ETL processes to AWS Glue with AWS SCT
- Converting ETL processes using the Python API for AWS Glue with AWS SCT
- Converting Informatica ETL scripts with AWS SCT
- Converting SSIS to AWS Glue with AWS SCT
- Converting SSIS to AWS Glue Studio with AWS SCT
- Converting Teradata BTEQ scripts to Amazon Redshift RSQL with AWS SCT
- Converting shell scripts with embedded Teradata BTEQ commands to Amazon Redshift RSQL with AWS SCT
- Converting Teradata FastExport job scripts to Amazon Redshift RSQL with AWS SCT
- Converting Teradata FastLoad job scripts to Amazon Redshift RSQL with AWS SCT
- Converting Teradata MultiLoad job scripts to Amazon Redshift RSQL with AWS SCT
