SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. | ||
| -- https://www.sql-workbench.eu/ | ||
Elastic does not endorse, promote or provide support for this application; for native Elasticsearch integration in this product, please reach out to its vendor.
- Elasticsearch SQL JDBC driver
Add the Elasticsearch JDBC driver to SQL Workbench/J through Manage Drivers either from the main windows in the File menu or from the Connect window:
Add a new entry to the list through the blank page button in the upper left corner. Add the JDBC jar, provide a name and click on the magnifier button to have the driver Classname picked-up automatically:
With the driver configured, create a new connection profile through File > Connect Window (or Alt+C shortcut):
Select the previously configured driver and set the URL of your cluster using the JDBC syntax. Verify the connection through the Test button - a confirmation window should appear that everything is properly configured.
The setup is complete.
