Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Alteryx makes it easy to publish your data source directly to Tableau Server. Publishing directly to Server means you won’t need to refresh your data extract.

Before you begin

  1. Make sure you have downloaded the Tableau Tools (which should include the Tableau Output Tool) from Alteryx Marketplace (these tools are free, but you are required to create an account to download those tools).

  2. Be sure your account is set up on Alteryx Server (to test this, login to https://alteryx.pitt.edu/gallery/ using your Pitt SSO credentials). If you do not yet have an account, submit a Help Desk ticket here to get added. Include in your request that you have a Designer license and plan to publish workflows to Alteryx Server.

Create a Personal Access Token

To authenticate to our Tableau Server, you should generate a Personal Access Token. Tokens cannot be used simultaneously. If a token is already in use when a new workflow calls it, the first action will be canceled. For this reason, we recommend you be sure to schedule workflows in sequence using the Runner, or simply set up separate personal access tokens for each data source refresh.

Steps to request a personal access token (PAT)

  1. Login to Tableau Server at https://analytics.pitt.edu and navigate to “My Account Settings” by clicking on the icon in the upper-right corner of your screen.

  2. About halfway down the page, there is a place to create a Personal Access Token. Be sure to save the Token Name and Secret. (The Secret will NOT be available once you close the initial window where it is generated; so be sure to save it.) Tokens will expire if they are not used for 15 consecutive days, and will expire after XX days otherwise.

tableau-PAT.gif

Token usage will be monitored by Pitt IT; if usage begins to impact Server Performance, your token may be revoked.

Log-on to Alteryx Server

Before setting up a connection, make sure you are connected to Alteryx Server. To do this, navigate to: File>>Open Workflow>>My Company’s Gallery.

add-a-new-server.png
add-alteryx-server.png

If you do not yet have your gallery set up, navigate to File>>Open Workflow>>Add New Server, and then enter https://analytics.pitt.edu/gallery/ as the URL (as shown on the screenshot on the right above).

In the next window, login using your Pitt credentials:

sso-login.png

After your login completes, a new window should pop-up with any workflows that you may have saved to Alteryx Server. You can close this window, as the login process is now complete.

Create a Data Source and Setup your Credentials

To setup your Data Source and Credentials, select Manage Data Connections from the File menu.

On the menu that pops-up, select “Add New Data Source” button in the upper-right corner of the screen.

connection-manager-1.png

On the next screen, select “Tableau Output” as the Technology.

add-data-source-1.png

On the next screen, fill-in:

  • the name your data source connection (any name you’d like).

  • the server url: https://analytics.pitt.edu/

  • the site: u

add-data-source-2.png

add-credentials-1.png

add-credentials-2.png

Once you have completed the server details, click “Save”. Next, you’ll want to create a credential. To do this, click on “Connect Credential” in the lower-right portion of the screen.

Notice that you can easily update or swap out your credentials here, and it will change across all Alteryx workflows that use them.

Setup the Tableau Output Tool

Sync Connection with Alteryx Server

Test your workflow on Alteryx Server

  • No labels