Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server 2016 R Services: Guide for Client Configuration


By:   |   Read Comments (2)   |   Related Tips: More > SQL Server 2016

Quickly Resolve Performance Problems for IIS, .NET and SQL Server       >>>   Get Started


Problem

SQL Server 2016 comes with the integration of the popular language R built into the database engine. This feature has been introduced in SQL Server 2016 preview CTP3.0 and is called SQL Server R Services. In a previous tip - SQL Server 2016 R Services: Guide for Server Configuration - we went over the installation and configuration of the server components. This tip will guide you through the set-up and configuration of the client workstation.

Solution

SQL Server 2016 preview

As mentioned earlier, SQL Server 2016 is still in preview at the time of writing and CTP 3.0 has been released. This means that R Services features can change and that functionality might change, disappear or be added.

Setting up a Client Workstation

Just as with the server components, several steps need to be taken to set-up a client workstation. In the official documentation (Installing SQL Server R Services) this is referred to as creating a data science workstation. In this tip I'll refer sometimes to the set-up of the server components. You can read all about it in SQL Server 2016 R Services: Guide for Server Configuration.

1. Install Revolution R Open 3.2.2

This will install a distribution of R which includes the open source R runtime and other libraries. In the documentation this is also referred to as Microsoft R Open, but it's exactly the same distribution as the one installed on the server.

You can download the software here. Next run the installer as an Administrator.

RRO installer

The installation itself is straight-forward and doesn't need extra explanation. Just as on the server, this will also install a simple development environment called Connector RGUI 7.5.0 64-bit. This is not the same IDE as mentioned before, the full Revolution R Enterprise IDE is installed in the next step.

RGUI

2. Install Revolution Enterprise 7.5

You can download the software here. Revolution Enterprise is a platform for scaling R code which includes many enhanced R packages and R functions. At the download page, you can choose between the server software (a node, around 80MB) or the client software (around 470MB). Since we want to configure a client workstation, the full installer is needed. This means we're installing actually more software on the client than on the server, with the exception of the Advanced Analytics Extensions in the database engine.

Run the installer as an administrator. The first step is to check the prerequisites:

Prerequisites

Most prerequisites are the same as on the server, but since an IDE is installed as well there's also a check on the .NET framework and on the Visual Studio 2008 shell, which is apparently used in the software just like in the old Business Intelligence Development Studio (BIDS) in SQL Server 2008.

Installation of these prerequisites should be pretty quick. It's normal to go through several installation wizards, one for each prerequisite that needs to be installed or upgraded. The following screenshot shows for example the wizard for the VS 2008 shell:

Prerequisites - Shell

When all the prerequisites are installed, the Revolution R Enterprise set-up will launch automatically.

Revolution R set-up

During the set-up, you can optionally install the R packages rpart and lattice.

Revolution R set-up - packages
  • rpart is a package for recursive partitioning for classification, regression and survival trees
  • lattice is a package for data visualizations inspired on Trellis graphics

After choosing the installation folder, the wizard is finished. Unlike the server components, there are no post-installation scripts to run.

The Revolution R Enterprise software will now be installed on the client machine and can be found in the Start menu.

Revolution R Enterprise software

Since the development environment uses a Visual Studio shell, the look-n-feel of the software is quite familiar.

Revolution R Enterprise IDE

You can now run R code on your machine.

Running R

If you installed the server components and enabled the Advanced Analytics Extensions in SQL Server, you can also write R code in the Revolution R Enterprise IDE, but offload calculations to SQL Server.

Running R in SQL Server

In a next tip we will describe how this can be done.

Conclusion

This tip guided you through the client-side set-up of SQL Server R Services. You can now write and run R code locally, or you can let the code run in SQL Server and display the results locally. Future tips will go into more detail.

Next Steps


Last Update:


signup button

next tip button



About the author
MSSQLTips author Koen Verbeeck Koen Verbeeck is a BI professional, specializing in the Microsoft BI stack with a particular love for SSIS.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Monday, January 04, 2016 - 3:27:40 PM - Koen Verbeeck Back To Top

Hi Peter,

thanks for the link!
Seems they changed the download page into two seperate download pages.


Monday, January 04, 2016 - 11:10:01 AM - Peter Tilsted Back To Top

The Revolution R Enterprise 7.5.0 Client is now found here: http://www.microsoft.com/en-us/download/details.aspx?id=50351


Learn more about SQL Server tools