This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Client drivers support

Vertica provides JDBC, ODBC, OLE DB, Python, vsql, and ADO.NET client drivers.

Vertica provides JDBC, ODBC, OLE DB, Python, vsql, and ADO.NET client drivers. Download the latest drivers from Vertica Client Drivers. Choose from drivers for the following platforms:

Platform Drivers See also
Linux/UNIX ODBC, JDBC, Python, ADO.NET, vsql Installing the ODBC client driver
Windows ODBC, JDBC, OLE DB, ADO.NET, vsql Windows client driver installer
macOS (including M1 and M2 processors) ODBC, JDBC, ADO.NET, vsql Installing the ODBC client driver

To view a list of driver and server version compatibility, see Client driver and server version compatibility.

ADO.NET Driver

The ADO.NET and OLE DB drivers are supported on the following platforms:

Platform Processor Supported Versions .NET Requirements
Microsoft Windows x86 (32-bit) Windows 10 Microsoft .NET Standard 2.0+ or higher (Microsoft .NET Framework 4.6.1+ and .NET Core 3.1+)
Microsoft Windows x64 (64-bit) Windows 10
Microsoft Windows Server x64 (64-bit)

2016

2019

Linux x64 (64-bit) For supported distributions, see the Microsoft documentation.
macOS x64 (64-bit) For supported versions, see the Microsoft documentation.

OLE DB Driver

The ADO.NET and OLE DB drivers are supported on the following platforms:

Platform Processor Supported Versions .NET Requirements
Microsoft Windows x86 (32-bit) Windows 10 Microsoft .NET Framework 4.6 or higher service packs
Microsoft Windows x64 (64-bit) Windows 10
Microsoft Windows Server x64 (64-bit)

2016

2019

JDBC driver

All non-FIPS JDBC drivers are supported on any Java 5-compliant platform or later (Java 5 is the minimum).

ODBC driver

Vertica Analytic Database provides both 32-bit and 64-bit ODBC drivers. Vertica 23.3.x ODBC drivers are supported on the following platforms:

Platform Processor Supported Versions Driver Manager
Microsoft Windows x86 (32-bit) Windows 10 Microsoft ODBC MDAC 2.8
Microsoft Windows x64 (64-bit) Windows 10
Microsoft Windows Server x64 (64-bit)

2016

2019

Red Hat Enterprise Linux / CentOS x86_64 7.0, 7.3 and later

iODBC 3.52.6 and higher

unixODBC 2.3.0 and higher

DataDirect 5.3 and 6.1 and higher

FIPS-compliant Red Hat Enterprise Linux x86_64 8.1 and higher
SUSE Linux Enterprise x86_64 12 SP2, 12 SP3, 12 SP4
openSUSE x86_64 42.3

Oracle Enterprise Linux

(Red Hat compatible kernel only)

x86_64 7.3 and higher
Ubuntu x86_64 14.04 LTS, 16.04 LTS, 18.04 LTS, 19.1
Amazon Linux x86_64 2
Debian Linux x86_64 8.5, 8.9, 10
macOS x86_64, M1, M2 10.15 and higher

vsql client

The Vertica vsql client is included in all client packages. It is not available as a separate download. The vsql client is supported on the following platforms:

Operating System Processor Supported Versions
Microsoft Windows x86, x64

Windows 2016, 2019

Windows 10

Red Hat Enterprise Linux / CentOS x86, x64

7.x: all

8.x: all

FIPS-compliant Red Hat Enterprise Linux x64 8.1 and higher
SUSE Linux Enterprise x86, x64 12: SP2 and higher
openSUSE x86, x64 42.3

Oracle Enterprise Linux

(Red Hat compatible kernels only)

x86, x64

6.7 and higher

7.x: all

Ubuntu x86, x64 14.04 LTS, 16.04 LTS, 18.04 LTS, 19.1
Debian Linux x86, x64 8.5, 8.9
macOS x86, x64, M1, M2 10.15 and higher
Amazon Linux x86, x64 2

1 - Perl driver requirements

To use Perl with Vertica, you must install the Perl driver modules (DBI and DBD::ODBC) and a Vertica ODBC driver on the machine where Perl is installed.

To use Perl with Vertica, you must install the Perl driver modules (DBI and DBD::ODBC) and a Vertica ODBC driver on the machine where Perl is installed. The following table lists the Perl versions supported with Vertica 23.3.x.

Later versions of Perl (5.10 and above), DBI, and DBD::ODBC might also work.

Perl Version Perl Driver Modules ODBC Requirements
  • 5.8

  • 5.10

  • DBI driver version 1.609

  • DBD::ODBC version 1.22

See Client drivers support.

2 - Python driver requirements

To use Python with Vertica, you must install either:.

To use Python with Vertica, you must install either:

  • The vertica-python client.

  • The pyodbc module.

For details, see Installing Python client drivers.

The following table lists compatible versions of Python, the Python drivers, and ODBC.

Python Version Python Driver Module ODBC Requirements
2.4.6 pyodbc 2.1.6 See Client drivers support.
2.7.x Vertica Python Client (Linux only)
2.7.3 pyodbc 3.0.6
3.3.4 pyodbc 3.0.7