DbVisualizer
editDbVisualizer
editYou can use the Elasticsearch JDBC driver to access Elasticsearch data from DbVisualizer.
Elastic does not endorse, promote or provide support for this application.
Prerequisites
edit- DbVisualizer 13.0 or higher
-
Elasticsearch SQL JDBC driver
- Note
- Pre 13.0 versions of DbVisualizer can still connect to Elasticsearch by having the JDBC driver set up from the generic Custom template.
Setup the Elasticsearch JDBC driver
editSetup the Elasticsearch JDBC driver through Tools > Driver Manager:
Select Elasticsearch driver template from the left sidebar to create a new user driver:
Download the driver locally:
and check its availability status:
Create a new connection
editOnce the Elasticsearch driver is in place, create a new connection:
by double-clicking the Elasticsearch entry in the list of available drivers:
Enter the connection details, then press Connect and the driver version (as that of the cluster) should show up under Connection Message.
Execute SQL queries
editThe setup is done. DbVisualizer can be used to run queries against Elasticsearch and explore its content: