cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
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.
 
Version history
Last update:
‎03-02-2023 08:42 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy