Was this page helpful?
Yes No

Pass Expressions to External Services

Tableau supports a set of functions that you can use to pass expressions to external services for integration with R, MATLAB, and Python. Tableau supports integration with the following services:

  • R

    R is an open source software programming language and a software environment for statistical computing and graphics.

    Watch a Video: To see related concepts demonstrated in Tableau, watch the free training videos How to Integrate R and Tableau (4:40 minutes) and Using R with Tableau (4:44 minutes). Use your tableau.com account to sign in.

  • MATLAB

    MATLAB is a high-level language that enables you to perform computationally intensive tasks faster than with traditional programming languages such as C, C++, and Fortran. You can use MATLAB in a wide range of applications, including signal and image processing, communications, control design, test and measurement, financial modeling and analysis, and computational biology. For information on how to configure your MATLAB server to work with Tableau please contact MATLAB support.

    To read more about the possibilities of MATLAB in Tableau, see Put your MATLAB models and algorithms to work in Tableau.

  • Python

    Python is a widely used high-level programming language for general-purpose programming. By sending Python commands to an external service, you can do things like predicting customer churn or running sentiment analysis.

    Tableau Python Server (TabPy) is part of Tableau's expanding range of extensibility options. To install TabPy, visit this GitHub page. To read more about the possibilities of Python in Tableau, see Building advanced-analytics applications with TabPy.

SCRIPT functions for expressions

In Tableau Desktop, a set of four SCRIPT functions are available for passing expressions to external services and obtaining a result. The functions are:

SCRIPT_BOOL

SCRIPT_INT

SCRIPT_REAL

SCRIPT_STR

See SCRIPT_BOOL for details and examples. Because these SCRIPT_ functions are table calculations functions, addressing and partitioning concepts apply. (For an explanation of these concepts, see The basics: addressing and partitioning.) Tableau makes one call to an external service per partition.

Because connecting to an external service involves some overhead, try to pass values as vectors rather than as individual values whenever possible. For example if you set addressing to Cell (for example, by clicking the field in the view and choosing Compute Along > Cell), Tableau will make a separate call per row to the external service; depending on the size of the data, this can result in a very large number of individual calls. If you instead use a column that identifies each row that you would use in the level of detail, you could compute along that column so that Tableau could pass those values in a single call.

Configure an external service connection

Tableau allows connections to external services via a set of SCRIPT functions. In order to use these external services, you must establish a connection to an external server. Connections to Rserve, MATLAB Server, and Python Server are currently supported.

For R, you need access to a server which allows applications to access R functionality. See Rserve for details. For information on installing, running, and configuring Rserve, as well as on optimizing R scripts and R security, see the Tableau Community post R Implementation Notes. For more information about using R with Tableau, see the blog post Tableau 8.1 and R.

Tableau Desktop can connect to R via either plaintext or SSL-encrypted traffic. For direction on which type to use, consult your system administrator.

Note: For R integration, Tableau has been tested with R versions 3.4.4 through 3.5.1, and with Rserve versions 0.6-8 through 1.7.3.

To configure an external service connection:

  1. In Tableau Desktop, click the Help menu, and then select Settings and Performance > Manage External Service connection to open the External Service Connection dialog box:

    Example of External Service Connection dialog box set up for an Rserve connection.

  2. Specify the type of external service you want to connect to: RServe or TabPy/External API. The TabPy/External API option covers connections to TabPy and MATLAB.

  3. Enter or select a server by domain name or IP address. The drop-down list includes Localhost and the server you most recently connected to, as well as the Disable option.

  4. Enter or select a server name using a domain or an IP address. The drop-down list includes localhost and the server you most recently connected to.

  5. Specify a port.

    • Port 6311 is the default port for plaintext Rserve servers.

    • Port 4912 is the default port for SSL-encrypted RServe servers.

    • Port 9004 is the default port for TabPy.

  6. If the server requires credentials, select Sign in with a username and password to enable the Username and Password fields. Add your credentials for these fields.

    If your server is using SSL encryption, select the Require SSL option. Click the Custom configuration file... link to specify a certificate for the connection.

    Note: Tableau only supports PEM encoded certificates when connecting to TabPy or RServe.

  7. Click Test Connection.

  8. Click OK.

If no connection can be established, an error message is displayed. Click Show Details in the message to see any diagnostic information returned by the server.

Share a workbook that requires an external service connection

You might need to send a workbook that contains external service functionality to other users, who may be using different copies of Tableau Desktop on other computers. Or, users may download a workbook from Tableau Server that contains external service functionality. If you share your workbook with someone, they must configure external service connections on their computers.

Publish a workbook that requires an external service connection

Before you publish a workbook that relies on an external service connection to Tableau Server, you should verify that the server is configured to be able to run scripts, and also configure Tableau Server to have its own external service connection.

Configure Tableau Server to be able to run scripts

If you publish a workbook that relies on an external service connection, you must verify that the server is configured to allow scripts. The following two settings are relevant:

  • vizqlserver.allow_insecure_scripts

    This setting allows affects scripts of all kinds (initial sql, custom sql, script calcs) in published workbooks. The default value is false. Setting it to true allows scripts that include string parameters (that is, scripts that reference a Tableau parameter) to run. Scripts that reference a Tableau parameter can constitute a vulnerability because of the potential for injection of code.

  • vizqlserver.script.disabled

    This parameter determines whether external service calls from a workbook on Tableau Server can run. The default value is true, which seems like it would mean that scripts are disabled. But in fact true means scripts can run. To prevent scripts from running, set this parameter to false. This parameter does not affect the ability to upload workbooks with scripts, only the ability to execute script commands once a workbook is uploaded.

Use the Tableau Services Manager (TSM) command line tool to configure these settings. For details, see tsm configuration in the Tableau Server help.

Configure Tableau Server for an external service connection

Use tsm security external-ssl enable to configure Tableau Server for external services. The settings are equivalent to the values you set in the External Service Connection dialog box.

For details, see tsm security external-ssl enable in Tableau Server help.

Note: Tableau Server on Windows now includes Tableau Services Manager (TSM), which replaces the Configuration Utility and the command line tool. If you need help for an earlier version of Tableau Server, see the Tableau Help page.

If you configured Tableau Server for an external service connection in Tableau 10.0 to 2018.3, you would have used tsm configuration set and its associated settings (documented intsm configuration set options in Tableau Server help).

If you configured Tableau Server for an external service connection prior to Tableau 10.0, these settings had different names. The configuration vizqlserver.extsvc was introduced in Tableau Server 10.1 as a replacement for vizqlserver.rserve. However, there is reverse compatibility in Tableau Server starting with version 10.1. In these more recent versions of Tableau Server, vizqlserver.extsvc settings will be checked for first, but if there are no vizqlserver.extsvc settings then Tableau Server will check for vizqlserver.rserve settings.

Tableau cannot verify that workbooks that use an external service will render properly on Tableau Server. There might be scenarios where a required statistical library is available on a user’s machine but not on the external service instance that Tableau Server is using.

For views that cannot be rendered in Tableau Server because of a script error, you see a warning error when you publish the workbook:

This worksheet contains external service scripts, which cannot be viewed on the target platform until the administrator configures an external service connection.

You cannot publish a workbook that contains external service scripting to Tableau Online.

Because Tableau Server provides an authentication mechanism, it can be more secure to expose external service functionality to users through Tableau Server than in Tableau Desktop.