Driver prerequisites

• 1: ODBC prerequisites
• 2: ADO.NET prerequisites
• 3: Python prerequisites
• 4: Perl prerequisites
• 5: PHP prerequisites

1 - ODBC prerequisites

There are several requirements your client systems must meet before you can install the Vertica ODBC drivers.

Operating system

The Vertica ODBC driver requires a supported platform. The list of currently-supported platforms can be found at Client drivers support.

ODBC driver manager

ODBC driver requires that the client system have a supported driver manager. See Installing driver managers on Linux and other UNIX-like platforms for details.

UTF-8, UTF-16 and UTF-32 support

The Vertica ODBC driver is a universal driver that supports UTF-8, UTF-16, and UTF-32 encoding. The default setting depends on the client platform. (see Required ODBC driver configuration settings for Linux and UNIX for more information).

When using the driver with the DataDirect Connect driver manager, DataDirect Connect adapts to the ODBC driver's text encoding settings. You should configure the ODBC driver to use the encoding method that your application requires. This allows strings to be passed between the driver and the application without intermediate conversion.

See also

• Client drivers
• Programming ODBC client applications
• Creating an ODBC data source name (DSN)

2 - ADO.NET prerequisites

The Vertica driver for ADO.NET requires the following software and hardware components:

Operating system

The Vertica ADO.NET driver requires a supported Windows operating system. The list of supported platforms can be found in the Supported Platforms document at https://docs.vertica.com/latest.

Memory

Vertica suggests a minimum of 512MB of RAM.

.NET framework

The requirements for the .NET framework for ADO.NET in Vertica can be found in the Supported Platforms document at https://docs.vertica.com/latest.

See also

• Programming ADO.NET applications

3 - Python prerequisites

Python is a free, agile, object-oriented, cross-platform programming language designed to emphasize rapid development and code readability. Python has been released under several different open source licenses.

Vertica's ODBC driver is tested with multiple versions of Python. See Perl and Python requirements for details.

Python driver

Vertica requires the open source Vertica Python Client or the pyodbc driver module. See your system's Python documentation for installation and configuration information.

Supported operating systems

The Vertica ODBC driver requires one of the operating systems listed in ODBC prerequisites.

For usage and examples, see Programming Python client applications.

4 - Perl prerequisites

Perl is a free, stable, open source, cross-platform programming language licensed under its Artistic License, or the GNU General Public License (GPL).

Your Perl scripts access Vertica through its ODBC driver, using the Perl Database Interface (DBI) module with the ODBC Database Driver (DBD::ODBC). The Vertica ODBC driver is known to be compatible with these versions of Perl:

• 5.8

• 5.10

Later Perl versions may also work.

Perl drivers

The following Perl driver modules have been tested with the Vertica ODBC driver:

• The DBI driver module, version 1.609

• The DBD::ODBC driver module, version 1.22

Other versions may also work.

Supported client systems

The Vertica ODBC driver requires one of the operating systems and driver managers listed in ODBC prerequisites.

5 - PHP prerequisites

PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML. PHP is licensed under the PHP License, an open-source BSD-style license certified by the Open Source Initiative.

PHP modules

The following PHP modules are required:

• php

• php-odbc

• php-pdo

• UnixODBC (if you are using the Unix ODBC driver)

• libiodbc (if you are using the iODBC driver)

Supported client systems

The Vertica ODBC driver requires one of the operating systems and driver managers listed in ODBC prerequisites.