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
| |
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. |
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 | |
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. | |
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. | |
PHP | To connect a PHP application to a PolarDB for PostgreSQL (compatible with Oracle) cluster, install the pgsql driver. For more information, see PHP. |
|
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. | |
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. |