ODBC Driver for elasticsearch

[muhammad_qassem]

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 .

for secuirty tab i choose first choice disable all communication un crypted

and the error was empty reply from server

[Sander_Philipse]

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?

[leandrojmp (Leandro Pereira)]

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

[muhammad_qassem]

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.

[muhammad_qassem]

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.

[muhammad_qassem]

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

[dadoonet (David Pilato)]

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

[muhammad_qassem]

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

[dadoonet (David Pilato)]

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