Step 4: Install Amazon SCT on Your Local Computer - Database Migration Guide
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Step 4: Install Amazon SCT on Your Local Computer

In this step, you install and configure the Amazon Schema Conversion Tool. In this walkthrough, we run Amazon SCT and the data extraction agent on Windows. However, you can use Amazon SCT and data extraction agents on other supported operating systems. For more information, see Installing the schema conversion tool and Installing extraction agents.

To install Amazon SCT

  1. Download the compressed file that contains Amazon SCT installer for Microsoft Windows from https://s3.amazonaws.com/publicsctdownload/Windows/aws-schema-conversion-tool-1.0.latest.zip.

  2. Extract Amazon SCT installer file.

  3. Run Amazon SCT installer file that you extracted in the previous step.

  4. Choose Next, accept the terms of the License Agreement, and choose Next again.

  5. Enter the path to the folder where you want to install Amazon SCT, and choose Next.

  6. Choose Install.

  7. Choose Finish to close the installation wizard.

Now you can run Amazon SCT. Before you create a new project, make sure that you add the path to an Amazon Redshift JDBC driver in the application settings. You don’t need a JDBC driver to connect to your BigQuery project.

To configure driver settings in Amazon SCT

  1. Download an Amazon Redshift JDBC driver version 2.1.0.9 or later from https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-download-driver.html.

  2. Extract the JDBC driver from the compressed file that you downloaded.

  3. Open Amazon SCT, and choose Global settings from Settings.

  4. Choose Drivers.

  5. For Amazon Redshift driver path, choose Browse and choose the redshift-jdbc42-2.1.0.9.jar file that you extracted.

  6. Choose Apply, and then choose OK to close the settings window.

To access Amazon services such as Amazon S3 from Amazon SCT, you configure an Amazon service profile. An Amazon service profile is a set of Amazon credentials that includes your Amazon access key, Amazon secret access key, Amazon Region, and Amazon S3 bucket.

To create an Amazon service profile in Amazon SCT

  1. Open Amazon SCT, and choose Global settings from Settings.

  2. Choose Amazon service profiles.

  3. Choose Add a new Amazon service profile.

  4. For Profile name, enter a descriptive name for your profile.

  5. For Amazon access key, enter your Amazon access key.

  6. For Amazon secret key, enter your Amazon secret access key. For more information about Amazon access keys, see Programmatic access.

  7. For Region, choose the Amazon Region where you created your Amazon S3 bucket in the previous step.

  8. For Amazon S3 bucket folder, choose the Amazon S3 bucket that you created in the previous step.

  9. Choose Apply, and then choose OK to close the settings window.