Create a System DSN in Windows XP
- Click Start, point to Control Panel, double-click Administrative Tools, and then double-click Data Sources(ODBC).
- Click the System DSN tab, and then click Add.
- Click the database driver that corresponds with the database type to which you are connecting, and then click Finish.
- Type the data source name. Make sure that you choose a name that you can remember. You will need to use this name later.
- Click Select.
- Click the correct database, and then click OK.
- Click OK, and then click OK.
Oracle
How to do it-
http://blog.rguha.net/?p=340
R Packages
|R Oracle
using the RODBC
db <- odbcConnect(dsn=”testdsn”, uid=”testuser”, pwd=”testpasswd”, believeNRows=FALSE )
MySQL
http://www.mysql.com/
http://www.mysql.com/products/community/
http://www.mysql.com/downloads/workbench/
How to-
R Package
PostgreSQL
http://www.postgresql.org/download/
Read-
R Package-
Additional R Packages
http://rpgsql.sourceforge.net/
http://cran.r-project.org/web/packages/RPostgreSQL/
IMPORTANT UPDATE
Pre-compiled binary packages for R-2.12.x for Windows
Packages related to many database system must be linked to the exact
version of the database system the user has installed, hence it does
not make sense to provide binaries for packages
RMySQL, ROracle, ROracleUI, RPostgreSQL
although it is possible to install such packages from sources by
install.packages('packagename', type='source')
after reading the manual 'R Installation and Administration'.
R with MongoDB
This R package provides an interface to the NoSQL MongoDB database
using the MongoDB C-driver version 0.8
ps-
R with JSON
This package is a fork of the RJSONIO package by Duncan Temple Lang. It builds on the same libjson c++ parser, but implements a smarter mapping between JSON data and R classes. The vignette describes the behavior in great detail. In addition to drop-in replacements for toJSON and fromJSON, the package contains functions to serialize objects and many unit tests to make verify that all edge cases are encoded and decoded consistently for use with dynamic data in systems and applications.
R with CouchDB
https://github.com/wactbprot/R4CouchDB
R with MonetDB
MonetDB.R: Connect MonetDB to R
Allows to pull data from MonetDB into R
Cassandra with R
Neo4j with R
# Function for querying Neo4j from within R
# from http://stackoverflow.com/questions/11188918/use-neo4j-with-r
query <- function(querystring) {
h = basicTextGatherer()
curlPerform(url = "localhost:7474/db/data/ext/CypherPlugin/graphdb/execute_query",
postfields = paste("query", curlEscape(querystring),
sep = "="), writefunction = h$update, verbose = FALSE)
result <- fromJSON(h$value())
data <- data.frame(t(sapply(result$data, unlist)))
names(data) <- result$columns
return(data)
}
# --------------------------------------
# import all data into neo4j
# --------------------------------------
nrow(venueDataset) # number of venueshttps://github.com/RevolutionAnalytics/RHadoop/wiki
RHadoop consists of the following packages:
- NEW! plyrmr – higher level plyr-like data processing for structured data, powered by
rmr - rmr – functions providing Hadoop MapReduce functionality in R
- rhdfs – functions providing file management of the HDFS from within R
- rhbase – functions providing database management for the HBase distributed database from within R
The Latest Official RHadoop Releases
R with Spark
http://amplab-extras.github.io/SparkR-pkg/
SparkR is an R package that provides a light-weight frontend to use Apache Spark from R. SparkR exposes the Spark API through the RDD class and allows users to interactively run jobs from the R shell on a cluster.
R with Hive
http://nexr.github.io/RHive/
RHive is an R extension facilitating distributed computing via HIVE query. RHive allows easy usage of HQL(Hive SQL) in R, and allows easy usage of R objects and R functions in Hive.
DDR with R – Rhipe
http://www.datadr.org/
RImpala
A package to connect and run queries on Cloudera Impala (thanks to Mu Sigma)
R for Business Analytics 