Menu
Is it possible to read the data stored in MS SQL server from R interface?
If it is I would be also thankful if anyone could show the way to do it.
875
We can use the Rio package for data import and export in various formats using the R scripts. It is an external package and does not install when you configure the SQL Server Machine Learning for R. To check the Rio package in your environment, you can run the following script.
R can connect to almost any existing database type.
Tried the RODBC package already?
http://cran.r-project.org/web/packages/RODBC/index.html
There's also the RJDBC package : http://www.rforge.net/RJDBC/
See also : http://www.r-bloggers.com/connecting-to-sql-server-from-r-using-rjdbc/
84
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
