# ODBC Driver for elasticsearch

**URL:** <https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783>\
**Category:** Elasticsearch\
**Tags:** jdbc\
**Created:** [January 25, 2024, 10:17am UTC](https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783 "2024-01-25T10:17:54Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![muhammad\_qassem](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/muhammad_qassem/32/127942_2.png) [@muhammad\_qassem](https://discuss.elastic.co/u/muhammad_qassem)\
**Post date:** [January 25, 2024, 10:17am UTC](https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783/1 "2024-01-25T10:17:55Z")

</div>

Hi, I am trying to configure the elastic odbc driver for Elasticsearch to then get data to power bi but when i test the connection for that it gives me error i dont know this error is related to what certificate or authorization error ?? could help me please with all appreciate .

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/5/85c2bfc381486d871e9d737df07b33c723309167.png)  
for secuirty tab i choose first choice disable all communication un crypted

and the error was empty reply from server

---

<div class="post-metadata">

**Author:** ![Sander\_Philipse](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sander_philipse/32/101890_2.png) [@Sander\_Philipse](https://discuss.elastic.co/u/Sander_Philipse)\
**Post date:** [January 25, 2024, 2:29pm UTC](https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783/2 "2024-01-25T14:29:46Z")

</div>

Hi @muhammad_qassem,

It's hard to diagnose what's going on based on the information you've given, any number of things could be preventing you from reaching Elasticsearch. What is the error you're receiving? Is your Elasticsearch cluster reachable through curl or other direct network requests? How are you running Elasticsearch?

---

<div class="post-metadata">

**Author:** ![leandrojmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leandrojmp/32/107231_2.png) [@leandrojmp](https://discuss.elastic.co/u/leandrojmp)\
**Post date:** [January 25, 2024, 5:26pm UTC](https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783/3 "2024-01-25T17:26:33Z")

</div>

Do you have an enterprise license? The ODBC Driver requires a paid Enterprise License.

---

<div class="post-metadata">

**Author:** ![muhammad\_qassem](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/muhammad_qassem/32/127942_2.png) [@muhammad\_qassem](https://discuss.elastic.co/u/muhammad_qassem)\
**Post date:** [January 28, 2024, 11:31am UTC](https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783/4 "2024-01-28T11:31:48Z")

</div>

![ODBC#4](https://us1.discourse-cdn.com/elastic/original/3X/8/5/857ffff7244aeda4243f1b2f48328fa70c300d8d.png)  
this is the error while i chose second choice of the secuirty tab ,, i installed elastic on windows 10 and actually i don't know odbc driver for elatic requires a licencse .. I just try to connect to it to get data to power bi as this is my task .

Thanks.

---

<div class="post-metadata">

**Author:** ![muhammad\_qassem](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/muhammad_qassem/32/127942_2.png) [@muhammad\_qassem](https://discuss.elastic.co/u/muhammad_qassem)\
**Post date:** [January 28, 2024, 11:42am UTC](https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783/5 "2024-01-28T11:42:41Z")

</div>

actually to add , this is just in my virtual machine i just downloaded elastic and run it then downloaded elastic driver for odbc of the same version and configured it so.

---

<div class="post-metadata">

**Author:** ![muhammad\_qassem](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/muhammad_qassem/32/127942_2.png) [@muhammad\_qassem](https://discuss.elastic.co/u/muhammad_qassem)\
**Post date:** [January 28, 2024, 11:46am UTC](https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783/6 "2024-01-28T11:46:52Z")

</div>

sorry for confusing, i found that it need a subscription so does there any other wat to get data in power bi ??

---

<div class="post-metadata">

**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:** [January 28, 2024, 11:47am UTC](https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783/7 "2024-01-28T11:47:31Z")

</div>

Yes you need a commercial licence for this feature.  
You can activate the trial for 30 days from Kibana.

---

<div class="post-metadata">

**Author:** ![muhammad\_qassem](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/muhammad_qassem/32/127942_2.png) [@muhammad\_qassem](https://discuss.elastic.co/u/muhammad_qassem)\
**Post date:** [January 29, 2024, 6:07am UTC](https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783/8 "2024-01-29T06:07:52Z")

</div>

does using Elastic Rest API as a data source for my power bi need a licencse also ??

---

<div class="post-metadata">

**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:** [January 29, 2024, 8:11am UTC](https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783/9 "2024-01-29T08:11:57Z")

</div>

You can use the REST API with the basic default license.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 26, 2024, 8:12am UTC](https://discuss.elastic.co/t/odbc-driver-for-elasticsearch/351783/10 "2024-02-26T08:12:20Z")

</div>

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