IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
« DBeaver SQquirelL SQL »
Elastic Docs ›Elasticsearch Guide [6.5] ›SQL Access ›SQL Client Applications

DbVisualizer

edit

DbVisualizer

edit

This functionality is in technical preview and may be changed or removed in a future release. Elastic will work to fix any issues, but features in technical preview are not subject to the support SLA of official GA features.

DbVisualizer is a database management and analysis tool for all major databases.
-- http://www.dbvis.com/

Prerequisites

edit

Add Elasticsearch JDBC driver

edit

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

dbvis 1 driver manager

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 liste locations button, the second from the bottom on the right hand side:

dbvis 2 driver

Create a new connection

edit

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

dbvis 3 new conn

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

dbvis 4 conn props

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

Execute SQL queries

edit

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

dbvis 5 data

« DBeaver SQquirelL SQL »