---
schema_version: "1"
id: eacf74885853a2e42bb91dcd3a9e8f94955f951174b45ea986664baef9c5b0c9
title: Tableau Online Output Connection
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_connectors_output_tableau_hyper.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_connectors_output_tableau_hyper.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f976a96c7229199036a391d6d3032e8226ee2218cb2e307c96fd7a843379720a
description: Push your prepared data from CRM Analytics into Tableau Online with the Tableau Online Output connector and Data Prep recipes. Use the connector to push your transformed, merged, and cleaned data to Tableau Online as a .hyper file for further analysis. For example, prepare historical Opportunity data for struggling products in CRM Analytics, and then use Tableau Online’s analytics tools to identify helpful trends to optimize deals.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Tableau Online Output Connection

Push your prepared data from CRM Analytics into Tableau Online with the Tableau Online Output connector and Data Prep recipes. Use the connector to push your transformed, merged, and cleaned data to Tableau Online as a .hyper file for further analysis. For example, prepare historical Opportunity data for struggling products in CRM Analytics, and then use Tableau Online’s analytics tools to identify helpful trends to optimize deals.

## How the Tableau Online Output Connector Works

The Tableau Online Output connector, from CRM Analytics, allows you to write the outcome of a recipe to a Tableau Online project as a .hyper file. After you configure an output connector to Tableau Online, create a recipe using Data Prep. Add an Output node to the recipe, select the Tableau Online Output connection, and configure the node with the object (Tableau Online project). When the recipe runs, CRM Analytics writes the output dataset as a .hyper file to the selected project. When the recipe runs again we overwrite the .hyper file, but you can view the historical versions of files in Tableau Online.The credentials used to create the Tableau Online output connection must use the Creator license. The Creator role provides needed access.

## Enable and Add the Tableau Online Output Connector

1. From Setup, in the Quick Find box, enter Analytics, select **Analytics**, and then **Settings**.
2. Select **Enable Tableau Online output connection** and then save your changes.
3. In the Data Manager, click the **Connections** tab.
4. Click **New Connection**.
5. Click **Output**.
6. Click the connector’s icon and enter its settings, as described in the Connection Settings section.
7. Click **Save & Test**. Save & Test validates your settings by attempting to connect to the source. If the connection fails, CRM Analytics shows possible reasons.

All settings require a value, unless otherwise indicated.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d182319e100">Setting</th>
            <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d182319e103">Description</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e100 ">Connection Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e103 ">Required. Identifies the connection. Use a convention that lets you easily distinguish
              between different connections.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e100 ">Developer Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e103 ">Required. The API name for the connection. This name can’t include spaces. You can’t change
              the developer name after you create the connection.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e100 ">Description</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e103 ">Required. The description for the connection.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e100 ">Username</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e103 ">Required for password authentication. The user name for the Tableau Online account.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e100 ">Password</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e103 ">Required for password authentication. The assword for your Tableau Online account.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e100 ">Authentication Type</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e103 ">
              <p>Required. The authentication type. Valid values include <code>Password</code> and <code>PersonalAccessToken</code>.
              </p>
              <p>If you use <code>Password</code>, enter a value in the
                <strong class="uicontrol">Username</strong> and <strong class="uicontrol">Password</strong> fields.
              </p>
              <p style="margin-bottom:0;">If you enter <code>PersonalAccessToken</code>, enter values in the
                <strong class="uicontrol">Personal Access Token Name</strong> and <strong class="uicontrol">Personal Access Token Secret</strong> fields.
              </p>
            </td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e100 ">Personal Access Token Name</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e103 ">Required for personal access token authentication. The name associated with a personal access token from your
              Tableau Online account. Learn more about personal access tokens, including their 15
              day expiration when unused, in <a href="https://help.tableau.com/current/pro/desktop/en-us/useracct.htm#create-and-revoke-personal-access-tokens" target="_blank">Tableau's PAT
                documentation</a>.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e100 ">Personal Access Token Secret</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e103 ">Required for personal access token authentication. The secret code associated with a personal access token from
              your Tableau Online account.</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e100 ">Content URL</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e103 ">Required. The subpath portion of your Tableau Online URL. To isolate the Content URL,
              sign into Tableau Online and pull the bolded portion of your URL:
              https://us-west-5a.online.tableau.com/#/site/<strong>exampleurl5a</strong>/home</td>

          </tr>
          <tr class="">
            <td data-label="Setting" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e100 ">Server URL</td>

            <td data-label="Description" class="slds-cell-wrap" style="vertical-align:top;" headers="d182319e103 ">Required. The base URL for your Tableau Online server, including the pod name. To isolate
              the Server URL, sign into Tableau Online and pull the bolded portion of your
              URL:<strong>https://us-west-5a.online.tableau.com</strong>/#/site/exampleurl5a/home</td>

          </tr>
        </tbody>
      </table>

## Push Data to Tableau Online

With the Tableau Online Output Connector configured, build a Data Prep recipe that merges and transforms the data to push to Tableau Online. Add an output node and configure it to use the Tableau Online Output connector.

![A Data Prep output node configured with a Tableau Hyper output connection.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_tableau_output_recipe.png)

1. Select to write to an **Output Connection** (1).
2. Select the connection name of the Tableau Online Output connection you created (2).
3. Select the destination Tableau Online project as the Object Name (3). Projects available to the username used to create the output connector are listed.
4. Optionally, specify the .hyper file name in the Hyper File field. If you don't specify a file name, the file will is named Extract.hyper.
5. Select **Apply**.
6. Save the recipe.

Keep these behaviors in mind when working with the Tableau Online output connector and using a Data Prep recipe output node.

- You can use an output connection more than once per recipe, but each output node must use a different object. Each output node can use up to the connector's per-run limit independently, but is still subject to the rolling 24 hour limit.To push again from the same recipe, add another connection with the same credentials
- Output connections are only available for recipes built with Data Prep.
- The Free Trial version of Tableau Online isn’t supported by this connector.
- This connector requires the presence of your Tableau Online default project.
- The output file uses the column label as the header. All column labels must be unique, or the output fails and no data writes to Tableau Online. To customize column labels, add a transform node and use the Edit Attributes transformation.
- When a recipe runs, a new hyper file is created in Tableau Online if one doesn’t already exist. Tableau Online limits the initial file size to 64MB. Once the hyper file is present, subsequent runs of the recipe overwrite the existing file, and there is no file size limit for these overwrites.
- If a job run takes longer than 12 hours, the Tableau Online security token may reset and cancel the run. Before the 12th hour, to prevent reset of the security token, sign into Tableau Online with the credentials used to configure the connector.