Installing ODBC drivers on Linux
Read Driver prerequisites before you proceed.
For Red Hat Enterprise Linux and SUSE Linux Enterprise Server, you can download and install a client RPM that installs both the ODBC and JDBC driver and the vsql client. See Installing the client RPM on red hat and SUSE.
Note
The ODBC and JDBC client drivers are installed by the server .rpm files. If you have installed Vertica on your Linux system for development or testing purposes, you do not need to download and install the client drivers on it—you just need to configure the drivers. To use ODBC, you need to create a DSN (see Creating an ODBC DSN for Linux). To use JDBC, you need to add the JDBC client driver to the Java CLASSPATH (see Modifying the Java CLASSPATH). (The JDBC client driver is not available on FIPS-compliant systems.)
For details, see Supported platforms.
The ODBC driver installation packages are broken down by client platform on the Vertica driver downloads page. The package's filename is named based on its operating system and architecture (for example, vertica_
11.1.x.xx_odbc_x86_64_linux.tar.gz)
Important
Vertica provides the FIPS-compliant client driver only as an rpm for 64-bit clients. You can install this rpm only on FIPS-enabled machines. The FIPS client includes vsql and ODBC drivers. If you are installing the FIPS-specific client, refer to the section, Installing the FIPS client driver for ODBC and vsql.Installation procedure
-
Open a web browser and browse to the Vertica driver downloads page.
-
Locate and download the driver package that matches your Vertica version and platform.
-
If you did not directly download to the client system, transfer the downloaded file to it.
-
Log in to the client system as root.
-
If the directory
/opt/vertica/does not exist, create it:# mkdir -p /opt/vertica/ -
Copy the downloaded file to the
/opt/vertica/directory. For example:# cp vertica_11.1.x.xx_odbc_x86_64_linux.tar.gz /opt/vertica/ -
Change to the /opt/vertica/ directory:
# cd /opt/vertica/ -
Uncompress the file you downloaded. For example:
$
tar vzxfvertica_11.1.x.xx_odbc_x86_64_linux.tar.gzTwo folders are created: one for the include file, and one for the library files. The path of the library file depends on the processor architecture:
libfor 32-bit libraries, andlib64for 64-bit libraries. So, a 64-bit driver client download creates the directories:-
/opt/vertica/include, which contains the header file -
/opt/vertica/lib64, which contains the library file
-
Post driver installation configuration
You must configure the ODBC driver before you can use it. There are two required configuration files:
-
The
odbc.iniconfiguration file defines the Data Source Names (DSNs) that tell the ODBC how to access your Vertica databases. See Creating an ODBC Data Source Name for instructions to create this file. -
The
vertica.iniconfiguration file defines some Vertica-specific settings required by the drivers. See Required ODBC driver configuration settings for Linux and UNIX for instructions to create this file.
Note
If you are upgrading your ODBC driver, you must either update your DSNs to point to the newly-installed driver or create new DSNs. If yourodbc.ini file references drivers defined in an odbcinst.ini file, you just need to update the odbcinst.ini file. See Creating an ODBC data source name (DSN) for details.