0.190/installation/tableau.html

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    
    <title>2.6. Web Connector for Tableau &#8212; Presto 0.190 Documentation</title>
    
    <link rel="stylesheet" href="../_static/presto.css" type="text/css" />
    <link rel="stylesheet" href="../_static/pygments.css" type="text/css" />
    
    <script type="text/javascript">
      var DOCUMENTATION_OPTIONS = {
        URL_ROOT:    '../',
        VERSION:     '0.190',
        COLLAPSE_INDEX: false,
        FILE_SUFFIX: '.html',
        HAS_SOURCE:  true
      };
    </script>
    <script type="text/javascript" src="../_static/jquery.js"></script>
    <script type="text/javascript" src="../_static/underscore.js"></script>
    <script type="text/javascript" src="../_static/doctools.js"></script>
    <link rel="index" title="Index" href="../genindex.html" />
    <link rel="search" title="Search" href="../search.html" />
    <link rel="top" title="Presto 0.190 Documentation" href="../index.html" />
    <link rel="up" title="2. Installation" href="../installation.html" />
    <link rel="next" title="3. Security" href="../security.html" />
    <link rel="prev" title="2.5. Benchmark Driver" href="benchmark-driver.html" /> 
  </head>
  <body role="document">
<div class="header">
    <h1 class="heading"><a href="../index.html">
        <span>Presto 0.190 Documentation</span></a></h1>
    <h2 class="heading"><span>2.6. Web Connector for Tableau</span></h2>
</div>
<div class="topnav">
    
<p class="nav">
    <span class="left">
        &laquo; <a href="benchmark-driver.html">2.5. Benchmark Driver</a>
    </span>
    <span class="right">
        <a href="../security.html">3. Security</a> &raquo;
    </span>
</p>

</div>
<div class="content">
    
  <div class="section" id="web-connector-for-tableau">
<h1>2.6. Web Connector for Tableau</h1>
<p>The Presto web connector for Tableau lets users run queries from
Tableau against Presto. It implements the functions in the
<a class="reference external" href="https://community.tableau.com/community/developers/web-data-connectors">Tableau web connector API</a>.</p>
<p>When creating a new web data source, Tableau will ask for the URL of the web
connector. Use the following URL, replacing <code class="docutils literal"><span class="pre">example.net:8080</span></code> with the
hostname and port number of the Presto coordinator
(the default port is <code class="docutils literal"><span class="pre">8080</span></code>):</p>
<div class="highlight-none"><div class="highlight"><pre><span></span>http://example.net:8080/tableau/presto-connector.html
</pre></div>
</div>
<p>When Tableau first loads the Presto web connector, it will render an HTML
form. In this form you need to fill in details such as your user name,
the catalog and the schema you want to query, the data source name,
session parameters you want to set and finally the SQL query to run.
After you click <code class="docutils literal"><span class="pre">Submit</span></code>, the query will be submitted to the Presto
coordinator and Tableau will then create an extract out of the results
retrieved from the coordinator, page by page. After Tableau is done
extracting the results of your query, you can then use this extract
for further analysis with Tableau.</p>
<div class="admonition note">
<p class="first admonition-title">Note</p>
<p>With the Presto web connector, you can only create Tableau extracts,
because the web connector API currently does not support the live mode.</p>
<p class="last">The web connector API only supports a subset of the data types available
in Presto. In particular, the Tableau web connector API currently supports
the following Tableau data types:
<code class="docutils literal"><span class="pre">bool</span></code>, <code class="docutils literal"><span class="pre">date</span></code>, <code class="docutils literal"><span class="pre">datetime</span></code>, <code class="docutils literal"><span class="pre">float</span></code>, <code class="docutils literal"><span class="pre">int</span></code> and <code class="docutils literal"><span class="pre">string</span></code>.
Presto <code class="docutils literal"><span class="pre">boolean</span></code> and <code class="docutils literal"><span class="pre">date</span></code> types will be converted to the Tableau
data types <code class="docutils literal"><span class="pre">bool</span></code> and <code class="docutils literal"><span class="pre">date</span></code>, respectively, on the Tableau client side.
Any other Presto types such as <code class="docutils literal"><span class="pre">array</span></code>, <code class="docutils literal"><span class="pre">map</span></code>, <code class="docutils literal"><span class="pre">row</span></code>, <code class="docutils literal"><span class="pre">double</span></code>,
<code class="docutils literal"><span class="pre">bigint</span></code>, etc., will be converted to a Tableau <code class="docutils literal"><span class="pre">string</span></code> as they do
not map to any Tableau type.</p>
</div>
</div>


</div>
<div class="bottomnav">
    
<p class="nav">
    <span class="left">
        &laquo; <a href="benchmark-driver.html">2.5. Benchmark Driver</a>
    </span>
    <span class="right">
        <a href="../security.html">3. Security</a> &raquo;
    </span>
</p>

</div>

    <div class="footer" role="contentinfo">
    </div>
  </body>
</html>