R Language Notes Connection database

1. ODBC interface

Accessing a database through the RODBC package in R is perhaps the most popular way to allow R to connect to any

Having an ODBC-driven database is virtually all the databases on the market.

The first step is to install and configure the appropriate ODBC drivers for your system and database type--they are not part of R

Score of If your machine does not have the necessary drivers installed, search the Internet to find it.

After installing and configuring the driver for the selected database, install the RODBC package. You can use the command

Install.packages ("RODBC") to install it.

2. DBI-related packages

The DBI package provides a common and consistent client interface for accessing the database. The RJDBC package built on top of this framework

Provides a scenario for accessing a database through the JDBC driver. Be sure to install the necessary for your system and database when you use it

JDBC driver. Other useful, DBI-based packages are rmysql, roracle, Rpostgresql, and Rsqlite. These

Packages provide native database drivers for the corresponding database, but may not be available on all systems. For more information, see

The corresponding document on CRAN (http://cran.r-project.org).

R Language Notes Connection database