Integrating R into Visual Studio?

Anyone who has some expierence in combining "R" (http://statmethods.net/)

with Visual Studio / SSAS?

Please provide interesting links in this context.

/Bjorn

January 31st, 2012 8:34am

I have used R together with SSAS, although not in an integrated way (unfortunately), to add classical statistical testing weight to patterns emphasized by SSAS. The closes thing to an integration was to use the RExcel add-in (http://en.wikipedia.org/wiki/RExcel or http://rcom.univie.ac.at/) on the same instance of Excel which was running the data mining add-ins, typically on top of add-ins output.
Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2012 11:52pm

Hi Bjorn,

The Visual Studio environment is slightly different from the BIDS SSAS project environment. The BIDS SSAS project is for deploying SSAS solutions only.

The Microsoft visual studio is an integrated development environment (IDE) from Microsoft for developing applications. Its supported languages are mentioned in http://msdn.microsoft.com/en-us/library/bb514232.aspx.

The R home website has a blog which mentions that users of "other" statistical packages (SAS, SPSS, Stata) can transition to R,  but it did not mention anything about Visual Studio, so it implies that it is not common/not documented to integrate R with Visual Studio.

Perhaps, this question should be posted to the "R" website since it allows feedback and suggestions.

Thanks,

Cathy Miller

February 7th, 2012 6:01pm

Hi Bjorn,

I both use R as well as SSAS for data mining tasks. R can easily read and write from sql server, which I belive is prefeable to the Excel or C# integration of R. Try to have a look at the following:

http://www.r-project.org/conferences/useR-2010/slides/Wei+Kitts.pdf

I hope it can help you.

Best regards,

Kim Lillese

Dataminds

Free Windows Admin Tool Kit Click here and download it now
February 9th, 2012 2:00pm

the new version of R(3.1.0) is platform agnostic, it integrates in many datasources, including SQL SERVER

but Visual Studio is not mentioned yet

November 14th, 2014 8:03am

Currently Visual Studio is not integrated with R. Check out my blog post about the subject on LinkedIn. R and Microsoft and the plans for future integration. You can use R on Azure, however, it is just to execute it. Visual Studio Code has limited R Support, however, you will have to configure it yourself using the JSON config files to load the execution engine, etc. I just started working with VS Code and can provide you with an update if I get it working.

I do agree with you on the steep learning curve. Adding it to VS with Intellisense will make it a lot easier to work with especially when Subsetting. The best place to learn it in my opinion is on Microsoft-authored training on edX.org. The course name if you are interested is Microsoft: DAT204x Introduction to R.

HTH,

Bash

Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 9:43pm

Actually you can't include R packages into VS project. However, you can interact with VS at the .NET level. Here is a library for R and C# interaction (or any other CLI languages) R.NET 

You cal install one via NuGet. Here is the R.NET documentation 

Other links you may find useful:

There is Visual Studio Code taht supports R.

VisualStudio added syntax highlighting for R in March.

Coco/R for Visual Studio

How to evaluate R things from Visual Studio?

September 12th, 2015 1:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics