How to connect to AWS Elasticsearch JDBC Connection

[Community_Admin]

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&region=eu-west-1&User=AWS_ACCESS_KEY&Password=AWS_SECRE..."

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.