There are two methods available to connect Tableau with Jethro - DSN based connection (Recommended), and DSN-less connection. Both have the same prerequisites.

The following guide will explain what are the prerequisites, how to set a connection for each type of method, and what are the (small) differences between them:

Prerequisites

The following two steps are required to be made before opening a connection in Tableau:

  1. Install the JethroODBC driver (Instructions can be found here).
  2. Make sure the TDC file is in place. During the installation of JethroODBC (for Windows), the TDC file for Jethro should be placed automatically under the paths Tableau requires it to be put at. If for any reason the file is not there (or if your Tableau is not using Windows), you can copy the file jethro.tdc from the directory of JethroODBC (by default, C:\Program Files\JethroData\JethroODBC) to the target directory required according to your version of Tableau, as specified below.

Connecting using a DSN

  1. Define a DSN connection to your Jethro Instance using the ODBC Administrator (Instructions can be found here).
  2. Start Tableau Desktop.
  3. Under Connect > To a Server, click More….and choose Other Databases (ODBC).
  4. Under Connect using choose DSN, and select the Jethro DSN that you have defined from the drop-down list.


  5. Click Connect, and then click Sign In once the button is clickable (changed its color to orange).

Connecting using a DSN-less connection

  1. Start Tableau Desktop.
  2. Under Connect > To a Server, click More….and choose Other Databases (ODBC).
  3. Under Connect using choose Driver, and select JethroODBCDriver.



  4. Jethro Connection Dialog will show up. 
    Fill in the connection details of your Jethro Instance (Ignore the field 'Data Source'):



  5. Click OK, and than click Sign In.

The pros and cons of a DSN connection vs a DSN-less connection 

DSN based connection (Recommended)

Pros:

Cons:

DSN-less connection

Pros:

Cons: