KNOWLEDGE BASE

How to connect to PostgreSQL 12 from Tableau Desktop/Prep Builder 2020.3 or earlier?


Published: 25 Nov 2020
Last Modified Date: 01 Mar 2021

Question

How to connect to PostgreSQL 12 from Tableau Desktop/Prep Builder 2020.3 or earlier?
Note: The current PostgreSQL ODBC driver distributed with Tableau does not support connectivity with PostgreSQL 12 databases. A new PostgreSQL JDBC driver is planned for release with Tableau 2020.4. At that time, you'll be able to connect to PostgreSQL 12 databases when you upgrade to Tableau 2020.4 and use the new JDBC driver.

Environment

  • Tableau Desktop 2020.3 or earlier
  • Tableau Prep Builder 2020.3 or earlier
  • PostgreSQL 12

Answer

As a possible workaround, use Other Databases (JDBC) connector

Version 2020.2 - 2020.3
Windows
  1. Close Tableau Desktop
  2. If Java is not already installed on your computer, download and install the latest Java 8 version. There are many options available. We recommend downloading from https://adoptopenjdk.net/index.html
    Choose your operating system, choose "OpenJDK 8 (LTS)", and choose "Hotspot". Then click Latest Release and follow the on-screen instructions to install
  3. Download the latest JDBC driver (.jar file) from https://jdbc.postgresql.org/download.html 
  4. Move the downloaded .jar file to C:\Program Files\Tableau\Drivers
  5. Open Tableau Desktop and connect via Other Databases (JDBC) connector
Mac
  1. Close Tableau Desktop
  2. If Java is not already installed on your computer, download and install the latest Java 8 version. There are many options available. We recommend downloading from https://adoptopenjdk.net/index.html
    Choose your operating system, choose "OpenJDK 8 (LTS)", and choose "Hotspot". Then click Latest Release and follow the on-screen instructions to install
  3. Download the latest JDBC driver (.jar file) from https://jdbc.postgresql.org/download.html 
  4. Copy the downloaded .jar file to the /Library/JDBC directory. You might have to create the JDBC directory if it doesn't already exist
  5. Make sure that you have read permissions for the .jar file so that Tableau can access it
  6. Open Tableau Desktop and connect via Other Databases (JDBC) connector
Version 2020.1 or earlier
Windows
  1. Close Tableau Desktop
  2. Download the latest JDBC driver (.jar file) from https://jdbc.postgresql.org/download.html 
  3. Move the downloaded .jar file to C:\Program Files\Tableau\Drivers
  4. Open Tableau Desktop and connect via Other Databases (JDBC) connector
Mac
  1. Close Tableau Desktop
  2. Download the latest JDBC driver (.jar file) from https://jdbc.postgresql.org/download.html 
  3. Copy the downloaded .jar file to the /Library/JDBC directory. You might have to create the JDBC directory if it doesn't already exist
  4. Make sure that you have read permissions for the .jar file so that Tableau can access it
  5. Open Tableau Desktop and connect via Other Databases (JDBC) connector
Did this article resolve the issue?