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, vsql clients Installing the client drivers on Linux and UNIX-Like platforms
Windows ODBC, ADO.NET, OLE DB client drivers, the vsql client, Microsoft Connectivity Pack, Visual Studio plug-in Installing the client drivers and tools on Windows
Mac OS X ODBC, vsql clients Installing the client drivers on Mac OS X
Cross-platform JDBC client driver .jar file available for installation on all platforms

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

ADO.NET and OLE DB drivers

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 3.5 SP1 and 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 11.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 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
Mac OS X x86_64 10.12 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
Mac OS X x86, x64 10.12 and higher
Amazon Linux x86, x64 2