Skip to main content

How to connect with SSL enabled DB when cluster manager type is Databricks ?

  • December 22, 2021
  • 0 replies
  • 142 views

AkshayJadhav
StreamSets Employee
Forum|alt.badge.img

Product: StreamSets Transformer 

Cluster Manager Type: DataBrick 

JDBC_00 - Cannot connect to specified database: Error setting up SSL: truststore.jks (No such file or directory) 
: conf.connectionConfig.jdbcUrl

Goal:

How to pass the truststore file to connect with SSL enabled Database.

Solution:

These truststore files need to be present in advance to our databrick cluster because spark executor will reference to this path.

- Upload this truststore file to DBFS

- Then specify  as additional jdbc parameterSSLKeyStorePath and absolute dbfs path for this file.

SSLKeyStorePath = /dbfs/<Dir>/trustore.jks 

Did this topic help you find an answer to your question?
This topic has been closed for comments