With RC1 (GIT 611) onwards of helical insight version 5.0 enterprise version we are supporting Elasticsearch by default. In this blog we are covering how to make the connection string as well as in case if you are using an older version of helical insight how can you make it work.
- Download the Elastic_Search.zip and extract
- Copy elasticsearchsql.xml and elasticsearchsql.js file into below server path
"....\hi\hi-repository\System\Admin\SqlFunctions"
- Open sqlDialects.properties file and copy line :
# elasticsearch elasticsearch.xpack.sql.jdbc.EsDriver=org.hibernate.dialect.PostgreSQLDialect
add this line into your sqlDialects.properties located at
"....\hi\hi-repository\System\Admin"
- Open sqlFunctionsXmlMapping.properties file and copy line :
#elasticsearch elasticsearch.xpack.sql.jdbc.EsDriver=elasticsearchsql
add this line into your sqlFunctionsXmlMapping.properties located at
"....\hi\hi-repository\System\Admin"
- Copy x-pack-sql-jdbc-7.9.1.jar file and into below server path
"....\hi\hi-repository\System\Drivers"
- Restart Helical Insight application server.
NOTE : Above dialect configuration and JDBC driver by default come in Helical V5.0 RC2 onwards , you need to configure if you are using older version of Helical Insight
Sample connection String for Elastic search database :
jdbc:elasticsearch://<HOSTNAME>:9243/