DbVisualizer
editDbVisualizer
editThis functionality is in beta and is subject to change. The design and code is less mature than official GA features and is being provided as-is with no warranties. Beta features are not subject to the support SLA of official GA features.
You can use the Elasticsearch JDBC driver to access Elasticsearch data from DbVisualizer.
Prerequisites
edit- DbVisualizer
- Elasticsearch SQL JDBC driver
Add Elasticsearch JDBC driver
editAdd the Elasticsearch JDBC driver to DbVisualizer through Tools > 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:
Create a new connection
editOnce the Elasticsearch driver is in place, create a new connection:
One can use the wizard or add the settings all at once:
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: