Requirements and compatibility

Before installation, ensure that your system meets the necessary requirements and that your environment is compatible with supported platforms and tools.

Requirements

To ensure optimal performance and compatibility, your system must meet the following requirements before you install ODBC Driver for PostgreSQL:

  • Only one version of the driver can be installed on your system at a time.
  • Direct mode: No additional client software is required.

Compatibility

PostgreSQL compatibility

The driver supports seamless integration with PostgreSQL, ensuring compatibility with the following environments:

  • PostgreSQL server versions: 8.0-18

  • Microsoft Azure Database for PostgreSQL

  • Amazon Aurora for PostgreSQL

  • Amazon RDS for PostgreSQL

  • Google Cloud SQL for PostgreSQL

  • AlloyDB for PostgreSQL (Google Cloud)

  • CockroachDB (PostgreSQL-compatible)

  • Heroku Postgres

Supported platforms

The driver is compatible with major operating systems:

  • Windows (32-bit and 64-bit, including Windows Terminal Server).
  • macOS (32-bit and 64-bit) and ARM (Apple Silicon M1).
  • Linux (32-bit and 64-bit).

Verified compatibility with data integration tools

The driver integrates with various development environments, database management systems, BI tools, and office software. Please note that the following list of supported tools is not exhaustive.

Application development tools

  • Adobe ColdFusion
  • Embarcadero Delphi & C++Builder (UniDAC, FireDAC, dbGo (ADO), BDE, dbExpress)
  • FileMaker
  • Lazarus
  • Microsoft Visual FoxPro
  • Microsoft Visual Studio (Server Explorer, ADO.NET ODBC Provider)
  • Omnis Studio
  • PHP
  • PowerBASIC
  • Python

Database management tools

  • Aqua Data Studio
  • dbForge Studio
  • dBeaver
  • EMS SQL Management Studio
  • Informatica Cloud
  • RazorSQL
  • SQL Server Data Tools
  • SQL Server Management Studio
  • SQL Server Reporting Services

BI & analytics software

  • Alteryx
  • DBxtra
  • Dundas BI
  • IBM SPSS Statistics
  • MicroStrategy
  • Power BI
  • Qlik Sense
  • QlikView
  • RStudio
  • SAP Crystal Reports
  • SAS JMP
  • Tableau
  • TARGIT
  • TIBCO Spotfire

Office software suites

  • LibreOffice
  • Microsoft Access
  • Microsoft Excel
  • OpenOffice
  • StarOffice

For more information on integrations, see PostgreSQL Integrations Using ODBC Driver.