Vertica 9.3.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
.jarfile 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 10 |
Microsoft .NET Framework 3.5 SP1 or later 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. (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 9.3. on a FIPS-enabled machine, you may encounter the following error: "Upgrading to Vertica 9.3.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.
Python Driver
The Python driver requires Python version 2.7.x. Vertica supports Python 2.7.x on the following platforms:
| Platform | Processor | Supported Versions |
|---|---|---|
|
Red Hat Enterprise Linux |
x86_64 | 6.6, 6.7, 6.8*, 6.9*, 6.10, 7.0*, 7.3, 7.4, 7.5, 7.6 |
|
CentOS |
x86_64 |
6.6, 6.7, 6.8*, 6.9*, 6.10, 7.0*, 7.3, 7.4, 7.5, 7.6 |
| SUSE Linux Enterprise | x86_64 |
12 SP2, 12 SP3, 12 SP4 |
| openSUSE | x86_64 | 42.3 |
| Oracle Enterprise Linux (Red Hat compatible kernels only) | x86_64 | 6.7, 6.8, 6.9, 6.10, 7.3, 7.4, 7.5, 7.6 |
| Debian Linux | x86_64 | 8.5, 8.9 |
| Ubuntu | x86_64 |
14.04 LTS*, 16.04 LTS, 18.04 LTS |
| Amazon Linux | x86_64 |
2 |
* Vertica is phasing out support for this operating system. See End-of-Support Notices for more information.
ODBC Driver
Vertica Analytic Database provides both 32-bit and 64-bit ODBC drivers. Vertica 9.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 | x86_64 | 6.6, 6.7, 6.8*, 6.9*, 6.10, 7.0*, 7.3, 7.4, 7.5, 7.6 |
iODBC 3.52.6 or later unixODBC 2.3.0 or later DataDirect 5.3 and 6.1 or later |
| FIPS-compliant Red Hat Enterprise Linux | x86_64 | 6.6, 7.8 | |
| CentOS | x86_64 | 6.6, 6.7, 6.8*, 6.10, 7.0*, 7.3, 7.4, 7.5, 7.6 | |
| 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, 6.8, 6.9, 6.10, 7.3, 7.4, 7.5, 7.6 | |
| Ubuntu |
x86_64 |
14.04 LTS*, 16.04 LTS, 18.04 LTS |
|
| Amazon Linux | x86_64 | 2 | |
| Debian Linux | x86_64 | 8.5, 8.9 | |
| Mac OS X | x86_64 | 10.11*, 10.12 |
* Vertica is phasing out support for this operating system. See End-of-Support 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.
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, 9.0.x, 9.1.x, 9.2.x, 9.3.x |
| 7.0.x | 7.0.x, 7.1.x, 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x, 9.3.x | |
| 7.1.x | 7.1.x, 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x, 9.3.x | |
| 7.2.x | 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x, 9.3.x | |
| 8.0.x | 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x, 9.3.x | |
| 8.1.x | 8.1.x, 9.0.x, 9.1.x, 9.2.x, 9.3.x | |
| 9.0.x | 9.0.x, 9.1.x, 9.2.x, 9.3.x | |
| 9.1.x | 9.1.x, 9.2.x, 9.3.x | |
| 9.2.x | 9.2.x, 9.3.x | |
| 9.3.x | 9.3.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 ODBC | 9.0.x | 8.0.x, 8.1.x, 9.0.x |
| FIPS-enabled ODBC | 9.1.x | 8.0.x, 8.1.x, 9.0.x, 9.1.x |
| FIPS-enabled JDBC | 8.1.x | 8.1.x |
| FIPS-enabled JDBC | 9.0.x | 8.1.x, 9.0.x |
| FIPS-enabled JDBC | 9.1.x | 8.1.x, 9.0.x, 9.1.x |
| FIPS-enabled JDBC | 9.2.x | 8.1.x, 9.0.x, 9.1.x, 9.2.x |
| FIPS-enabled JDBC | 9.3.x | No support. If you need FIPS support, install or stay on 9.2.x |
The following table indicates that the 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 |
| ODBC (backwards compatibility) | 9.0.x | 7.1.x, 7.2.x, 8.0.x, 8.1.x, 9.0.x |
|
ODBC (backwards compatibility) |
9.1.x | 7.1.x, 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x |
|
ODBC (backwards compatibility) |
9.2.x | 7.1.x, 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x |
The following table indicates that the JDBC and ADO.NET clients are backward compatible.
| Client | Client Driver Version | Compatible Server Versions |
|---|---|---|
|
JDBC and ADO.NET (backwards compatibility) |
9.1.1 | 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x |
|
JDBC and ADO.NET (backwards compatibility) |
9.2.0 | 7.2.x, 8.0.x, 8.1.x, 9.0.x, 9.1.x, 9.2.x |
Vertica ODBC client drivers are backwards compatible to all Vertica server versions 7.1 and later. JDBC and ADO.NET client drivers are backwards compatible to all Vertica server versions 7.2 and later.
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
|
x86, x64 |
Windows 2016, 2019: all variants Windows 10 |
| Red Hat Enterprise Linux 6.6, 6.7, 6.8*, 6.9*, 6.10, 7.0*, 7.3, 7.4, 7.5, 7.6 | x86, x64 | |
| CentOS 6.6, 6.7, 6.8*, 6.9*, 6.10, 7.0*, 7.3, 7.4, 7.5, 7.6 | x86, x64 | |
| FIPS-compliant Red Hat Enterprise Linux 6.6, 7.8 | x64 | |
| SUSE Linux Enterprise 12 SP2, 12 SP3, 12 SP4 | x86, x64 | |
| openSUSE 42.3 | x86, x64 | |
| Oracle Enterprise Linux 6.7, 6.8, 6.9, 6.10, 7.3, 7.4, 7.5, 7.6 (Red Hat compatible kernels only) | x86, x64 | |
| Ubuntu 14.04 LTS*, 16.04 LTS, 18.04 LTS | x86, x64 | |
| Debian Linux 8.5, 8.9 | x86, x64 | |
| Mac OS X 10.11*, 10.12, 10.13 | x86, x64 | |
| Amazon Linux 2 | x86, x64 |
* Vertica is phasing out support for this operating system. See End-of-Support Notices for more information.