I'm writing this post to hopefully make someone's day a little easier, probably someone else will be struggling with "How to connect Sisense to AWS ElasticSearch".
Recently I stumbled upon a task to connect AWS ElasticSearch to our Sisense, this turned out to be not that easy. Somehow I managed to make it through and there's a couple of things which are documented nowhere.
So first of all, JDBC connector. 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.16418.104.22.168
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.
Here are all the tips I wanted to share, hope it will help somebody.
Please sign in to leave a comment.