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
... View more