Query elasticsearch from excel


I ma trying to use the JDBC [GitHub - amazon-archives/sql-jdbc: πŸ” Open Distro for Elasticsearch JDBC Driver] in order to set a connection between excel and elasticsearch so that I can for example retrieve an index content from excel as it can be done with MySQL using an ODBC to get a table content.

Is this possible? If yes, how can this be done?

Thanks in advance for your help.

Hi, thank you for the question. I’m not sure if we currently support this, but I am currently looking into it and will let you know what my findings are.

Hi @snamous, there are multiple JDBC drivers available for excel that can be used to establish a connection between excel & elasticsearch.

I recommend doing a google search for one of these tools, as I don’t believe we currently support this.

1 Like