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 Google Sheets 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/googlesheets is recommended, but the exact install location does not matter.
2. Copy cdata.tableau.googlesheets.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 Google Sheets 2024\lib\cdata.tableau.googlesheets.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.googlesheets.jar -l

This generates a license file called cdata.tableau.googlesheets.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:

OS	Java Package
Ubuntu	openjdk-8-jre-headless
Debian	openjdk-8-jre-headless
RHEL	java-1.8.0-openjdk
CentOS	java-1.8.0-openjdk
Fedora	java-1.8.0-openjdk
SUSE	java-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.googlesheets.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