# Converting FastLoad job scripts to Amazon Redshift RSQL with AWS Schema Conversion Tool
<a name="CHAP-converting-fastload-rsql"></a>

You can use the AWS Schema Conversion Tool (AWS SCT) to convert Teradata FastLoad job scripts to Amazon Redshift RSQL.

A *Teradata FastLoad script* is a set of commands that use multiple sessions to load data in an empty table on a Teradata Database. Teradata FastLoad processes a series of Teradata FastLoad commands and SQL statements. The Teradata FastLoad commands provide session control and data handling of the data transfers. The SQL statements create, maintain, and drop tables.

AWS SCT converts Teradata FastLoad commands and SQL statements to a format compatible with Amazon Redshift RSQL. After you migrate the Teradata database to Amazon Redshift, you can use these converted scripts to load data to your Amazon Redshift database.

**Topics**
+ [Adding FastLoad job scripts to your AWS SCT project](#CHAP-converting-fastload-rsql-create)
+ [Configuring substitution variables in Teradata FastLoad job scripts with AWS SCT](#CHAP-converting-fastload-rsql-variables)
+ [Converting Teradata FastLoad job scripts with AWS SCT](#CHAP-converting-fastload-rsql-convert)
+ [Managing Teradata FastLoad job scripts with AWS SCT](#CHAP-converting-fastload-rsql-manage)
+ [Creating an assessment report for a Teradata FastLoad job script conversion with AWS SCT](#CHAP-converting-fastload-rsql-assessment)
+ [Editing and saving your converted Teradata FastLoad job scripts with AWS SCT](#CHAP-converting-fastload-rsql-save)

## Adding FastLoad job scripts to your AWS SCT project
<a name="CHAP-converting-fastload-rsql-create"></a>

You can add multiple scripts to a single AWS SCT project.

**To add a FastLoad job script to your AWS SCT project**

1. Create a new project in AWS SCT, or open an existing project. For more information, see [Starting and managing Projects in AWS SCT](CHAP_UserInterface.Project.md). 

1. Choose **Add source** from the menu, and then choose **Teradata** to add your source database to the project. For more information, see [Teradata databases](CHAP_Source.Teradata.md).

1. Choose **Add target** from the menu and add a target Amazon Redshift database to your AWS SCT project.

   You can use a virtual Amazon Redshift target database platform. For more information, see [Mapping to virtual targets in the AWS Schema Conversion Tool](CHAP_Mapping.VirtualTargets.md).

1. Create a new mapping rule that includes your source Teradata database and your Amazon Redshift target. For more information, see [Mapping new data types in the AWS Schema Conversion Tool](CHAP_Mapping.New.md). 

1. On the **View** menu, choose **Main view**.

1. In the left panel, expand the **Scripts** node.

1.  Choose **FastLoad**, open the context (right-click) menu, and then choose **Load scripts**.

1.  Enter the location of your source Teradata FastLoad job scripts and choose **Select folder**.

   AWS SCT displays the **Load scripts** window.

1. Do one of the following:
   + If your Teradata FastLoad job scripts don't include the substitution variables, choose **No substitution variables**, and then choose **OK** to add scripts to your AWS SCT project.
   + If your Teradata FastLoad job scripts include the substitution variables, configure the substitution variables. For more information, see [Configuring substitution variables in FastLoad job scripts](#CHAP-converting-fastload-rsql-variables).

## Configuring substitution variables in Teradata FastLoad job scripts with AWS SCT
<a name="CHAP-converting-fastload-rsql-variables"></a>

Your Teradata FastLoad job scripts might include substitution variables. For example, you can use a single script with substitution variables to load data to different databases.

Before you run a FastLoad job script with substitution variables, make sure to assign the values for all variables. To do this, you can use other tools or applications such as a Bash script, UC4 (Automic), and so on.

AWS SCT can resolve and convert substitution variables only after you assign their values. Before you start the conversion of your source Teradata FastLoad job scripts, make sure that you assign values for all substitution variables. You can use AWS SCT to configure substitution variables in your Teradata scripts. 

**To configure substitution variables in your FastLoad job script**

1. When you add your source Teradata FastLoad job scripts to your AWS SCT project, choose **Substitution variables are used**. For more information about adding these scripts, see [Adding FastLoad job scripts to your AWS SCT project](#CHAP-converting-fastload-rsql-create). 

1. For **Define variable format**, enter a regular expression that matches all substitution variables in your script.

   For example, if the names of your substitution variables start with `${` and end with `}`, use the `\$\{\w+\}` regular expression. To match substitution variables that start either with a dollar sign or a percent sign, use the `\$\w+|\%\w+` regular expression.

   Regular expressions in AWS SCT conform to the Java regular expression syntax. For more information, see [java.util.regex Class Pattern](https://docs.oracle.com/javase/6/docs/api/java/util/regex/Pattern.html) in the Java documentation. 

1. Choose **OK** to load scripts to your AWS SCT project, and then choose **OK** to close the **Load scripts** window.

1. In the left panel, expand the **Scripts** node. Choose **FastLoad**, and then choose your folder with scripts. Open the context (right-click) menu, and then choose **Export variables** under **Substitution variables**.

   Also, you can export substitution variables for one script. Expand your folder with scripts, choose your script, open the context (right-click) menu, and choose **Export variables** under **Substitution variables**.

1. Enter the name of the comma-separated value (CSV) file to save the substitution variables, and then choose **Save**.

1. Open this CSV file and fill in the values for the substitution variables.

   Depending on the operating system, AWS SCT uses different formats for the CSV file. The values in the file might be either enclosed in quotation marks or not. Make sure that you use the same format for the values of substitution variables as the other values in the file. AWS SCT can't import the CSV file with values in different formats.

1. Save the CSV file.

1. In the left panel, expand the **Scripts** node. Choose **FastLoad**, and then choose your script. Open the context (right-click) menu, and then choose **Import variables** under **Substitution variables**.

1. Choose your CSV file, and then choose **Open**.

1. Choose **Variables** to view all discovered substitution variables and their values.

## Converting Teradata FastLoad job scripts with AWS SCT
<a name="CHAP-converting-fastload-rsql-convert"></a>

Following, find how to convert Teradata FastLoad job to Amazon Redshift RSQL using AWS SCT. 

**To convert a Teradata FastLoad job script to Amazon Redshift RSQL**

1. Add your FastLoad job scripts to your AWS SCT project. For more information, see [Adding FastLoad job scripts to your AWS SCT project](#CHAP-converting-fastload-rsql-create).

1. Configure the substitution variables. For more information, see [Configuring substitution variables in FastLoad job scripts](#CHAP-converting-fastload-rsql-variables).

1. In the left panel, expand the **Scripts** node.

1. Do one of the following:
   + To convert a single FastLoad job script, expand the **FastLoad** node, choose the script to convert, and then choose **Convert script** from the context (right-click) menu.
   + To covert multiple scripts, make sure that you select all scripts to convert. Choose **FastLoad**, open the context (right-click) menu, and then choose **Convert script**. Then do one of the following:
     + If you store your source data file on Amazon S3, choose **S3 object path** for **Source data file location**.

       Enter values for **Amazon S3 bucket folder** and **Amazon S3 bucket for manifest file** for your source data file.
     + If you don't store your source data file on Amazon S3, choose **Host address** for **Source data file location**.

       Enter values for **URL or IP address of the host**, **Host user login name**, and **Amazon S3 bucket for manifest file** for your source data file.

1. Choose **OK**.

   AWS SCT converts all your selected Teradata FastLoad job scripts to a format compatible with Amazon Redshift RSQL. Find your converted scripts in the **Scripts** node in the target database panel.

1. Edit your converted Amazon Redshift RSQL scripts or save them. For more information, see [Editing and saving your converted FastLoad job scripts](#CHAP-converting-fastload-rsql-save).

## Managing Teradata FastLoad job scripts with AWS SCT
<a name="CHAP-converting-fastload-rsql-manage"></a>

You can add multiple Teradata FastLoad job scripts or remove a FastLoad job script from your AWS SCT project.

**To add a new FastLoad job script to your AWS SCT project**

1. Expand the **Scripts** node in the left panel.

1. Choose the **FastLoad** node and open the context (right-click) menu.

1. Choose **Load scripts**.

1. Enter the information that is required to add a new FastLoad job script and configure substitution variables. For more information, see [Adding FastLoad job scripts to your AWS SCT project](#CHAP-converting-fastload-rsql-create) and [Configuring substitution variables in FastLoad job scripts](#CHAP-converting-fastload-rsql-variables).

**To remove a FastLoad job script from your AWS SCT project**

1. Expand the **FastLoad** node under **Scripts** in the left panel.

1. Choose the script to remove, and open the context (right-click) menu.

1. Choose **Delete script**.

## Creating an assessment report for a Teradata FastLoad job script conversion with AWS SCT
<a name="CHAP-converting-fastload-rsql-assessment"></a>

The *FastLoad job script conversion assessment report* provides information about converting the FastLoad commands and SQL statements. The conversion is from your source scripts to a format compatible with Amazon Redshift RSQL. The assessment report includes action items for FastLoad commands and SQL statements that AWS SCT can't convert. 

**To create a script conversion assessment report for a Teradata FastLoad job**

1. Expand the **FastLoad** node under **Scripts** in the left panel.

1. Choose the script to convert, open the context (right-click) menu, and then choose **Create report**.

1. View the **Summary** tab. 

   The **Summary** tab displays the executive summary information from the FastLoad job script assessment report. It includes conversion results for all FastLoad commands and SQL statements from your source scripts. 

1. (Optional) Save a local copy of the FastLoad job script conversion assessment report as either a PDF file or a comma-separated value (CSV) file:
   + To save the FastLoad job script conversion assessment report as a PDF file, choose **Save to PDF** at upper right.

      The PDF file contains the executive summary, action items, and recommendations for script conversion.
   + To save the FastLoad job script conversion assessment report as a CSV file, choose **Save to CSV **at upper right.

     The CSV file contains action items, recommended actions, and an estimated complexity of manual effort required to convert the scripts.

1. Choose the **Action items** tab. This tab contains a list of items that require manual conversion to Amazon Redshift RSQL. When you select an action item from the list, AWS SCT highlights the item from your source FastLoad job script that the action item applies to. 

## Editing and saving your converted Teradata FastLoad job scripts with AWS SCT
<a name="CHAP-converting-fastload-rsql-save"></a>

You can edit your converted scripts in the lower panel of your AWS SCT project. AWS SCT stores the edited script as part of your project.

**To save your converted scripts**

1. Expand the **RSQL scripts** node under **Scripts** in the target database panel.

1. Choose your converted script, open the context (right-click) menu, and choose **Save script**.

1. Enter the path to the folder to save the converted script and choose **Save**.

   AWS SCT saves the converted script to a file and opens this file.