cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Get Started Discussions
Start your journey with Databricks by joining discussions on getting started guides, tutorials, and introductory topics. Connect with beginners and experts alike to kickstart your Databricks experience.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Has anyone being able to connect to Databricks using ODBC?

Vadimalk
New Contributor II

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?

4 REPLIES 4

szymon_dybczak
Contributor III

Hi @Vadimalk ,

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

szymon_dybczak_0-1726554451847.png

 

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)

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?

szymon_dybczak_0-1726557252714.pngszymon_dybczak_1-1726557262509.png

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.

szymon_dybczak_0-1726557731835.png

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

szymon_dybczak_1-1726557843692.png

 

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:

Vadimalk_0-1726636044074.png

- 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?

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group