C/C++
You must install the ODBC client driver before creating C/C++ client applications.
Note
You must install the ODBC client driver before creating C/C++ client applications.Vertica provides an Open Database Connectivity (ODBC) driver that allows applications to connect to the Vertica database. This driver can be used by custom-written client applications that use the ODBC API to interact with Vertica. ODBC is also used by many third-party applications to connect to Vertica, including business intelligence applications and extract, transform, and load (ETL) applications.
This section details the process for configuring the Vertica ODBC driver. It also explains how to use the ODBC API to connect to Vertica in your own client applications.
While client applications written in C, C++, Perl, PHP, etc. all use the ODBC client driver to connect to Vertica, this section only concerns C and C++ applications.
In this section
- ODBC architecture
- ODBC feature support
- Vertica and ODBC data type translation
- ODBC header file
- Connecting to the database
- Load balancing
- Configuring TLS for ODBC Clients
- Connection failover
- Prompting windows users for missing connection properties
- Prompting windows users for passwords
- Setting the locale and encoding for ODBC sessions
- AUTOCOMMIT and ODBC transactions
- Retrieving data
- Loading data