KNOWLEDGE BASE

No Generic ODBC Available in Tableau Prep Builder


Published: 01 May 2018
Last modified date: 20 Jul 2023

Issue

Unable to connect to a database from Tableau Prep using the generic ODBC connector.

Environment

Tableau Prep 2018.1.1

Resolution

Option 1: 

Upgrade to Tableau Prep Builder 2019.2.1 or a newer version.  Click here for downloads of Tableau Prep: Tableau Prep Downloads and Release Notes. For more information on current releases, see Install Tableau Prep and Prep Upgrade.

Option 2:

Use the following workaround:
  1. Open Tableau Desktop and connect to the database using the generic ODBC connector.
  2. Create an extract of the data source and save it to a location on your machine.
  3. Use the resulting extract as input in Tableau Prep by selecting Connections > Tableau Extract.

Cause

Generic ODBC connections were added to Tableau Prep Builder 2019.2.1.  
 

Additional information

See the Tableau Prep technical specifications page for a list of the available and supported connectors.


Did this article resolve the issue?