Installing, verifying, and updating the AWS SCT
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 Amazon Corretto JDK 11.
Some AWS SCT builds don't have builds for Apple macOS. For more information see your build of interest at Release notes.
To ensure that you get the correct version of the AWS SCT distribution file, we provide verification steps after you download the compressed file. You can verify the file using the steps provided.
Topics
Installing the AWS SCT
To install the AWS SCT
-
Download the compressed file that contains the AWS SCT installer, using the link for your operating system. All compressed files have a .zip extension. When you extract the AWS SCT installer file, it will be in the appropriate format for your operating system.
-
Note Some AWS SCT builds don't have builds for Apple macOS. For more information see your build of interest at Release notes.
-
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.rpmmacOS
AWS Schema Conversion Tool-1.0.
build-number
.dmgNote Some AWS SCT builds don't have builds for Apple macOS. For more information see your build of interest at Release notes.
Microsoft Windows
AWS Schema Conversion Tool-1.0.
build-number
.msiUbuntu Linux
aws-schema-conversion-tool-1.0.
build-number
.deb -
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.rpmmacOS
In Finder, locate and extract the zip file. In the extracted folder, open
AWS Schema Conversion Tool-1.0.
.build-number
.dmgTo complete installation, drag the
AWS Schema Conversion Tool.app
icon to the Applications folder.Close the installation window, if open. In finder, eject the installation drive, if mounted.
Note Some AWS SCT builds don't have builds for Apple macOS. For more information see your build of interest at Release notes.
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 -
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 previous versions of the AWS SCT
You can download and install previous versions of the AWS SCT. Use the following format to download a previous version. You must provide the version and OS information using this format.
https://d211wdu1froga6.cloudfront.net/builds/1.0/
<version>
/<OS>
/aws-schema-conversion-tool-1.0.zip
For example, to download AWS SCT version 632, do the following:
There may be a later version for your OS than shown here. For more information, see Release notes.
-
MacOS - https://d211wdu1froga6.cloudfront.net/builds/1.0/632/MacOS/aws-schema-conversion-tool-1.0.zip
Note Some AWS SCT builds don't have builds for Apple macOS. For more information see your build of interest at Release notes.
-
Windows - https://d211wdu1froga6.cloudfront.net/builds/1.0/632/Windows/aws-schema-conversion-tool-1.0.zip
-
Ubuntu - https://d211wdu1froga6.cloudfront.net/builds/1.0/632/Ubuntu/aws-schema-conversion-tool-1.0.zip
-
Fedora - https://d211wdu1froga6.cloudfront.net/builds/1.0/632/Fedora/aws-schema-conversion-tool-1.0.zip
Verifying the AWS SCT file download
There are several ways you can verify the distribution file of the AWS SCT. The simplest is to compare the checksum of the file with the published checksum from AWS. As an additional level of security, you can use the procedures following to verify the distribution file, based on the operating system where you installed the file.
This section includes the following topics.
Topics
Verifying the checksum of the AWS SCT file
In order to detect any errors that could have been introduced when downloading or storing the AWS SCT compressed file, you can compare the file checksum with a value provided by AWS. AWS uses the SHA256 algorithm for the checksum.
To verify the AWS SCT distribution file using a checksum
-
Download the AWS SCT distribution file using the links in the Installing section.
-
Download the latest checksum file, called sha256Check.txt
. For example, the file can appear like the following: Fedora b4f5f66f91bfcc1b312e2827e960691c269a9002cd1371cf1841593f88cbb5e6 Ubuntu 4315eb666449d4fcd95932351f00399adb6c6cf64b9f30adda2eec903c54eca4 Windows 6e29679a3c53c5396a06d8d50f308981e4ec34bd0acd608874470700a0ae9a23 MacOs ed56d3ab49309e92ac4d2ef439d35449ac1326f470c23dc5866e1bf0a60b0e67
-
Run the SHA256 validation command for your operating system in the directory that contains the distribution file. For example, the command to run on the Mac operating system is the following:
shasum -a 256 aws-schema-conversion-tool-1.0.latest.zip
-
Compare the results of the command with the value shown in the sha256Check.txt file. The two values should match.
Verifying the AWS SCT RPM files on Fedora
AWS provides another level of validation in addition to the distribution file
checksum. All RPM files in the distribution file are signed by an AWS private key.
The public GPG key can be viewed at amazon.com.public.gpg-key
To verify the AWS SCT RPM files on Fedora
-
Download the AWS SCT distribution file using the links in the Installing section.
-
Verifying the checksum of the AWS SCT distribution file.
-
Extract the contents of the distribution file. Locate the RPM file you want to verify.
-
Download GPG public key from amazon.com.public.gpg-key
-
Import the public key to your RPM DB (make sure you have the appropriate permissions) by using the following command:
sudo rpm --import aws-dms-team@amazon.com.public.gpg-key
-
Check that the import was successful by running the following command:
rpm -q --qf "%{NAME}-%{VERSION}-%{RELEASE} \n %{SUMMARY} \n" gpg-pubkey-ea22abf4-5a21d30c
-
Check the RPM signature by running the following command:
rpm --checksig -v aws-schema-conversion-tool-1.0.
build number
-1.x86_64.rpm
Verifying the AWS SCT DEB files on Ubuntu
AWS provides another level of validation in addition to the distribution file checksum. All DEB files in the distribution file are signed by a GPG detached signature.
To verify the AWS SCT DEB files on Ubuntu
-
Download the AWS SCT distribution file using the links in the Installing section.
-
Verifying the checksum of the AWS SCT distribution file.
-
Extract the contents of the distribution file. Locate the DEB file you want to verify.
-
Download the detached signature from aws-schema-conversion-tool-1.0.latest.deb.asc
. -
Download the GPG public key from amazon.com.public.gpg-key
. -
Import the GPG public key by running the following command:
gpg --import aws-dms-team@amazon.com.public.gpg-key
-
Verify the signature by running the following command:
gpg --verify aws-schema-conversion-tool-1.0.latest.deb.asc aws-schema-conversion-tool-1.0.
build number
.deb
Verifying the AWS SCT MSI file on Microsoft Windows
AWS provides another level of validation in addition to the distribution file checksum. The MSI file has a digital signature you can check to ensure it was signed by AWS.
To verify the AWS SCT MSI file on Windows
-
Download the AWS SCT distribution file using the links in the Installing section.
-
Verifying the checksum of the AWS SCT distribution file.
-
Extract the contents of the distribution file. Locate the MSI file you want to verify.
-
In Windows Explorer, right-click the MSI file and select Properties.
-
Choose the Digital Signatures tab.
-
Verify that the digital signature is from Amazon Services LLC.
Verifying the AWS SCT application on Mac OS
AWS provides another level of validation in addition to the distribution file checksum. Once you have installed the AWS SCT on the Mac OS, you can verify the application using the following procedure.
To verify the AWS SCT Application on Mac OS
-
Download the AWS SCT distribution file using the links in the Installing section.
-
Verifying the checksum of the AWS SCT distribution file.
-
Extract the contents of the distribution file.
-
Double-click the DMG file.
-
Install the AWS SCT.
-
Verify the application by running the following command:
codesign -dvvv /Applications/AWS\ Schema\ Conversion\ Tool.app/
Installing the required database drivers
For the AWS SCT 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.
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 |
|
Amazon Aurora (PostgreSQL compatible) |
postgresql-9.4-1204-jdbc42.jar |
|
Amazon Redshift |
RedshiftJDBC42-1.2.43.1067.jar |
https://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html |
Greenplum Database |
postgresql-9.4-1204-jdbc42.jar |
|
Maria DB |
mariadb-java-client-2.4.0.jar |
https://mariadb.com/downloads/#connectors |
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 |
|
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. |
|
Oracle |
ojdbc8.jar Driver versions 8 and later are supported. |
https://www.oracle.com/database/technologies/jdbc-ucp-122-downloads.html |
PostgreSQL |
postgresql-9.4-1204-jdbc42.jar |
|
SAP ASE (Sybase ASE) | jconn4.jar | Available as part of the SDK for SAP Adaptive Server Enterprise 16 provided with SAP
ASE product. You can download the trial version of the SDK at https://www.sap.com/developer/trials-downloads/additional-downloads/sdk-for-sap-adaptive-server-enterprise-16-13351.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. |
|
IBM DB2 LUW |
db2jcc-db2jcc4.jar |
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
-
Create a directory to store the JDBC drivers in.
PROMPT>sudo mkdir –p /usr/local/jdbc-drivers
-
Install the JDBC driver for your database engine using the commands shown following.
Database engine Installation commands Amazon Aurora (MySQL compatible)
PROMPT> cd /usr/local/jdbc-drivers PROMPT> sudo tar xzvf /tmp/mysql-connector-java-X.X.X.tar.gz
Amazon Aurora (PostgreSQL compatible)
PROMPT> cd /usr/local/jdbc-drivers PROMPT> sudo cp -a /tmp/postgresql-X.X.X.jre7.tar .
Microsoft SQL Server
PROMPT> cd /usr/local/jdbc-drivers PROMPT> sudo tar xzvf /tmp/sqljdbc_X.X.X_enu.tar.gz
MySQL
PROMPT> cd /usr/local/jdbc-drivers PROMPT> sudo tar xzvf /tmp/mysql-connector-java-X.X.X.tar.gz
Oracle
PROMPT> cd /usr/local/jdbc-drivers PROMPT> sudo mkdir oracle-jdbc PROMPT> cd oracle-jdbc PROMPT> sudo cp -a /tmp/ojdbc8.jar .
PostgreSQL
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
-
In the AWS SCT, choose Settings, and then choose Global Settings.
-
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.
-
When you are finished adding the driver paths, choose OK.
Updating the AWS SCT
AWS periodically updates the AWS SCT with new features and functionality. If you are updating from a previous version, create a new AWS SCT project and reconvert any database objects you are using.
You can check to see if updates exist for the AWS SCT.
To check for updates to AWS SCT
-
When in the AWS SCT, choose Help and then choose Check for Updates.
-
In the Check for Updates dialog box, choose What's New. If the link does not appear, you have the latest version.