Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Installing and Updating the AWS Schema Conversion Tool

The AWS Schema Conversion Tool (AWS SCT) is a standalone application that provides a project-based user interface. AWS SCT is available for Fedora Linux, macOS, Microsoft Windows, and Ubuntu Linux version 15.04. AWS SCT is supported only on 64-bit operating systems. AWS SCT also installs the Java Runtime Environment (JRE) version 8u45.

Installing the AWS Schema Conversion Tool

To install the AWS Schema Conversion Tool

  1. Download the .zip file that contains the AWS SCT installer, using the link for your operating system, shown following:

  2. Extract the AWS SCT installer file for your operating system, shown following.

    Operating System File Name

    Fedora Linux

    aws-schema-conversion-tool-1.0.build-number.x86_64.rpm

    macOS

    AWS Schema Conversion Tool-1.0.build-number.dmg

    Microsoft Windows

    AWS Schema Conversion Tool-1.0.build-number.msi

    Ubuntu Linux

    aws-schema-conversion-tool-1.0.build-number.deb

  3. Run the AWS SCT installer file extracted in the previous step. Use the instructions for your operating system, shown following.

    Operating System Install Instructions

    Fedora Linux

    Run the following command in the folder that you downloaded the file to:

    sudo yum install aws-schema-conversion-tool-1.0.build-number.x86_64.rpm

    macOS

    In Finder, open AWS Schema Conversion Tool-1.0.build-number.dmg.

    Drag AWS Schema Conversion Tool-1.0.build-number.dmg to the Applications folder.

    Microsoft Windows

    Double-click the file to run the installer.

    Ubuntu Linux

    Run the following command in the folder that you downloaded the file to:

    sudo dpkg -i aws-schema-conversion-tool-1.0.build-number.deb

  4. Install the Java Database Connectivity (JDBC) drivers for your source and target database engines. For instructions and download links, see Installing the Required Database Drivers.

Installing the Required Database Drivers

For the AWS Schema Conversion Tool to work correctly, you must install the JDBC drivers for your source and target database engines.

After you download the drivers, you give the location of the driver files. For more information, see Storing Driver Paths in the Global Settings.

You can download the database drivers from the following locations.

Important

Install the latest version of the driver available. The versions in the table following are example version numbers.

Database Engine Drivers Download Location

Amazon Aurora (MySQL compatible)

mysql-connector-java-5.1.6.jar

https://www.mysql.com/products/connector/

Amazon Aurora (PostgreSQL compatible)

postgresql-9.4-1204-jdbc42.jar

https://jdbc.postgresql.org/download.html

Amazon Redshift

RedshiftJDBC41-1.1.10.1010.jar

http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html

Greenplum Database

postgresql-9.4-1204-jdbc42.jar

https://jdbc.postgresql.org/

Microsoft SQL Server

sqljdbc4.jar

https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774

MySQL

mysql-connector-java-5.1.6.jar

https://www.mysql.com/products/connector/

Netezza

nzjdbc.jar

Use the client tools software. Install driver version 7.2.1, which is backwards compatible with data warehouse version 7.2.0.

http://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.datacon.doc/c_datacon_plg_overview.html

Oracle

ojdbc7.jar

Driver versions 7 and later are supported.

http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html

PostgreSQL

postgresql-9.4-1204-jdbc42.jar

https://jdbc.postgresql.org/download.html

Teradata

terajdbc4.jar

tdgssconfig.jar

https://downloads.teradata.com/download/connectivity/jdbc-driver

Vertica

vertica-jdbc-7.2.3-0_all

Driver versions 7.2.0 and later are supported.

https://my.vertica.com/download/vertica/client-drivers/

Installing JDBC Drivers on Linux

You can use the following steps to install the JDBC drivers on your Linux system for use with AWS SCT.

To install JDBC drivers on your Linux system

  1. Create a directory to store the JDBC drivers in.

    Copy
    PROMPT>sudo mkdir –p /usr/local/jdbc-drivers
  2. Install the JDBC driver for your database engine using the commands shown following.

    Database Engine Installation Commands

    Amazon Aurora (MySQL compatible)

    Copy
    PROMPT> cd /usr/local/jdbc-drivers PROMPT> sudo tar xzvf /tmp/mysql-connector-java-X.X.X.tar.gz

    Amazon Aurora (PostgreSQL compatible)

    Copy
    PROMPT> cd /usr/local/jdbc-drivers PROMPT> sudo cp -a /tmp/postgresql-X.X.X.jre7.tar .

    Microsoft SQL Server

    Copy
    PROMPT> cd /usr/local/jdbc-drivers PROMPT> sudo tar xzvf /tmp/sqljdbc_X.X.X_enu.tar.gz

    MySQL

    Copy
    PROMPT> cd /usr/local/jdbc-drivers PROMPT> sudo tar xzvf /tmp/mysql-connector-java-X.X.X.tar.gz

    Oracle

    Copy
    PROMPT> cd /usr/local/jdbc-drivers PROMPT> sudo mkdir oracle-jdbc PROMPT> cd oracle-jdbc PROMPT> sudo cp -a /tmp/ojdbc7.jar .

    PostgreSQL

    Copy
    PROMPT> cd /usr/local/jdbc-drivers PROMPT> sudo cp -a /tmp/postgresql-X.X.X.jre7.tar .

Storing Driver Paths in the Global Settings

After you have downloaded and installed the required JDBC drivers, you can set the location of the drivers globally in the AWS SCT settings. If you don't set the location of the drivers globally, the application asks you for the location of the drivers when you connect to a database.

To update the driver file locations

  1. In the AWS Schema Conversion Tool, choose Settings, and then choose Global Settings.

    
                            Choose global settings
  2. For Global settings, choose Drivers. Add the file path to the JDBC driver for your source database engine and your target Amazon RDS DB instance database engine.

    Note

    For Teradata, you specify two drivers separated by a semicolon.

    
                            Global settings
  3. When you are finished adding the driver paths, choose OK.

Updating the AWS Schema Conversion Tool

To check whether new version of AWS SCT is available, choose Help, and then choose Check for Updates. If there is a newer version of AWS SCT available, you are prompted to download and install the newer version.

Related Topics