-->

DbVisualizer

 

DbVisualizer is a database management and analysis tool for all major databases.

 
 -- http://www.dbvis.com/
Important

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

Prerequisites

Add Elasticsearch JDBC driver

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

images/sql/client-apps/dbvis-1-driver-manager.png

Create a new driver entry through Driver > Create Driver entry and add the JDBC driver in the files panel through the buttons on the right. Once specify, 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:

images/sql/client-apps/dbvis-2-driver.png

Create a new connection

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

images/sql/client-apps/dbvis-3-new-conn.png

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

images/sql/client-apps/dbvis-4-conn-props.png

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

Execute SQL queries

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

images/sql/client-apps/dbvis-5-data.png