Connecting to Databricks from Workato. JDBCDriver 500593 Communication Link failure

[RossMacrae777]

I'm trying to connect to Databricks from Workato, to pull data in as part of a Workato Recipe.  I'm getting the following error when I test the connection:

"Database bridge error: Failed since could not connect to the database - Failed to initialize pool: [Databricks][JDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 403, Error message: Unknown."

As an independent connection test, I tried connecting to the same Databricks workspace from PowerBI, with all of the same credentials, and was able to connect and retrieve data successfully.

Has anyone successfully connected to Databricks from Workato before, and if so, did you need to do any additional config to get it working?  Is it possible there's a restriction applied to an iPaaS platform such as Workato that would need to be lifted?

Thanks!

[RossMacrae777]

This turned out to be location-related.  It looks as though the location of the Workato instance, along with the particular way that our application is integrated with Workato, combine to cause the connection to fail.  When I switch to a US host, from my Australia host, it connects successfully.  Still getting to the bottom of it, but happy to report that there's no on-going issue, Workato and Databricks can connect just fine.  

[nicolai_nqbt]

I have a similar issue but both my workato and databricks platforms run on europe locations. Did you figure out the root cause or how did you fix it?

[WiliamRosa]

To connect Workato to Databricks, the recommended approach is to use Workato’s built-in Databricks connector, where you define the server hostname, HTTP path, authentication type (username/password or personal access token), and optionally specify catalog and schema settings directly in the connection UI. If you prefer using the JDBC connector, you’ll need to configure Workato’s on-prem agent, supply the correct JDBC URL, driver class, credentials, and any advanced properties required by Databricks. Alternatively, a third-party layer like CData Connect Cloud can act as a SQL interface between Workato and Databricks—allowing Workato to connect via its SQL Server connector and delegate data fetching to Databricks seamlessly.

[nicolai_nqbt]

Hi WiliamRosa

I am in fact trying to connect via the recommended method of using the built-in databricks connector. When I provide all the relevant details for the configuration I get the error mentioned in the original post. I don't understand why i get a 403 error. I have also tried to query data directly from the sql warehouse through the databricks web ui and that works without issues.