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

Import Data From SQL Server Into R Using RODBC Package

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

The functions provided by the RODBC package can be categorized into two groups:

  1. The mainly internal odbc* functions implement low-level access to the ODBC functions of similar name.
  2. The sql* functions operate at a higher level to read, save, copy and manipulate data between data frames and SQL tables

Read more Import Data From SQL Server Into R Using RODBC Package