Tableau Connector for WooCommerce

Build 24.0.9060

Tableau Server

Prerequisites

The connector supports Tableau Server 2020.1 or later. For earlier versions of Tableau Server, please use either the CData ODBC Driver or JDBC Driver for WooCommerce instead.

Install the Connector

After the prerequisites are satisfied, complete the following instructions depending upon your platform:

Windows

  1. Run the setup.exe installer. The driver JAR file is automatically placed in the drivers directory, C:\Program Files\Tableau\Drivers.
  2. Follow the instructions in the License the Connector section to license the connector within Tableau Server.
  3. Determine your Tableau Server installation directory (TableauServerRoot). This is usually C:\ProgramData\Tableau\Tableau Server.
  4. Follow the instructions in the Register with Tableau Server section to register the connector for use with published workbooks, as well as Tableau Prep Conductor and Tableau Prep Flow Authoring.

Linux

  1. Unpack the setup.zip archive. Creating a directory for the connector like /opt/cdata/woocommerce is recommended, but the exact install location does not matter.
  2. Copy cdata.tableau.woocommerce.jar from the lib directory into /opt/tableau/tableau_driver/jdbc.
  3. Follow the instructions in the License the Connector section to license the connector within Tableau Server.
  4. Determine your Tableau Server installation directory (TableauServerRoot). This is usually /var/opt/tableau/tableau_server.
  5. Follow the instructions in the Register with Tableau Server section to register the connector for use with published workbooks, as well as Tableau Prep Conductor and Tableau Prep Flow Authoring.

License The Connector

On Windows, the connector setup prompts for a product key and registers a license automatically. The license file is created at C:\Program Files\CData\CData Tableau Connector for WooCommerce 2024\lib\cdata.tableau.woocommerce.lic. Copy this file into C:\Program Files\Tableau\Drivers.

On Linux, you must run the licensing tool after the connector is unpacked. Navigate to the connector lib directory and run the following command to license the connector:

java -jar cdata.tableau.woocommerce.jar -l

This generates a license file called cdata.tableau.woocommerce.lic in the same directory. Copy this file into /opt/tableau/tableau_driver/jdbc.

If you cannot execute the java command, youmust install a Java runtime environment. The name of this package differs on Red Hat-based and Debian-based systems:

OSJava Package
Ubuntuopenjdk-8-jre-headless
Debianopenjdk-8-jre-headless
RHELjava-1.8.0-openjdk
CentOSjava-1.8.0-openjdk
Fedorajava-1.8.0-openjdk
SUSEjava-1_8_0-openjdk

You can substitute Java 8 with a later Java release as needed.

Register with Tableau Server

The connector must be registered with Tableau Server before it can be used with published workbooks or flows.

  1. Go to the lib folder in the connector install directory.
  2. Copy cdata.woocommerce.taco into TableauServerRoot/data/tabsvc/vizqlserver/Connectors.
  3. If you want to use the connector with Tableau Prep, copy that TACO file into these locations:
    • TableauServerRoot/data/tabsvc/flowprocessor/Connectors
    • TableauServerRoot/data/tabsvc/flowqueryservice/Connectors

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060