Programming ODBC client applications
Vertica provides an Open Database Connectivity (ODBC) driver that allows applications to connect to the Vertica database.
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.
This section assumes that you have already installed the ODBC libraries on your client system. If you have not, see Client drivers.
In this section
- ODBC architecture
- ODBC feature support
- Vertica and ODBC data type translation
- ODBC header file specific to Vertica
- Connecting to the database
- Load balancing in ODBC
- Configuring TLS for ODBC Clients
- ODBC 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 through ODBC
- Loading data through ODBC