How to connect to AWS Elasticsearch JDBC Connection
Question
How can I connect to AWS ElasticSearch?
Answer
If you're running ElasticSearch on AWS you would need another connector, not the one from CData (which is suggested somewhere else on this forum). You would need this one - https://github.com/opendistro-for-elasticsearch/sql-jdbc
Unzip it anywhere, I used the same folder as for the default JDBC driver - C:\ProgramData\Sisense\DataConnectors\GenericJDBC\Sisense.GenericJDBC.JVM.1.0.16423.127.0.0
Next, as a Driver's Class name use "com.amazon.opendistroforelasticsearch.jdbc.Driver"
Your Connection String should look like "jdbc:elasticsearch://https://elastic_endpoint.com/?auth=aws_sigv4®ion=eu-west-1&User=AWS_ACCESS_KEY&Password=AWS_SECRET_KEY"
where https://elastic_endpoint.com/ is the endpoint you get from the AWS Console and AWS_ACCESS&SECRET keys are obtained with IAM, these are not your Cognito credentials, rather than the IAM User.
Next, as a Driver's Class name use "com.amazon.opendistroforelasticsearch.jdbc.Driver"
Your Connection String should look like "jdbc:elasticsearch://https://elastic_endpoint.com/?auth=aws_sigv4®ion=eu-west-1&User=AWS_ACCESS_KEY&Password=AWS_SECRET_KEY"
where https://elastic_endpoint.com/ is the endpoint you get from the AWS Console and AWS_ACCESS&SECRET keys are obtained with IAM, these are not your Cognito credentials, rather than the IAM User.
Published 10-17-2021
