Elasticsearch SQL ODBC Driver with MicroStrategy

Elastic Stack Elasticsearch
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.

2

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

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

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.

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)

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

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

8

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

9

@shrikantgulia, yes, you can have MicroStrategy Desktop pull data out of Elasticsearch through the ODBC driver. The steps you'd need to follow are documented here:
https://www.elastic.co/guide/en/elasticsearch/reference/master/sql-client-apps-microstrat.html

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.