Windsor.ai Tableau Connector Installation Guide

This guide helps you to get up and running with the Tableau connector for Windsor.ai. Follow the steps below to get started with importing data from more than 300 sources into Tableau.

Instructions

Prerequisites

Tableau Desktop version 2023.1 or later.

Important notes before you start

This Tableau connector is built using the V3 SDK of Tableau. Sadly Tableau decided to make connectors developed on this SDK – which is the latest they offer – extract only. What this means for you is that it allows you to visualize your data and publish your analysis like any other data source. However, to refresh the data, you must either do it manually in Tableau Desktop or use Tableau Server.

The Windsor.ai Tableau connector is compatible with all Tableau products, such as Tableau Desktop, Tableau Server, Tableau Prep, and Tableau Catalog.

Using Windsor.ai’s direct connection to Tableau may not be ideal for all situations, such as when working with large datasets exceeding 100K rows per flow or when performing complex SQL transformations. Refer to the table below to determine the best implementation for your specific needs.

Use CaseSolution
Personal DashboardUse the Windsor.ai Tableau Connector
Shared DashboardUse the Windsor.ai Tableau Connector  and configure Tableau Server
Shared Dashboard with complex or large data (e.g., complex SQL transformations or over 100K rows per table)First, use a database like BigQuery, Snowflake, Azure SQL, MySQL or PostgreSQL as your data destination. Then, use Tableau’s native connection to connect to the chosen database.

 

Installation of the connector

Ensure your Tableau version is at least 2023.1. If it’s not, please update it.

Instructions for Mac

  1. Download the Windsor.ai Connector Plugin file.
  2. Save the file to the appropriate location ~/Documents/My Tableau Repository/Connectors
  3. Restart your Tableau Desktop.

 

Method 1: Run Tableau from the Terminal with Disabled Plugin Configuration

Step 1: Find the Installation Path of Tableau Desktop

First, determine where Tableau Desktop is installed on your Mac. By default, it is usually in the Applications folder: /Applications/Tableau Desktop <version>.app. Replace <version> with the specific version of Tableau you have installed (for example, Tableau Desktop 2021.1.app).

Step 2: Open the Terminal

  1. Press Command + Space to open Spotlight Search.
  2. Type Terminal and press Enter to open the Terminal application.

Step 3: Execute the Command

Make sure to include quotes around the full path to the Tableau executable:

cd "/Applications/Tableau Desktop <version>.app/Contents/MacOS"
./tableau -DDisableVerifyConnectorPluginSignature=true

Replace <version> with your current installed version of Tableau.

 

Method 2 (recommended): Create an Alias for Terminal to Run Tableau with the Disabled Plugin Configuration

Step 1: Open the Terminal

  1. Press Command + Space to open Spotlight Search.
  2. Type Terminal and press Enter to open the Terminal application.

Step 2: Create an Alias

  1. Open your shell configuration file in a text editor. For example, if you are using bash, you would edit .bash_profile or .bashrc:
    nano ~/.bash_profile
  2. Add the following line to create an alias for running Tableau with the disabled plugin configuration:
    alias tableau-disable-signature='"/Applications/Tableau Desktop <version>.app/Contents/MacOS/tableau" -DDisableVerifyConnectorPluginSignature=true'

    Replace <version> with your installed version of Tableau.

  3. Save the file and exit the text editor (Ctrl + X to exit nano).

Step 3: Apply the Changes

  1. Reload the shell configuration file:
    source ~/.bash_profile

Step 4: Use the Alias

You can now use this alias to open Tableau with the desired configuration by typing:

tableau-disable-signature

This method allows you to easily open Tableau with the disabled plugin configuration without having to remember the full command each time.

Instructions for Windows

Step 1: Download the Windsor.ai Connector Plugin file.

Step 2: Save the file to the appropriate location:

C:\Users\[Windows User]\Documents\My Tableau Repository\Connectors

Step 3: Restart your Tableau Desktop.

 

Method 1: Run Tableau from the CLI with Disabled Plugin Configuration

  1. Find the Installation Path of Tableau Desktop:First, you need to know where Tableau Desktop is installed on your computer. By default, it is usually in a path like:
    C:\Program Files\Tableau\Tableau <version>\bin

    Replace <version> with the specific version of Tableau you have installed (for example, Tableau 2021.1).

  2. Open the Command Line:
    • Press Win + R to open the “Run” dialog box.
    • Type cmd and press Enter to open the command line.
  3. Execute the Command:Make sure to include quotes around the full path to the Tableau executable:
    cd "C:\Program Files\Tableau\Tableau <version>\bin"
    "tableau.exe" -DDisableVerifyConnectorPluginSignature=true

    Make sure you replace <version> with your currently installed version of Tableau.

 

Method 2 (recommended): Create a Shortcut on Your Desktop

If you prefer not to use the command line each time, create a shortcut with the following process:

  1. Create a New Shortcut:
      • Right-click on the desktop and select New > Shortcut.
      • In the location of the item, enter the path to the Tableau executable and add the configuration option. For example:
    "C:\Program Files\Tableau\Tableau <version>\bin\tableau.exe" -DDisableVerifyConnectorPluginSignature=true

    Replace <version> with your installed version of Tableau. For instance, if your Tableau version is 2024.1, you would insert the following:

    "C:\Program Files\Tableau\Tableau 2024.1\bin\tableau.exe" -DDisableVerifyConnectorPluginSignature=true
    • Click Next, give the shortcut a name (e.g., Tableau Disable Signature), and click Finish.
  2. Use the Shortcut:You can now use this shortcut to open Tableau with the desired configuration.

 

Usage of the connector

Defining your query

In the Windsor.ai Data Preview build your query and copy it as shown in the screenshot below

 

 

Now open Tableau and you should find Windsor.ai under “Connect to a Server” on the left-hand side, within the “More” section.

  1. Open Tableau Desktop.
  2. Click on the “Windsor.ai by Windsor.ai” connector located on the left side.
  3. Enter your connector URL you have in your clipboard and click “Connect”.
  4. The data will now be loaded into Tableau.