KNOWLEDGE BASE

Tableau Desktop does not read .pgpass file for postgresql connections using JDBC driver


Published: 19 May 2021
Last Modified Date: 24 May 2021

Issue

After updating to version 2021.1, Tableau Desktop no longer reads .pgpass file for postgreSQL connections

Environment

  • Tableau Desktop 2021.1.
  • PostgreSQL

Resolution

Possible workarounds are:

  1. Use ODBC driver
  2. Use postgres.properties file with JDBC driver.

 

Cause

JDBC connection does not read pgpass file by design.
 

Additional Information

JDBC connection can be customized by using .properties file. More info here
Example of "Postgres.properties" file.
user=UserName
password=Password
 
Saved on "My Tableau Repository\Datasources\"
Did this article resolve the issue?