I am trying to use Elasticsearch SQL ODBC Driver to push data from Elasticsearch to MicroStrategy on Windows 10. I've created a system DSN in Windows and a Database Instance in MicroStrategy Developer Tool for this purpose. But the connection keeps failing.
Has anyone successfully connected Elasticsearch and MicroStrategy? I am open to other approaches to achieve the same.
Then on microstratage
ElasticSearch URl - http://address:9200
User basic authentication - I didn't use anything because I had no security
index name -
type - type "doc" here otherwise it didn't work
leave everything else empty.
play around with this part
also Microstratage guy have to enter
https://:3000/elasticsearch-connector.html in some connector access point (don't know what it was)
You'd indeed need to have SQL enabled on the Elasticsearch cluster and the proper licensing in place (or the trial mode active). If these points are addressed and you still encounter difficulties, please post the errors you encounter.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.