Pc Client Install Jdbc Driver For Mac

 

Tableau Desktop & Tableau Server: All supported versions

Linux, Unix, Windows 10, Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Windows Vista The following summarizes requirements. It will be important to see System Requirements for the JDBC Driver for more detail.

Follow these steps to install the Windows driver for Actian Matrix:

  1. Go to the Actian website and sign in.
  2. In the Select Via Product box, select the following:
    • Under Product: Actian Matrix Drivers
    • Under Release: ODBC
  3. In the list that displays, select the latest ODBC Driver for your platform and bit version.
  4. Download and install the driver.
Resources
Tableau Desktop & Tableau Server: All supported versions

Follow these steps to install the Windows driver for Actian Vector:

  1. Go to the Actian website and sign in.
  2. In the Select Via Product box, select the following:
    • Under Product: Actian Ingres Drivers
    • Under Release: ODBC
  3. In the list that displays, select the latest ODBC Driver for your platform and bit version.
  4. Download and install the drivers.
Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop & Tableau Server: 10.3 - 2019.2.3

Follow these steps to install the JDBC driver for Amazon Athena on your Windows computer:

  1. If Java is not already installed on your computer, download and install the latest Java 8 version (64-bit recommended) from https://java.com/en/download/manual.jsp.
  2. Download the JDBC driver (.jar file) from the Amazon Athena User Guide on Amazon's website.
  3. Move the downloaded .jar file to C:Program FilesTableauDrivers.
Resources
Tableau Desktop: 10.3 -2019.2.3

Follow these steps to install the JDBC driver for Amazon Athena on your Mac computer:

  1. Close Tableau Desktop.
  2. If Java is not already installed on your Mac, download and install the latest Java 8 version from https://www.java.com/en/download/manual.jsp.
  3. Download the JDBC driver (.jar file) from the Amazon Athena User Guide on Amazon's website.
  4. Copy the downloaded .jar file to the /Library/JDBC directory. You might have to create the JDBC directory if it doesn't already exist.
  5. Make sure that you have read permissions for the .jar file so that Tableau can access it.
  6. Open Tableau Desktop and connect to Amazon Athena.
Resources
Tableau Prep Builder: 2019.2.1 - 2019.2.3

Follow these steps to install the JDBC driver for Amazon Athena on your Mac computer:

  1. Close Tableau Prep Builder.
  2. If Java is not already installed on your Mac, download and install the latest Java 8 version from https://www.java.com/en/download/manual.jsp.
  3. Download the JDBC driver (.jar file) from the Amazon Athena User Guide on Amazon's website.
  4. Copy the downloaded .jar file to the /Library/JDBC directory. You might have to create the JDBC directory if it doesn't already exist.
  5. Make sure that you have read permissions for the .jar file so that Tableau can access it.
  6. Open Tableau Prep Builder and connect to Amazon Athena.
Resources

Follow these steps to install the JDBC driver for Amazon Athena on your Windows computer:

  1. If Java is not already installed on your computer, download and install the latest Java 8 version (64-bit recommended) from https://java.com/en/download/manual.jsp.
  2. Download the JDBC driver (.jar file) from the Amazon Athena User Guide on Amazon's website.
  3. Move the downloaded .jar file to C:Program FilesTableauDrivers.
Resources
Tableau Server: 10.5 - 2019.2.3

To install, follow the instructions below to download the driver, put it in the correct location, and set the appropriate permissions.

Note: The Amazon Athena driver is a JDBC driver so it doesn't require an odbc.ini file.

You can download the JDBC driver (.jar file) from the Amazon Athena User Guide on Amazon's website.

After you download the .jar file, copy it to this location on the Linux computer:

/opt/tableau/tableau_driver/jdbc

If the directory does not exist, create it and make sure it is readable by the 'tableau' user. To do this:

  1. Create the directory:

    sudo mkdir -p /opt/tableau/tableau_driver/jdbc

  2. Copy the downloaded driver file to the location, replacing [/path/to/file] with the path and [driver file name] with the name of the driver you downloaded:

    sudo cp [/path/to/file/][driver file name].jar /opt/tableau/tableau_driver/jdbc

  3. Set permissions so the file is readable by the 'tableau' user, replacing [driver file name] with the name of the driver you downloaded:

    sudo chmod 755 /opt/tableau/tableau_driver/jdbc/[driver file name].jar

Resources
Tableau Desktop: 9.3 - 2019.2.3

Amazon Aurora uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Go to the MySQL website.
  2. Select your operating system from the drop-down list.
  3. Select the bit version of the driver for your Windows environment.
  4. Download and install the driver.
Resources
Tableau Desktop: 9.0.4 - 2019.2.3

Amazon Aurora uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Mac driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Close Tableau Desktop.
  2. Install the iODBC Driver Manager, if it's not already installed on your Mac. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

    Note: You must install iODBC before you install the MySQL ODBC connector.

  3. Download and install the MySQL ODBC connector for your Mac OS X version:
    • Older versions:
      1. Select Version: 5.2.7
      2. Select Operating System: Mac OS X
      3. Select OS Version: Select the OS version for your Mac.

    For more information, see Installing Connector/ODBC on macOS on the Oracle website.

  4. Open Tableau Desktop and connect to Amazon Aurora.

Note: We strongly recommend that you upgrade to the latest MySQL ODBC driver because it contains fixes for an outdated OpenSSL library and other vulnerabilities. For more information, see the Security Bulletin.

Resources
Tableau Desktop: 9.0.4 - 9.2

Amazon Aurora uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. On the MySQL website, review the prerequisites for installing the Connector/ODBC drivers on Windows. Make sure the prerequisite software is installed on your computer.
  2. On the Download Connector/ODBC page, select the driver for your platform and bit version.
  3. Download and install the driver.
Resources
Tableau Prep Builder: All supported versions

Amazon Aurora uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Mac driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Close Tableau Prep Builder.
  2. Install the iODBC Driver Manager, if it's not already installed on your Mac. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

    Note: You must install iODBC before you install the MySQL ODBC connector.

  3. Download and install the MySQL ODBC connector for your Mac OS X version:
    • Older versions:
      1. Select Version: 5.2.7
      2. Select Operating System: Mac OS X
      3. Select OS Version: Select the OS version for your Mac.

    For more information, see Installing Connector/ODBC on OS X on the Oracle website.

  4. Open Tableau Prep Builder and connect to Amazon Aurora.

Note: We strongly recommend that you upgrade to the latest MySQL ODBC driver because it contains fixes for an outdated OpenSSL library and other vulnerabilities. For more information, see the Security Bulletin.

Resources

Amazon Aurora uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the 64-bit Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Go to the MySQL website.
  2. Select your operating system from the drop-down list.
  3. Select the 64-bit version of the driver.
  4. Download and install the driver.
Resources
Tableau Server: 10.5 - 2019.2.3

Amazon Aurora uses MySQL drivers. If you don't have the MySQL driver installed, you can get it from the MySQL website.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

Go to the MySQL website:

Select your operating system from the drop-down list. Select the 64-bit version of the driver.

  • On CentOS and RHEL, download the .rpm file and then run the following command:

    sudo yum install mysql-connector-odbc-[version].[architecture].rpm

  • On Ubuntu, download the TAR archive and then follow the instructions on the MySQL website:

After you install the driver, add these entries to the /etc/odbcinst.ini file, if they're not already there:

Resources
Tableau Server: 9.0.4 - 2019.2.3

Amazon Aurora uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. On the MySQL website, review the prerequisites for installing the Connector/ODBC drivers on Windows. Make sure the prerequisite software is installed on your computer.
  2. On the Download Connector/ODBC page, select the driver for your platform and bit version.
  3. Download and install the driver.
Resources
Tableau Desktop & Tableau Server: 8.2.7 - 8.2.x, 8.3.2 - 2019.2.3

Note: Beginning in version 2018.2, Tableau supports Amazon EMR Hadoop Hive only, not Impala. Amazon no longer provides Impala drivers.

Follow these steps to install the Windows drivers for Amazon EMR:

  1. Go to the Use Business Intelligence Tools with Amazon EMR page on the AWS website and select the AmazonHiveODBC_[version].zip link to download the file.
  2. Download and install the drivers.
Resources
Tableau Desktop: 8.2.7 - 8.2.x, 8.3.2 - 2019.2.3

Note: Beginning in version 2018.2, Tableau supports Amazon EMR Hadoop Hive only, not Impala. Amazon no longer provides Impala drivers.

Follow these steps to install the Amazon EMR Hive drivers on your Mac computer:

  1. Verify that you have ODBC Administrator installed. You can download it from Apple: https://support.apple.com/kb/DL895. Control-click to install the downloaded .dmg file.
  2. Go to the Use Business Intelligence Tools with Amazon EMR page on the AWS website and select the AmazonHiveODBC_[version].zip link to download the file.
  3. Double-click the downloaded file, and then navigate to and open the MacOSX folder.
  4. Double-click the AmazonHiveODBC.dmg file.
  5. Double-click the AmazonHiveODBC.pkg file and accept the defaults.
  6. From Finder, select Utilities, and then open ODBC Administrator.
  7. Select the Drivers tab, and then click Add.
  8. In the Description field, enter Amazon Hive ODBC Driver.
  9. In the Driver file field, choose or enter /opt/amazon/hiveodbc/lib/universal/libamazonhiveodbc.dylib.
  10. Click OK, click Apply, and then close the ODBC Administrator.
  11. Log out and then log in to your Mac.
  12. Open Tableau Desktop and connect to Amazon EMR.
Resources
Tableau Prep Builder: 2018.2.1 - 2019.2.3

Install the drivers for the Amazon EMR Hive installation on your Mac computer.

  1. Verify that you have ODBC Administrator installed. You can download it from Apple: https://support.apple.com/kb/DL895. Control-click to install the downloaded .dmg file.
  2. Go to the Use Business Intelligence Tools with Amazon EMR page on the AWS website and select the AmazonHiveODBC_[version].zip link to download the file.
  3. Double-click the downloaded file, and then navigate to and open the MacOSX folder.
  4. Double-click the AmazonHiveODBC.dmg file.
  5. Double-click the AmazonHiveODBC.pkg file and accept the defaults.
  6. From Finder, select Utilities, and then open ODBC Administrator.
  7. Select the Drivers tab, and then click Add.
  8. In the Description field, enter Amazon Hive ODBC Driver.
  9. In the Driver file field, choose or enter /opt/amazon/hiveodbc/lib/universal/libamazonhiveodbc.dylib.
  10. Click OK, click Apply, and then close the ODBC Administrator.
  11. Log out and then log in to your Mac.
  12. Open Tableau Prep Builder and connect to Amazon EMR.
Resources

Follow these steps to install the Windows drivers for Amazon EMR:

  1. Go to the Use Business Intelligence Tools with Amazon EMR page on the AWS website and select the AmazonHiveODBC_[version].zip link to download the file.
  2. Download and install the drivers.
Resources
Tableau Server: 10.5 - 2019.2.3

Follow the steps for your distro: CentOS and RHEL, or Ubuntu.

Beginning in version 2018.2, Tableau supports Amazon EMR Hadoop Hive only, not Impala. Amazon no longer provides Impala drivers.

Note: The current ODBC driver supports EL6 and earlier (CentOS/RHEL 6 and earlier).

For CentOS and RHEL

  1. Download and unzip the AmazonHiveODBC_1.1.1.1001.zip file available from Amazon's site:
  2. Go to AmazonHiveODBC_1.1.1.1001/Linux/EL6.
  3. Install dependencies by running the following command:

    sudo yum install cyrus-sasl-gssapi cyrus-sasl-plain cyrus-sasl

  4. Install the driver by running the following command:

    sudo rpm ––nodeps –ivh AmazonHiveODBC-1.1.1.1001-1.el6.x86_64.rpm

  5. Append the following lines to the /etc/odbcinst.ini file:
  6. To move the amazon.hiveodbc.ini file to the /etc directory, run the following command:

    sudo mv /opt/amazon/hiveodbc/lib/64/amazon.hiveodbc.ini /etc

  7. Modify the following values in the /etc/amazon.hiveodbc.ini file:

    From: DriverManagerEncoding=UTF-32 To: DriverManagerEncoding=UTF-16

    From: LogPath=[LogPath] To: LogPath=/tmp (optional)

    From: ODBCInstLib=libiodbcinst.so To: #ODBCInstLib=libiodbcinst.so

    From: #ODBCInstLib=libodbcinst.so To: ODBCInstLib=libodbcinst.so

Driver

Note: If /usr/lib64/libsasl2.so.2 doesn't exist, run the following command:

sudo ln -s /usr/lib64/libsasl2.so.3 /usr/lib64/libsasl2.so.2

The current driver package is for CentOS/RHEL 6, which has an older version of this library.

For Ubuntu

Follow steps above, except for steps 3 and 4:

  1. Install dependencies by running the following command:

    sudo apt-get install libsasl2-2

  1. Alienate the .rpm package, and then install it.

    sudo alien AmazonHiveODBC-1.1.1.1001-1.el6.x86_64.rpm

    sudo gdebi amazonhiveodbc_1.1.1.1001-2_amd64.deb

Resources
Tableau Desktop & Tableau Server: 8.2.9 - 8.2.x, 8.3.4 - 9.2.x

Follow these steps to install the Windows driver for Amazon Redshift:

  1. Go to the Amazon Web Services website.
  2. Follow the instructions To install the ODBC driver.

Note that you don't have to create a system DSN entry in order for the driver to work with Tableau.

Resources
  • Tuning your Amazon Redshift and Tableau Software Deployment for Better Performance (registration required)
  • Explore Big Data Analytics with Amazon Redshift (video—registration required)
Tableau Desktop & Tableau Server: 8.2.0 - 8.2.8, 8.3.0 - 8.3.3
Download windows 32 bit

Click the Download link and install the Windows 32-bit driver for Amazon Redshift.

Resources
  • Tuning your Amazon Redshift and Tableau Software Deployment for Better Performance (registration required)
  • Explore Big Data Analytics with Amazon Redshift (video—registration required)
Download windows 64 bit

Click the Download link and install the Windows 64-bit driver for Amazon Redshift.

Resources
  • Tuning your Amazon Redshift and Tableau Software Deployment for Better Performance (registration required)
  • Explore Big Data Analytics with Amazon Redshift (video—registration required)
Tableau Desktop: 10.2 - 2019.2.3

The Mac driver for Amazon Redshift is installed by default with Tableau Desktop.

Resources
  • Tuning your Amazon Redshift and Tableau Software Deployment for Better Performance (registration required)
  • Explore Big Data Analytics with Amazon Redshift (video—registration required)
Tableau Desktop: 9.3 - 2019.2.3

The Amazon Redshift driver for Windows is installed by default with Tableau Desktop 9.3 and later.

Resources
  • Tuning your Amazon Redshift and Tableau Software Deployment for Better Performance (registration required)
  • Explore Big Data Analytics with Amazon Redshift (video—registration required)
Tableau Desktop: 8.2.9 - 8.2.x, 8.3.4 - 10.1

Follow these steps to install the Mac driver for Amazon Redshift:

  1. Close Tableau Desktop.
  2. Download the AmazonRedshiftODBC.dmg file from the Amazon Redshift page on Amazon's documentation site.
  3. Double-click the downloaded AmazonRedshiftODBC.dmg file.
  4. Double-click the AmazonRedshiftODBC.pkg file, and then accept the defaults.
  5. Open Tableau Desktop and connect to Amazon Redshift.
Resources
  • Tuning your Amazon Redshift and Tableau Software Deployment for Better Performance (registration required)
  • Explore Big Data Analytics with Amazon Redshift (video—registration required)
Tableau Desktop: 8.2.0 - 8.2.8, 8.3.0 - 8.3.3
Download mac

Follow these steps to install the Mac driver for Amazon Redshift:

  1. Close Tableau Desktop.
  2. Download the drivers from the Download link.
  3. Double-click the downloaded file, TableauDrivers.dmg.
  4. Double-click Tableau PostgreSQL Libraries.
  5. Accept the defaults.
  6. Open Tableau Desktop and connect to Amazon Redshift.
Resources
  • Tuning your Amazon Redshift and Tableau Software Deployment for Better Performance (registration required)
  • Explore Big Data Analytics with Amazon Redshift (video—registration required)
Tableau Prep Builder: All supported versions

The Mac driver for Amazon Redshift is installed by default with Tableau Prep.

Resources

The Amazon Redshift driver for Windows is installed by default with Tableau Prep.

Resources
Tableau Server: 10.5 - 2019.2.3

Drivers are available from Amazon’s website at the following URL:

  • On CentOS and RHEL, download the .rpm file and then run the following command, with the correct driver version replacing [version]:

    sudo yum --nogpgcheck install AmazonRedshiftODBC-64bit-[version].x86_64.rpm

    For example:

    sudo yum --nogpgcheck install AmazonRedshiftODBC-64bit-1.2.7.1007-1.x86_64.rpm

  • On Ubuntu, download the 64-bit .deb file and then run the following command, with the correct driver version replacing [version]:

    sudo gdebi AmazonRedshiftODBC-64bit-[version].x86_64.deb

    For example:

    sudo gdebi AmazonRedshiftODBC-64bit-1.3.7.1000-1.x86_64.deb

Afterwards, on all distros, append the following to the /etc/odbcinst.ini file. Note: Be sure to use your driver name in the entry (in this example, [Amazon Redshift (x64)] is the driver name).

Then, modify the following values in the /opt/amazon/redshiftodbc/lib/64/amazon.redshiftodbc.ini file:

From: DriverManagerEncoding=UTF-32 To: DriverManagerEncoding=UTF-16

From: LogPath=[LogPath] To: LogPath=/tmp (optional)

From: ODBCInstLib=libiodbcinst.so To: #ODBCInstLib=libiodbcinst.so

From: #ODBCInstLib=libodbcinst.so To: ODBCInstLib=libodbcinst.so

Resources
Tableau Server: 9.3 - 2019.2.3

For Tableau Server, follow these steps to get the Windows driver for Amazon Redshift:

  1. Go to the Amazon Web Services website.
  2. Follow the instructions To install the ODBC driver.

Note that you don't have to create a system DSN entry in order for the driver to work with Tableau.

Resources
  • Tuning your Amazon Redshift and Tableau Software Deployment for Better Performance (registration required)
  • Explore Big Data Analytics with Amazon Redshift (video—registration required)
Tableau Desktop & Tableau Server: 10.1.2 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 10.1.2 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: 10.2 - 2019.2.3

Follow the instructions for installing the Drill ODBC driver on Windows, available on the Apache Drill website.

Note the following:

  • Apache Drill ODBC driver version 1.3.8 is not compatible with Tableau.
  • Starting in Tableau 10.2, you don't need to install or use a TDC file.
Resources
Tableau Desktop: 10.2 - 2019.2.3

Follow the instructions for installing the driver on Mac OS X, available on the Apache Drill website.

Note: Apache Drill ODBC driver version 1.3.8 is not compatible with Tableau.

Resources
Tableau Prep Builder: 2018.2.1 - 2019.2.3

Follow the instructions for installing the driver on Mac OS X, available on the Apache Drill website.

Note: Apache Drill ODBC driver version 1.3.8 is not compatible with Tableau.

Resources

Follow the instructions for installing the Drill ODBC driver on Windows, available on the Apache Drill website.

Note: Apache Drill ODBC driver version 1.3.8 is not compatible with Tableau.

Resources
Tableau Server: 2019.1 - 2019.2.3

Drivers are available from the MapR site:

  1. Download the .rpm file.
  2. To install the driver, run the following command.
    sudo yum install maprdrill-1.3.16.1049-1.x86_64.rpm
  3. After installing the driver package, append the following lines to the /etc/odbcinst.ini file, if they're not already there:
Resources
Tableau Desktop & Tableau Server: All supported versions

The Aster 5.x and later ODBC driver is required for Aster database 5.x and later. The Aster 4.6.3 ODBC driver is required for Aster database 4.6.x.

Follow these steps to install the Windows driver for Aster Database:

  1. Sign in to the Teradata website to access Aster drivers.
  2. Under Aster Client Tools for Windows, select the .zip file for your Windows environment: 32-bit or 64-bit.
  3. Download and install the drivers.
Resources
Tableau Desktop: 10.2 - 2019.2.3
Download mac

Follow these steps to install the Mac driver for Aster Database:

  1. Close Tableau Desktop.
  2. Download the drivers from the Download link.
  3. Click the downloaded file.
  4. Control-click the .pkg file, and then click Open > Open to run the installer.
  5. Accept the defaults.
  6. Open Tableau Desktop and connect to Aster Database.
Resources
Tableau Prep Builder: All supported versions
Download mac

Follow these steps to install the Mac driver for Aster Database:

  1. Close Tableau Prep.
  2. Download the drivers from the Download link.
  3. Click the downloaded file.
  4. Control-click the .pkg file, and then click Open > Open to run the installer.
  5. Accept the defaults.
  6. Open Tableau Prep and connect to Aster Database.
Resources

The Aster 5.x and later ODBC driver is required for Aster database 5.x and later. The Aster 4.6.3 ODBC driver is required for Aster database 4.6.x.

Follow these steps to install the Windows driver for Aster Database:

  1. Sign in to the Teradata website to access Aster drivers.
  2. Under Aster Client Tools for Windows, select the 64-bit .zip file.
  3. Download and install the drivers.
Resources
Tableau Desktop: 2019.1 - 2019.2.3

The Mac driver for Microsoft Azure SQL Data Warehouse is installed by default with Tableau Desktop.

Resources
Tableau Desktop: 2019.1- 2019.2.3

Azure SQL Data Warehouse uses the Microsoft SQL Server driver, which is installed by default.

Resources
Tableau Prep Builder: 2019.1.4 - 2019.2.3

The Mac driver for Microsoft Azure SQL Data Warehouse is installed by default with Tableau Prep Builder.

Resources

Azure SQL Data Warehouse uses the Microsoft SQL Server driver, which is installed by default.

Resources
Tableau Server: 2019.1 - 2019.2.3
Download windows 64 bit

Azure SQL Data Warehouse uses the Microsoft SQL Server driver. If that driver isn't already installed on your machine, click the Download link and install it.

Resources

Azure SQL Data Warehouse uses the Microsoft SQL Server driver. If that driver isn't already installed on your server, follow these steps to install it:

On CentOS and RHEL:

  1. Download the .rpm file.
  2. To install the driver, run the following command:

    sudo yum install tableau-freetds-1.00.40-1.x86_64.rpm

On Ubuntu:

  1. Download the .deb file.
  2. To install the driver, run the following command:

    sudo gdebi tableau-freetds_1.00.40_amd64.deb

Resources
Tableau Desktop & Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

Make sure you use the latest available drivers. Follow these steps to install the Windows driver on Cloudera Hadoop:

  1. Go to the Cloudera website and sign in.
  2. Under ODBC and JDBC Drivers, select the ODBC driver download for your environment (Hive or Impala).
  3. Select your operating system version.
  4. Download and install the drivers.

Note: Don't use Cloudera Impala ODBC driver v2.5.28. It's not compatible with Tableau.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: All supported versions

Make sure you use the latest available drivers. Follow these steps to install the Cloudera Hadoop Mac driver:

  1. Go to the Cloudera website and sign in.
  2. Under ODBC and JDBC Drivers, select the ODBC driver download for your environment (Hive or Impala).
  3. Select your operating system version.
  4. Download and install the drivers.

Note: Don't use Cloudera Impala ODBC driver v2.5.28. It's not compatible with Tableau.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: 2018.2.1 - 2019.2.3

Make sure you use the latest available drivers. Follow these steps to install the Cloudera Hadoop Mac driver:

  1. Go to the Cloudera website and sign in.
  2. Under ODBC and JDBC Drivers, select the ODBC driver download for your environment (Hive or Impala).
  3. Select your operating system version.
  4. Download and install the drivers.

Note: Don't use Cloudera Impala ODBC driver v2.5.28. It's not compatible with Tableau.

Resources

Make sure you use the latest available drivers. Follow these steps to install the Windows driver on Cloudera Hadoop:

  1. Go to the Cloudera website and sign in.
  2. Under ODBC and JDBC Drivers, select the ODBC driver download for your environment (Hive or Impala).
  3. Select Windows for the Operating System and 64 bit for the version.
  4. Download and install the drivers.

Note: Don't use Cloudera Impala ODBC driver v2.5.28. It's not compatible with Tableau.

Resources
Tableau Server: 10.5 - 2019.2.3

Follow the steps for your installation of Cloudera Hadoop: Hive or Impala.

Hive

Drivers are available from the Cloudera website:

To configure the driver for Tableau Server, follow these steps:

  1. Download and install the driver package.

  2. After installing the driver package, append the following lines to the /etc/odbcinst.ini file:

  3. Update the driver configuration file /opt/cloudera/hiveodbc/lib/64/cloudera.hiveodbc.ini

    Add or update the following parameter: DriverManagerEncoding=UTF-16

Note: The Cloudera manual might recommend setting various environment variables, but this isn't required.

Impala

Drivers are available from the Cloudera website:

To configure the driver for Tableau Server:

  1. Download and install the driver package.

  2. After installing the driver package, append the following lines to the /etc/odbcinst.ini file:

  3. Update the driver configuration file /opt/cloudera/impalaodbc/lib/64/cloudera.impalaodbc.ini

    Add or update the following parameter: DriverManagerEncoding=UTF-16

Note: The Cloudera manual might recommend setting various environment variables, but this isn't required.

Resources
Tableau Desktop & Tableau Server: 8.2 - 10.3

Note: Starting in 10.4, Tableau no longer supports the DataStax Enterprise connector.

Follow these steps to install the Windows driver for DataStax Enterprise:

  1. Go to the DataStax website.
  2. Under Loaders and ODBC/JDBC Drivers, select the driver for your environment.
  3. Download and install the driver.
Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop & Tableau Server: 10.4 - 2019.2.3

Denodo uses the PostgreSQL driver, which is installed by default with Tableau Desktop and Tableau Server. The PostgreSQL driver version automatically installed is 9.6.5, which currently doesn't work with Denodo. See the note below for alternatives.

To connect Tableau to Denodo, apply update 20170515 to the Denodo 6.0 database. For more information about update 20170515 for Denodo 6.0, see the Denodo website. (Sign in required.)

Note: The PostgreSQL driver version 9.6.5 currently doesn't work with Denodo. Some alternatives you can try include:

  • Update Virtual DataPort to use the PostgreSQL 9.6.5 driver. By default, the ODBC driver provided by Virtual DataPort is based on the ODBC PostgreSQL driver version 09.03.
  • Use the Denodo driver. See Install the ODBC Driver on Windows on the Denodo website.
  • Use an earlier version of the PostgreSQL library to connect (9.3).
Resources
Tableau Desktop: 10.4 - 2019.2.3

Denodo uses the PostgreSQL driver, which is installed by default with Tableau Desktop. The PostgreSQL driver version automatically installed is 9.6.5, which currently doesn't work with Denodo. See the note below for alternatives.

If you can't connect to PostgreSQL, install the iODBC Driver Manager and then try connecting again. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

To connect Tableau Prep to Denodo, apply update 20170515 to the Denodo 6.0 database. For more information about update 20170515 for Denodo 6.0, see the Denodo website. (Sign in required.)

Note: The PostgreSQL driver version 9.6.5 currently doesn't work with Denodo. Some alternatives you can try include:

  • Update Virtual DataPort to use the PostgreSQL 9.6.5 driver. By default, the ODBC driver provided by Virtual DataPort is based on the ODBC PostgreSQL driver version 09.03.
  • Use an earlier version of the PostgreSQL library to connect (9.3).
Resources
Tableau Prep Builder: All supported versions

Denodo uses the PostgreSQL driver, which is installed by default with Tableau Prep. The PostgreSQL driver version automatically installed is 9.6.5, which currently doesn't work with Denodo. See the note below for alternatives.

If you can't connect to PostgreSQL, install the iODBC Driver Manager and then try connecting again. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

To connect Tableau Prep to Denodo, apply update 20170515 to the Denodo 6.0 database. For more information about update 20170515 for Denodo 6.0, see the Denodo website. (Sign in required.)

Note: The PostgreSQL driver version 9.6.5 currently doesn't work with Denodo. Some alternatives you can try include:

  • Update Virtual DataPort to use the PostgreSQL 9.6.5 driver. By default, the ODBC driver provided by Virtual DataPort is based on the ODBC PostgreSQL driver version 09.03.
  • Use an earlier version of the PostgreSQL library to connect (9.3).
Resources

Denodo uses the PostgreSQL driver, which is installed by default with Tableau Prep. The PostgreSQL driver version automatically installed is 9.6.5, which currently doesn't work with Denodo. See the note below for alternatives.

To connect Tableau Prep to Denodo, apply update 20170515 to the Denodo 6.0 database. For more information about update 20170515 for Denodo 6.0, see the Denodo website. (Sign in required.)

Note: The PostgreSQL driver version 9.6.5 currently doesn't work with Denodo. Some alternatives you can try include:

  • Update Virtual DataPort to use the PostgreSQL 9.6.5 driver. By default, the ODBC driver provided by Virtual DataPort is based on the ODBC PostgreSQL driver version 09.03.
  • Use the Denodo driver. See Install the ODBC Driver on Windows on the Denodo website.
  • Use an earlier version of the PostgreSQL library to connect (9.3).
Resources
Tableau Server: 2018.3 - 2019.2.3

Denodo uses the PostgreSQL driver. If you don't have the PostgreSQL driver installed, follow these instructions to download and install the Linux 64-bit driver for Tableau Server. The PostgreSQL driver version you download is version 9.6.5, which currently doesn't work with Denodo. See the note below for alternatives.

On CentOS and RHEL:

  1. Download the .rpm file.
  2. To install the driver, run the following command:

    sudo yum install tableau-postgresql-odbc-09.06.0500-1.x86_64.rpm

On Ubuntu:

  1. Download the .deb file.
  2. To install the driver, run the following command:

    sudo gdebi tableau-postgresql-odbc_09.06.0500-2_amd64.deb

Note: The PostgreSQL driver version 9.6.5 currently doesn't work with Denodo. Some alternatives you can try include:

  • Update Virtual DataPort to use the PostgreSQL 9.6.5 driver. By default, the ODBC driver provided by Virtual DataPort is based on the ODBC PostgreSQL driver version 09.03.
  • Use the Denodo driver. See Install the ODBC Driver on Linux on the Denodo website.
  • Use an earlier version of the PostgreSQL library to connect (9.3).
Resources
Tableau Desktop & Tableau Server: 10.3 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 10.3 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

Follow these steps to install the Windows driver for Exasol:

  1. Go to Downloads on the Exasol website.
  2. Download and install the latest ODBC driver for your Windows environment (x86.msi or x86_64.msi).
Resources
  • Expert Opinion: How to Analyze Big Data in Tableau (Registration required on Exasol website.)
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: All supported versions

Follow these steps to install the Mac driver for Exasol:

  1. Close Tableau Desktop.
  2. Go to Downloads on the Exasol website.
  3. Download the latest ODBC driver for macOS.
  4. Double-click the downloaded .dmg file.
  5. Double-click Click to install to install the driver.
  6. Open Tableau Desktop and connect to Exasol.
Resources
  • Expert Opinion: How to Analyze Big Data in Tableau (Registration required on Exasol website.)
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: All supported versions

Follow these steps to install the Mac driver for Exasol:

  1. Close Tableau Prep Builder.
  2. Go to Downloads on the Exasol website.
  3. Download the latest ODBC driver for macOS.
  4. Double-click the downloaded .dmg file.
  5. Double-click Click to install to install the driver.
  6. Open Tableau Prep Builder and connect to Exasol.
Resources

Follow these steps to install the Windows driver for Exasol:

  1. Go to Downloads on the Exasol website.
  2. Download and install the latest x86_64.msi ODBC driver.
Resources
Tableau Server: 2018.1 - 2019.2.3

Drivers are available from the Exasol website:

  1. Download and extract the ODBC driver tar file for Linux.
  2. Run the copy command to copy the driver to /opt/exasol. (You may need to create the folder if it doesn’t already exist.) Replace [file name] with the file name of the driver you downloaded, for example, libexaodbc-uo2214lv2.so.

    cp lib/linux/x86_64/[file name]/opt/exasol

  3. On all distros, append the following section to the /etc/odbcinst.ini file:
Resources
Tableau Desktop & Tableau Server: All supported versions

You don't have to install a driver.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: All supported versions

You don't have to install a driver.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: 2019.1 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 2019.1 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Server: 2019.1 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

You don't have to install a driver.

Resources
  • 5 Tips to Get More from Google Analytics (registration required)
Tableau Desktop: All supported versions

You don't have to install a driver.

Resources
  • 5 Tips to Get More from Google Analytics (registration required)
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

You don't have to install a driver.

Resources
  • Google BigQuery & Tableau: Best Practices (registration required)
Tableau Desktop: All supported versions

You don't have to install a driver.

Resources
  • Google BigQuery & Tableau: Best Practices (registration required)
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 9.3 - 2019.2.3

Google Cloud SQL uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the 64-bit Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Go to the MySQL website.
  2. Select your operating system from the drop-down list.
  3. Select the 64-bit version of the driver.
  4. Download and install the driver.
Resources
Tableau Desktop: 8.2 - 9.2

Google Cloud SQL uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. On the MySQL website, review the prerequisites for installing the Connector/ODBC drivers on Windows. Make sure the prerequisite software is installed on your computer.
  2. On the Download Connector/ODBC page, select the driver for your platform and bit version.
  3. Download and install the driver.
Resources
Tableau Desktop: All supported versions

Google Cloud SQL uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Mac driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Close Tableau Desktop.
  2. Install the iODBC Driver Manager, if it's not already installed on your Mac. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

    Note: You must install iODBC before you install the MySQL ODBC connector.

  3. Download and install the MySQL ODBC connector for your Mac OS X version:
    • Older versions:
      1. Select Version: 5.2.7
      2. Select Operating System: Mac OS X
      3. Select OS Version: Select the OS version for your Mac.

    For more information, see Installing Connector/ODBC on OS X on the Oracle website.

  4. Open Tableau Desktop and connect to Google Cloud SQL.

Note: We strongly recommend that you upgrade to the latest MySQL ODBC driver because it contains fixes for an outdated OpenSSL library and other vulnerabilities. For more information, see the Security Bulletin.

Resources
Tableau Prep Builder: All supported versions

Google Cloud SQL uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Mac driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Close Tableau Prep Builder.
  2. Install the iODBC Driver Manager, if it's not already installed on your Mac. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

    Note: You must install iODBC before you install the MySQL ODBC connector.

  3. Download and install the MySQL ODBC connector for your Mac OS X version:
    • Older versions:
      1. Select Version: 5.2.7
      2. Select Operating System: Mac OS X
      3. Select OS Version: Select the OS version for your Mac.

    For more information, see Installing Connector/ODBC on OS X on the Oracle website.

  4. Open Tableau Prep Builder and connect to Google Cloud SQL.

Note: We strongly recommend that you upgrade to the latest MySQL ODBC driver because it contains fixes for an outdated OpenSSL library and other vulnerabilities. For more information, see the Security Bulletin.

Resources

Google Cloud SQL uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the 64-bit Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Go to the MySQL website.
  2. Select your operating system from the drop-down list.
  3. Select the 64-bit version of the driver.
  4. Download and install the driver.
Resources
Tableau Server: 10.5 - 2019.2.3

Google Cloud SQL uses the MySQL driver. If you don't have the MySQL driver installed, you can get it from the MySQL website.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

Go to the MySQL website:

Select your operating system from the drop-down list. Select the 64-bit version of the driver.

  • On CentOS and RHEL, download the .rpm file and then run the following command:

    sudo yum install mysql-connector-odbc-[version].[archictecture].rpm

  • On Ubuntu, download the TAR archive and then follow the instructions on the MySQL website:

After you install the driver, add these entries to the /etc/odbcinst.ini file, if they're not already there:

Resources
Tableau Server: All supported versions

Google Cloud SQL uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. On the MySQL website, review the prerequisites for installing the Connector/ODBC drivers on Windows. Make sure the prerequisite software is installed on your computer.
  2. On the Download Connector/ODBC page, select the driver for your platform and bit version.
  3. Download and install the driver.
Resources
Tableau Desktop & Tableau Server: 2019.1 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 2019.1 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Server: 2019.1 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

Make sure you use the latest available drivers. Follow these steps to install the Hortonworks Hadoop Hive driver on your Windows computer:

  1. Go to the Hortonworks website.
  2. Under Hortonworks ODBC Driver for Apache Hive, select the driver for your Windows bit-version environment.
  3. Download and install the driver.
Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: All supported versions

Make sure you use the latest available drivers. Follow these steps to install the Mac driver for Hortonworks Hadoop Hive:

  1. Close Tableau Desktop.
  2. Go to the Hortonworks website.
  3. Under Hortonworks ODBC Driver for Apache Hive, download the driver for OS X.
  4. Click Documentation to open the Hortonworks Hive ODBC Driver with SQL Connector User Guide, and follow the instructions in the topic 'Installing the Driver' in the Mac OS X Driver section.
  5. Open Tableau Desktop and connect to Hortonworks.
Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: 2018.2.1 - 2019.2.3

Make sure you use the latest available drivers. Follow these steps to install the Mac driver for Hortonworks Hadoop Hive:

  1. Close Tableau Prep Builder.
  2. Go to the Hortonworks website.
  3. Under Hortonworks ODBC Driver for Apache Hive, download the driver for OS X.
  4. Click Documentation to open the Hortonworks Hive ODBC Driver with SQL Connector User Guide, and follow the instructions in the topic 'Installing the Driver' in the Mac OS X Driver section.
  5. Open Tableau Prep Builder and connect to Hortonworks.
Resources
Tableau Prep Builder: 2018.2.1 - 2019.2.3

Make sure you use the latest available drivers. Follow these steps to install the Hortonworks Hadoop Hive driver on your Windows computer:

  1. Go to the Hortonworks website.
  2. Under Hortonworks ODBC Driver for Apache Hive, select the 64-bit driver for Windows.
  3. Download and install the driver.
Resources

Jdbc Driver For Windows 10

Tableau Server: 10.5 - 2019.2.3

Drivers are available from the Hortonworks website:

  1. Download the 64-bit driver for your distribution under Hortonworks ODBC Driver for Apache Hive.
  2. To install the driver, follow the instructions in the documentation, which is available from the Hortonworks download site.
  3. After you install the driver, append the following lines to the /etc/odbcinst.ini file, modifying the path to the driver if needed:
Resources
Tableau Desktop & Tableau Server: 8.2.3 - 10.4
Download windows 32 bit

Click the Download link and install the Windows 32-bit driver for IBM BigInsights.

Resources
Tableau Desktop & Tableau Server: 8.2.3 - 2019.2.3
Download windows 64 bit

Click the Download link and install the Windows 64-bit driver for IBM BigInsights.

Resources
Tableau Prep Builder: All supported versions
Download windows 64 bit

Click the Download link and install the Windows 64-bit driver for IBM BigInsights.

Resources
Tableau Desktop & Tableau Server: All supported versions
Download windows 32 bit

You can use this connector to connect to an IBM DB2 for z/OS database or to IBM dashDB.

Click the Download link and install the Windows 32-bit driver for IBM DB2.

Resources
  • Connecting Tableau to dashDB article on the IBM website.
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

You can use this connector to connect to an IBM DB2 for z/OS database or to IBM dashDB.

Click the Download link and install the Windows 64-bit driver for IBM DB2.

Resources
  • Connecting Tableau to dashDB article on the IBM website.
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: All supported versions
Download windows 64 bit

You can use this connector to connect to an IBM DB2 for z/OS database or to IBM dashDB.

Click the Download link and install the Windows 64-bit driver for IBM DB2.

Resources
Tableau Server: 10.5 - 2019.2.3
Download linux 64 bit

Click the Download link to download the tar file, then extract the contents with the following command:

sudo tar -C /opt/db2 -xzvf ~/Downloads/v11.1.3fp3a_linuxx64_odbc_cli.tar.gz.

Then, on all distros, append the following section to the /etc/odbcinst.ini file:

Resources
  • Installing the Db2 driver package on Linux or PowerLinux article on the IBM website
Tableau Desktop & Tableau Server: All supported versions

Contact your Netezza account team.

Resources
Tableau Prep Builder: All supported versions

Contact your Netezza account team.

Resources
Tableau Desktop & Tableau Server: 10.0 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

You don't have to install a driver.

Resources
Tableau Desktop: All supported versions

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: 9.3.1 - 10.4
Download windows 32 bit

Click the Download link and install the Windows 32-bit driver for Kognitio.

Resources
Tableau Desktop & Tableau Server: 9.3.1 - 2019.2.3
Download windows 64 bit

Click the Download link and install the Windows 64-bit driver for Kognitio.

Resources
Tableau Desktop: 9.3.1 - 2019.2.3
Download mac

Follow these steps to install the Mac driver for Kognitio:

  1. Close Tableau Desktop.
  2. Download the drivers from the Download link.
  3. Click the downloaded file.
  4. Control-click Kognitio-ODBC-80101s160113.pkg, and then click Open > Open to run the installer.
  5. Accept the defaults.
  6. Open Tableau Desktop and connect to Kognitio.
Resources
Tableau Prep Builder: All supported versions
Download mac

Follow these steps to install the Mac driver for Kognitio:

  1. Close Tableau Prep Builder.
  2. Download the drivers from the Download link.
  3. Click the downloaded file.
  4. Control-click Kognitio-ODBC-80101s160113.pkg, and then click Open > Open to run the installer.
  5. Accept the defaults.
  6. Open Tableau Prep Builder and connect to Kognitio.
Resources
Download windows 64 bit

Click the Download link and install the Windows 64-bit driver for Kognitio.

Resources
Tableau Desktop & Tableau Server: All supported versions

Make sure you use the latest available drivers. Follow these steps to install the Windows driver for MapR Hadoop Hive:

  1. On the MapR doc website, go to Install the Hive ODBC Connector on Windows. The instructions provide a link to download the driver package.
  2. Download the package for your Windows environment.
  3. Follow the instructions for installing the ODBC connector.
Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: All supported versions

Make sure you use the latest available drivers. Follow these steps to install the Mac driver for MapR Hadoop Hive:

  1. Close Tableau Desktop.
  2. Go to the 'Installing the Hive ODBC Connector on MacOS' section on the MapR Hive ODBC Connector web page.
  3. Click the link in the 'Systems Requirements' section to download the MacOS Hive ODBC connector.
  4. Double-click the downloaded MapRHiveODBC.dmg file.
  5. Control-click the MapRHiveODBC.pkg and then click Open to run the package. Accept the defaults.
  6. Open Tableau Desktop and connect to MapR Hadoop Hive.
Resources
  • For information about supported database versions, see Technical Specifications.

Pc Client Install Jdbc Driver For Mac

Tableau Prep Builder: 2018.2.1 - 2019.2.3

Make sure you use the latest available drivers. Follow these steps to install the Mac driver for MapR Hadoop Hive:

  1. Close Tableau Prep Builder.
  2. Go to the 'Installing the Hive ODBC Connector on MacOS' section on the MapR Hive ODBC Connector web page.
  3. Click the link in the 'Systems Requirements' section to download the MacOS Hive ODBC connector.
  4. Double-click the downloaded MapRHiveODBC.dmg file.
  5. Control-click the MapRHiveODBC.pkg and then click Open to run the package. Accept the defaults.
  6. Open Tableau Prep Builder and connect to MapR Hadoop Hive.
Resources

Make sure you use the latest available drivers. Follow these steps to install the Windows driver for MapR Hadoop Hive:

  1. On the MapR doc website, go to Install the Hive ODBC Connector on Windows. The instructions provide a link to download the driver package.
  2. Download the package for the 64-bit Windows environment.
  3. Follow the instructions for installing the ODBC connector.
Resources
Tableau Desktop & Tableau Server: 2019.1 - 2019.2.3

MariaDB ODBC drivers are available to download from the MariaDB website.

  1. Select the Product: ODBC connector.
  2. Select the latest GA Version.
  3. Select the OS: MS Windows 64-bit.
  4. Select Download, and then follow the prompts to install the driver.
Resources
Tableau Desktop: 2019.1 - 2019.2.3

MariaDB ODBC drivers are available to download from the MariaDB website.

  1. Select the Product: ODBC connector.
  2. Select the latest GA Version.
  3. Select the OS: MacOS.
  4. Select Download, and then follow the prompts to install the driver.
Resources
Tableau Prep Builder: 2019.1.4 - 2019.2.3

MariaDB ODBC drivers are available to download from the MariaDB website.

  1. Select the Product: ODBC connector.
  2. Select the latest GA Version.
  3. Select the OS: MacOS.
  4. Select Download, and then follow the prompts to install the driver.
Resources

MariaDB ODBC drivers are available to download from the MariaDB website.

  1. Select the Product: ODBC connector.
  2. Select the latest GA Version.
  3. Select the OS: MS Windows 64-bit.
  4. Select Download, and then follow the prompts to install the driver.
Resources
Tableau Server: 2019.1 - 2019.2.3

MariaDB ODBC drivers are available to download from the MariaDB website.

  1. Select the Product: ODBC connector.
  2. Select the latest GA Version.
  3. Select the OS: RHEL7 64-bit.
  4. Select Download to download the file.
  5. To install the driver, follow the Installation instructions on the MariaDB website.
Resources
Tableau Desktop & Tableau Server: 10.0.1 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 10.0.1 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: 8.2.3 - 10.4
Download windows 32 bit

Click the Download link and install the Windows 32-bit driver for MarkLogic.

Resources
Tableau Desktop & Tableau Server: 8.2.3 - 2019.2.3
Download windows 64 bit

Click the Download link and install the Windows 64-bit driver for MarkLogic.

Resources
Tableau Prep Builder: All supported versions
Download windows 64 bit

Click the Download link and install the Windows 64-bit driver for MarkLogic.

Resources
Tableau Desktop: 10.0 - 2019.2.3

MemSQL uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Mac driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Close Tableau Desktop.
  2. Install the iODBC Driver Manager, if it's not already installed on your Mac. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

    Note: You must install iODBC before you install the MySQL ODBC connector.

  3. Download and install the MySQL ODBC connector for your Mac OS X version:
    • Older versions:
      1. Select Version: 5.2.7
      2. Select Operating System: Mac OS X
      3. Select OS Version: Select the OS version for your Mac.

    For more information, see Installing Connector/ODBC on OS X on the Oracle website.

  4. Open Tableau Desktop and connect to MemSQL.

Note: We strongly recommend that you upgrade to the latest MySQL ODBC driver because it contains fixes for an outdated OpenSSL library and other vulnerabilities. For more information, see the Security Bulletin.

Resources

MemSQL uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Go to the MySQL website.
  2. Select your operating system from the drop-down list.
  3. Select the correct bit version of the driver for your Windows environment.
  4. Download and install the driver.
Resources
Tableau Prep Builder: All supported versions

MemSQL uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Mac driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Close Tableau Prep Builder.
  2. Install the iODBC Driver Manager, if it's not already installed on your Mac. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

    Note: You must install iODBC before you install the MySQL ODBC connector.

  3. Download and install the MySQL ODBC connector for your Mac OS X version:
    • Older versions:
      1. Select Version: 5.2.7
      2. Select Operating System: Mac OS X
      3. Select OS Version: Select the OS version for your Mac.

    For more information, see Installing Connector/ODBC on OS X on the Oracle website.

  4. Open Tableau Prep Builder and connect to MemSQL.

Note: We strongly recommend that you upgrade to the latest MySQL ODBC driver because it contains fixes for an outdated OpenSSL library and other vulnerabilities. For more information, see the Security Bulletin.

Resources

MemSQL uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Go to the MySQL website.
  2. Select your operating system from the drop-down list.
  3. Select the 64-bit version of the driver.
  4. Download and install the driver.
Resources
Tableau Server: 2018.1 - 2019.2.3

MemSQL uses MySQL drivers. If you don't have the MySQL driver installed, you can get it from the MySQL website.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

Go to the MySQL website:

Select your operating system from the drop-down list. Select the 64-bit version of the driver.

  • On CentOS and RHEL, download the .rpm file and then run the following command:

    sudo yum install mysql-connector-odbc-[version].[archictecture].rpm

  • On Ubuntu, download the TAR archive and then follow the instructions on the MySQL website:

After you install the driver, add these entries to the /etc/odbcinst.ini file, if they're not already there:

Resources
Tableau Server: 10.0 - 2019.2.3

MemSQL uses MySQL drivers. If you don't have MySQL drivers installed, follow the steps to install the Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. On the MySQL website, review the prerequisites for installing the Connector/ODBC drivers on Windows. Make sure the prerequisite software is installed on your computer.
  2. On the Download Connector/ODBC page, select the driver for your platform and bit version.
  3. Download and install the driver.
Resources
Tableau Desktop & Tableau Server: All supported versions

Tableau uses the drivers installed by Microsoft Office if the bit version of Tableau and Microsoft Office match (that is, installed versions of Tableau and Office are both 32-bit or both 64-bit). If the bit versions match, you don't have to install any additional drivers.

However, you must download and install Microsoft Access Database Engine if one of the following conditions is true:

  • You do not have Microsoft Office installed.
  • You have Microsoft Office installed, but the bit version of Microsoft Office does not match the bit version of Tableau.
Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: 2018.2.2 - 2019.2.3

You must download and install the 64-bit version of Microsoft Access Database Engine if it's not already installed.

Note: If you have a 32-bit version installed, you must uninstall it before you install the 64-bit version.

Resources
Tableau Desktop & Tableau Server: All supported versions

Install the drivers for your 32-bit version of Microsoft Analysis Services:

2014 SP1 (version 12.0.2000.8)

  • Download and install the SQL_AS_OLEDB driver from the Tableau website.
  • You might also need to install 32-bit Microsoft Core XML Services (MSXML) 6.0.

2012 SP1 (version 11.0.2100.60)

  • Download and install the SQL_AS_OLEDB driver from the Tableau website.
  • You might also need to install 32-bit Microsoft Core XML Services (MSXML) 6.0.

2008 R2 (version 10.51.2500.0)

  • Download and install the SQLSERVER2008_ASOLEDB10 driver from the Tableau website.
  • You might also need to install 32-bit Microsoft Core XML Services (MSXML) 6.0 .

2008

  • Download and install the SQLSERVER2008_ASOLEDB10 driver from the Tableau website.
  • You might also need to install 32-bit Microsoft Core XML Services (MSXML) 6.0.

2005

  • Download and install the SQLSERVER2005_ASOLEDB9 driver from the Tableau website.
  • You might also need to install 32-bit Microsoft Core XML Services (MSXML) 6.0.
Resources
  • For information about supported database versions, see Technical Specifications.

Install the drivers for your 64-bit version of Microsoft Analysis Services:

2014 SP1 (version 12.0.2000.8)

  • Download and install the SQL_AS_OLEDB driver from the Tableau website.
  • You might also need to install 64-bit Microsoft Core XML Services (MSXML) 6.0.

2012 SP1 (version 11.0.2100.60)

  • Download and install the SQL_AS_OLEDB driver from the Tableau website.
  • You might also need to install 64-bit Microsoft Core XML Services (MSXML) 6.0.

2008 R2 (version 10.51.2500.0)

  • Download and install the SQLSERVER2008_ASOLEDB10 driver from the Tableau website.
  • You might also need to install 64-bit Microsoft Core XML Services (MSXML) 6.0.

2008

  • Download and install the SQLSERVER2008_ASOLEDB10 driver from the Tableau website.
  • You might also need to install 64-bit Microsoft Core XML Services (MSXML) 6.0.

2005

  • Download and install the SQLSERVER2005_ASOLEDBB9 driver from the Tableau website.
  • You might also need to install 64-bit Microsoft Core XML Services (MSXML) 6.0.
Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop & Tableau Server: All supported versions

Tableau uses the drivers installed by Microsoft Office to connect to Excel files if the bit version of Tableau and Microsoft Office match (that is, installed versions of Tableau and Office are both 32-bit or both 64-bit). If the bit versions match, you don't have to install any additional drivers.

However, to connect Tableau to Excel, you must download and install Microsoft Access Database Engine if one of the following conditions is true:

  • You do not have Microsoft Office installed.
  • You have Microsoft Office installed, but the bit version of Microsoft Office does not match the bit version of Tableau.
Resources
  • Data Prep with Text and Excel Files (video—registration required)
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: All supported versions

You don't have to install a driver.

Resources
  • Data Prep with Text and Excel Files (video—registration required)
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: All supported versions

You don't have to install a driver.

Resources

Tableau uses the drivers installed by Microsoft Office to connect to Excel files if the bit version of Tableau and Microsoft Office match (that is, installed versions of Tableau and Office are both 64-bit). If the bit versions match, you don't have to install any additional drivers.

However, to connect Tableau to Excel, you must download and install Microsoft Access Database Engine if one of the following conditions is true:

  • You do not have Microsoft Office installed.
  • You have Microsoft Office installed, but the bit version of Microsoft Office does not match the bit version of Tableau.
Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

Important: For PowerPivot, install the driver bit version that matches the Microsoft Office bit version installed on your computer.

To connect to PowerPivot, you must install the driver that supports how you connect to PowerPivot, and then install the Tableau Add-in for PowerPivot.

SharePoint URL and Microsoft Office 32-bit

If you connect Tableau to PowerPivot using a SharePoint URL, download and install the 32-bit SQLSERVER2008_ASOLEDB10 driver from the Tableau website.

You might also need to install 32-bit Microsoft Core XML Services (MSXML) 6.0.

SharePoint URL and Microsoft Office 64-bit

If you connect Tableau to PowerPivot using a SharePoint URL, download and install the 64-bit SQLSERVER2008_ASOLEDB10 driver from the Tableau website.

You might also need to install 64-bit Microsoft Core XML Services (MSXML) 6.0.

SharePoint UNC or local Excel file

If you connect Tableau to PowerPivot using a SharePoint UNC, or you connect to a local Excel file, install the following drivers:

  1. Go the to the Microsoft SQL Server 2012 SP1 PowerPivot for Microsoft Excel 2010 page and click Download.
  2. Select the installer that matches the Microsoft Office bit version installed on your computer.
  3. Download and install the driver.

Install the Tableau Add-In

Next, you must install the Tableau Add-In for Microsoft PowerPivot. Install the Tableau Add-In bit version that matches your Microsoft Office bit version:

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.2 - 2019.2.3

The Mac driver for Microsoft SQL Server is installed by default with Tableau Desktop.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 8.2 - 10.1
Download mac

You can use the Microsoft SQL Server connector to connect Tableau to Microsoft SQL Server PDW, and starting with Tableau 9.0.3, to connect to Microsoft Azure SQL Database.

Follow these steps to install the Microsoft SQL Server driver for your Mac computer.

  1. Close Tableau Desktop.
  2. Download the drivers from the Download link.
  3. Double-click the downloaded file, TableauDrivers.dmg.
  4. Double-click Simba SQL Server ODBC.pkg to run the installer.
  5. Accept the defaults.
  6. Open Tableau Desktop and connect to Microsoft SQL Server.
Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: All supported versions

You can use the Microsoft SQL Server connector to connect Tableau to Microsoft SQL Server PDW, and starting with Tableau 9.0.3, to connect to Microsoft Azure SQL Database and Microsoft Azure SQL Data Warehouse.

For Tableau Desktop 9.3 and later, the Microsoft SQL Server driver is installed by default.

For earlier Tableau Desktop versions, download and install the driver.

Resources
  • For information about supported database versions, see Technical Specifications.

You can use the Microsoft SQL Server connector to connect Tableau to Microsoft SQL Server PDW, and starting with Tableau 9.0.3, to connect to Microsoft Azure SQL Database.

For Tableau Desktop 9.3 and later, the Microsoft SQL Server driver is installed by default.

For earlier Tableau Desktop versions, download and install the driver.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: All supported versions

The Mac driver for Microsoft SQL Server is installed by default with Tableau Prep Builder.

Resources

You can use the Microsoft SQL Server connector to connect Tableau to Microsoft SQL Server PDW, Microsoft Azure SQL Database, and Microsoft Azure SQL Data Warehouse.

For Tableau Prep Builder, the Microsoft SQL Server driver is installed by default.

Resources
Tableau Server: 10.5 - 2019.2.3

You can use the Microsoft SQL Server connector to connect Tableau to Microsoft Azure SQL Database.

On CentOS and RHEL:

  1. Download the .rpm file.
  2. To install the driver, run the following command:

    sudo yum install tableau-freetds-1.00.40-1.x86_64.rpm

On Ubuntu:

  1. Download the .deb file.
  2. To install the driver, run the following command:

    sudo gdebi tableau-freetds_1.00.40_amd64.deb

Resources
Tableau Server: All supported versions
Download windows 64 bit

You can use the Microsoft SQL Server connector to connect Tableau to Microsoft SQL Server PDW, and starting with Tableau 9.0.3, to connect to Microsoft Azure SQL Database.

Click the Download link and install the Windows 64-bit Microsoft SQL Server driver for Tableau Server.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 32 bit

You can use the Microsoft SQL Server connector to connect Tableau to Microsoft SQL Server PDW, and starting with Tableau 9.0.3, to connect to Microsoft Azure SQL Database and Microsoft Azure SQL Data Warehouse.

Click the Download link and install the Windows 32-bit Microsoft SQL Server driver for Tableau Server.

Resources
Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop & Tableau Server: 9.1.2 - 2019.2.3

Follow these steps to install the MonetDB Windows driver for Tableau 9.1.2 and later:

  1. Go to the MonetDB download page for Windows.
  2. Select the archive directory.
  3. Scroll to and select the file for your environment: We recommend using the June 2016 driver.
    • MonetDB-ODBC-Installer-i386-20160610.msi
    • MonetDB-ODBC-Installer-x86_64-20160610.msi
  4. Download and install the driver.
Resources
Tableau Prep Builder: All supported versions

Follow these steps to install the MonetDB Windows driver:

  1. Go to the MonetDB download page for Windows.
  2. Select the archive directory.
  3. Scroll to and select the MonetDB-ODBC-Installer-x86_64-20160610.msi file.
    We recommend using the June 2016 driver.
  4. Download and install the driver.
Resources
Tableau Desktop & Tableau Server: 10.3 - 2019.2.3

MongoDB BI Connector uses the MySQL driver. If you don't have a MySQL driver installed, follow the steps to install the Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Go to the MySQL website.
  2. Select your operating system from the drop-down list.
  3. Select the 64-bit version of the driver.
  4. Download and install the driver.

You also need to install and run the MongoDB Connector for BI, version 2.1 or later, before you can connect Tableau to your MongoDB BI data. For information about getting and installing the MongoDB Connector for BI, see Connecting Tableau to MongoDB on the MongoDB website.

Resources
Tableau Desktop: 10.3 - 2019.2.3

MongoDB BI Connector uses MySQL drivers. If you don't have MySQL drivers installed, you need to install them using the following instructions.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

You also need to install and run the MongoDB Connector for BI, version 2.1 or later, before you can connect Tableau to your MongoDB BI data. For information about getting and installing the MongoDB Connector for BI, see Connecting Tableau to MongoDB on the MongoDB website.

Follow these steps to install the Mac driver for MySQL:

  1. Close Tableau Desktop.
  2. Install the iODBC Driver Manager, if it's not already installed on your Mac. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

    Note: You must install iODBC before you install the MySQL ODBC connector.

  3. Download and install the MySQL ODBC connector for your Mac OS X version:
    • Older versions:
      1. Select Version: 5.2.7
      2. Select Operating System: Mac OS X
      3. Select OS Version: Select the OS version for your Mac.

    For more information, see Installing Connector/ODBC on macOS on the MySQL website.

  4. Open Tableau Desktop and connect to MongoDB BI Connector.

Note: We strongly recommend that you upgrade to the latest MySQL ODBC driver because it contains fixes for an outdated OpenSSL library and other vulnerabilities. For more information, see the Security Bulletin.

Resources
Tableau Prep Builder: 2018.2.3 - 2019.2.3

MongoDB BI Connector uses MySQL drivers. If you don't have MySQL drivers installed, you need to install them using the following instructions.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

You also need to install and run the MongoDB Connector for BI, version 2.1 or later, before you can connect Tableau to your MongoDB BI data. For information about getting and installing the MongoDB Connector for BI, see Connecting Tableau to MongoDB on the MongoDB website.

Follow these steps to install the Mac driver for MySQL:

  1. Close Tableau Prep Builder.
  2. Install the iODBC Driver Manager, if it's not already installed on your Mac. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

    Note: You must install iODBC before you install the MySQL ODBC connector.

  3. Download and install the MySQL ODBC connector for your Mac OS X version:
    • Older versions:
      1. Select Version: 5.2.7
      2. Select Operating System: Mac OS X
      3. Select OS Version: Select the OS version for your Mac.

    For more information, see Installing Connector/ODBC on macOS on the MySQL website.

  4. Open Tableau Prep Builder and connect using MongoDB BI Connector.

Note: We strongly recommend that you upgrade to the latest MySQL ODBC driver because it contains fixes for an outdated OpenSSL library and other vulnerabilities. For more information, see the Security Bulletin.

Resources

MongoDB BI Connector uses the MySQL driver. If you don't have a MySQL driver installed, follow the steps to install the 64-bit Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Go to the MySQL website.
  2. Select your operating system from the drop-down list.
  3. Select the 64-bit version of the driver.
  4. Download and install the driver.

You also need to install and run the MongoDB Connector for BI, version 2.1 or later, before you can connect Tableau to your MongoDB BI data. For information about getting and installing the MongoDB Connector for BI, see Connecting Tableau to MongoDB on the MongoDB website.

Resources
Tableau Server: 2018.1 - 2019.2.3

MongoDB BI Connector uses MySQL drivers. If you don't have the MySQL driver installed, you can get it from the MySQL website.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

Go to the MySQL website:

Select your operating system from the drop-down list. Select the 64-bit version of the driver.

  • On CentOS and RHEL, download the .rpm file and then run the following command:

    sudo yum install mysql-connector-odbc-[version].[archictecture].rpm

  • On Ubuntu, download the TAR archive and then follow the instructions on the MySQL website:

After you install the driver, add these entries to the /etc/odbcinst.ini file, if they're not already there:

Resources
Tableau Desktop: 9.3 - 2019.2.3

If you don't have MySQL drivers installed, follow the steps to install the Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Go to the MySQL website.
  2. Select your operating system from the drop-down list.
  3. Select the version of the driver for your Windows environment.
  4. Download and install the driver.
Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 8.2 - 9.2

If you don't have MySQL drivers installed, follow the steps to install the MySQL Windows driver on your computer.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. On the MySQL website, review the prerequisites for installing the Connector/ODBC drivers on Windows. Make sure the prerequisite software is installed on your computer.
  2. On the Download Connector/ODBC page, select the driver for your platform and bit version.
  3. Download and install the driver.

Note: We strongly recommend upgrading to the latest MySQL ODBC driver as it contains a fix for the Heartbleed vulnerability.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: All supported versions

Follow the steps to install the MySQL driver on your Mac computer.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Close Tableau Desktop.
  2. Install the iODBC Driver Manager, if it's not already installed on your Mac. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

    Note: You must install iODBC before you install the MySQL ODBC connector.

  3. Download and install the MySQL ODBC connector for your Mac OS X version:
    • Older versions:
      1. Select Version: 5.2.7
      2. Select Operating System: Mac OS X
      3. Select OS Version: Select the OS version for your Mac.

    For more information, see Installing Connector/ODBC on OS X on the Oracle website.

  4. Open Tableau Desktop and connect to MySQL.

Note: We strongly recommend that you upgrade to the latest MySQL ODBC driver because it contains fixes for an outdated OpenSSL library and other vulnerabilities. For more information, see the Security Bulletin.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: All supported versions

Follow the steps to install the MySQL driver on your Mac computer.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Close Tableau Prep Builder.
  2. Install the iODBC Driver Manager, if it's not already installed on your Mac. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

    Note: You must install iODBC before you install the MySQL ODBC connector.

  3. Download and install the MySQL ODBC connector for your Mac OS X version:
    • Older versions:
      1. Select Version: 5.2.7
      2. Select Operating System: Mac OS X
      3. Select OS Version: Select the OS version for your Mac.

    For more information, see Installing Connector/ODBC on OS X on the Oracle website.

  4. Open Tableau Prep Builder and connect to MySQL.

Note: We strongly recommend that you upgrade to the latest MySQL ODBC driver because it contains fixes for an outdated OpenSSL library and other vulnerabilities. For more information, see the Security Bulletin.

Resources

If you don't have MySQL drivers installed, follow the steps to install the Windows driver for MySQL.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. Go to the MySQL website.
  2. Select your operating system from the drop-down list.
  3. Select the 64-bit version of the driver.
  4. Download and install the driver.
Resources
Tableau Server: 10.5 - 2019.2.3

Install Sql Server Jdbc Driver

Download and install the drivers from the MySQL website. (The drivers in the operating system repository might not be the latest.)

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

Go to the MySQL website:

Select your operating system from the drop-down list. Select the 64-bit version of the driver.

  • On CentOS and RHEL, download the .rpm file and then run the following command:

    sudo yum install mysql-connector-odbc-[version].[archictecture].rpm

  • On Ubuntu, download the TAR archive and then follow the instructions on the MySQL website:

After you install the driver, add these entries to the /etc/odbcinst.ini file, if they're not already there:

Resources
Tableau Server: All supported versions

If you don't have MySQL drivers installed, follow the steps to install the MySQL Windows driver on your computer.

Important: There have been some cases where MySQL driver 8.0.x can't connect to MySQL 5.x database. Therefore, we strongly recommend you use the latest driver version that most closely matches the database version you need to connect to. For example, if you connect to a 5.x database, use the latest 5.x driver.

  1. On the MySQL website, review the prerequisites for installing the Connector/ODBC drivers on Windows. Make sure the prerequisite software is installed on your computer.
  2. On the Download Connector/ODBC page, select the driver for your platform and bit version.
  3. Download and install the driver.

Note: We strongly recommend upgrading to the latest MySQL ODBC driver as it contains a fix for the Heartbleed vulnerability.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop & Tableau Server: All supported versions

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: 10.3 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 10.3 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 2019.2
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 2019.2.

IMPORTANT: Tableau Prep does not use this driver. The latest driver for Tableau Prep can be found by scrolling down this page to the Tableau Prep entry, after the last Tableau Desktop entry.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 2019.1
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 2019.1.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 2018.3
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 2018.3.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 2018.2
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 2018.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 2018.1
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 2018.1.

  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.5
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 10.5.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.4
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle driver for Tableau Desktop 10.4.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 10.4.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.3
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle driver for Tableau Desktop 10.3.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 10.3.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.2
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle driver for Tableau Desktop 10.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 10.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.2 - 2019.2.3

The Mac driver for Oracle is installed by default with Tableau Desktop.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.1
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle driver for Tableau Desktop 10.1.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 10.1.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.0
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle driver for Tableau Desktop 10.0.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 10.0.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 9.3
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle driver for Tableau Desktop 9.3.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 9.3.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 9.2
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle driver for Tableau Desktop 9.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 9.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 9.1
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle driver for Tableau Desktop 9.1.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 9.1.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 9.0
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle driver for Tableau Desktop 9.0.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 9.0.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 8.3
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle driver for Tableau Desktop 8.3.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 8.3.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 8.2
Download windows 32 bit

Click the Download link and install the Window 32-bit Oracle driver for Tableau Desktop 8.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 8.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 8.2 - 10.1
Download mac

Follow these steps to install the Oracle driver on your Mac computer:

  1. Close Tableau Desktop.
  2. Download the drivers from the Download link.
  3. Double-click the downloaded file, TableauDrivers.dmg.
  4. Double-click Tableau Oracle Libraries.
  5. Accept the defaults.
  6. Open Tableau Desktop and connect to Oracle.
Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: 2019.2.3
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep Builder 2019.2.3.

Resources
Tableau Prep Builder: 2019.2.2
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep Builder 2019.2.2.

Resources
Tableau Prep Builder: 2019.2.1
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep Builder 2019.2.1.

Resources
Tableau Prep Builder: 2019.1.4
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep Builder 2019.1.4.

Resources
Tableau Prep Builder: 2019.1.3
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep Builder 2019.1.3.

Resources
Tableau Prep Builder: 2019.1.2
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep Builder 2019.1.2.

Resources
Tableau Prep Builder: 2019.1.1
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep Builder 2019.1.1.

Resources
Tableau Prep Builder: 2018.3.3
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.3.3.

Resources
Tableau Prep Builder: 2018.3.2
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.3.2.

Resources
Tableau Prep Builder: 2018.3.1
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.3.1.

Resources
Tableau Prep Builder: 2018.2.3
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.2.3.

Resources
Tableau Prep Builder: 2018.2.2
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.2.2.

Resources
Tableau Prep Builder: 2018.2.1
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.2.1.

Resources
Tableau Prep Builder: 2018.1.2
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.1.2.

Resources
Tableau Prep Builder: 2018.1.1
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.1.1.

Resources
Tableau Prep Builder: All supported versions

The Mac driver for Oracle is installed by default with Tableau Prep Builder.

Resources
Tableau Server: 10.5 - 2019.2.3

Follow these instructions to download and install the Linux 64-bit driver for Tableau Server.

On CentOS and RHEL:

  1. Download the .rpm file.
  2. To install the driver, run the following command:

    sudo yum install tableau-oracle-12.1.0.2.0-1.x86_64.rpm

On Ubuntu:

  1. Download the .deb file.
  2. To install the driver, run the following command:

    sudo gdebi tableau-oracle_12.1.0.2.0_amd64.deb

    If you get a dependency error, run the following command to resolve:

    sudo apt-get install -f

Resources
Tableau Server: All supported versions

The Windows 32-bit Oracle driver is installed by default with Tableau Server.

Resources
  • For information about supported database versions, see Technical Specifications.

The Windows 64-bit Oracle driver is installed by default with Tableau Server.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop & Tableau Server: 10.1.2 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 10.1.2 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 2019.2
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 2019.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 2019.1
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 2019.1.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 2018.3
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 2018.3.

Resources
  • For information about supported database versions, see Technical Specifications.

Windows Jdbc Driver

Tableau Desktop: 2018.2
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 2018.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 2018.1
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 2018.1.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.5
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 10.5.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.4
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 10.4.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle Essbase driver for Tableau Desktop 10.4.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.3
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 10.3.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle Essbase driver for Tableau Desktop 10.3.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.2
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 10.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle Essbase driver for Tableau Desktop 10.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.1
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 10.1.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle Essbase driver for Tableau Desktop 10.1.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.0
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 10.0.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle Essbase driver for Tableau Desktop 10.0.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 9.3
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle Essbase driver for Tableau Desktop 9.3.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 9.3.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 9.2
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle Essbase driver for Tableau Desktop 9.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 9.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 9.1
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle Essbase driver for Tableau Desktop 9.1.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 9.1.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 9.0
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle Essbase driver for Tableau Desktop 9.0.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 9.0.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 8.3
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle Essbase driver for Tableau Desktop 8.3.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 8.3.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 8.2
Download windows 32 bit

Click the Download link and install the Windows 32-bit Oracle Essbase driver for Tableau Desktop 8.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Download windows 64 bit

Click the Download link and install the Windows 64-bit Oracle Essbase driver for Tableau Desktop 8.2.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Server: 10.5 - 2019.2.3

Follow these instructions to download and install the Linux 64-bit driver for Tableau Server.

On CentOS and RHEL:

  1. Download the .rpm file.
  2. To install the driver, run the following commands:

    sudo yum install tableau-essbase-11.1.2.0-1.x86_64.rpm

On Ubuntu:

  1. Download the .deb file.
  2. To install the driver, run the following commands:

    sudo gdebi tableau-essbase_11.1.2.0_amd64.deb

Resources
Tableau Server: All supported versions

The Oracle Essbase 32-bit Windows driver is installed by default with Tableau Server.

Resources
  • For information about supported database versions, see Technical Specifications.

The Oracle Essbase 64-bit Windows driver is installed by default with Tableau Server.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop & Tableau Server: 2018.3 - 2019.2.3

Make sure that the JDBC driver you want to use with the Other Databases (JDBC) connector is installed.

Important: When you use a JDBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau product features is not guaranteed.

Resources
Tableau Desktop: 2018.3 - 2019.2.3

Make sure that the JDBC driver you want to use with the Other Databases (JDBC) connector is installed.

Important: When you use a JDBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau product features is not guaranteed.

Resources
Tableau Prep Builder: 2019.2.1 - 2019.2.3

Make sure that the JDBC driver you want to use with the Other Databases (JDBC) connector is installed.

Important: When you use a JDBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau product features is not guaranteed.

Resources
Tableau Prep Builder: 2019.2.1 - 2019.2.3

Make sure that the JDBC driver you want to use with the Other Databases (JDBC) connector is installed.

Important: When you use a JDBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau product features is not guaranteed.

Resources
Tableau Server: 2018.3 - 2019.2.3

Make sure that the JDBC driver you want to use with the Other Databases (JDBC) connector is installed.

Important: When you use a JDBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau product features is not guaranteed.

Resources
Tableau Desktop & Tableau Server: 10.4 - 2019.2.3

Make sure that the ODBC driver you want to use with the Other Databases (ODBC) connector is installed.

Important: When you use an ODBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau product features is not guaranteed.

Resources
Tableau Desktop & Tableau Server: All supported versions

Make sure that the ODBC driver you want to use with the Other Databases (ODBC) connector is installed.

Important: When you use an ODBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau product features is not guaranteed.

Resources
Tableau Prep Builder: 2019.2.2

Make sure that the ODBC driver you want to use with the Other Databases (ODBC) connector is installed.

Important: When you use an ODBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau product features is not guaranteed.

Resources

Make sure that the ODBC driver you want to use with the Other Databases (ODBC) connector is installed.

Important: When you use an ODBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau product features is not guaranteed.

Resources
Tableau Server: 10.5 - 2019.2.3

Make sure that the ODBC driver you want to use with the Other Databases (ODBC) connector is installed.

Important: When you use an ODBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau product features is not guaranteed.

Resources
Tableau Desktop & Tableau Server: 10.3 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 10.3 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Prep Builder: 2018.3.1 - 2019.2.3

You don't have to install a driver.

Resources

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

Follow these steps to install the Pivotal Greenplum Database driver on your Windows computer:

  1. Go to the Pivotal website, and then sign in.
  2. Scroll down to the Data section, and then click Pivotal Greenplum.
  3. Under Release Download Files, click Greenplum DataDirect ODBC and JDBC.
  4. Select the ODBC driver for your environment: Windows 32-bit or 64-bit.
  5. Download and install the driver.
Resources
Tableau Desktop: All supported versions
Download mac

Follow these steps to install the Pivotal Greenplum Database driver on your Mac computer.

  1. Close Tableau Desktop.
  2. Download the drivers from the Download link.
  3. Double-click the downloaded file, TableauDrivers.dmg.
  4. Double-click Tableau PostgreSQL Libraries.
  5. Accept the defaults.
  6. Open Tableau Desktop and connect to Pivotal Greenplum Database.
Resources
Tableau Prep Builder: All supported versions
Download mac

Follow these steps to install the Pivotal Greenplum Database driver on your Mac computer.

  1. Close Tableau Prep Builder.
  2. Download the drivers from the Download link.
  3. Double-click the downloaded file, TableauDrivers.dmg.
  4. Double-click Tableau PostgreSQL Libraries.
  5. Accept the defaults.
  6. Open Tableau Prep Builder and connect to Pivotal Greenplum Database.
Resources

Follow these steps to install the Pivotal Greenplum Database driver on your Windows computer:

  1. Go to the Pivotal website, and then sign in.
  2. Scroll down to the Data section, and then click Pivotal Greenplum.
  3. Under Release Download Files, click Greenplum DataDirect ODBC and JDBC.
  4. Select the 64-bit ODBC driver.
  5. Download and install the driver.
Resources
Tableau Server: 10.5 - 2019.2.3

Pivotal Greenplum Database uses PostgreSQL drivers. If you don't have PostgreSQL drivers installed, follow these instructions to download and install the Linux 64-bit PostgreSQL driver for Tableau Server.

On CentOS and RHEL:

  1. Download the .rpm file.
  2. To install the driver, run the following command:

    sudo yum install tableau-postgresql-odbc-09.06.0500-1.x86_64.rpm

On Ubuntu:

  1. Download the .deb file.
  2. To install the driver, run the following command:

    sudo gdebi tableau-postgresql-odbc_09.06.0500-2_amd64.deb

Resources
Tableau Desktop: 10.2 - 2019.2.3

The Mac driver for PostgreSQL is installed by default with Tableau Desktop. If you can't connect to PostgreSQL, install the iODBC Driver Manager and then try connecting again. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 9.3 - 2019.2.3

The PostgreSQL driver is installed by default with Tableau Desktop 9.3 and later.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 8.2 - 9.2
Download windows 32 bit

Select the Download link and install the Windows 32-bit driver for PostgreSQL.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 8.2 - 10.1
Download mac

Follow these steps to install the Mac driver for PostgreSQL:

  1. Close Tableau Desktop.
  2. Download the drivers from the Download link.
  3. Double-click the downloaded file.
  4. Double-click Tableau PostgreSQL Libraries.
  5. Accept the defaults.
  6. Open Tableau Desktop and connect to PostgreSQL.

    7. If you can't connect to PostgreSQL after installing the driver, install the iODBC Driver Manager and then try connecting again. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 8.2 - 9.2
Download windows 64 bit

Select the Download link and install the Windows 64-bit driver for PostgreSQL.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: All supported versions

The Mac driver for PostgreSQL is installed by default with Tableau Prep Builder. If you can't connect to PostgreSQL, install the iODBC Driver Manager and then try connecting again. You can get the latest version (mxkozzz.dmg) from the iODBC.org website or download the file directly.

Resources

The PostgreSQL driver is installed by default with Tableau Prep Builder.

Resources
Tableau Server: 10.5 - 2019.2.3

Follow these instructions to download and install the Linux 64-bit driver for Tableau Server.

Important: Built-in administrative views will not display unless you install the PostgreSQL driver on every node running the VizQL Server process.

On CentOS and RHEL:

  1. Download the .rpm file.
  2. To install the driver, run the following command:

    sudo yum install tableau-postgresql-odbc-09.06.0500-1.x86_64.rpm

On Ubuntu:

  1. Download the .deb file.
  2. To install the driver, run the following command:

    sudo gdebi tableau-postgresql-odbc_09.06.0501_amd64.deb

Resources
Tableau Server: All supported versions
Download windows 64 bit

The Windows driver for PostgreSQL is installed by default with Tableau Server. If you need to install the driver manually, select the Download link and install the 64-bit driver for PostgreSQL.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop & Tableau Server: 10.0 - 10.4
Download windows 32 bit

Select the Download link and install the Windows 32-bit driver for Presto.

Resources
Tableau Desktop & Tableau Server: 10.0 - 2019.2.3
Download windows 64 bit

Select the Download link and install the Windows 64-bit driver for Presto.

Resources
Tableau Desktop: 10.0 - 10.4
Download mac

Follow these steps to install the Mac driver for Presto:

  1. Close Tableau Desktop.
  2. Download the driver from the Download link.
  3. Click the downloaded file.
  4. Double-click the Presto .pkg file to run the installer.
  5. Accept the defaults.
  6. Open Tableau Desktop and connect to Presto.
Resources
Tableau Prep Builder: 2018.1.2 - 2019.2.3
Download windows 64 bit

Select the Download link and install the Windows 64-bit driver for Presto.

Resources
Download mac

Follow these steps to install the Mac driver for Presto:

  1. Close Tableau Prep Builder.
  2. Download the driver from the Download link.
  3. Click the downloaded file.
  4. Double-click the Presto .pkg file to run the installer.
  5. Accept the defaults.
  6. Open Tableau Prep Builder and connect to Presto.
Resources
Tableau Server: 2018.1 - 2019.2.3
Download linux 64 bit

Follow these steps to install the driver:

  1. Click the Download link to download the 64-bit Linux driver for Presto.
  2. To install the driver, run the following command:

    sudo yum install simbapresto-1.1-x86_64.rpm

  3. After you install the driver, append the following section to the /etc/odbcinst.ini file, if it isn't already there:

If you follow these step and can't connect, see the instructions for Installing the Driver using the RPM File on the Magnitude Simba website for more details.

Resources
Tableau Desktop & Tableau Server: All supported versions

Contact your account team at Progress.

Latest driver version tested by Tableau: 11.1

Tableau assumes that new drivers will be compatible, but changes can be introduced that we have not yet tested for. If a newer driver version introduces problems, Start a Case to let us know.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop & Tableau Server: All supported versions

You don't have to install a driver.

Resources
  • 5 Ways to Maximize Your Salesforce Data (registration required)
  • Connect to Salesforce (registration required)
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

Sign in to the SAP Software Download Center to get the Windows driver for SAP HANA. If you don't have login credentials, contact your SAP administrator for help getting the driver.

Resources
Tableau Desktop: 10.0 - 2019.2.3

Follow these steps to install the JDBC driver for SAP HANA on your Mac computer:

  1. Close Tableau Desktop.
  2. If Java is not already installed on your Mac, download and install the latest Java 8 version from https://www.java.com/en/download/manual.jsp.
  3. Get the SAP HANA JDBC driver (ngdbc.jar) from your administrator, and then copy it to the ~/Library/Tableau/Drivers directory. This directory is created the first time you launch Tableau.
  4. Make sure that you have read permissions for the .jar file so that Tableau can access it.
  5. Open Tableau Desktop and connect to SAP HANA.
Resources
Tableau Prep Builder: 2019.1.4 - 2019.2.3

Sign in to the SAP Software Download Center to get the Windows driver for SAP HANA. If you don't have login credentials, contact your SAP administrator for help getting the driver.

Resources

Follow these steps to install the JDBC driver for SAP HANA on your Mac computer:

  1. Close Tableau Prep Builder.
  2. If Java is not already installed on your computer, download and install the latest Java 8 version from https://www.java.com/en/download/manual.jsp.
  3. Get the SAP HANA JDBC driver (ngdbc.jar) from your administrator, and then copy it to the ~/Library/Tableau/Drivers directory. This directory is created the first time you launch Tableau.
  4. Make sure that you have read permissions for the .jar file so that Tableau can access it.
  5. Open Tableau Prep Builder and connect to SAP HANA.
Resources
Tableau Server: 10.5 - 2019.2.3

Drivers are available from the SAP Marketplace. You must have an account to access and download them.

After you install the driver, append the following section to the /etc/odbcinst.ini file:

Resources
Tableau Desktop & Tableau Server: All supported versions

Sign in to the SAP Software Download Center to get the Windows driver for SAP NetWeaver Business Warehouse. If you don't have login credentials, contact your SAP administrator for help getting the driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

Sign in to the SAP Software Download Center to get the Windows driver for SAP Sybase ASE. If you don't have login credentials, contact your SAP administrator for help getting the driver.

Resources
Tableau Prep Builder: All supported versions

Sign in to the SAP Software Download Center to get the Windows driver for SAP Sybase ASE. If you don't have login credentials, contact your SAP administrator for help getting the driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

Sign in to the SAP Software Download Center to get the Windows driver for SAP Sybase IQ. If you don't have login credentials, contact your SAP administrator for help getting the driver.

Resources
Tableau Prep Builder: All supported versions

Sign in to the SAP Software Download Center to get the Windows driver for SAP Sybase IQ. If you don't have login credentials, contact your SAP administrator for help getting the driver.

Resources
Tableau Desktop & Tableau Server: 10.3 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 10.3 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: 10.2 - 2019.2.3
Download windows 32 bit, 64 bit

Click the Download link and follow the prompts to install the Windows driver for SharePoint Lists (CData ODBC Driver for SharePoint).

Note: There are no licensing fees when you use the CData driver with the Tableau SharePoint Lists connector. However, if you use this CData driver with the Tableau Other Databases (ODBC) connector or outside of Tableau, licensing fees might apply.

Resources
Tableau Desktop: 10.2 - 2019.2.3
Download mac

Follow these steps to install the Mac driver for SharePoint Lists:

  1. Close Tableau Desktop.
  2. Download the drivers from the Download Mac link.
  3. Click the downloaded .dmg file.
  4. Double-click the CData ODBC Driver for SharePoint .pkg file to run the installer.
  5. Accept the defaults.
  6. Open Tableau Desktop and connect to SharePoint Lists.

Note: There are no licensing fees when you use the CData driver with the Tableau SharePoint Lists connector. However, if you use this CData driver with the Tableau Other Databases (ODBC) connector or outside of Tableau, licensing fees might apply.

Resources
Tableau Server: 2018.3 - 2019.2.3

Follow these instructions to download and install the Linux 64-bit SharePoint Lists driver for Tableau Server.

On CentOS and RHEL:

  1. Download the .rpm file.
  2. To install the driver, run the following command:

    sudo yum install SharePoint_Tableau_6883.x86_64.rpm

On Ubuntu:

  1. Download the .deb file.
  2. To install the driver, run the following command:

    sudo gdebi SharePoint_Tableau_6883.x86_64.deb

After you install the driver, add this entry to the /etc/odbcinst.ini file, if it’s not already there:

Resources
Tableau Desktop & Tableau Server: 9.3 - 2019.2.3

Follow these steps to get the Windows ODBC driver for Snowflake:

  1. Sign in to your Snowflake instance.
  2. Select Help > Download > ODBC Driver.
  3. Select the ODBC driver for your operating system to download the latest version.

For installation and configuration details, follow the Snowflake Documentation link on the ODBC Driver page.

Resources
  • Best Practices for Using Tableau with Snowflake on the Snowflake website (registration required)
Tableau Desktop: 9.3 - 2019.2.3

Follow these steps to get the Mac ODBC driver for Snowflake:

  1. Sign in to your Snowflake instance.
  2. Select Help > Download > ODBC Driver.
  3. Select the ODBC driver for your operating system to download the latest version.

For installation and configuration details, follow the Snowflake Documentation link on the ODBC Driver page.

Resources
  • Best Practices for Using Tableau with Snowflake on the Snowflake website (registration required)
Tableau Prep Builder: 2018.2.1 - 2019.2.3

Follow these steps to get the Mac ODBC driver for Snowflake:

  1. Sign in to your Snowflake instance.
  2. Select Help > Download > ODBC Driver.
  3. Select the ODBC driver for your operating system to download the latest version.

For installation and configuration details, follow the Snowflake Documentation link on the ODBC Driver page.

Resources
  • Best Practices for Using Tableau with Snowflake on the Snowflake website (registration required)

Follow these steps to get the Windows ODBC driver for Snowflake:

  1. Sign in to your Snowflake instance.
  2. Select Help > Download > ODBC Driver.
  3. Select the 64-bit ODBC driver for Windows to download the latest version.

For installation and configuration details, follow the Snowflake Documentation link on the ODBC Driver page.

Resources
  • Best Practices for Using Tableau with Snowflake on the Snowflake website (registration required)
Tableau Server: 10.5 - 2019.2.3

Drivers and installation instructions are available from the Snowflake website:

Resources
  • Best Practices for Using Tableau with Snowflake on the Snowflake website (registration required)
Tableau Desktop & Tableau Server: 8.2.8 - 8.2.x, 8.3.3 - 8.3.x, 9.0 - 10.4
Download windows 32 bit

You can use the SparkSQL connector to connect to a Spark cluster on Azure HDInsight, Databricks, or Apache Spark.

Click the Download link and install the Windows 32-bit driver for Spark SQL.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop & Tableau Server: 8.2.8 - 8.2.x, 8.3.3 - 8.3.x, 9.0 - 2019.2.3
Download windows 64 bit

You can use the SparkSQL connector to connect to a Spark cluster on Azure HDInsight, Databricks, or Apache Spark.

Click the Download link and install the Windows 64-bit driver for Spark SQL.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 10.2 - 2019.2.3

The Mac driver for Spark SQL is installed by default with Tableau Desktop.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 8.2.8 - 8.2.x, 8.3.3 - 8.3.x, 9.0 - 10.1
Download mac

Follow these steps to install the Spark SQL driver for your Mac computer:

  1. Close Tableau Desktop.
  2. Download the drivers from the Download link.
  3. Double-click the downloaded file, TableauDrivers.dmg.
  4. Double-click SimbaSparkODBC.dmg to run the installer.
  5. Accept the defaults.
  6. Open Tableau Desktop and connect to Spark SQL.
    7. Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: 2018.2.1 - 2019.2.3

The Mac driver for Spark SQL is installed by default with Tableau Prep Builder.

Resources
Download windows 64 bit

You can use the SparkSQL connector to connect to a Spark cluster on Azure HDInsight, Databricks, or Apache Spark.

Click the Download link and install the Windows 64-bit driver for Spark SQL.

Resources
Tableau Server: 2018.1 - 2019.2.3
Download linux 64 bit

Follow these instructions to download and install the Linux 64-bit driver for Spark SQL on CentOS and RHEL.

  1. Click the Download link to download the driver.
  2. To install the driver, run the following command:

After you install the driver, add this entry to the /etc/odbcinst.ini file, if it’s not already there:

Resources
Tableau Desktop & Tableau Server: 10.2 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop: 10.2 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

Follow these steps to install the Windows driver for Splunk:

  1. Go to the Splunk ODBC driver page and sign in.
  2. Download and install the driver.
Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: All supported versions

Follow these steps to install the Windows driver for Splunk:

  1. Go to the Splunk ODBC driver page and sign in.
  2. Download and install the driver.
Resources
Tableau Desktop & Tableau Server: 9.0 - 2019.2.3

You don't have to install a driver.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: 9.0 - 2019.2.3

You don't have to install a driver.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: 2018.1.2 - 2019.2.3

You don't have to install a driver.

Resources

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: All supported versions

In addition to connecting to a Teradata server, for Tableau Desktop 8.2.9 - 8.2.x, 8.3.4 and later, you can use the Teradata connector to connect to a Teradata Unity server.

Follow these steps to install the Windows driver for Teradata:

  1. Go to the Teradata Downloads page and sign in.
  2. Select ODBC Driver > Windows.
  3. Download the latest Teradata ODBC Driver for Windows.
  4. Extract the downloaded file and install the drivers.
Resources
  • Tableau and Teradata: The visual approach to the active warehouse. (registration required)
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: All supported versions

In addition to connecting to a Teradata server, for Tableau Desktop 8.2.9 - 8.2.x, 8.3.4 and later, you can use the Teradata connector to connect to a Teradata Unity server.

Follow these steps to install the Mac drivers for Teradata:

  1. Close Tableau Desktop.
  2. On the Teradata Downloads page, sign in to your Teradata account.
  3. Select ODBC Driver > Mac.
  4. Download the latest Teradata ODBC Driver for Mac OS X.
  5. Double-click the downloaded .tar file.
  6. Control-click and then click Open to run the Teradata .pkg file. Accept the defaults.
    Note: The following error message might appear: 'ODBC Administrator Tool does not appear to be installed.' Click OK to dismiss the error; it does not affect the driver installation.
  7. Restart your computer.
  8. Open Tableau Desktop and connect to a Teradata server.
Resources
  • Tableau and Teradata: The visual approach to the active warehouse. (registration required)
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: All supported versions

In addition to connecting to a Teradata server, you can use the Teradata connector to connect to a Teradata Unity server.

Follow these steps to install the Mac drivers for Teradata:

  1. Close Tableau Prep Builder.
  2. On the Teradata Downloads page, sign in to your Teradata account.
  3. Select ODBC Driver > Mac.
  4. Download the latest Teradata ODBC Driver for Mac OS X.
  5. Double-click the downloaded .tar file.
  6. Control-click and then click Open to run the Teradata .pkg file. Accept the defaults.
    Note: The following error message might appear: 'ODBC Administrator Tool does not appear to be installed.' Click OK to dismiss the error; it does not affect the driver installation.
  7. Restart your computer.
  8. Open Tableau Prep Builder and connect to a Teradata server.
Resources

In addition to connecting to a Teradata server, you can use the Teradata connector to connect to a Teradata Unity server.

Follow these steps to install the Windows driver for Teradata:

  1. Go to the Teradata Downloads page and sign in.
  2. Select ODBC Driver > Windows.
  3. Download the latest Teradata ODBC Driver for Windows.
  4. Extract the downloaded file and install the drivers.
Resources
Tableau Server: 10.5 - 2019.2.3

Tableau supports Teradata ODBC Driver for Linux, versions 16.x or later.

Drivers are available from the Teradata website at the following URL:

Note: Tableau Server doesn't support Teradata on Ubuntu.

  1. Download the latest tar file, then extract the contents with the following command, replacing [tar file name] with the name of the tar file you download:

    tar -xzvf ~/Downloads/[tar file name].tar.gz

    For example:

    tar -xzvf ~/Downloads/todbc1610__linux_indep.16.10.00.03-1.tar.gz

  2. Install the driver dependencies listed in the driver README file on the Teradata website.
  3. Install the driver with the following command, replacing [driver file name] with the name of the .rpm file:

    sudo yum install [driver file name].rpm

    For example:

    sudo yum install tdodbc1610-16.10.00.03-1.noarch.rpm

  4. After you install the driver, append the following entry to the /etc/odbcinst.ini file, if it’s not already there. Replace [driver version] with the verion of the driver and [file name] with the name of the shared library file used by the driver version you install.

    For example, if you install Teradata ODBC driver version 16.20, you would add this entry:

Resources
Tableau Desktop & Tableau Server: All supported versions

Contact your account team at Teradata.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop & Tableau Server: All supported versions

You don't have to install a driver.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: All supported versions

You don't have to install a driver.

Resources
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: All supported versions

You don't have to install a driver.

Resources

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Desktop & Tableau Server: 9.3.1 - 2019.2.3

Follow these steps to download the Windows driver for TIBCO Data Virtualization (formerly called Cisco Information Server):

  1. Go to edelivery.tibco.com.
  2. Search for TIBCO Data Virtualization and go to the TIBCO Data Virtualization page on TIBCO eDelivery.
  3. Select Download and sign in to your account.
  4. On the download page, select your operating system.
  5. Agree to the terms, select the individual file option, and expand the download file list.
  6. Select the file named TIB_tdv_drivers_X.X.X_all.zip, where X.X.X is the current version.
  7. Download and install the driver.
Resources
Tableau Desktop & Tableau Server: All supported versions

Follow these steps to install the Windows driver for Vertica:

  1. Go to the Vertica Downloads page on the Vertica website.
  2. Download and install the latest version of ODBC driver for Windows.
Resources
  • Vertica & Tableau Solution Overview (registration required)
  • For information about supported database versions, see Technical Specifications.
Tableau Desktop: All supported versions

Install the Mac driver for your Vertica version:

Vertica 7.1 and later – Follow these steps to install the Mac driver for Vertica 7.1 and later.

  1. Close Tableau Desktop.
  2. Download the ODBC driver for the Mac from the Vertica Downloads page on the Vertica web site.
  3. Control-click vertica-odbc-[version].mac.pkg, and then click Open to run the package. Accept the defaults.
  4. Open Tableau Desktop and connect to Vertica.

Vertica 7.0.x and earlier – Follow these steps to install the Mac driver for Vertica 7.0.x and earlier:

  1. Verify that you have an ODBC Administrator. You can download one from Apple: https://support.apple.com/kb/DL895. Control-click to install the downloaded dmg.
  2. Download the latest version of the 64-bit MAC driver from the myVertica portal.
    For other installation scenarios, see Installing the ODBC Driver on Macintosh OS X on the Vertica website.
  3. Start Terminal and type in the following command to create target directory:
    sudo mkdir -p /Library/ODBC/vertica
  4. Change to the directory you just created:
    cd /Library/ODBC/vertica
  5. Unpack the file containing the ODBC driver using the following command:
    sudo tar -xzf ~/Downloads/vertica-odbc-[version].64.mac.tar
    Note: Replace [version] with the version number of the file you downloaded.
  6. Download the drivers from the Download link.
  7. Double-click TableauDrivers.dmg in the Downloads folder.
  8. Double-click Tableau Vertica Configure.pkg and accept the defaults. You will be asked to restart your Mac.
  9. Open Tableau Desktop and connect to Vertica.
Resources
  • Vertica & Tableau Solution Overview (registration required)
  • For information about supported database versions, see Technical Specifications.
Tableau Prep Builder: All supported versions

Install the Mac driver for your Vertica version:

Vertica 7.1 and later – Follow these steps to install the Mac driver for Vertica 7.1 and later.

  1. Close Tableau Prep Builder.
  2. Download the ODBC driver for the Mac from the Vertica Downloads page on the Vertica web site.
  3. Control-click vertica-odbc-[version].mac.pkg, and then click Open to run the package. Accept the defaults.
  4. Open Tableau Prep Builder and connect to Vertica.

Vertica 7.0.x and earlier – Follow these steps to install the Mac driver for Vertica 7.0.x and earlier:

  1. Verify that you have an ODBC Administrator. You can download one from Apple: https://support.apple.com/kb/DL895. Control-click to install the downloaded dmg.
  2. Download the latest version of the 64-bit MAC driver from the myVertica portal.
    For other installation scenarios, see Installing the ODBC Driver on Macintosh OS X on the Vertica website.
  3. Start Terminal and type in the following command to create target directory:
    sudo mkdir -p /Library/ODBC/vertica
  4. Change to the directory you just created:
    cd /Library/ODBC/vertica
  5. Unpack the file containing the ODBC driver using the following command:
    sudo tar -xzf ~/Downloads/vertica-odbc-[version].64.mac.tar
    Note: Replace [version] with the version number of the file you downloaded.
  6. Download the drivers from the Download link.
  7. Double-click TableauDrivers.dmg in the Downloads folder.
  8. Double-click Tableau Vertica Configure.pkg and accept the defaults. You will be asked to restart your Mac.
  9. Open Tableau Prep Builder and connect to Vertica.
Resources

Follow these steps to install the Windows driver for Vertica:

  1. Go to the Vertica Downloads page on the Vertica website.
  2. Download and install the latest version of ODBC driver for Windows.
Resources
Tableau Server: 10.5 - 2019.2.3

Download the Vertica 7.1.x Linux rpm or tar drivers from the Vertica website, and install the 64-bit ODBC drivers:

  • On CentOS and RHEL, download the .rpm file and then run the following command:

    sudo yum install vertica-client-7.1.2-0.x86_64.rpm

  • On Ubuntu, download the tar file, then extract the contents with the following command:

    sudo tar -C / -xzvf vertica-client-7.1.2-0.x86_64.tar.gz

Then, on all distros, append the following section to the /etc/odbcinst.ini file:

Resources
Tableau Desktop & Tableau Server: 9.1 - 2019.2.3

You don't have to install a driver.

Resources
Tableau Server: 10.5 - 2019.2.3

You don't have to install a driver.

Resources

Prior to connecting to an MS SQL Server instance from a Mac machine, there are some configuration settings that need to enabled on the SQL Server database.

1. The SQL Server database should be configured to accept TCP/IP connections. Many SQL Server installations are set up to only allow shared memory or named pipe access. You can setup the TCP/IP option using a tool like the SQL Server Configuration manager. Under Network Configuration there should be an option for Protocols. One of those protocols is TCP/IP . Make sure to enable TCP/IP.

2. If the user connecting to the database does not have a valid user id and password for the windows domain used by SQL Server, mixed mode authentation would need to be enabled on the SQL Server instance, and an administrator would need to create a SQL Server user id and password for the user connecting to the instance.

The easiest way to connect to MS SQL Server from Mac is with a JDBC (Java Database Connectivity) driver. There are two options for JDBC driver. Once is the open source jTDS driver. The other is the JDBC driver from Microsoft.

RazorSQL can use either of these drivers to connect to SQL Server, and the jTDS driver comes pre-installed with RazorSQL. If you are looking for a client program to query, edit, browse, and manage your SQL Server instance, check out RazorSQL. Free trials can be downloaded from here: https://razorsql.com/download.html

If you would like to proceed with writing your own programs to access SQL Server, check out the documentation for the jTDS driver to get started:
http://jtds.sourceforge.net/

If you need an editor for developing your Java JDBC program, check out EditRocket, available here:
https://editrocket.com/