Vertica 10.0.x 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:

Plaform Drivers See also
Linux/UNIX ODBC, JDBC, 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

If you are installing on Windows Server 2019, you must manually install the .NET 3.5 framework.

 

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).

Vertica 9.3.x and 10.0.x do not support FIPS because of a limitation with OpenSSL. If you need FIPS support, install or upgrade to 10.1.1 or above.

If you install or upgrade from Vertica 9.2.x to Vertica 10.0. on a FIPS-enabled machine, you may encounter the following error: "Upgrading to Vertica 10.0.x-xxxxxxxx on a FIPS system is not supported." To resolve this, you must downgrade to Vertica 9.2.x: uninstall the Vertica RPM on every node in the cluster and then reinstallVertica 9.2.x.

ODBC Driver

Vertica Analytic Database provides both 32-bit and 64-bit ODBC drivers. Vertica 10.0.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

6.6 and later

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 6.6, 7.8
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

6.7 and higher

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.11, 10.12

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

6.6 and higher

7.x: all

FIPS-compliant Red Hat Enterprise Linux x64 6.6, 7.8
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.11, 10.12, 10.13
Amazon Linux x86, x64 2