Tableau Load

image_pdfimage_print

This load type writes data from Jedox into a .hyper file for use with Tableau Software, e.g. Tableau Desktop. You can also publish the .hyper file directly to Tableau Server during the load.

Jedox Integrator supports Tableau 10.5 and later. For this load type, a Tableau Connector License and a connection to Tableau HyperFile is required.

Notes:

  • To use this component, the Visual C++ Redistributable Packages for Visual Studio 2013 must be installed on the system where Jedox is running. Tableau SDK and Tableau Extract API must be downloaded and unzipped, and the respective file path of the bin folders must be added to the system “path” variable. Please refer to Tableau’s documentation.
  • Logs can be read by adding environment variables TAB_SDK_LOGDIR and TAB_SDK_TMPDIR to the desired paths, if desired.
Main settings

Data Source

Jedox In-Memory DB file, extract, or transform

Tree format

See Overview of Tree Formats

Target Connection

A connection of type TDE file

Mode

The following modes are available:

create: Overwrites an existing .hyper file
add: Adds rows to an existing .hyper file

Publish to Tableau server

You can optionally publish the .hyper file directly to a Tableau Server. The name of the data source in Tableau will be identical to the the name of the file.

Tableau connection

A connection of type Tableau (required).

Tableau project

A project in the site of the Tableau Server. If not set, the default project will be used.

image_pdfimage_print