Using RStudio Professional Drivers#

Install odbc package#

You will use the odbc R package to access your database with R. Installing odbc will also install DBI, the database interface for R.

From an R prompt, install the odbc package:

R Console

> install.packages("odbc")
Dependencies

On Linux, the odbc R package requires the following system dependencies in Linux:

  • C++11
  • GCC 4.8 or later

On older versions of RHEL, you can install GCC 4.8 with RedHat Developer Toolset:

$ sudo yum install devtoolset-4-gcc-c++

Test connectivity#

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.

Troubleshooting#

Refer to the support article on Troubleshooting Connections for additional information on troubleshooting the Connections pane in the RStudio IDE.