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.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 2209 views
  • 0 likes
  • 2 in conversation