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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 2063 views
  • 0 likes
  • 2 in conversation