Hello, I'm working on to configure Azure databricks custom connector in Spotfire v12.0 LTS. I've deployed sdn (v12.0.17.0). I'm able to make a connection successfully in Spotfire analyst, but the same report is not working in spotfire web client.

[imran Ahmed 2]

Here is the error details:

Could not connect due to an unknown error.

External error:

ERROR [HY000] [TIBCO][ThriftExtension] (5) Error occurred while contacting server: invalid sasl status. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.

ERROR [HY000] [TIBCO][ThriftExtension] (5) Error occurred while contacting server: invalid sasl status. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.

Data connection:

Azure Databricks (Custom)

[David Boot-Olazabal]

Hi Imran,

Not sure if you still have the issue, but I came across the same problem.

We ended up using the native ODBC driver from Databricks, which worked perfectly fine in both Spotfire Analyst and Spotfire web clients. The only thing you need to be aware of, is the way you 'target' the tables, as Databricks can have different catalogs. To be on the safe side, we put in every 'layer' in our Select statement:
Select * from <catalog>.<database>.<tablename>.

Kind regards,

David

[Gerco ten Kate]

I see you are trying to use a standard connection vs a SSL enabled endpoint. which means you must specify the SSL port, usually 443.
When you need to establish SSL connection and you get error
[Simba][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed

Go into the installation directory for your Simba ODBC connector and in a bin folder you find a cacerts.pem file.

You must add the certificates here in the pem format. (especially root CA etc to be able to verify the certificate that is presented when connecting)

 

Edited August 8 by Gerco ten Kate
error string