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, ADO.NET, vsql | Installing the ODBC client driver |
| Windows | ODBC, JDBC, OLE DB, ADO.NET, vsql | Windows client driver installer |
| macOS (including M1 and M2 processors) | ODBC, JDBC, ADO.NET, vsql | Installing the ODBC client driver |
To view a list of driver and server version compatibility, see Client driver and server version compatibility.
ADO.NET Driver
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 Standard 2.0+ or higher (Microsoft .NET Framework 4.6.1+ and .NET Core 3.1+) |
| Microsoft Windows | x64 (64-bit) | Windows 10 | |
| Microsoft Windows Server | x64 (64-bit) |
2016 2019 | |
| Linux | x64 (64-bit) | For supported distributions, see the Microsoft documentation. | |
| macOS | x64 (64-bit) | For supported versions, see the Microsoft documentation. |
OLE DB Driver
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 8-compliant platform or later (Java 8 is the minimum).
ODBC driver
Vertica Analytic Database provides both 32-bit and 64-bit ODBC drivers. Vertica 23.4.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 |