SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

getting error while testing AWS Athena odbc connection in Linux machine

Reply
Occasional Contributor
Posts: 5

getting error while testing AWS Athena odbc connection in Linux machine

[ Edited ]

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

Super User
Posts: 3,856

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

Posted in reply to srinivask

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

Ask a Question
Discussion stats
  • 1 reply
  • 296 views
  • 0 likes
  • 2 in conversation