topic Re: Has anyone being able to connect to Databricks using ODBC? in Get Started Discussions

Has anyone being able to connect to Databricks using ODBC?

Vadimalk — Tue, 17 Sep 2024 01:08:06 GMT

I'm trying to connect to the Databricks cluster from the Excel using ODBC and following this official guide:
https://docs.databricks.com/en/integrations/excel.html#connect-from-microsoft-excel

But the authentication is always failing, returning "500 Internal server error" response.
My emails to Databricks support were not replied, so asking here: Has anyone had a success connecting to the Databricks workspace using ODBC?
If yes, what are the steps to get a successful authentication?

Re: Has anyone being able to connect to Databricks using ODBC?

szymon_dybczak — Tue, 17 Sep 2024 06:27:55 GMT

Hi @Vadimalk ,

Could you check if you have following options enabled in simba driver configuration:

Re: Has anyone being able to connect to Databricks using ODBC?

Vadimalk — Tue, 17 Sep 2024 06:35:34 GMT

Hi @szymon_dybczak ,
"Enable SSL" checkbox was enabled.
Ticking the "Use System Trust Store" didn't change the output.
(I would assume it just affects the ability to establish the SSL/TLS connection and should not have anything to do with the server response, which happens only after the connection is already established)

Re: Has anyone being able to connect to Databricks using ODBC?

szymon_dybczak — Tue, 17 Sep 2024 07:24:22 GMT

So I've installed this driver on my environment and follow guide and it works without any issue. I choose OAuth2 as an authentication option. Maybe you missed some step in configuration?

Edit: Don't be offended that I'm asking, but didn't you copy the http endpoint from the documentation in the section below? I've seen a lot of people who used the example address from the documentation instead of their endpoint.

Also, if you use OAuth2 authentication make sure that you didn't omit below step:

Re: Has anyone being able to connect to Databricks using ODBC?

Vadimalk — Wed, 18 Sep 2024 05:44:41 GMT

Thanks @szymon_dybczak,
- I have copied the http endpoint from my Cluster's ODBC/JDBC page. Although it looks significantly different from the yours HTTP endpoint:

- Auth_Flow = 2 parameter has been added as well.

It supposed to open the browser page asking for the username and the password (https://community.cloud.databricks.com/oidc/oauth2/v2.0/authorize), but that page it opens is always returns "500: Internal server error reply", regardless of parameters passed in or their absence.

Edit: Have you been following that guide to the point where it says:
"Click on OK button to connect. You will be prompted to authenticate yourself on a browser pop-up window."
What URL would it open for you?