Client drivers

You must install the Vertica client drivers to access Vertica from your client application.

You must install the Vertica client drivers to access Vertica from your client application. The drivers create and maintain connections to the database and provide APIs that your applications use to access your data. The client drivers support connections using JDBC, ODBC, and ADO.NET.

Client driver standards

The client drivers support the following standards:

  • ODBC drivers conform to ODBC 3.5.1 specifications.

  • JDBC drivers conform to JDK 5 specifications.

  • ADO.NET drivers conform to .NET framework 3.0 specifications.

Installing the client drivers

How you install client drivers depends on the client's operating system:

  • For Linux and UNIX clients, you must first install a Linux driver manager. After you have installed the driver manager, there are two different ways to install the client drivers:

    • On Red Hat Enterprise Linux 5, 64-bit and SUSE Linux Enterprise Server 10/11 64-bit, you can use the Vertica client RPM package to install the ODBC and JDBC drivers as well as the vsql client.

    • On other Linux platforms and UNIX-like platforms you can download the ODBC and JDBC drivers and install them individually.

  • On Mac OS X clients, download the ODBC client driver .pkg file. The driver is compatible with both 32-bit and 64-bit applications.

  • On Windows clients, download the 32-bit or 64-bit client installer. The installer provides the ODBC client driver, the ADO.NET client driver, the OLE DB client driver, the vsql client, the Microsoft Connectivity Pack, and the Visual Studio plug-in.

  • There is a cross-platform JDBC client driver .jar file available for installation on all platforms.

The remainder of this section explains the requirements for the Vertica client drivers, and the procedure for downloading, installing, and configuring them.