SQL Server 2016 - Getting started with R Services

R Services (In-Database) provides a platform for developing and deploying intelligent applications that uncover new insights.

R Services (In-Database) integrates the R language with SQL Server, you can keep analytics close to the data and eliminate the costs and security risks associated with data movement.

To install R Services

Click on SQL Server set up file and follow below steps:

To use R code in T-SQL:

Execute below commands from SSMS and then restart both SQL Server Launchpad & SQL Server services

Exec sp_configure  'external scripts enabled', 1 
Reconfigure  with override


After successfully setting up R-Services, let us try tutorial from MSDN BOL

Open Windows PowerShell command console and run below commands to download data & scripts:

Set-ExecutionPolicy Unrestricted -Scope Process -Force

Change the destination directory if required:

$source = '' 
$ps1_dest = "$pwd\Download_Scripts_R_Walkthrough.ps1" 
$wc = New-Object System.Net.WebClient 
$wc.DownloadFile($source, $ps1_dest) 
.\Download_Scripts_R_Walkthrough.ps1 –DestDir

Run below command from Windows PowerShell command console to execute downloaded scripts [create database, tables, stored procedure, function and import data]


Open RGui and Install R libraries by running below commands

# Install required R libraries for this walkthrough if they are not installed.  

if (!('ggmap' %in% rownames(installed.packages()))){ 

if (!('mapproj' %in% rownames(installed.packages()))){ 

if (!('ROCR' %in% rownames(installed.packages()))){ 

if (!('RODBC' %in% rownames(installed.packages()))){ 

install.packages("ggmap", lib=grep("Program Files", .libPaths(), value=TRUE)[1]) 
install.packages("mapproj", lib=grep("Program Files", .libPaths(), value=TRUE)[1])
install.packages("ROCR", lib=grep("Program Files", .libPaths(), value=TRUE)[1])
install.packages("RODBC", lib=grep("Program Files", .libPaths(), value=TRUE)[1])

Other lessons that are part of this tutorial can be continued from here.


No comments: