Setting up SQuirreL

[knicely87]

Some folks at my company are using the SQuirreL client tool to connect to Vertica.

Here is a link to a great blog post by Tom Gendron that'll help you set up SQuirreL:

http://tomgendron.wordpress.com/2011/08/26/connection-to-vertica-with-squirrel-sql-client/

[piglet]

Why doesn't Vertica release a GUI client we can use?

[knicely87]

Probably because they're an analytic database platform provider There are already a number of free graphical client tools that can be used to access the data. Try one of them.

[DataWhisperer]

Has anyone else had issues w/ time and timezones using SQuirreL?

We use it extensively, but have a few people in different timezones and of course SQuirreL localizes the time to them. Normally I don't care, but it's doing this to the TIME data-type, which is unacceptable. It's treating it like TIMETZ which the value is not.

They are on GMT/BST and the rest of us are on CET/CEST with the servers in CET/CEST (and all date/times stored as UTC). They are also on Windows 7, we're all on Ubuntu 11.04.

Rather confusing and frustrating.

[sKwa]

Hi, Jim and @all


Did you try DBeaver? IMHO much better than SQuirreL.

[knicely87]

I've been using DbVisualizer, unless I need to export data to an Excel spreadsheet directly. For that I use Toad for Data Analysts Beta 3.1. It has a great feature to allow you to export directly to Excel and even to new worksheets within an open workbook.

I'll give DBeaver a try today. Thanks for letting us know about it.

On an aside, how come all these tools are named after animals? Hmm. I guess I did the same thing with the blue alligator It must just be cool to do that.

[greeness]

This is alligator, not Kangaroo?

I guess I did the same thing with the blue alligator It must just be cool to do that.

[knicely87]

Yeah, that's supposed to be an alligator on the http://vertica-forums.com logo

[knicely87]

DataWhisperer,

From your post:

Has anyone else had issues w/ time and timezones using SQuirreL?

Have you read the following post at the link below?

viewtopic.php?f=50&t=282&hilit=squirrel

Maybe you and circles85 can work together on a solution?

Thanks!