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​

info

Prepare Personal Access Token before use

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.