(This article was first published on Statistical Research » R, and kindly contributed to R-bloggers)
Connecting to MySQL and Microsoft SQL Server
Connecting to a MySQL database or MS SQL Server from the R environment can be extremely useful. It allows a researcher direct access to the data without have to first export it from a database and then import it from a csv file or entering it directly into R.
This example shows the process to set up Windows to allow R to connect to MySQL and SQL Server (other databases such as Oracle and PostgreSQL would follow a similar pattern). These are step-by-step instruction on the setup and provides the R code on how to query the database once connectivity is established.
To leave a comment for the author, please follow the link and comment on their blog: Statistical Research » R.
R-bloggers.com offers daily e-mail updates about R news and tutorials on topics such as: Data science, Big Data, R jobs, visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...