odbc - A modern database interface

with Jim Hester

useR!2017: odbc - A modern database interface

Keywords: ODBC, DBI, databases, dplyr, RStudio
Webpages: https://CRAN.R-project.org/package=odbc, https://github.com/rstats-db/odbc
Getting data into and out of databases is one of the most fundamental parts of data science. Much of the world's data is stored in databases, including traditional databases such as SQL Server, MySQL, PostgreSQL, and Oracle, as well as non-traditional databases like Hive, BigQuery, Redshift and Spark.
The odbc package provides an R interface to Open Database Connectivity (ODBC) drivers and databases including all those listed previously. odbc provides consistent output; including support for timestamps and 64-bit integers, improved performance for reading and writing, and complete compatibility with the DBI package.
odbc connections can be used as dplyr backends, allowing one to perform expensive queries within the database and reduce the need to transfer and load large amounts of data in an R session. odbc is also integrated into the RStudio IDE, with dialogs to setup and establish connections, preview available tables and schemas and run ad-hoc SQL queries. The RStudio Professional Products are bundled with a suite of ODBC drivers, to make it easy for System Administrators to establish and support connections to a variety of database technologies.