SQL Server 2016 R Services: Guide for Client Configuration

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.

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.

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.

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:

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:

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

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

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.

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

You can now run R code on your machine.

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.

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

Try it out yourself!
Download and install the SQL Server 2016 preview and follow the steps in
this tip to configure your machine for R Services.

About the author

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
Email me updates

Signup for our newsletter
I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.

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

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.