Using dplyr to connect to a remote database with SSL encryption

Question

I would like to use the package dplyrin R, but to connect to a remote SSL encrypted database. How to set up a workaround here? I am going to create a backend that uses the RODBC package. Is it possible?

Answer 1

In fact, you can connect to an SSL-encrypted connection with dplyr, and it is easy.

You just need to pass the parameters for your connection in a parameter dbnamelike this (this is a postgresql example):

db <- src_postgres(dbname="dbname=my_db sslcert=my_cert.crt sslkey=my_key.key sslmode=require", user="username", host="your.host.com")