Social Network For Analytic Professionals

R software

Hi All,

Can any one tell me how to integrate R with SQL Server2005..?

I would like to go for R instead of SAS ..How do u think about it ..

Permalink Reply by Kevin Qin on December 2, 2008 at 7:27pm: Currently R can import data from excel and csv file.
I doubt that it can read in data from SQL Server smoothly while SAS can handle almost all data source.

Can anyone confirm it?

-Kevin; ▶ Reply to This

Permalink Reply by Jan Theodore Galkowski on December 2, 2008 at 11:14pm: The standard R Import-Export documentation (PDF) describes how to access databases. In the Windows context, this amounts to creating an ODBC link, and then accessing it directly from R.

Many people (including me!) use R to access relational databases via SQL directly. As a local database, you can always install something like PostgreSQL and use R to write to it for later retrieval, or you can use something like the database package Filehash for such storage.; ▶ Reply to This

Permalink Reply by Kevin Qin on December 2, 2008 at 11:55pm: Thank you for the clarification.; ▶ Reply to This

Permalink Reply by Michael Zeller on December 9, 2008 at 4:20pm: You may also want to take a look at the open source package KNIME. It has an excellent visual interface, can read from a database, and it integrates with R.

Hope this helps.; ▶ Reply to This

Permalink Reply by Jens Godsk Katz-Kolberg on February 1, 2009 at 12:13am: KNIME is not open source software according to the OSI (http://www.opensource.org/) definition, because it descriminates commercial use.; ▶ Reply to This

Permalink Reply by AJAY OHRI on December 15, 2008 at 2:53am: also consider to look at the R for SAS and SPSS users book (http://www.decisionstats.com/?p=599) and the Rattle GUI from www.togaware.com; ▶ Reply to This

Permalink Reply by John A Morrison on December 19, 2008 at 5:32am: the correct thing to be doing in my view; ▶ Reply to This

Permalink Reply by chewik on December 25, 2008 at 6:34am: Hello Ram,
One possible way to use SQL server with R is via package RODBC. You should try it first. Then you can go for RDBI package.

I recommend R for using as data mining tool. There are thousands of packages. You should find out what people did in those packages and then you can write your own functions over others work. You dont have to reinvent the wheel, do you?

F.; ▶ Reply to This