Skip to main content
Version: v2

Tableau Canner Connector

Tableau Server / Desktop version support

Only versions above 2020.2 (inclusive) are currently supported.

You will learn

  1. How to use Canner Connector in Tableau Desktop
  2. How to configure Canner Connector in Tableau Server

Download Canner Enterprise Connector & Driver upload point

Tableau Desktop operation steps

Step 1: Install Canner Enterprise JDBC Driver

After downloading the Canner Enterprise JDBC Driver, follow the [official website instructions](https://help.tableau.com/current/pro/desktop/zh-tw/examples_otherdatabases_jdbc.htm#%E6%8C%87%E5%AE%9A% E6%AD%A3%E7%A2%BA%E7%9A%84-jdbc-%E9%A9%85%E5%8B%95%E7%A8%8B%E5%BC%8F) Canner, JDBC Driver placed under the indicated path

info

The JDBC driver is a separate jar file. Place the .jar file in a folder for your operating system. (If the folder does not exist, you must create a folder).

  • Windows: C:\Program Files\Tableau\Drivers
  • Mac: ~/Library/Tableau/Drivers
  • Linux: /opt/tableau/tableau_driver/jdbc

Step 2: Install Canner Connector (.taco)

After downloading Canner Connector (.taco), follow the [official website instructions](https://help.tableau.com/current/pro/desktop/zh-tw/examples_connector_sdk.htm#%E4%BD%BF%E7% 94%A8%E4%BB%A5-tableau-connector-sdk-%E7%B5%84%E4%BB%B6%E7%9A%84%E9%80%A3%E7%B7%9A%E5%99 %A8) placed under the indicated path

info

Place the .taco file in the following directory (default location):

for Tableau Desktop

  • Windows - C:\Users\[Windows users]\Documents\My Tableau Repository\Connectors
  • macOS - /Users/[user]/Documents/My Tableau Repository/Connectors

For Tableau Prep

  • Windows: C:\Users\[Windows Users]\Documents\My Tableau Prep Repository\Connectors
  • MacOS: /Users//Documents/My Tableau Prep Repository/Connectors

For web workflow on Tableau Server:

  • /data/tabsvc/flowqueryservice/Connectors

For Tableau Prep Conductor, on Tableau Server:

  • /data/tabsvc/flowprocessor/Connectors

For Tableau Server

  • C:\ProgramData\Tableau\Tableau Server\data\tabsvc\vizqlserver\Connectors

Step 3: Connect to Canner Enterprise

Canner Enterprise is visible in the list of sources tableau-connector-list

After selecting Canner Connector by Canner, fill in the login information and log in tableau-connector-sign-in

  • Server: Canner Server URL, IP address or Host, excluding http, https, Ex: my-canner.abc.com
  • Port: Support Https, use 443; if not, please use 80
  • Workspace: Please go to Config > SQL Name in the Workspace you want to connect to, and copy the SQL Name of the Workspace
  • Token: Paste Personal Access Token

The Workspace's tables on Canner Enterprise is then available in Tableau tableau-connector-screenshot

How to configure Canner Connector in Tableau Server

1. Create a folder (ex: /home/<user>/tableau_connectors), and put Canner Connector (.taco) under it

2. Use the command to set the path of the connector

tsm configuration set -k native_api.connect_plugins_path -v <path to folder created in step 1>

For example, using /home/<user>/tableau_connectors as folder would be

tsm configuration set -k native_api.connect_plugins_path -v /home/<user>/tableau_connectors

3. Place the JDBC Driver Place Canner Enterprise JDBC Driver under /opt/tableau/tableau_driver/jdbc

4. Apply changes

Apply changes to the Tableau server; this command will restart Tableau Server.

tsm pending-changes apply

Next, the Tableau reports connected to Canner Enterprise can be published to Tableau Server.