Installing PostgresSQL JDBC Drivers
As an alternative to the Hive ODBC drivers, you can connect to Tableau using the PostgresSQL JDBC driver. For the list of drivers AtScale supports for Tableau, see AtScale Supported Tools and Platforms.
Note: AtScale only supports basic authentication when connecting to Tableau via the PostgresSQL driver.
Before you begin
Before you can install the PostgresSQL driver, you need to make some changes to your system's configuration:
-
Update the following engine settings. For instructions on changing engine settings, see Changing Engine Settings.
- Set
metadataExport.driver.type
topostgres
. - Set
tableau.pgwire.client.protocol
topostgres
. - If you use an external load balancer, set
load.balancer.pgsql.url
to the base URL for the engine's PostgresSQL-compatible SQL endpoint. This should be in the formatschema://hostname:port
. For more information, see Configure an External Load Balancer.
- Set
-
Set the Postgres Server Port field for your organizations. This should be set to
15432
for your first organization. For any additional organizations, increase the port number by one (for example,15433
for your second organization).For more information on configuring organizations, see Create an Organization.
Note: If you upgraded to I2024.2.0 or later from a previous version of AtScale, Postgres Server Port is automatically set for all of your organizations.
Procedure
To install the PostgresSQL driver:
- Download the Java 8 42.7.3 JDBC driver from the PostgresSQL download page.
- Copy the
.jar
file to theDrivers/
folder under Tableau's install location. You may need to create this folder if it doesn't exist.