Using RStudio Professional Drivers

From an R prompt, install the odbc package:

R Console

> install.packages("odbc")

Test your connection in R with odbc::odbc(). If you are using the RStudio IDE, you can use the New Connection dialog to help you write the connection string, for example:

R Console

> con <- DBI::dbConnect(odbc::odbc(),
         Driver = "Driver Name",
         Database = "Database",
         UID = "User",
         PWD = "Password",
         Server = "Server",
         Port = 5432)

Visit db.rstudio.com for best practices, examples, and additional configurations to use when working with databases and the RStudio Professional Drivers.