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:
Setting up SQuirreL
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Setting up SQuirreL
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Setting up SQuirreL
Why doesn't Vertica release a GUI client we can use?
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Setting up SQuirreL
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.
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
-
- Newbie
- Posts: 16
- Joined: Fri May 11, 2012 12:25 pm
Re: Setting up SQuirreL
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.
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.
Re: Setting up SQuirreL
Hi, Jim and @all
Did you try DBeaver? IMHO much better than SQuirreL.
Did you try DBeaver? IMHO much better than SQuirreL.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Setting up SQuirreL
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.
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.
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Setting up SQuirreL
This is alligator, not Kangaroo?
knicely87 wrote: I guess I did the same thing with the blue alligator It must just be cool to do that.