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