Overview

Progress DataDirect’s ODBC Driver for PostgreSQL offers a high-performing, secure and reliable connectivity solution for ODBC applications to access PostgreSQL data. Our ODBC driver can be easily used with all versions of SQL and across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as Tableau, Power BI, Qlik, Excel, Cognos, Informatica, SAS, Board, MicroStrategy, SSIS, Oracle OBIEE and more.

  • SQL92 Compliant single connector for multiple PostgreSQL versions and variants like Amazon RDS PostgreSQL, Amazon Aurora, Enterprise DB etc.  
  • Save on cost and time by speeding up data uploads and extraction to and from PostgreSQL variant data warehouses 
  • Protect your data with the most secure authentication methods during data transfer using latest SSL/TLS protocols 
  • Configure ODBC Driver for PostgreSQL
  • Configure ODBC with operating systems: Windows, Solaris, AIX, and Linux

Features

Support for Windows Truststore for SSL Certificate Validation

Secure Authentication

Secure authentication methods for connections, 

Supports the latest TLS protocols for data encryption, and HTTP Proxy for client security while connecting to cloud deployments 

Fast

Perform high performance bulk data upload using our innovative proprietary features

Versatile

Single connector for on-premises PostgreSQL, PostgreSQL RDS and other PostgreSQL variants like Amazon Aurora, Enterprise DB, across multiple cloud infrastructures and on every major platform. Certified to work with leading applications such as Power BI, Tableau, Informatica, SAS, Cognos, Business Objects and more. 

Robust

Ensure high availability via application failover and workload balancing without changing application code 

Ease of Use

True standards compliance with ODBC and JDBC and SQL 92 

Customizable

Multiple connection properties to tune the driver performance and behaviors to your organizations specific behavior and needs 

Performance Leadership

Delivers maximum throughput with the best utilization of resources like CPU and memory for real-world usage scenarios. 

Technical Specifications

Progress DataDirect for ODBC for PostgreSQL Wire Protocol Driver
Version 8.0.2
(32- and 64-bit drivers are available for all supported databases and platforms unless otherwise noted.)

ODBC Version Support

  • Compatible with ODBC 3.8 applications

Database Support

  • Amazon Aurora PostgreSQL 16.0 and higher
  • Amazon Aurora PostgreSQL 15.0 and higher
  • Amazon Aurora PostgreSQL 14.6 and higher
  • Amazon Aurora PostgreSQL 13.9 and higher
  • Amazon Aurora PostgreSQL 12.13 and higher
  • Amazon Aurora PostgreSQL 11.18 and higher
  • EDB Postgres Advanced Server 10.1 and higher
  • PostgreSQL 17.0 and higher
  • PostgreSQL 16.0 and higher
  • PostgreSQL 15.0 and higher
  • PostgreSQL 14.0 and higher
  • PostgreSQL 13.0 and higher
  • PostgreSQL 12.0 and higher
  • PostgreSQL 11.0 and higher
  • Yellowbrick Data Warehouse

Operating System Support

AIX (32- and 64-bit)

  • AIX, version 7.3 and higher
  • AIX, version 7.1 and higher

Linux x86 (32- and 64-bit for AMD and Intel processors. 64-bit for Itanium II.)

  • Debian Linux x86, version 12.0 and higher
  • Oracle Linux x86, version 9.0 and higher
  • Red Hat Enterprise Linux x86, version 8.0, 9.0 and higher
  • SUSE Linux Enterprise Server Linux x86, version 12, 15 and higher
  • Ubuntu Linux x86, version 20.04, 22.04 and higher

Solaris (32- and 64-bit)

  • Solaris x86, version 10 (Solaris 5.10), 11 and higher
  • Solaris on SPARC, version 10, 11 and higher

Note: For Solaris and Solaris on SPARC, the 32-bit driver installers work only on 64-bit platforms. Please contact Technical Support if you want to use the driver on the 32-bit platforms.

Windows (32- and 64-bit)

  • Windows (x86), version 10, 11 and higher
  • Windows Server (x86), version 2016, 2019, 2022 and higher

Driver/Client Software Requirements

  • No Requirements

Connect any application to any data source anywhere

Explore all DataDirect Connectors

A product specialist will be glad to get in touch with you

Contact Us