Page 1 of 1

Another Client Tool!

Posted: Thu Dec 06, 2012 1:42 pm
by 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

Re: Another Client Tool!

Posted: Sat Dec 08, 2012 2:12 pm
by 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?

Re: Another Client Tool!

Posted: Tue Dec 11, 2012 7:11 pm
by 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