Hana Odbc Driver Download
ExpressConnect for HANA DB (ECH) does not include the required HANA DB ODBC drivers. Download these libraries from the SAP Service Marketplace and install them after you have installed Replication Server. The HANA Client installation also provides JDBC, ODBC drivers. The SAP HANA Studio is the Eclipse based development Environment for SAP HANA.
Hi All, The topic of my Blogging activities in SDN will be initially on Installation of SAP HANA CLIENT, ODBC & DESIGN STUDIO.
TOOLS INFORMATION:
HANA CLIENT TOOL
ODBC
DESIGN STUDIO
PREREQUISITES:
The following components need to be installed before starting the installation:
- Microsoft Office 2007
- Adobe Flash 10.1 or higher
- SQL Server Native Drivers.
- Hana client tools.
HANA CLIENT TOOL
The SAP HANA client software can be installed on a variety of platforms.
The following platform types are supported:
● AIX
● HP-UX
● Linux
● Microsoft Windows
● Solaris
HANA Client is the piece of software which enables you to connect any other entity, including Non-Native applications to a HANA server. This “other” entity can be, say, an NW Application Server, an IIS server..etc. The HANA Client installation also provides JDBC, ODBC drivers. This enables applications written in .Net, Java..etc to connect to a HANA server, and use the server as a remote database. So, consider client as the primary connection enabler to HANA server.
- SAP HANA Client are the “client tools” like ODBC Drivers for windows to connect to the HANA Database when you want to use for example excel to connect to SAP HANA.
- The SAP HANA Studio is the Eclipse based development Environment for SAP HANA.
Download the media from service market place, Need SMP credentials
When you install the SAP HANA client software package, supported clients are installed and available. The clients available on Microsoft Windows platforms are as follows:
● SQLDBC
● ODBO
● ODBC
● JDBC
● Microsoft ADO.NET
Run the setup file with run as administrator rights, follow the wizard
Confirm the standard options and go through the short installation procedure:
Click on Install
After installing SAP HANA Client and SAP HANA Studio, we can start HANA Studio by navigating to the Windows Start menu, go to “All Programs type SAP HANA and hit “SAP HANA Studio”:
Installation completed successfully.
Default Installation Paths for Windows
Microsoft Windows x86, 64-bit 64-bit C:Program Filessap hdbclient
For more info, please check SAP guides.
1577128 – Supported clients for SAP HANA
ODBC Connection to SAP HANA
After the HANA Client is installed, if not already created, you will need to create an ODBC Connection to HANA.
What is ODBC?
ODBC (Open Database Connectivity) is a standard programming language middle ware API for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems.
The figure above shows how ODBC fits in between an application and the database it is accessing.
From the Start menu → select Control Panel →Select Administrative Tools
Select Data Sources (ODBC)
Select the System DSN tab → Select Add → Select HDBODBC for 64 bit machines → Select HDBODC32 for 32 bit machines → Select Finish.
Click on finish tab.
Complete the entries Data Source Name → HANA_ODBC (suggested) Description • HANA ODBC (suggested) Server Port → Select Connect
Server name should be filled in for you to test your connection, leave the User and Password field blank! Your AD/MC credentials will transmit automatically
When you receive the Connect successful! Message • Click OK.
DESIGN STUDIO MEDIA DOWNLOAD AND INSTALLATION PROCESS:
System Requirements:
Before installing the design tool of SAP Business Objects Design Studio, make sure that the following components are installed on the local machines of your application designers:
● Internet Explorer 9.0, 10 or 11
● For 64-bit version of design tool installer: 64-bit version of Windows
● For 64-bit version of design tool installer: 64-bit Secure Login Client of SAP NetWeaver Single-Sign On .
SAP BusinessObjects Design Studio enables application designers to create analysis applications and dashboards – based on SAP NetWeaver BW, SAP HANA and universe data sources – for browsers and mobile devices (iPads, for example).
SAP BusinessObjects Design Studio can be used locally and integrated in the following platforms:
- SAP BusinessObjects Business Intelligence (BI platform)
- SAP NetWeaver
- SAP HANA
Download the media from service market place by providing the credentials.
Click on DESIGN STUDIO CLIENT 1.5 and download the required media.
INSTALLATION PROCESS:
Run the setup file with run as administrator rights,
Click on next tab
Click on next tab, Installation process started…
Installation completed successfully.
The default path for 32-bit is C:Program Files (x86)SAP BusinessObjectsDesign Studio and for 64-bit the path is C:Program FilesSAP BusinessObjectsDesign Studio.
Connecting Design Studio
Go to Application–> New
Provide the necessary information and choose finish.
Click on Add Data Source Tab
Click on Browse tab, automatically our Hana db system will appears as we have configured ODBC server, choose DBH.
Click on OK tab, provide the Hana database credentials,
Now connection is active,
Click on ok.
Able to view tables successfully.
That’s it, in my next blog will explain about SAP LUMIRA and Analysis office.
Thank you for reading the blog.
Rajesh K.
Tableau Desktop & Tableau Server: All supported versions
Follow these steps to install the Windows driver for Actian Matrix:
- Go to the Actian website and sign in.
- In the Select Via Product box, select the following:
- Under Product: Actian Matrix Drivers
- Under Release: ODBC
- In the list that displays, select the latest ODBC Driver for your platform and bit version.
- Download and install the driver.
Resources
Tableau Desktop & Tableau Server: All supported versions
Follow these steps to install the Windows driver for Actian Vector:
- Go to the Actian website and sign in.
- In the Select Via Product box, select the following:
- Under Product: Actian Ingres Drivers
- Under Release: ODBC
- In the list that displays, select the latest ODBC Driver for your platform and bit version.
- Download and install the drivers.
Resources
- For information about supported database versions, see Technical Specifications.
Tableau Desktop & Tableau Server: 10.3 - 2019.1.3
Follow these steps to install the JDBC driver for Amazon Athena on your Windows computer:
- If Java is not already installed on your computer, download and install the latest Java version from https://java.com/en/download/manual.jsp.
- Download the JDBC driver (.jar file) from the Amazon Athena User Guide on Amazon's website.
- Move the downloaded .jar file to C:Program FilesTableauDrivers.
Resources
Tableau Desktop: 10.3 -2019.1.3
Follow these steps to install the JDBC driver for Amazon Athena on your Mac computer:
- Close Tableau Desktop.
- If Java is not already installed on your Mac, download and install the latest Java version from https://www.java.com/en/download/manual.jsp.
- Download the JDBC driver (.jar file) from the Amazon Athena User Guide on Amazon's website.
- Copy the downloaded .jar file to the /Library/JDBC directory. You might have to create the JDBC directory if it doesn't already exist.
- Make sure that you have read permissions for the .jar file so that Tableau can access it.
- Open Tableau Desktop and connect to Amazon Athena.
Resources
Tableau Server: 10.5 - 2019.1.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:
- Create the directory:
sudo mkdir -p /opt/tableau/tableau_driver/jdbc
- 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
- 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.1.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.
- Go to the MySQL website.
- Select your operating system from the drop-down list.
- Select the bit version of the driver for your Windows environment.
- Download and install the driver.
Resources
Tableau Desktop: 9.0.4 - 2019.1.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.
- Close Tableau Desktop.
- 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.
- Download and install the MySQL ODBC connector for your Mac OS X version:
- Older versions:
- Select Version: 5.2.7
- Select Operating System: Mac OS X
- Select OS Version: Select the OS version for your Mac.
For more information, see Installing Connector/ODBC on macOS on the Oracle website.
- Older versions:
- 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.
- 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.
- On the Download Connector/ODBC page, select the driver for your platform and bit version.
- Download and install the driver.
Resources
Tableau Prep: 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.
- Close Tableau Prep.
- 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.
- Download and install the MySQL ODBC connector for your Mac OS X version:
- Older versions:
- Select Version: 5.2.7
- Select Operating System: Mac OS X
- Select OS Version: Select the OS version for your Mac.
For more information, see Installing Connector/ODBC on OS X on the Oracle website.
- Older versions:
- Open Tableau Prep 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.
- Go to the MySQL website.
- Select your operating system from the drop-down list.
- Select the 64-bit version of the driver.
- Download and install the driver.
Resources
Tableau Server: 10.5 - 2019.1.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].[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: 9.0.4 - 2019.1.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.
- 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.
- On the Download Connector/ODBC page, select the driver for your platform and bit version.
- Download and install the driver.
Resources
Tableau Desktop & Tableau Server: 8.2.7 - 8.2.x, 8.3.2 - 2019.1.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:
- 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.
- Download and install the drivers.
Resources
Tableau Desktop: 8.2.7 - 8.2.x, 8.3.2 - 2019.1.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:
- 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.
- 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.
- Double-click the downloaded file, and then navigate to and open the MacOSX folder.
- Double-click the AmazonHiveODBC.dmg file.
- Double-click the AmazonHiveODBC.pkg file and accept the defaults.
- From Finder, select Utilities, and then open ODBC Administrator.
- Select the Drivers tab, and then click Add.
- In the Description field, enter Amazon Hive ODBC Driver.
- In the Driver file field, choose or enter /opt/amazon/hiveodbc/lib/universal/libamazonhiveodbc.dylib.
- Click OK, click Apply, and then close the ODBC Administrator.
- Log out and then log in to your Mac.
- Open Tableau Desktop and connect to Amazon EMR.
Resources
Tableau Prep: 2018.2.1 - 2019.1.4
Install the drivers for the Amazon EMR Hive installation on your Mac computer.
- 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.
- 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.
- Double-click the downloaded file, and then navigate to and open the MacOSX folder.
- Double-click the AmazonHiveODBC.dmg file.
- Double-click the AmazonHiveODBC.pkg file and accept the defaults.
- From Finder, select Utilities, and then open ODBC Administrator.
- Select the Drivers tab, and then click Add.
- In the Description field, enter Amazon Hive ODBC Driver.
- In the Driver file field, choose or enter /opt/amazon/hiveodbc/lib/universal/libamazonhiveodbc.dylib.
- Click OK, click Apply, and then close the ODBC Administrator.
- Log out and then log in to your Mac.
- Open Tableau Prep and connect to Amazon EMR.
Resources
Follow these steps to install the Windows drivers for Amazon EMR:
- 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.
- Download and install the drivers.
Resources
Tableau Server: 10.5 - 2019.1.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
- Download and unzip the AmazonHiveODBC_1.1.1.1001.zip file available from Amazon's site:
- Go to AmazonHiveODBC_1.1.1.1001/Linux/EL6.
- Install dependencies by running the following command:
sudo yum install cyrus-sasl-gssapi cyrus-sasl-plain cyrus-sasl
- Install the driver by running the following command:
sudo rpm ––nodeps –ivh AmazonHiveODBC-1.1.1.1001-1.el6.x86_64.rpm
- Append the following lines to the /etc/odbcinst.ini file:
- 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
- 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
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:
- Install dependencies by running the following command:
sudo apt-get install libsasl2-2
- 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:
- Go to the Amazon Web Services website.
- 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 bitClick 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)
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.1.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.1.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:
- Close Tableau Desktop.
- Download the AmazonRedshiftODBC.dmg file from the Amazon Redshift page on Amazon's documentation site.
- Double-click the downloaded AmazonRedshiftODBC.dmg file.
- Double-click the AmazonRedshiftODBC.pkg file, and then accept the defaults.
- 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 macFollow these steps to install the Mac driver for Amazon Redshift:
- Close Tableau Desktop.
- Download the drivers from the Download link.
- Double-click the downloaded file, TableauDrivers.dmg.
- Double-click Tableau PostgreSQL Libraries.
- Accept the defaults.
- 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: 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.1.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:
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.1.3
For Tableau Server, follow these steps to get the Windows driver for Amazon Redshift:
- Go to the Amazon Web Services website.
- 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.1.3
You don't have to install a driver.
Resources
Tableau Desktop: 10.1.2 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Server: 10.5 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Desktop & Tableau Server: 10.2 - 2019.1.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.1.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: 2018.2.1 - 2019.1.4
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.1.3
Drivers are available from the MapR site:
- Download the .rpm file.
- To install the driver, run the following command.
sudo yum install maprdrill-1.3.16.1049-1.x86_64.rpm
- 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:
- Sign in to the Teradata website to access Aster drivers.
- Under Aster Client Tools for Windows, select the .zip file for your Windows environment: 32-bit or 64-bit.
- Download and install the drivers.
Resources
Tableau Desktop: 10.2 - 2019.1.3
Download macFollow these steps to install the Mac driver for Aster Database:
- Close Tableau Desktop.
- Download the drivers from the Download link.
- Click the downloaded file.
- Control-click the .pkg file, and then click Open > Open to run the installer.
- Accept the defaults.
- Open Tableau Desktop and connect to Aster Database.
Resources
Tableau Prep: All supported versions
Download macFollow these steps to install the Mac driver for Aster Database:
- Close Tableau Prep.
- Download the drivers from the Download link.
- Click the downloaded file.
- Control-click the .pkg file, and then click Open > Open to run the installer.
- Accept the defaults.
- 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:
- Sign in to the Teradata website to access Aster drivers.
- Under Aster Client Tools for Windows, select the 64-bit .zip file.
- Download and install the drivers.
Resources
Tableau Desktop: 2019.1
The Mac driver for Microsoft Azure SQL Data Warehouse is installed by default with Tableau Desktop.
Resources
Azure SQL Data Warehouse uses the Microsoft SQL Server driver, which is installed by default.
Resources
Tableau Prep: 2019.1.4
The Mac driver for Microsoft Azure SQL Data Warehouse is installed by default with Tableau Prep.
Resources
Azure SQL Data Warehouse uses the Microsoft SQL Server driver, which is installed by default.
Resources
Tableau Server: 2019.1
Download windows 64 bitAzure SQL Datawarehouse 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:
- Download the .rpm file.
- To install the driver, run the following command:
sudo yum install tableau-freetds-1.00.40-1.x86_64.rpm
On Ubuntu:
- Download the .deb file.
- 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.1.3
You don't have to install a driver.
Resources
Tableau Desktop: 10.5 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Server: 10.5 - 2019.1.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:
- Go to the Cloudera website and sign in.
- Under ODBC and JDBC Drivers, select the ODBC driver download for your environment (Hive or Impala).
- Select your operating system version.
- 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:
- Go to the Cloudera website and sign in.
- Under ODBC and JDBC Drivers, select the ODBC driver download for your environment (Hive or Impala).
- Select your operating system version.
- 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: 2018.2.1 - 2019.1.4
Make sure you use the latest available drivers. Follow these steps to install the Cloudera Hadoop Mac driver:
- Go to the Cloudera website and sign in.
- Under ODBC and JDBC Drivers, select the ODBC driver download for your environment (Hive or Impala).
- Select your operating system version.
- 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:
- Go to the Cloudera website and sign in.
- Under ODBC and JDBC Drivers, select the ODBC driver download for your environment (Hive or Impala).
- Select Windows for the Operating System and 64 bit for the version.
- 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.1.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:
- Download and install the driver package.
After installing the driver package, append the following lines to the
/etc/odbcinst.ini
file: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:
- Download and install the driver package.
After installing the driver package, append the following lines to the
/etc/odbcinst.ini
file: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:
- Go to the DataStax website.
- Under Loaders and ODBC/JDBC Drivers, select the driver for your environment.
- Download and install the driver.
Resources
- For information about supported database versions, see Technical Specifications.
Tableau Desktop & Tableau Server: 10.4 - 2019.1.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.1.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: 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.1.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:
- Download the .rpm file.
- To install the driver, run the following command:
sudo yum install tableau-postgresql-odbc-09.06.0500-1.x86_64.rpm
On Ubuntu:
- Download the .deb file.
- 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.1.3
You don't have to install a driver.
Resources
Tableau Desktop: 10.3 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Server: 10.5 - 2019.1.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:
- Go to Downloads on the Exasol website.
- 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:
- Close Tableau Desktop.
- Go to Downloads on the Exasol website.
- Download the latest ODBC driver for macOS.
- Double-click the downloaded .dmg file.
- Double-click Click to install to install the driver.
- 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: All supported versions
Follow these steps to install the Mac driver for Exasol:
- Close Tableau Prep.
- Go to Downloads on the Exasol website.
- Download the latest ODBC driver for macOS.
- Double-click the downloaded .dmg file.
- Double-click Click to install to install the driver.
- Open Tableau Prep and connect to Exasol.
Resources
Follow these steps to install the Windows driver for Exasol:
- Go to Downloads on the Exasol website.
- Download and install the latest x86_64.msi ODBC driver.
Resources
Tableau Server: 2018.1 - 2019.1.3
Drivers are available from the Exasol website:
- Download and extract the ODBC driver tar file for Linux.
- 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
- 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.1.3
You don't have to install a driver.
Resources
Tableau Desktop & Tableau Server: 2019.1
You don't have to install a driver.
Resources
Tableau Desktop: 2019.1
You don't have to install a driver.
Resources
Tableau Server: 2019.1
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.1.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.1.3
You don't have to install a driver.
Resources
Tableau Desktop: 9.3 - 2019.1.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.
- Go to the MySQL website.
- Select your operating system from the drop-down list.
- Select the 64-bit version of the driver.
- 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.
- 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.
- On the Download Connector/ODBC page, select the driver for your platform and bit version.
- 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.
- Close Tableau Desktop.
- 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.
- Download and install the MySQL ODBC connector for your Mac OS X version:
- Older versions:
- Select Version: 5.2.7
- Select Operating System: Mac OS X
- Select OS Version: Select the OS version for your Mac.
For more information, see Installing Connector/ODBC on OS X on the Oracle website.
- Older versions:
- 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: 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.
- Close Tableau Prep.
- 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.
- Download and install the MySQL ODBC connector for your Mac OS X version:
- Older versions:
- Select Version: 5.2.7
- Select Operating System: Mac OS X
- Select OS Version: Select the OS version for your Mac.
For more information, see Installing Connector/ODBC on OS X on the Oracle website.
- Older versions:
- Open Tableau Prep 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.
- Go to the MySQL website.
- Select your operating system from the drop-down list.
- Select the 64-bit version of the driver.
- Download and install the driver.
Resources
Tableau Server: 10.5 - 2019.1.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.
- 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.
- On the Download Connector/ODBC page, select the driver for your platform and bit version.
- Download and install the driver.
Resources
Tableau Desktop & Tableau Server: 2019.1
You don't have to install a driver.
Resources
Tableau Desktop: 2019.1
You don't have to install a driver.
Resources
Tableau Server: 2019.1
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.1.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:
- Go to the Hortonworks website.
- Under Hortonworks ODBC Driver for Apache Hive, select the driver for your Windows bit-version environment.
- 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:
- Close Tableau Desktop.
- Go to the Hortonworks website.
- Under Hortonworks ODBC Driver for Apache Hive, download the driver for OS X.
- 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.
- Open Tableau Desktop and connect to Hortonworks.
Resources
- For information about supported database versions, see Technical Specifications.
Tableau Prep: 2018.2.1 - 2019.1.4
Make sure you use the latest available drivers. Follow these steps to install the Mac driver for Hortonworks Hadoop Hive:
- Close Tableau Prep.
- Go to the Hortonworks website.
- Under Hortonworks ODBC Driver for Apache Hive, download the driver for OS X.
- 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.
- Open Tableau Prep and connect to Hortonworks.
Resources
Tableau Prep: 2018.2.1 - 2019.1.4
Make sure you use the latest available drivers. Follow these steps to install the Hortonworks Hadoop Hive driver on your Windows computer:
- Go to the Hortonworks website.
- Under Hortonworks ODBC Driver for Apache Hive, select the 64-bit driver for Windows.
- Download and install the driver.
Resources
Tableau Server: 10.5 - 2019.1.3
Drivers are available from the Hortonworks website:
- Download the 64-bit driver for your distribution under Hortonworks ODBC Driver for Apache Hive.
- To install the driver, follow the instructions in the documentation, which is available from the Hortonworks download site.
- 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 bitClick the Download link and install the Windows 32-bit driver for IBM BigInsights.
Resources
Tableau Desktop & Tableau Server: 8.2.3 - 2019.1.3
Download windows 64 bitClick the Download link and install the Windows 64-bit driver for IBM BigInsights.
Resources
Tableau Prep: All supported versions
Download windows 64 bitClick the Download link and install the Windows 64-bit driver for IBM BigInsights.
Resources
Tableau Desktop & Tableau Server: All supported versions
Download windows 32 bitYou 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.
Microsoft Odbc Driver Download
Resources
- Connecting Tableau to dashDB article on the IBM website.
- For information about supported database versions, see Technical Specifications.
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: All supported versions
Download windows 64 bitYou 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.1.3
Download linux 64 bitClick 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: All supported versions
Contact your Netezza account team.
Resources
Tableau Desktop & Tableau Server: 10.0 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Server: 10.5 - 2019.1.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.1.3
You don't have to install a driver.
Resources
Tableau Desktop & Tableau Server: 9.3.1 - 10.4
Download windows 32 bitClick the Download link and install the Windows 32-bit driver for Kognitio.
Resources
Tableau Desktop & Tableau Server: 9.3.1 - 2019.1.3
Download windows 64 bitClick the Download link and install the Windows 64-bit driver for Kognitio.
Resources
Tableau Desktop: 9.3.1 - 2019.1.3
Download macFollow these steps to install the Mac driver for Kognitio:
- Close Tableau Desktop.
- Download the drivers from the Download link.
- Click the downloaded file.
- Control-click Kognitio-ODBC-80101s160113.pkg, and then click Open > Open to run the installer.
- Accept the defaults.
- Open Tableau Desktop and connect to Kognitio.
Resources
Tableau Prep: All supported versions
Download macFollow these steps to install the Mac driver for Kognitio:
- Close Tableau Prep.
- Download the drivers from the Download link.
- Click the downloaded file.
- Control-click Kognitio-ODBC-80101s160113.pkg, and then click Open > Open to run the installer.
- Accept the defaults.
- Open Tableau Prep and connect to Kognitio.
Resources
Download windows 64 bitClick 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:
- On the MapR doc website, go to Install the Hive ODBC Connector on Windows. The instructions provide a link to download the driver package.
- Download the package for your Windows environment.
- 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:
- Close Tableau Desktop.
- Go to the 'Installing the Hive ODBC Connector on MacOS' section on the MapR Hive ODBC Connector web page.
- Click the link in the 'Systems Requirements' section to download the MacOS Hive ODBC connector.
- Double-click the downloaded MapRHiveODBC.dmg file.
- Control-click the MapRHiveODBC.pkg and then click Open to run the package. Accept the defaults.
- Open Tableau Desktop and connect to MapR Hadoop Hive.
Resources
- For information about supported database versions, see Technical Specifications.
Tableau Prep: 2018.2.1 - 2019.1.4
Make sure you use the latest available drivers. Follow these steps to install the Mac driver for MapR Hadoop Hive:
- Close Tableau Prep.
- Go to the 'Installing the Hive ODBC Connector on MacOS' section on the MapR Hive ODBC Connector web page.
- Click the link in the 'Systems Requirements' section to download the MacOS Hive ODBC connector.
- Double-click the downloaded MapRHiveODBC.dmg file.
- Control-click the MapRHiveODBC.pkg and then click Open to run the package. Accept the defaults.
- Open Tableau Prep 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:
- On the MapR doc website, go to Install the Hive ODBC Connector on Windows. The instructions provide a link to download the driver package.
- Download the package for the 64-bit Windows environment.
- Follow the instructions for installing the ODBC connector.
Resources
Tableau Desktop & Tableau Server: 2019.1
MariaDB ODBC drivers are available to download from the MariaDB website.
- Select the Product: ODBC connector
- Select the latest GA Version
- Select the OS: MS Windows 64-bit
- Select Download, and then follow the prompts to install the driver.
Resources
Tableau Desktop: 2019.1
MariaDB ODBC drivers are available to download from the MariaDB website.
- Select the Product: ODBC connector
- Select the Version: 3.1.0-Development (non-production)
Note: A GA version is not yet available for macOS. - Select the OS: macOS
- Select Download, and then follow the prompts to install the driver.
Resources
Tableau Prep: 2019.1.4
MariaDB ODBC drivers are available to download from the MariaDB website.
- Select the Product: ODBC connector
- Select the Version: 3.1.0-Development (non-production)
Note: A GA version is not yet available for macOS. - Select the OS: macOS
- Select Download, and then follow the prompts to install the driver.
Resources
MariaDB ODBC drivers are available to download from the MariaDB website.
- Select the Product: ODBC connector
- Select the latest GA Version
- Select the OS: MS Windows 64-bit
- Select Download, and then follow the prompts to install the driver.
Resources
Tableau Server: 2019.1
MariaDB ODBC drivers are available to download from the MariaDB website.
- Select the Product: ODBC connector
- Select the latest GA Version
- Select the OS: RHEL7 64-bit
- Select Download to download the file.
- To install the driver, follow the Installation instructions on the MariaDB website.
Resources
Tableau Desktop & Tableau Server: 10.0.1 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Desktop: 10.0.1 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Server: 10.5 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Desktop & Tableau Server: 8.2.3 - 10.4
Download windows 32 bitClick the Download link and install the Windows 32-bit driver for MarkLogic.
Resources
Tableau Desktop & Tableau Server: 8.2.3 - 2019.1.3
Download windows 64 bitClick the Download link and install the Windows 64-bit driver for MarkLogic.
Resources
Tableau Prep: All supported versions
Download windows 64 bitClick the Download link and install the Windows 64-bit driver for MarkLogic.
Resources
Tableau Desktop: 10.0 - 2019.1.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.
- Close Tableau Desktop.
- 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.
- Download and install the MySQL ODBC connector for your Mac OS X version:
- Older versions:
- Select Version: 5.2.7
- Select Operating System: Mac OS X
- Select OS Version: Select the OS version for your Mac.
For more information, see Installing Connector/ODBC on OS X on the Oracle website.
- Older versions:
- 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.
- Go to the MySQL website.
- Select your operating system from the drop-down list.
- Select the correct bit version of the driver for your Windows environment.
- Download and install the driver.
Resources
Tableau Prep: 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.
- Close Tableau Prep.
- 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.
- Download and install the MySQL ODBC connector for your Mac OS X version:
- Older versions:
- Select Version: 5.2.7
- Select Operating System: Mac OS X
- Select OS Version: Select the OS version for your Mac.
For more information, see Installing Connector/ODBC on OS X on the Oracle website.
- Older versions:
- Open Tableau Prep 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.
- Go to the MySQL website.
- Select your operating system from the drop-down list.
- Select the 64-bit version of the driver.
- Download and install the driver.
Resources
Tableau Server: 2018.1 - 2019.1.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.1.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.
- 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.
- On the Download Connector/ODBC page, select the driver for your platform and bit version.
- 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: 2018.2.2 - 2019.1.4
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: 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.1.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:
- Go the to the Microsoft SQL Server 2012 SP1 PowerPivot for Microsoft Excel 2010 page and click Download.
- Select the installer that matches the Microsoft Office bit version installed on your computer.
- 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.1.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 macYou 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.
- Close Tableau Desktop.
- Download the drivers from the Download link.
- Double-click the downloaded file, TableauDrivers.dmg.
- Double-click Simba SQL Server ODBC.pkg to run the installer.
- Accept the defaults.
- 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: All supported versions
The Mac driver for Microsoft SQL Server is installed by default with Tableau Prep.
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, the Microsoft SQL Server driver is installed by default.
Resources
Tableau Server: 10.5 - 2019.1.3
You can use the Microsoft SQL Server connector to connect Tableau to Microsoft Azure SQL Database.
On CentOS and RHEL:
- Download the .rpm file.
- To install the driver, run the following command:
sudo yum install tableau-freetds-1.00.40-1.x86_64.rpm
On Ubuntu:
- Download the .deb file.
- 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 bitYou 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.
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.1.3
Follow these steps to install the MonetDB Windows driver for Tableau 9.1.2 and later:
- Go to the MonetDB download page for Windows.
- Select the archive directory.
- 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
- Download and install the driver.
Resources
Tableau Prep: All supported versions
Follow these steps to install the MonetDB Windows driver:
- Go to the MonetDB download page for Windows.
- Select the archive directory.
- Scroll to and select the MonetDB-ODBC-Installer-x86_64-20160610.msi file.
We recommend using the June 2016 driver. - Download and install the driver.
Resources
Tableau Desktop & Tableau Server: 10.3 - 2019.1.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.
- Go to the MySQL website.
- Select your operating system from the drop-down list.
- Select the 64-bit version of the driver.
- 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.1.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:
- Close Tableau Desktop.
- 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.
- Download and install the MySQL ODBC connector for your Mac OS X version:
- Older versions:
- Select Version: 5.2.7
- Select Operating System: Mac OS X
- Select OS Version: Select the OS version for your Mac.
For more information, see Installing Connector/ODBC on macOS on the MySQL website.
- Older versions:
- 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: 2018.2.3 - 2019.1.4
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:
- Close Tableau Prep.
- 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.
- Download and install the MySQL ODBC connector for your Mac OS X version:
- Older versions:
- Select Version: 5.2.7
- Select Operating System: Mac OS X
- Select OS Version: Select the OS version for your Mac.
For more information, see Installing Connector/ODBC on macOS on the MySQL website.
- Older versions:
- Open Tableau Prep 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.
- Go to the MySQL website.
- Select your operating system from the drop-down list.
- Select the 64-bit version of the driver.
- 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.1.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.1.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.
- Go to the MySQL website.
- Select your operating system from the drop-down list.
- Select the version of the driver for your Windows environment.
- 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.
- 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.
- On the Download Connector/ODBC page, select the driver for your platform and bit version.
- 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.
- Close Tableau Desktop.
- 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.
- Download and install the MySQL ODBC connector for your Mac OS X version:
- Older versions:
- Select Version: 5.2.7
- Select Operating System: Mac OS X
- Select OS Version: Select the OS version for your Mac.
For more information, see Installing Connector/ODBC on OS X on the Oracle website.
- Older versions:
- 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: 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.
- Close Tableau Prep.
- 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.
- Download and install the MySQL ODBC connector for your Mac OS X version:
- Older versions:
- Select Version: 5.2.7
- Select Operating System: Mac OS X
- Select OS Version: Select the OS version for your Mac.
For more information, see Installing Connector/ODBC on OS X on the Oracle website.
- Older versions:
- Open Tableau Prep 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.
- Go to the MySQL website.
- Select your operating system from the drop-down list.
- Select the 64-bit version of the driver.
- Download and install the driver.
Resources
Tableau Server: 10.5 - 2019.1.3
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.
- 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.
- On the Download Connector/ODBC page, select the driver for your platform and bit version.
- 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.1.3
You don't have to install a driver.
Resources
Tableau Desktop & Tableau Server: 10.3 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Desktop: 10.3 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Server: 10.5 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Desktop: 2019.1
Download windows 64 bitClick the Download link and install the Windows 64-bit Oracle driver for Tableau Desktop 2019.1.
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: 2018.3
Download windows 64 bitClick 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 bitClick 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 bitClick 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 bitClick 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 bitClick 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.
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 bitClick 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.
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 bitClick 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.
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.1.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 bitClick 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.
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 64 bitClick 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.
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.
Tableau Desktop: 9.3
Download windows 64 bitClick 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.
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.
Tableau Desktop: 9.2
Download windows 64 bitClick 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.
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.
Tableau Desktop: 9.1
Download windows 64 bitClick 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.
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.
Tableau Desktop: 9.0
Download windows 64 bitClick 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.
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.
Tableau Desktop: 8.3
Download windows 32 bitClick 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.
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 - 10.1
Download macFollow these steps to install the Oracle driver on your Mac computer:
- Close Tableau Desktop.
- Download the drivers from the Download link.
- Double-click the downloaded file, TableauDrivers.dmg.
- Double-click Tableau Oracle Libraries.
- Accept the defaults.
- Open Tableau Desktop and connect to Oracle.
Resources
- For information about supported database versions, see Technical Specifications.
Tableau Desktop: 8.2
Download windows 32 bitClick 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.
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 Prep: 2019.1.4
Download windows 64 bitClick the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2019.1.4.
Resources
Tableau Prep: 2019.1.3
Download windows 64 bitClick the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2019.1.3.
Resources
Tableau Prep: 2019.1.2
Download windows 64 bitClick the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2019.1.2.
Resources
Tableau Prep: 2019.1.1
Download windows 64 bitClick the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2019.1.1.
Resources
Tableau Prep: 2018.3.3
Download windows 64 bitClick the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.3.3.
Resources
Tableau Prep: 2018.3.2
Download windows 64 bitClick the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.3.2.
Resources
Tableau Prep: 2018.3.1
Download windows 64 bitClick the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.3.1.
Resources
Tableau Prep: 2018.2.3
Download windows 64 bitClick the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.2.3.
Resources
Tableau Prep: 2018.2.2
Download windows 64 bitClick the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.2.2.
Resources
Tableau Prep: 2018.2.1
Download windows 64 bitClick the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.2.1.
Resources
Tableau Prep: 2018.1.2
Download windows 64 bitClick the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.1.2.
Resources
Tableau Prep: 2018.1.1
Download windows 64 bitClick the Download link and install the Windows 64-bit Oracle driver for Tableau Prep 2018.1.1.
Resources
Tableau Prep: All supported versions
The Mac driver for Oracle is installed by default with Tableau Prep.
Resources
Tableau Server: 10.5 - 2019.1.3
Follow these instructions to download and install the Linux 64-bit driver for Tableau Server.
On CentOS and RHEL:
- Download the .rpm file.
- To install the driver, run the following command:
sudo yum install tableau-oracle-12.1.0.2.0-1.x86_64.rpm
On Ubuntu:
- Download the .deb file.
- 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.1.3
You don't have to install a driver.
Resources
Tableau Desktop: 10.1.2 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Server: 10.5 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Desktop: 2019.1
Download windows 64 bitClick 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 bitClick 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.
Tableau Desktop: 2018.2
Download windows 64 bitClick 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 bitClick 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 bitClick 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 bitClick 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.
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 bitClick 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.
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 bitClick 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.
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 bitClick 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.
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 bitClick 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.
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 64 bitClick 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.
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.
Tableau Desktop: 9.2
Download windows 32 bitClick 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.
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 bitClick 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.
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 bitClick 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.
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 bitClick 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.
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 bitClick 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.
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.1.3
Follow these instructions to download and install the Linux 64-bit driver for Tableau Server.
On CentOS and RHEL:
- Download the .rpm file.
- To install the driver, run the following commands:
sudo yum install tableau-essbase-11.1.2.0-1.x86_64.rpm
On Ubuntu:
- Download the .deb file.
- 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.1.3
You don't have to install a driver.
Important: When you use a JDBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau Desktop and Tableau Server features is not guaranteed.
Resources
Tableau Desktop: 2018.3 - 2019.1.3
You don't have to install a driver.
Important: When you use a JDBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau Desktop and Tableau Server features is not guaranteed.
Resources
Tableau Server: 2018.3 - 2019.1.3
You don't have to install a driver.
Important: When you use a JDBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau Desktop and Tableau Server features is not guaranteed.
Resources
Tableau Desktop & Tableau Server: 10.4 - 2019.1.3
You don't have to install a driver.
Important: When you use an ODBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau Desktop and Tableau Server features is not guaranteed.
Resources
Tableau Desktop & Tableau Server: All supported versions
You don't have to install a driver.
Important: When you use an ODBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau Desktop and Tableau Server features is not guaranteed.
Resources
Tableau Server: 10.5 - 2019.1.3
You don't have to install a driver.
Important: When you use an ODBC driver to connect to an unsupported database, the outcome might vary, and compatibility with Tableau Desktop and Tableau Server features is not guaranteed.
Resources
Tableau Desktop & Tableau Server: 10.3 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Desktop: 10.3 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Prep: 2018.3.1 - 2019.1.4
You don't have to install a driver.
Resources
You don't have to install a driver.
Resources
Tableau Server: 10.5 - 2019.1.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:
- Go to the Pivotal website, and then sign in.
- Scroll down to the Data section, and then click Pivotal Greenplum.
- Under Release Download Files, click Greenplum DataDirect ODBC and JDBC.
- Select the ODBC driver for your environment: Windows 32-bit or 64-bit.
- Download and install the driver.
Resources
Tableau Desktop: All supported versions
Download macFollow these steps to install the Pivotal Greenplum Database driver on your Mac computer.
- Close Tableau Desktop.
- Download the drivers from the Download link.
- Double-click the downloaded file, TableauDrivers.dmg.
- Double-click Tableau PostgreSQL Libraries.
- Accept the defaults.
- Open Tableau Desktop and connect to Pivotal Greenplum Database.
Resources
Tableau Prep: All supported versions
Download macFollow these steps to install the Pivotal Greenplum Database driver on your Mac computer.
- Close Tableau Prep.
- Download the drivers from the Download link.
- Double-click the downloaded file, TableauDrivers.dmg.
- Double-click Tableau PostgreSQL Libraries.
- Accept the defaults.
- Open Tableau Prep and connect to Pivotal Greenplum Database.
Resources
Follow these steps to install the Pivotal Greenplum Database driver on your Windows computer:
- Go to the Pivotal website, and then sign in.
- Scroll down to the Data section, and then click Pivotal Greenplum.
- Under Release Download Files, click Greenplum DataDirect ODBC and JDBC.
- Select the 64-bit ODBC driver.
- Download and install the driver.
Resources
Tableau Server: 10.5 - 2019.1.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:
- Download the .rpm file.
- To install the driver, run the following command:
sudo yum install tableau-postgresql-odbc-09.06.0500-1.x86_64.rpm
On Ubuntu:
- Download the .deb file.
- 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.1.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.1.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 bitSelect 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 macFollow these steps to install the Mac driver for PostgreSQL:
- Close Tableau Desktop.
- Download the drivers from the Download link.
- Double-click the downloaded file.
- Double-click Tableau PostgreSQL Libraries.
- Accept the defaults.
- Open Tableau Desktop and connect to PostgreSQL.
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 bitSelect the Download link and install the Windows 64-bit driver for PostgreSQL.
Resources
- For information about supported database versions, see Technical Specifications.
Tableau Prep: All supported versions
The Mac driver for PostgreSQL is installed by default with Tableau Prep. 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.
Resources
Tableau Server: 10.5 - 2019.1.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:
- Download the .rpm file.
- To install the driver, run the following command:
sudo yum install tableau-postgresql-odbc-09.06.0500-1.x86_64.rpm
On Ubuntu:
- Download the .deb file.
- 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 bitThe 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 bitSelect the Download link and install the Windows 32-bit driver for Presto.
Resources
Tableau Desktop & Tableau Server: 10.0 - 2019.1.3
Download windows 64 bitSelect the Download link and install the Windows 64-bit driver for Presto.
Resources
Tableau Desktop: 10.0 - 10.4
Download macFollow these steps to install the Mac driver for Presto:
- Close Tableau Desktop.
- Download the driver from the Download link.
- Click the downloaded file.
- Double-click the Presto .pkg file to run the installer.
- Accept the defaults.
- Open Tableau Desktop and connect to Presto.
Resources
Tableau Prep: 2018.1.2 - 2019.1.4
Download windows 64 bitSelect the Download link and install the Windows 64-bit driver for Presto.
Resources
Download macFollow these steps to install the Mac driver for Presto:
- Close Tableau Prep.
- Download the driver from the Download link.
- Click the downloaded file.
- Double-click the Presto .pkg file to run the installer.
- Accept the defaults.
- Open Tableau Prep and connect to Presto.
Resources
Tableau Server: 2018.1 - 2019.1.3
Download linux 64 bitFollow these steps to install the driver:
- Click the Download link to download the 64-bit Linux driver for Presto.
- To install the driver, run the following command:
sudo yum install simbapresto-1.1-x86_64.rpm
- 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.1.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.1.3
Follow these steps to install the JDBC driver for SAP HANA on your Mac computer:
- Close Tableau Desktop.
- If Java is not already installed on your Mac, download and install the latest Java version from https://www.java.com/en/download/manual.jsp.
- 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.
- Make sure that you have read permissions for the .jar file so that Tableau can access it.
- Open Tableau Desktop and connect to SAP HANA.
Resources
Tableau Prep: 2019.1.4
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:
- Close Tableau Prep.
- If Java is not already installed on your Mac, download and install the latest Java version from https://www.java.com/en/download/manual.jsp.
- 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.
- Make sure that you have read permissions for the .jar file so that Tableau can access it.
- Open Tableau Prep and connect to SAP HANA.
Resources
Tableau Server: 10.5 - 2019.1.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: 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: 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.1.3
You don't have to install a driver.
Resources
Tableau Desktop: 10.3 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Server: 10.5 - 2019.1.3
You don't have to install a driver.
Resources
Tableau Desktop & Tableau Server: 10.2 - 2019.1.3
Download windows 32 bit, 64 bitClick 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.1.3
Download macFollow these steps to install the Mac driver for SharePoint Lists:
- Close Tableau Desktop.
- Download the drivers from the Download Mac link.
- Click the downloaded .dmg file.
- Double-click the CData ODBC Driver for SharePoint .pkg file to run the installer.
- Accept the defaults.
- 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.1.3
Follow these instructions to download and install the Linux 64-bit SharePoint Lists driver for Tableau Server.
On CentOS and RHEL:
- Download the .rpm file.
- To install the driver, run the following command:
sudo yum install SharePoint_Tableau_6883.x86_64.rpm
On Ubuntu:
- Download the .deb file.
- 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.1.3
Follow these steps to get the Windows ODBC driver for Snowflake:
- Sign in to your Snowflake instance.
- Select Help > Download > ODBC Driver.
- 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.1.3
Follow these steps to get the Mac ODBC driver for Snowflake:
- Sign in to your Snowflake instance.
- Select Help > Download > ODBC Driver.
- 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: 2018.2.1 - 2019.1.4
Follow these steps to get the Mac ODBC driver for Snowflake:
- Sign in to your Snowflake instance.
- Select Help > Download > ODBC Driver.
- 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:
- Sign in to your Snowflake instance.
- Select Help > Download > ODBC Driver.
- 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.1.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 bitYou 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.1.3
Download windows 64 bitYou 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.1.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 macFollow these steps to install the Spark SQL driver for your Mac computer:
- Close Tableau Desktop.
- Download the drivers from the Download link.
- Double-click the downloaded file, TableauDrivers.dmg.
- Double-click SimbaSparkODBC.dmg to run the installer.
- Accept the defaults.
- Open Tableau Desktop and connect to Spark SQL.
Resources
- For information about supported database versions, see Technical Specifications.
Tableau Prep: 2018.2.1 - 2019.1.4
The Mac driver for Spark SQL is installed by default with Tableau Prep.
Resources
Download windows 64 bitYou 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.1.3
Download linux 64 bitFollow these instructions to download and install the Linux 64-bit driver for Spark SQL on CentOS and RHEL.
- Click the Download link to download the driver.
- 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.1.3
You don't have to install a driver.
Resources
Tableau Desktop: 10.2 - 2019.1.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:
- Go to the Splunk ODBC driver page and sign in.
- Download and install the driver.
Resources
- For information about supported database versions, see Technical Specifications.
Tableau Prep: All supported versions
Follow these steps to install the Windows driver for Splunk:
- Go to the Splunk ODBC driver page and sign in.
- Download and install the driver.
Resources
Tableau Desktop & Tableau Server: 9.0 - 2019.1.3
You don't have to install a driver.
Resources
- For information about supported database versions, see Technical Specifications.
Tableau Desktop: 9.0 - 2019.1.3
You don't have to install a driver.
Resources
- For information about supported database versions, see Technical Specifications.
Tableau Prep: 2018.1.2 - 2019.1.4
You don't have to install a driver.
Resources
You don't have to install a driver.
Resources
Tableau Server: 10.5 - 2019.1.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:
- Go to the Teradata Downloads page and sign in.
- Select ODBC Driver > Windows.
- Download the latest Teradata ODBC Driver for Windows.
- 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:
- Close Tableau Desktop.
- On the Teradata Downloads page, sign in to your Teradata account.
- Select ODBC Driver > Mac.
- Download the latest Teradata ODBC Driver for Mac OS X.
- Double-click the downloaded .tar file.
- 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. - Restart your computer.
- 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: 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:
- Close Tableau Desktop.
- On the Teradata Downloads page, sign in to your Teradata account.
- Select ODBC Driver > Mac.
- Download the latest Teradata ODBC Driver for Mac OS X.
- Double-click the downloaded .tar file.
- 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. - Restart your computer.
- Open Tableau Desktop 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:
- Go to the Teradata Downloads page and sign in.
- Select ODBC Driver > Windows.
- Download the latest Teradata ODBC Driver for Windows.
- Extract the downloaded file and install the drivers.
Resources
Tableau Server: 10.5 - 2019.1.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.
- 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
- Install the driver dependencies listed in the driver README file on the Teradata website.
- 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
- 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: 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.1.3
You don't have to install a driver.
Resources
Tableau Desktop & Tableau Server: 9.3.1 - 2019.1.3
Follow these steps to download the Windows driver for TIBCO Data Virtualization (formerly called Cisco Information Server):
- Go to edelivery.tibco.com.
- Search for TIBCO Data Virtualization and go to the TIBCO Data Virtualization page on TIBCO eDelivery.
- Select Download and sign in to your account.
- On the download page, select your operating system.
- Agree to the terms, select the individual file option, and expand the download file list.
- Select the file named TIB_tdv_drivers_X.X.X_all.zip, where X.X.X is the current version.
- Download and install the driver.
Resources
Tableau Desktop & Tableau Server: All supported versions
Follow these steps to install the Windows driver for Vertica:
- Go to the Vertica Downloads page on the Vertica website.
- 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.
- Close Tableau Desktop.
- Download the ODBC driver for the Mac from the Vertica Downloads page on the Vertica web site.
- Control-click vertica-odbc-[version].mac.pkg, and then click Open to run the package. Accept the defaults.
- 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:
- 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.
- 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. - Start Terminal and type in the following command to create target directory:
sudo mkdir -p /Library/ODBC/vertica
- Change to the directory you just created:
cd /Library/ODBC/vertica - 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. - Download the drivers from the Download link.
- Double-click TableauDrivers.dmg in the Downloads folder.
- Double-click Tableau Vertica Configure.pkg and accept the defaults. You will be asked to restart your Mac.
- 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: 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.
- Close Tableau Prep.
- Download the ODBC driver for the Mac from the Vertica Downloads page on the Vertica web site.
- Control-click vertica-odbc-[version].mac.pkg, and then click Open to run the package. Accept the defaults.
- Open Tableau Prep 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:
- 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.
- 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. - Start Terminal and type in the following command to create target directory:
sudo mkdir -p /Library/ODBC/vertica
- Change to the directory you just created:
cd /Library/ODBC/vertica - 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. - Download the drivers from the Download link.
- Double-click TableauDrivers.dmg in the Downloads folder.
- Double-click Tableau Vertica Configure.pkg and accept the defaults. You will be asked to restart your Mac.
- Open Tableau Prep and connect to Vertica.
Resources
Follow these steps to install the Windows driver for Vertica:
- Go to the Vertica Downloads page on the Vertica website.
- Download and install the latest version of ODBC driver for Windows.
Resources
Tableau Server: 10.5 - 2019.1.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.1.3
You don't have to install a driver.
Resources
Tableau Server: 10.5 - 2019.1.3
You don't have to install a driver.