Import data from SQL server into R using RJDBC package

This tutorial talks about how to import data from SQL server into R using RJDBC package.

About the package

RJDBC is a package implementing DBI in R on the basis of JDBC. This allows the use of any DBMS in R through the JDBC interface. The only requirement is working Java and a JDBC driver for the database engine to be accessed.

Environment

  • Windows 7, 64-bit
  • R 2.15.1 (32- & 64-bit)
  • Microsoft SQL Server 2008

Read more Import data from SQL server into R using RJDBC package