Unable to Connect to PostgreSQL via Proxy with JDBC Driver in Tableau Prep Builder

KNOWLEDGE BASE

Unable to Connect to PostgreSQL via Proxy with JDBC Driver in Tableau Prep Builder

Published: 09 Mar 2023
Last Modified Date: 10 Mar 2023

Issue

When connecting to PostgreSQL via proxy with JDBC driver in Tableau Prep Builder, the following error messages may appear.

Channel is in state TRANSIENT_FAILURE
Unable to connect to the PostgreSQL server 'xxxxx'. Check that the server is running and that you have access privileges to the requested database.

Environment

Tableau Prep Builder
PostgreSQL
JDBC driver
Windows

Resolution

As a workaround, install and use the ODBC driver.

1. Stop all Tableau Prep Builder applications.
2. Delete JDBC driver from "C:\Program Files\Tableau\Drivers" directory, if it exists.
3. Download ODBC driver installer corresponding to your PostgreSQL version from the website below.
PostgreSQL ODBC driver
4. Install the ODBC driver.