Vertica 8.1.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 these drivers:

Linux and UNIX-like platforms: ODBC, JDBC, Python, and vsql clients. See Installing the Client Drivers on Linux and UNIX-Like Platforms.
Windows platforms: ODBC, ADO.NET, and OLE DB client drivers, the vsql client, the Microsoft Connectivity Pack, and the Visual Studio plug-in. See Installing the Client Drivers and Tools on Windows.
Mac OS X platforms: ODBC and vsql clients. See Installing the Client Drivers on Mac OS X.
The cross-platform JDBC client driver .jar file available for installation on all platforms.

To view a list of driver and server version compatibility, see Vertica Analytic Database Driver/Server 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 7 Windows 8 Windows 10	Microsoft .NET Framework 3.5 SP1 or later
Microsoft Windows	x64 (64-bit)	Windows 7 Windows 8 Windows 10
Microsoft Windows Server	x64 (64-bit)	2012 2012 R2 2016

Platform

Processor

Supported Versions

.NET Requirements

Microsoft Windows

x86 (32-bit)

Windows 7

Windows 8

Windows 10

Microsoft .NET Framework 3.5 SP1 or later

Microsoft Windows

x64 (64-bit)

Windows 7

Windows 8

Windows 10

Microsoft Windows Server

x64 (64-bit)

2012

2012 R2

2016

JDBC Driver

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

The Vertica 8.1.x FIPS-enabled JDBC driver requires RHEL 6.6.

Python Driver

The Python driver requires Python version 2.7.x, and is supported on the following platforms:

Platform	Processor	Supported Versions
Red Hat Enterprise Linux	x86_64	6.6, 6.7, 6.8, 6.9, 7.0, 7.3, 7.4
CentOS	x86_64	6.6, 6.7, 6.8, 6.9, 7.0, 7.3, 7.4
SUSE Linux Enterprise	x86_64	11.0 SP3**, 12 SP2
Oracle Enterprise Linux (Red Hat Compatible Kernel only)	x86_64	6.7, 6.8, 7.3, 7.4*
Debian Linux	x86_64	7.6, 7.7, 8.5, 8.9*
Ubuntu	x86_64	12.04 LTS** 14.04 LTS

*Vertica 8.1.1-7 and later 8.1.1 hotfixes support Red Hat Enterprise Linux 6.9, 7.4, CentOS 6.9, 7.4, Oracle Enterprise Linux 7.4, and Debian Linux 8.9.

**OpenText is phasing out support for this operating system. See End-of-Support and Deprecation Notices for more information.

ODBC Driver

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

Platform	Processor	Supported Versions	Driver Manager
Microsoft Windows	x86 (32-bit)	Windows 7 Windows 8 Windows 10	Microsoft ODBC MDAC 2.8
Microsoft Windows	x64 (64-bit)	Windows 7 Windows 8 Windows 10
Microsoft Windows Server	x64 (64-bit)	2012 2012 R2 2016
Red Hat Enterprise Linux	x86_64	6.6, 6.7, 6.8, 6.9, 7.0, 7.3, 7.4	iODBC 3.52.6 and higher unixODBC 2.3.0 and higher DataDirect 5.3 and 6.1 and higher
CentOS	x86_64	6.6, 6.7, 6.8, 6.9, 7.0, 7.3, 7.4
FIPS-compliant Red Hat Enterprise Linux	x86_64	6.6
SUSE Linux Enterprise	x86_64	11.0 SP3*, 12 SP2
Oracle Enterprise Linux (Red Hat Compatible Kernel only)	x86_64	6.7, 6.8, 7.3, 7.4*
Ubuntu	x86_64	12.04 LTS** 14.04 LTS
Debian Linux	x86_64	7.6, 7.7, 8.5, 8.9*
AIX	PowerPC-64	7.1
HP-UX	IA-64	11i V3**
Solaris	SPARC-64	10
Mac OS X	x86_64	10.10, 10.11, 10.12

*Vertica 8.1.1-7 and later 8.1.1 hotfixes support Red Hat Enterprise Linux 6.9, 7.4, CentOS 6.9, 7.4, Oracle Enterprise Linux 7.4, and Debian Linux 8.9.

** OpenText is phasing out support on this operating system. See End-of-Support and Deprecation Notices for more information.

Vertica Analytic Database Driver/Server Compatibility

This section provides information on compatibility for the Vertica Analytic Database driver and server versions.

Note: SHA password security is supported on client driver and server versions 7.1.x and later.

The following table indicates that, in general, all clients are forward compatible.

Client	Client Driver Version	Compatible Server Versions
All Clients	6.1.x	6.1.x, 7.0.x, 7.1.x, 7.2.x, 8.0.x, 8.1.x
	7.0.x	7.0.x, 7.1.x, 7.2.x, 8.0.x, 8.1.x
	7.1.x	7.1.x, 7.2.x, 8.0.x, 8.1.x
	7.2.x	7.2.x, 8.0.x, 8.1.x
	8.0.x	8.0.x, 8.1.x
	8.1.x	8.1.x

The following table lists FIPS 140-2 compatible clients.

Client	Client Driver Version	Compatible Server Versions
FIPS-enabled ODBC	8.0.x	8.0.x, 8.1.x
FIPS-enabled ODBC	8.1.x	8.0.x, 8.1.x
FIPS-enabled JDBC	8.1.x	8.1.x

The following table indicates that the 8.1.x ODBC client is backward compatible.

Client	Client Driver Version	Compatible Server Versions
ODBC (backwards compatibility)	8.1.x	7.1.x, 7.2.x, 8.0.x, 8.1.x

Note: Vertica Release 8.1.x and later adds backwards compatibility for the ODBC client driver. The 8.1.x ODBC client driver is backwards compatible to Vertica server version 7.1. For full compatibility with the previous server version, specify the Protocol property in your connection string. For more information about the Protocol property, see Data Source Name (DSN) Connection Properties.

vsql Client

The Vertica vsql client is included in all client packages; it is not available for download separately. The vsql client is supported on the following platforms:

Operating System	Processor
Microsoft Windows Windows 2012, 2012 R2, 2016, all variants Windows 7, all variants Windows 8, all variants Windows 10	x86, x64
Red Hat Enterprise Linux 6.6, 6.7, 6.8, 6.9, 7.0, 7.3, 7.4	x86, x64
CentOS 6.6, 6.7, 6.8, 6.9, 7.0, 7.3, 7.4	x86, x64
FIPS-compliant Red Hat Enterprise Linux 6.6	x64
Oracle Enterprise Linux 6.7, 6.8, 7.3, 7.4* (Red Hat Compatible Kernels only)	x86, x64
Ubuntu 12.04LTS**, 14.04 LTS	x86, x64
Debian Linux 7.6, 7.7, 8.5, 8.9*	x86, x64
Solaris 10	SPARC-64
AIX 7.1	PowerPC-64
HP-UX 11i V3	IA64
Mac OS X 10.10, 10.11, 10.12	x86, x64

*Vertica 8.1.1-7 and later 8.1.1 hotfixes support Red Hat Enterprise Linux 6.9, 7.4, CentOS 6.9, 7.4, Oracle Enterprise Linux 7.4, and Debian Linux 8.9.

**OpenText is phasing out support for these operating systems. See End-of-Support and Deprecation Notices for more information.