Table of Contents:
Overview
Progress DataDirect’s JDBC Driver for PostgreSQL offers a high-performing, secure and reliable connectivity solution for JDBC applications to access PostgreSQL data. Our JDBC driver can be easily used with all versions of SQL and across both 32-bit and 64-bit platforms. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as SAS, Yellowfin, SAP, Sisense, Denodo, Cognos, Jaspersoft, Tableau, Tibco, OBIEE, and more.
- Single connector to multiple PostgreSQL variants like Amazon RDS PostgreSQL, Amazon Aurora, EnterpriseDB, etc.
- Save on costs and time by speeding up data upload and extractions from/to PostgreSQL variant data warehouses
- Protect your data with the most secure authentication methods during data transfer using latest SSL/TLS protocols
Features
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
Super-fast data download using COPY
Download PostgreSQL tables now only to server side files but to client side local files as well using extended PostgreSQL COPY command syntax.
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 JDBC for PostgreSQL Driver
Version 6.0.0
Supported Versions
- 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 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
- Google AlloyDB for PostgreSQL
Platform Support
- 32- and 64-bit platforms
Software Requirements
- Java Virtual Machine (JVM): Java SE 8 or higher (LTS version), including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.
