Support

System Requirements for ODBC Connections and RStudio Professional Drivers

Avatar
Nathan Stephens
Follow

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. At least one RStudio professional product
  2. The unixODBC driver manager
  3. The latest odbc and DBI R packages as described in db.rstudio.com
  4. RStudio Professional Drivers

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.

1. RStudio Professional Products

You can only use RStudio Professional Drivers in conjunction with RStudio Server Pro, RStudio Connect, and Shiny Server Pro. These drivers cannot be used in isolation or with our open-source products. When you install the drivers you agree to the terms and conditions in the RStudio EULA.

2. unixODBC

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

# Redhat/CentOS 6, 7
$ sudo yum install unixODBC unixODBC-devel
# Debian/Ubuntu 12.04, 14.04, 16.04
$ sudo apt-get install unixodbc unixodbc-dev
# OpenSUSE/SLES 11, 12
$ sudo zypper install unixODBC unixODBC-devel

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. 

3. 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("devtools")
> devtools::install_github("rstats-db/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 through with RedHat Developer Toolset

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

4. RStudio Professional Drivers

System requirements for RStudio professional drivers can be found in the "Driver Installation and Configuration Guide" located under docs in your driver install directory. Plan on 150 MB of disk space for every driver. Some drivers are operating system dependent:


RStudio

Debian
8

RHEL/
CentOS
6

RHEL/
CentOS
7

Ubuntu
12.04

Ubuntu
14.04

Ubuntu
16.04

SLES
11

SLES
12

Amazon Redshift

x

x

x

x

x

x

x

x

Hive

  

x

x

x

x

  

x

x

Impala

  

x

x

x

x

  

x

x

Oracle

  

x

x

      

x

  

PostgreSQL

x

x

x

x

x

x

x

x

Salesforce

x

x

x

  

x

x

x

x

SQL Server

x

x

x

x

x

x

x

x

Additional driver specific requirements

These drivers require additional dependencies.

Oracle

Hive and Impala

  • 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