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:
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
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.
On Linux, the odbc R package requires the following system libraries:
- 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
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