Anyone who has some expierence in combining "R" (http://statmethods.net/)
with Visual Studio / SSAS?
Please provide interesting links in this context.
/Bjorn
Technology Tips and News
Anyone who has some expierence in combining "R" (http://statmethods.net/)
with Visual Studio / SSAS?
Please provide interesting links in this context.
/Bjorn
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
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
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
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
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.