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 8-compliant platform or later (Java 8 is the minimum).

ODBC driver

Vertica Analytic Database provides both 32-bit and 64-bit ODBC drivers. Vertica 24.1.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 8.0 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: all variants

Windows 10

Red Hat Enterprise Linux / CentOS x86, x64 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