# Elasticsearch SQL ODBC Driver with MicroStrategy **URL:** \ **Category:** Elasticsearch\ **Created:** [May 15, 2019, 9:28am UTC](https://discuss.elastic.co/t/elasticsearch-sql-odbc-driver-with-microstrategy/181139 "2019-05-15T09:28:04Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![shrikantgulia](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Post date:** [May 15, 2019, 9:28am UTC](https://discuss.elastic.co/t/elasticsearch-sql-odbc-driver-with-microstrategy/181139/1 "2019-05-15T09:28:04Z")
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. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [May 15, 2019, 10:12am UTC](https://discuss.elastic.co/t/elasticsearch-sql-odbc-driver-with-microstrategy/181139/2 "2019-05-15T10:12:20Z")
What are the logs? Do you have a trial or platinum license? ---
**Author:** ![shrikantgulia](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Post date:** [May 15, 2019, 12:34pm UTC](https://discuss.elastic.co/t/elasticsearch-sql-odbc-driver-with-microstrategy/181139/3 "2019-05-15T12:34:14Z")
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 ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [May 15, 2019, 5:12pm UTC](https://discuss.elastic.co/t/elasticsearch-sql-odbc-driver-with-microstrategy/181139/4 "2019-05-15T17:12:54Z")
Yeah. See [Subscriptions](https://www.elastic.co/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](https://www.elastic.co/guide/en/elastic-stack-overview/6.7/license-management.html). ---
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [May 15, 2019, 6:17pm UTC](https://discuss.elastic.co/t/elasticsearch-sql-odbc-driver-with-microstrategy/181139/5 "2019-05-15T18:17:11Z")
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](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) ---
**Author:** ![shrikantgulia](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Post date:** [May 17, 2019, 5:09am UTC](https://discuss.elastic.co/t/elasticsearch-sql-odbc-driver-with-microstrategy/181139/6 "2019-05-17T05:09:15Z")
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 ---
**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\ **Post date:** [May 17, 2019, 1:08pm UTC](https://discuss.elastic.co/t/elasticsearch-sql-odbc-driver-with-microstrategy/181139/7 "2019-05-17T13:08:18Z")
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/ElasticSearch?language=en_US) [https://community.microstrategy.com/s/article/Connecting-to-ElasticSearch-with-MicroStrategy?language=en\_US](https://community.microstrategy.com/s/article/Connecting-to-ElasticSearch-with-MicroStrategy?language=en_US) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 14, 2019, 1:08pm UTC](https://discuss.elastic.co/t/elasticsearch-sql-odbc-driver-with-microstrategy/181139/8 "2019-06-14T13:08:22Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed. ---
**Author:** ![bogdan.pintea](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bogdan.pintea/32/45740_2.png) [@bogdan.pintea](https://discuss.elastic.co/u/bogdan.pintea)\ **Post date:** [June 21, 2019, 4:16pm UTC](https://discuss.elastic.co/t/elasticsearch-sql-odbc-driver-with-microstrategy/181139/9 "2019-06-21T16:16:52Z")
@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](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.