6 Replies Latest reply on Nov 6, 2017 2:37 PM by Andrew Clapson

How to connect R to Tableau Server

Shuai Zhao Dec 11, 2014 7:00 PM

Hi,

I want to connect Tableau Server and R, but got a problem

I have ran the following scripts, and no error message appears (R and Tableau Server are in the same machine), does that mean the connection is successful ?

tabadmin set vizqlserver.rserve.host localhost

tabadmin set vizqlserver.rserve.port 6311

But when I run a worksheet contains R scripts on Tableau Server, still received error message like

"An unexpected error occurred on the server. If you continue to receive this error please contact your Tableau Server Administrator.

TableauException: No Rserve connection configured. Specify a server name and try again."

What can I do next?

Many Thanks

1. Re: How to connect R to Tableau Server

Shuai Zhao Dec 11, 2014 11:17 PM (in response to Shuai Zhao)
continue...
I modified my command as:
tabadmin stop

tabadmin set vizqlserver.rserve.host localhost

tabadmin set vizqlserver.rserve.port 6311

tabadmin config

tabadmin start

and the error message shown as

an error occurred while communicating with the Rserve service.
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: How to connect R to Tableau Server

Cristian Vasile Dec 11, 2014 11:41 PM (in response to Shuai Zhao)

FYI.
Tableau and R Integration
Sections
    What you have to know about Tableau
    Getting started with R
        R Libraries
        R on the Mac (and Tableau on a Windows Virtual Machine)
    How Tableau sends data to R
        Disaggregated data
        Counting connections & R script operations
        Exactly what is sent to R
        Densification
        Order of operations
    Getting into arguments
        Nesting arguments
    Logging and Debugging
    What the Tableau/R integration doesn’t do

Regards,
Cristian
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
3. Re: How to connect R to Tableau Server

Russell Christopher Dec 12, 2014 5:36 PM (in response to Shuai Zhao)

Have you used any other tools to verify that RServ is running and accepting connections?

Assuming that RServ is listening on 6311, what you have so far looks fine - I noticed that you aren't specifying a username and/password for rserv, however. Is the server configured with those?

Also, depending on whether you are running IPV6 and IPV4 or only IPV4, your "localhost" machine name may not be resolving correctly. Try just using the IP address of your machine instead.
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
4. Re: How to connect R to Tableau Server

Cristian Vasile Dec 13, 2014 1:04 AM (in response to Shuai Zhao)

Shuai,

Check out the following links:
Resources for setting up and configuring RServer
R script troubleshooting
Using R studio server for R
RServe Actively Refuses the Connection?
Rserve - Binary R server - RForge.net

Russell is right, do not use localhost instead use loopback IP address aka 127.0.0.1 if R and Tableau Server are running on the same machine (your case) OR Rserve own IP.

Hope this helps.

Regards,
Cristian.
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
5. Re: How to connect R to Tableau Server

venkata krishna prasad anumula Jun 16, 2017 1:10 PM (in response to Shuai Zhao)

were you able to make it work?
Like Show 0 Likes(0)

Actions
6. Re: How to connect R to Tableau Server

Andrew Clapson Nov 6, 2017 2:37 PM (in response to Cristian Vasile)

So I spent part of last week configuring this exact issue (Tableau Server + R/RServer running on the same Windows Server), and what got it all working was indeed these settings:

tabadmin set vizqlserver.extsvc.host localhost
tabadmin set vizqlserver.extsvc.port 6311
*and*
tabadmin set vizqlserver.allow_insecure_scripts true

I had tried the loopback IP (vizqlserver.extsvc.host 127.0.0.1) at first, but it didn't work in my case - localhost was what was needed.

Thanks to Joshua Metz at Tableau Technical support who helped me troubleshoot this puppy...next is getting TabPy working!

Andy
Like Show 0 Likes(0)

Actions