Dremio <-> R connection without encryption

1

Hello,

currently I am using this example code to try out a connection between Dremio an R. Since my Dremio is a small example/test instance I don’t habe SSL/TLS enabled. Which should be according to the documentation not a big issue, since i can just add the useEncryption=false parameter.
But I can’t figure out how to do so:

install.packages("RODBC")
library(RODBC)
dremio_host <- "localhost"
dremio_port <- "31010"
dremio_uid <- "your dremio user"
dremio_pwd <- "your dremio password"
channel <- odbcDriverConnect(sprintf("DRIVER=Dremio Connector;HOST=%s;PORT=%s;UID=%s;PWD=%s;AUTHENTICATIONTYPE=Basic Authentication;CONNECTIONTYPE=Direct;USEENCRYPTION=false", dremio_host, dremio_port, dremio_uid, dremio_pwd))

and a lot of other variants I tried do not work.

Do you have any idea how I can connect form R to Dremio without encryption?

2

I got it working:
My problem was that the name of the driver is wrong. the fully working connection string has to look like this:

"DRIVER=Arrow Flight SQL ODBC Driver;HOST=%s;PORT=%s;UID=%s;PWD=%s;AUTHENTICATIONTYPE=Basic Authentication;CONNECTIONTYPE=Direct;USEENCRYPTION=false"
3

Thanks for letting us know you got things working. I suspect that page you linked with example code probably pre-dated the arrow flight sql odbc driver.