Using SQL via JDBC
The SQL access layer for Elasticsearch is able to provide data access via the two most used Database Management System (DBMS) protocols, Java Database Connectivity (JDBC) and Open Database Connectivity (ODBC). These drivers can be installed in the client application to easily integrate Elasticsearch with the most popular tools, such as the following:
- DBeaver
- Microsoft Excel
- Microsoft Power BI
- Qlik Sense Desktop
- Tableau
Getting ready
You need an up-and-running Elasticsearch installation, as we described in the Downloading and installing Elasticsearch recipe in Chapter 1, Getting Started.
We will use the datasets that were populated in Chapter 4, Exploring Search Capabilities and Chapter 7, Aggregations. In this recipe, we will configure DBeaver (https://dbeaver.io/) with Elasticsearch; you need to download (https://dbeaver.io/download/) and install it.
A trial license must be active to use a SQL JDBC connection...