I have been working on R, but corely on data set from .csv file on R Studio. I was curious to know more on R integration with SQL Server. I saw over internet about the same but found multiple things like MS Machine learning R server, Ms R Client, Ms R Open, R tools for Visual Studio, which led to confusion. Could you guide me or share me some useful material to read exclusively on importing data from SQL Server to R with respect to odbc package in R and what each term mean in argument in the function mean.
It would be really great if you can show me where to find each term which are use in SQL server SSMS window.
Also please help to understand the differences between MS Machine learning R server, Ms R Client, Ms R Open, R tools for Visual Studio and R Studio