All Products
Search

This Product

    PolarDB:Clients and drivers

    Document Center

    PolarDB:Clients and drivers

    Last Updated:Feb 24, 2025

    This topic describes the clients and drivers that you can use to connect to PolarDB for PostgreSQL (Compatible with Oracle) clusters.

    Clients

    Type

    Description

    Installation package

    PolarDB-Tools

    You can use PolarDB-Tools only in Alibaba Cloud Linux, Rocky Linux, CentOS Stream, and CentOS operating systems. PolarDB-Tools includes tools such as psql, pg_dump, and pg_restore. For more information, see PolarDB-Tools.

    Note

    • The tools in PolarDB-Tools, such as psql and pg_dump, are different from the tools of community editions. The tools in PolarDB-Tools are adapted for PolarDB for PostgreSQL (Compatible with Oracle) clusters. Unexpected errors, incomplete data backups, or incomplete restorations may occur if you use the tools of community editions such as psql and pg_dump to connect to PolarDB for PostgreSQL (Compatible with Oracle) clusters.

    PolarDB-Tools.tar.gz

    PolarPlus

    You can use PolarPlus only in Linux operating systems. PolarPlus provides a CLI and supports SQL statements, PolarPlus commands, Procedural Language/SQL (PL/SQL) anonymous blocks, functions, and stored procedures. For more information, see PolarPlus.

    PolarPlus

    Drivers

    Type

    Description

    Driver package

    JDBC

    PolarDB provides Java DataBase Connectivity (JDBC) drivers for Java 6, Java 7, and Java 8. The corresponding Java Archive (JAR) files are named polardb-jdbc16.jar, polardb-jdbc17.jar, and polardb-jdbc18.jar. You can select the appropriate JDBC driver based on the Java Development Kit (JDK) version used by the application. For more information, see JDBC.

    JDBC driver (42.2.9.1.6)

    OCI

    A native C language interface that you can use to connect to a PolarDB for PostgreSQL (Compatible with Oracle) cluster. You can use Oracle Call Interface (OCI) to build language-specific interfaces, including PolarDB JDBC, PolarDB .NET, and PolarDB Open Database Connectivity (ODBC). OCI allows you to execute query statements and invoke SQL functions for PolarDB for PostgreSQL (Compatible with Oracle) clusters. For more information, see OCI.

    polardb-oci.tar.gz

    ODBC

    An ODBC driver that you can use to connect a UNIX, Linux, or Windows application to a PolarDB for PostgreSQL (Compatible with Oracle) cluster. For more information, see ODBC.

    For 32-bit x86 UNIX or Linux, download PolarDB-ODBC_Linux_X86_32.tar.gz.

    For 64-bit x86 UNIX or Linux, download PolarDB-ODBC_Linux_X86_64.tar.gz.

    For 64-bit ARM UNIX or Linux, download PolarDB-ODBC_Linux_arm_64.tar.gz.

    For 64-bit x86 Windows, download PolarDB-ODBC_Windows_x86_64.7z.

    .NET

    PolarDB .NET, also known as ADO.NET Data Provider for PolarDB, is a driver that allows you to use applications written in programming languages such as C#, Visual Basic, and F# to connect to PolarDB clusters. The PolarDB .NET driver is compatible with Entity Framework Core and Entity Framework 6.x. You can use the PolarDB .NET driver together with Entity Framework to develop applications in an efficient manner. For more information, see .NET.

    . NET driver

    PHP

    To connect a PHP application to a PolarDB for PostgreSQL (compatible with Oracle) cluster, install the pgsql driver. For more information, see PHP.

    • Windows: Download and install WampServer. Then, install the pgsql driver.

    • Linux: Install the php-pgsql.x86_64 driver package.

    PolarDBO Flink CDC

    A Flink connector tailored for PolarDB for PostgreSQL (Compatible with Oracle) cluster. The connector is adapted from the community Postgres Change Data Capture (CDC) solution with minimal code modifications.

    PolarDBO Flink CDC

    Debezium PolarDBO connector

    A Debezium connector tailored for PolarDB for PostgreSQL (Compatible with Oracle) The connector is adapted from for the community Debezium PostgreSQL connector solution with minimal code modifications.

    Debezium PolarDBO connector