Preparing the Amazon Athena Environment

The following components are needed to use the adapter for Amazon Athena:

ODBC Driver:

• Download and install the Amazon Athena ODBC driver.
• Perform the configuration steps according to the Amazon/Simba instructions for your operating system.
• Obtain the AWS Region, S3 Output Location, Encryption Option, AWS access key, and AWS secret key from your Amazon Athena Administrator.

JDBC Driver:

• Download and install the Amazon Athena JDBC driver.
• Obtain the path to the JDBC driver jar files that you will use. For example, using JDBC 4.1 that is Java 8 compatible on Linux requires:

   /qas/authena/AthenaJDBC41-1.0.1.jar   

  This full path to the Athena driver .jar files value will be added to IBI_CLASSPATH during configuration.

• Obtain the connection URL, S3 staging directory, AWS access key and AWS secret key from your Amazon Athena Administrator.