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 QuickBooks Online instead.

Install the Connector

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

Windows

1. Run the setup.exe installer. The driver JAR file will be 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 connnector 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/quickbooksonline is recommended, but the exact install location does not matter.
2. Copy cdata.tableau.quickbooksonline.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 connnector 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 QuickBooks Online 2022\lib\cdata.tableau.quickbooksonline.lic. Copy this file into C:\Program Files\Tableau\Drivers.

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

java -jar cdata.tableau.quickbooksonline.jar -l

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

If you cannot execute the java commmand, you will need to 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.quickbooksonline.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