Elasticsearch SQL ODBC Driver with MicroStrategy

(Shrikant) #1

Hi All,

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.

(David Pilato) #2

What are the logs?
Do you have a trial or platinum license?

(Shrikant) #3

Hello @dadoonet,

Thank you for the response
No,
I am not having any kind of license for elastic.

  1. Do we need any kind of license for the connectors?

Regards

(David Pilato) #4

Yeah. See Subscriptions about the different features available.

The default distribution of Elasticsearch includes all of X-Pack, but the default license is "basic".

You can activate a free trial of the commercial features via Kibana (Management -> License) or via the API.

(Elastic-for-me) #5

I did once created connecting to microstratage and pull data from elk.
here is what I had to do.

in elasticsearch.yml

for MicroStrategy

http.cors.enabled: true
http.cors.allow-origin: "*"
http.cors.allow-headers: "X-Requested-With, Content-Type, Content-Length, Authorization"
http.cors.allow-methods: "OPTIONS, HEAD, GET, POST, PUT"
http.cors.allow-credentials: true

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)

(Shrikant) #6

Hello @elasticforme thanks for the response

  1. May I know where to enter the link (https://:3000/elasticsearch-connector.html in some connector access point (don't know what it was))

Can you please guide me.

Regards

(Elastic-for-me) #7

after I finish my part on elastic side I have to contact microstratage guy. who did that for me. I do not know where.
follow this link

https://community.microstrategy.com/s/article/ElasticSearch?language=en_US

https://community.microstrategy.com/s/article/Connecting-to-ElasticSearch-with-MicroStrategy?language=en_US