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:
- At least one RStudio professional product
- The unixODBC driver manager (version 2.3.1 or later)
- The latest
odbc
andDBI
R packages and their dependencies - 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
.
Details
1. RStudio Professional Products
Only use RStudio Professional Drivers in conjunction with RStudio Server Pro, RStudio Connect, and Shiny Server Pro. These drivers not licensed for use RStudio 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 2.3.1 or later). If it is not already installed on your server you can install it with:
# Redhat / CentOS 7
$ sudo yum install unixODBC unixODBC-devel
# Debian 9 / Ubuntu 14.04, 16.04, 18.04
$ sudo apt-get install unixodbc unixodbc-dev
# OpenSUSE / SLES 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("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. RStudio Professional Drivers are supported on the following Linux operating systems:
- Redhat/CentOS 7
- Debian 9 / Ubuntu 14.04/16.04/18.04
- openSUSE/SLES 12
Some drivers have additional requirements:
Oracle
- Install the Oracle Instant Client. You will have to register an account with Oracle before downloading. Make sure to install the correct version of OCI. Each version of the Oracle ODBC driver depends on a specific version of OCI. Check docs.rstudio.com for details.
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
Known Issues
- Writing temporary and permanent tables in Hive is currently not supported
- NTLM not supported in the Linux SQL Server ODBC driver.
- Windows domain not supported in the Linux SQL Server ODBC driver.
Database specific issues, such as dplyr translation issues, can be found on db.rstudio.com.
Comments