getting error while testing AWS Athena odbc connection in Linux machine

srinivask — Wed, 28 Mar 2018 11:18:12 GMT

we have a requirement " connect from SAS to Athena "

followed below steps

1. installed AWS Athena ODBC drivers

2. updated the odbc.ini , odbcinst.ini and simba.athenaodbc.ini

odbc.ini :

[AthenaAWS]
Driver=/opt/simba/athenaodbc/lib/64/libathenaodbc_sb64.so
AuthenticationType=Default Credentials
AwsRegion=us-east-1
S3OutputLocation=s3://aws-athena-tableau-results/
ProxyHost=Using proxy ip address
ProxyPort=80

odbcinst.ini:

[Simba Athena ODBC Driver 64-bit]
Description=Simba Athena ODBC Driver (64-bit)
Driver=/opt/simba/athenaodbc/lib/64/libathenaodbc_sb64.so

simba.athenaodbc.ini

[Driver]
## - Note that this default DriverManagerEncoding of UTF-32 is for iODBC.
ErrorMessagesPath=/opt/simba/athenaodbc/ErrorMessages
LogLevel=5
LogFileSize=100MB
LogPath=/tmp/athena.log
SwapFilePath=/tmp
# unixODBC
ODBCInstLib=/usr/lib64/libodbcinst.so

While Testing below error getting :

$isql -v AthenaAWS dummy dummy
[S1000][unixODBC][Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Athena Error No: 99, HTTP Response Code: 10562392, Error Message: Unable to connect to endpoint
[ISQL]ERROR: Could not SQLConnect

environment :

RHEL 6.7

JAVA Version :

$java -version
java version "1.7.0_79"
OpenJDK Runtime Environment (rhel-2.5.5.4.el6-x86_64 u79-b14)
OpenJDK 64-Bit Server VM (build 24.79-b02, mixed mode)

Please let us know the solution if anyone faced this issue earlier. And let me know if need more information on this.

Thanks in Advance

Re: getting error while testing AWS Athena odbc connection in Linux machine

SASKiwi — Fri, 30 Mar 2018 22:27:45 GMT

Since your testing to date doesn't yet involve SAS you might be better off posting this on an Athena-related forum.

topic getting error while testing AWS Athena odbc connection in Linux machine in SAS Data Management

getting error while testing AWS Athena odbc connection in Linux machine

Re: getting error while testing AWS Athena odbc connection in Linux machine