ODBC Resource R

The odbc.resourcer package is for accessing databases implementing the ODBC API.

For a MS SQL server database, the resource object would be:

library(odbc.resourcer)
res <- resourcer::newResource(url = "odbc+mssql://localhost:1433/database/CNSIM3", identity = "administrator", secret = "password1234")
client <- resourcer::newResourceClient(res)
client$asDataFrame()

The package is built on top of the odbc package and the DBI package.