How to connect to AWS Elasticsearch JDBC Connection

[intapiuser]

Question: How can I connect to AWS ElasticSearch?

Solution: 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.