OHDSI Home | Forums | Wiki | Github

Can not connect Databricks using ODBC driver

Developers
#1

Hi team,
Since JDBC driver does not work for Databricks, I am testing connection using ODBC. Below is an error message, as well as ConnectionDetails setting. Need help to set the ODBC connection parameters. Thanks!

Error: nanodbc/nanodbc.cpp:1118: HY000: [Simba][DriverSupport] (1110) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct and confirm if SSL should be enabled for the connection.

connectionDetails ← createConnectionDetails(
dbms = “spark”
server = “adb-xxxx.azuredatabricks.net”,
user = “token”,
port = 443,
password = “xxxx”,
extraSettings = list(HTTPPath = “sql/protocolv1/oxxxx”)

)

#2

I’ve managed to connect using

connectionDetailsDataBricksOdbc <- createConnectionDetails(
  dbms = "spark",
  server = keyring::key_get("dataBricksServer"),
  port = keyring::key_get("dataBricksPort"),
  user = keyring::key_get("dataBricksUser"),
  password = keyring::key_get("dataBricksPassword"),
  extraSettings = list(
    HTTPPath = keyring::key_get("dataBricksHttpPath"),
    SSL = 1,
    ThriftTransport = 2,
    AuthMech = 3
    )
)

You probably should also install the develop version of DatabaseConnector (from the develop branch). I’ve made some more progress there on DataBricks recently (although still not mature yet. I’m currently having issues with my testing environment).

#3

Thanks. I will test it.

t