RStudio Professional Drivers 1.6 Preview Release

RStudio makes it easy to connect to your data. RStudio Professional Drivers are ODBC data connectors for the most popular databases:

  • Athena
  • BigQuery
  • Cassandra
  • Hive
  • Impala
  • MongoDB
  • MySQL
  • Netezza
  • Oracle
  • PostgreSQL
  • Redshift
  • Teradata
  • Salesforce
  • SQL Server

Notes on upgrading from version 1.4 of the RStudio Professional Drivers

Starting with version 1.6, the RStudio Professional Drivers can be downloaded and installed using .rpm and .deb packages and your system package manager instead of the installer script that was used in version 1.4. In addition the new functionality provided in this release, this will also make future upgrades of the Pro Drivers much easier.

We recommend removing existing installations of version 1.4 of the Pro Drivers to avoid the accidental use of the wrong version of the drivers in your R and Python code. However, if desired, both versions of the drivers can coexist in the same system and be used without issues.

To uninstall version 1.4 of the Pro Drivers, you can remove the directory that they were installed to. Then follow the installation steps for version 1.6 as described below, and verify that the /etc/odbcinst.ini file is pointing to the new version of the drivers located at /opt/rstudio-drivers.

Install dependencies

Install an OBDC driver manager using your system package manager:

sudo yum install unixODBC unixODBC-devel
sudo apt-get install unixodbc unixodbc-dev gdebi
sudo zypper install unixODBC unixODBC-devel
Additional steps for using the Oracle database driver

If you are working with the Oracle database, you will also need to:

  • Install the Oracle Instant Client

  • Link the Oracle library directory to the RStudio Pro Drivers library directory by running the following command:

    ln -s /usr/lib/oracle/12.1/client64/lib/* /opt/rstudio-drivers/oracle/lib/
    

For more information on connecting to Oracle Databases look at this support article.

Download and install

Download and install the RStudio Professional Drivers:

curl -O https://drivers.rstudio.org/7C152C12/installer/rstudio-drivers-1.6.0-1.el7.x86_64.rpm
sudo yum install rstudio-drivers-1.6.0-1.el7.x86_64.rpm
curl -O https://drivers.rstudio.org/7C152C12/installer/rstudio-drivers_1.6.0_amd64.deb
sudo gdebi rstudio-drivers_1.6.0_amd64.deb
curl -O https://drivers.rstudio.org/7C152C12/installer/rstudio-drivers-1.6.0-1.sles12.x86_64.rpm
sudo zypper --no-gpg-checks install rstudio-drivers-1.6.0-1.sles12.x86_64.rpm
curl -O https://drivers.rstudio.org/7C152C12/installer/rstudio-drivers-1.6.0-1.sles15.x86_64.rpm
sudo zypper --no-gpg-checks install rstudio-drivers-1.6.0-1.sles15.x86_64.rpm

Configure driver locations

ODBC driver names and locations are specified in the /etc/odbcinst.ini configuration file.

A sample of this file is included at /opt/rstudio-drivers/odbcinst.ini that is preconfigured with the names and locations of the RStudio Professional Drivers.

You can use the following commands to backup your existing /etc/odbcinst.ini file and write the contents of the sample configuration file to /etc/odbcinst.ini on your system:

# Backup existing ODBC configuration file
sudo cp /etc/odbcinst.ini /etc/odbcinst.ini.bak

# Append sample ODBC configuration file into /etc/
cat /opt/rstudio-drivers/odbcinst.ini.sample | sudo tee /etc/odbcinst.ini
# Backup existing ODBC configuration file
sudo cp /etc/unixODBC/odbcinst.ini /etc/unixODBC/odbcinst.ini.bak

# Append sample ODBC configuration file into /etc/unixODBC/
cat /opt/rstudio-drivers/odbcinst.ini.sample | sudo tee /etc/unixODBC/odbcinst.ini

Testing database connectivity

You should test your database connections from the command line before creating new connections in RStudio. You can test connections by running isql, a command line tool for interactive SQL. Note that isql requires you to create a data source name first.

ODBC Data Source Names (DSNs) are defined in the /etc/odbc.ini configuration file.

To create a new DSN, edit the file odbc.ini and add a new entry with the following contents:

[test]
Driver = SQLServer
Server = my.server.name
Database = dbname
Port = 1433

The Driver setting in the DSN should refer to the corresponding driver name or path listed in /etc/odbcinst.ini.

To test this connection, run the following command:

isql test

Additional documentation

RStudio Professional Drivers 1.6 Release Notes

Refer to the support article on Getting Started with RStudio Professional Drivers for additional information on installing and configuring RStudio Professional Drivers.

Detailed documentation for supported database drivers

RStudio Professional Drivers 1.6: