Theodbc.resourcer package is for accessing databasesimplementing the ODBC API.
For aMSSQL server database, the resource object would be:
library(odbc.resourcer)# Create a resourceres<- resourcer::newResource(url ="odbc+mssql://localhost:1433/EpidemiologyDB/PatientData",identity ="sa",secret ="YourStrong@Password123")# Create a resource clientclient<- resourcer::newResourceClient(res)# Coerce resource to a data framedf<- client$asDataFrame()# Disconnect the clientclient$close()The package is built on top of theodbc package and theDBI package.