In this blog, we will show you how to connect to open source analytics engine, ElasticSearch to Open Source BI product Helical Insight.
Follow the below given steps in order to connect Helical Insight to ElasticSearch:
Step 1: Download this zip file and extract the contents.
Step 2: Go to DataSources page and click on “Add Driver” button.
Step 3: Upload the file named “x-pack-sql-jdbc-7.9.1.jar” from the downloaded folder. The JDBC driver for ElasticSearch has been added.
Step 4: Add files “elasticsearchsql.xml” and “elasticsearchsql.js” from the downloaded folder at the location ../hi/hi-repository/System/Admin/SqlFunctions
Step 5: Replace the files “sqlDialects.properties” and “sqlFunctionsXmlMapping.properties” present at the location …hi/hi-repository/System/Admin with the files present in the downloaded folder.
Step 6: Restart Helical Insight service.
Step 7: After restart, go to “DataSources” page and provide connection details for ElasticSearch. Test Connection and Save the datasource.
Helical Insight is now connected to ElasticSearch and metadata and reports can be created using the connection established.