DataSource^? Connectivity with Vertica Database

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.

Read more on Vertica DB here.

Note: You will need to register as a user to view the Documentations (user guides, installation guides etc.) and download the JDBC Driver/Software.

-- ZacSim^? - 12 Feb 2008