IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
Elasticsearch Guide [7.7] » SQL access » SQL Client Applications » DbVisualizer
« DBeaver Microsoft Excel »

DbVisualizeredit

You can use the Elasticsearch JDBC driver to access Elasticsearch data from DbVisualizer.

Elastic does not endorse, promote or provide support for this application; for native Elasticsearch integration in this product, please reach out to its vendor.

Prerequisitesedit

Add Elasticsearch JDBC driveredit

Add the Elasticsearch JDBC driver to DbVisualizer through Tools > Driver Manager:

dbvis 1 driver manager

Select Elasticsearch driver name from the left sidebar and add the JDBC driver in the files panel through the buttons on the right; if there is no such driver name check the DbVisualizer version or create a new driver entry through Driver > Create Driver.

dbvis 2 driver

Once specified, the driver class and its version should be automatically picked up - one can force the refresh through the Find driver in listed locations button, the second from the bottom on the right hand side:

dbvis 3 add driver

Create a new connectionedit

Once the Elasticsearch driver is in place, create a new connection:

dbvis 4 new conn

One can use the wizard or add the settings all at once:

dbvis 5 conn props

Press Connect and the driver version (as that of the cluster) should show up under Connection Message.

Execute SQL queriesedit

The setup is done. DbVisualizer can be used to run queries against Elasticsearch and explore its content:

dbvis 6 data

« DBeaver Microsoft Excel »