Does TIBCO Data Virtualization 8.7 support connecting to PostgreSQL13 and PostgreSQL14 database versions?

Does TIBCO Data Virtualization 8.7 support connecting to PostgreSQL13 and PostgreSQL14 database versions?

book

Article ID: KB0071497

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 8.7

Description

This article provides details on the support for connecting to PostgreSQL 13 and 14 with TIBCO Data Virtualization(TDV) 8.7 version. 

Issue/Introduction

Does TIBCO Data Virtualization 8.7 support connecting to PostgreSQL13 and PostgreSQL14 database versions?

Environment

All supported Operating Systems

Resolution

TDV 8.7 introduced a new adapter PostgreSQL 12. Though this adapter is named 'PostgreSQL 12', it is enhanced to support connection with PostgreSQL version 13 and 14 database versions and supports the newer functions available in those DB versions. For the complete list of functions Support, refer to the  TDV PostgreSQL 8.7 adapter guide.

Screenshot of the adapter for reference  :

User-added image 

NOTE: Like previous PostgreSQL adapters, this adapter comes installed with the "postgresql-42.2.26" JDBC driver for connection. 

Additional Information

Release Notes of 8.7 that confirm that Postgres 13 and Postgres 14 are supported (Under "Data Source Improvements" section) : https://docs.tibco.com/pub/tdv/8.7.0/TIB_tdv_8.7.0_relnotes.pdf#page=4