Another Client Tool!

[JimKnicely]

Hi,

A good friend recommended another client tool that we can use to access the Vertica database. I've been using it for a few days and like it a lot.

Check it out!

http://www.sql-workbench.net/

Excerpt from their web page:

SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and thus it should run on any operating system that provides a Java Runtime Environment.

It's main focus is on running SQL scripts (either interactively or as a batch) and export/import features. Graphical query building or more advanced DBA tasks are not the focus and are not planned

[piglet]

Thanks, knicely87!

How do I set this up to connect to Vertica? None of the drivers are for Vertica. Or should we just use the ODBC/JDBC bridge option?

[hans.castorp]

Adding a new driver is explained here:

http://www.sql-workbench.net/getting-started.html

In the section "Configuring the database (JDBC) drivers". It also includes screenshots (you need to click on the links)

And in more detail here: http://www.sql-workbench.net/manual/jdb ... re-drivers