imran Ahmed 2 Posted November 1, 2023 Share Posted November 1, 2023 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) Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted February 28 Share Posted February 28 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 Link to comment Share on other sites More sharing options...
Gerco ten Kate Posted August 8 Share Posted August 8 (edited) 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now