Converting Data Using ETL Processes in 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 in AWS Schema Conversion Tool
- Converting ETL processes to AWS Glue in AWS Schema Conversion Tool
- Converting Informatica ETL scripts with AWS Schema Conversion Tool
- Converting SSIS to AWS Glue with AWS SCT
- Converting SSIS pacakges to AWS Glue Studio with AWS Schema Conversion Tool
- Converting Teradata BTEQ scripts to Amazon Redshift RSQL with AWS SCT
- Converting shell scripts with embedded BTEQ commands to Amazon Redshift RSQL with AWS Schema Conversion Tool
- Converting FastExport scripts to Amazon Redshift RSQL with AWS Schema Conversion Tool
- Converting FastLoad job scripts to Amazon Redshift RSQL with AWS Schema Conversion Tool
- Converting MultiLoad scripts to Amazon Redshift RSQL with AWS Schema Conversion Tool
