When connecting to Vertica via ODBC prior to version 6, the Vertica ODBC client driver method loads data using a SQL INSERT statement to a single Vertica initiator node.
Configuring ODBC for Vertica
The Vertica configuration file, vertica.ini, is used by Vertica to determine the
absolute path to the file containing the ODBC installer library and the absolute path to
the directory containing the Vertica client driver's error message files. The path to
vertica.ini is set through the Vertica configuration file environment variable,
VERTICAINI.
Note: vertica.ini is different from the Connect node loading configuration
file, DMXVertica.ini, which is specified through DMX_VERTICA_INI_FILE.
To configure the Vertica ODBC driver:
Follow the instructions for defining ODBC data sources on Windows and UNIX systems.
For Vertica ODBC client driver v5.1 or later on UNIX/Linux platforms, specify the
following DSN parameters in vertica.ini and set the environment variable VERTICAINI to
point to the location of the vertica.ini file:
[Driver]
ODBCInstLib=<connect_install>/lib/libodbcinstSSL.so
ErrorMessagesPath=<absolute_path_to_directory_containing_Vertica_client_driver's_lo
calized_error_message_files>where <connect_install> is the directory where Connect is installed.
The error message files are generally stored in the same directory as the Vertica ODBC driver files.
When using the unixODBC driver manager, override the standard threading settings in the
ODBC section of odbcinst.ini as follows:
[ODBC]
Threading = 1For additional details, see the Vertica Programmer's Guide for your version of Vertica.