BookmarkSubscribeRSS Feed
srinivask
Calcite | Level 5

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

1 REPLY 1
SASKiwi
PROC Star

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

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 2415 views
  • 0 likes
  • 2 in conversation