Vertica Database allows the connection by either JDBC or ODBC drivers.
Using the JDBC driver will be recommended instead of using the ODBC Driver. The Sun JDBC/ODBC Bridge Driver is meant for experimental purposes as there can be other implications with certain features unsupported.
JDBC Connection
- Driver - com.vertica.Driver
- URL -
jdbc:vertica://(hostname):5433/(database)
Default Port used by Vertica Database is 5433.
A Sample JDBC Connection Details
- Driver - com.vertica.Driver
- URL -
jdbc:vertica://host001:5433/Stock_Schema
This connectivity is verifed on Vertica DB 2.0.5-0 32 bit using Fedora Core 6.