cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
Community Team Member
Community Team Member

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. 
Rate this article:
Version history
Last update:
‎10-17-2021 05:26 AM
Updated by:
Contributors