Support

System Requirements for RStudio Professional Drivers

Avatar
Nathan Stephens
Follow

RStudio Professional Drivers is a free add-on that is only available for use with RStudio Server Pro, RStudio Connect, and Shiny Server Pro. By using the drivers you agree to the terms and conditions in the RStudio EULA.

Overview

RStudio Professional Drivers are ODBC data connectors that work with RStudio professional products. In most cases, installation and configuration should be carried out by a system administrator with root access. You will need the following components stored on your system:

  1. The unixODBC driver manager (version 2.3.1 or later)
  2. The odbc R package
  3. 2 GB of disk space

You will also need the proper permissions and credentials to query your database. Typically you will need user, database, and host names, along with a port number and password. System administrators sometimes store this information as a Data Source Name (DSN) in odbc.ini.

Details

1. Driver manager

Using RStudio Professional Drivers with R requires the unixODBC driver manager (version 2.3.1 or later). If it is not already installed on your server you can install it with:

# Redhat / CentOS
$ sudo yum install unixODBC unixODBC-devel
# Debian / Ubuntu
$ sudo apt-get install unixodbc unixodbc-dev
# OpenSUSE / SLES
$ sudo zypper install unixODBC unixODBC-devel
# OS X
$ brew install gnu-getopt
$ brew link --force gnu-getopt
$ brew install wget
$ brew install unixodbc

The unixODBC driver manager will reference two configuration files

  • odbc.ini, which contains information about data source names (DSN's)
  • odbcinst.ini, which contains information about ODBC drivers

You can locate these two files with odbcinst -j after you install the driver manager. 

2. R packages

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

> install.packages("odbc")

On Linux, the odbc R package requires the following system libraries:

  • C++11
  • GCC 4.8 or later

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

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

3. Disk space

The drivers consume approximately 2 GB of disk space.

Driver specific requirements

Oracle

Connecting to Oracle databases requires the Oracle Instant Client.

Hive and Impala

If you are using authentication, install libraries for libsasl -- a framework for working with authentication, data integrity-checking, and encryption.

  • cyrus-sasl-2.1.22-7 or later
  • cyrus-sasl-gssapi-2.1.22-7 or later
  • cyrus-sasl-plain-2.1.22-7 or later

References

Comments