SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc, see Getting Started and Introduction. The minimum version of Java supported is 1.6.x as of SQuirreL version 3.0. See the Old Versions page for versions of SQuirreL that will work with older versions of Java.
In this post I will explain how to use SQuirrel SQL Client to Connect to Vertica Database.
Download the SQuirrel SQL Client by clicking the following link.
The SQuirreL SQL Client is installed with the Java installer. Download the file squirrel-sql-<version>-install.jar and execute it using the following command:
D:\software>java -jar squirrel-sql-3.4.0-install.jar
Now will open the client and configure JDBC to connect to vertica database.Down load jdbc driver from vertica database and rename it from vertica-jdk5-6.0.0-0 to vertica-jdbc5.
Configuring SQuirreL
Click on Drivers on the left hand side as shown below.
Click on Create a New Driver:
Now Click on Aliases on the left side.
Thanks
Vertica Database 