Setting up ODBC connection to ES (v6.6)

Elastic Stack Elasticsearch
1

Hi,
I am trying to setup up ODBC connection from Windows 10 64bit, but during DSN configuration I am getting the error:

[Elastic][EsODBC 6.6.1(de8a0e2+,u,r) Driver]invalid_index_name_exception: Invalid index name [_xpack], must not start with '_', '-', or '+'"

I was trying to get any information on the forums and web, but no luck getting anything helpful.

ElasticSearch Version: 6.6.1
Elastic ODBC driver version: 6.06.01.00

(It looks like the _xpack, that is packed into ES 6.6 by default, causes that exception obviously...)

Anybody would help to point in which direction should I look to get it working?

Thanks

2

Did you install the default distribution of Elasticsearch?

3

Thanks, Christian, that was the right direction :smiley:

I have used the homebrew for installation, but by default, it installs OSS version, not the BASIC one. And this makes the difference, although it's not visible at Subscriptions nor mentioned in ODBC prerequisites. . After installing the BASIC version, it works as supposed.

4

Thanks for pointing this out. We'll correct it.