Databricks DB is not working with Helical Insight

Database Support
, , , , ,
#1

Hello,

We are using open source BI Helical Insight version 6.1.0.852 GA (Docker version). We are not able to connect and use Databricks with the default Helical Insight configuration. Do we need to configure any additional configuration?

Thanks,
Netta.

#2

Hello Netta,

To connect Databricks with Helical Insight, please ensure the following configurations are applied:

  1. Update JDBC Driver:

Remove the existing databricks driver

Example : /opt/Helical610_852GA/hi/hi-repository/System/Drivers

and update new driver, click here to download

  1. Update Docker Configuration (YML):

Add the following in docker-compose.yml under CATALINA_OPTS:

CATALINA_OPTS=-Djdk.internal.httpclient.disableHostnameVerification=true

–add-opens=java.base/java.nio=ALL-UNNAMED

–add-opens=java.base/java.lang=ALL-UNNAMED

After applying these changes, restart the Helical Insight Docker container and try reconnecting to Databricks

Thanks,
Helical Insight.