Subscribe to DSC Newsletter

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 ..

Views: 94

Reply to This

Replies to This Discussion

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
Thank you for the clarification.
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.
KNIME is not open source software according to the OSI (http://www.opensource.org/) definition, because it descriminates commercial use.
the correct thing to be doing in my view
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.

RSS

On Data Science Central

© 2019   AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service