Loading…
This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
View analytic
Thursday, July 6 • 2:06pm - 2:24pm
odbc - A modern database interface

Sign up or log in to save this to your schedule and see who's attending!

Feedback form is now closed.
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.

Speakers

Thursday July 6, 2017 2:06pm - 2:24pm
2.01 Wild Gallery

Attendees (211)