Client drivers support
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 ODBC client driver |
| Windows | ODBC, ADO.NET, OLE DB client drivers, the vsql client, Microsoft Connectivity Pack, Visual Studio plug-in | Windows client driver installer |
| macOS (including M1 and M2 processors) | ODBC, vsql clients | Installing the ODBC client driver |
| 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 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 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 12.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 | 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 | |
| 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 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 |
| macOS | x86, x64, M1, M2 | 10.15 and higher |
| Amazon Linux | x86, x64 | 2 |