Download your free copy of DBVisualizer from http://www.dbvis.com/download/
I am going to give you the steps to setup vertica connection to DB Visualizer on a windows 7. Our windows might look different. But I suppose the terms used on the GUI would match that on any operating system.
I know this might be a big assumption as I don’t work for DBVisualizer and I haven’t installed it on any other platform. But it is always worth giving this a try if you are starting to use Vertica and would like to see your tables and write queries on a GUI based environment. I am not a big fan of GUIs. But some times it might become handy. Especially if you are a DBA and you manage quite a lot of databases.
Okay so once you have installed DbVisualizer, open it.
You should get your own account and you’ll be able to share ideas and ask questions and also download Vertica software.
Once you are signed up and you log in, you should be able to see something similar to the screenshot below:
You will be able to run vsql from your windows command prompt after the installation. You should also have the JDBC driver that you need to setup DbVisualizer installed in your system.
By default the driver file can be found in C:\\Program Files\\Vertica Systems\\JDBC
You will find it here only if you haven’t changed the installation directories when you were installing the Vertica client. Now don’t ask me where your driver is if you don’t remember where you installed it. Well if you don’t, then you just have to search for Vertica on your hard driver and you’ll end up finding the appropriate JDBC subdirectory somewhere on your hard drive.
The driver file is a jar file. The version I have is named: vertica-jdk5-6.0.1-0.jar
Getting back to your DBVisualizer window; After you open up Driver Manager as seen in the screen shot above, you should be able to see a window with the following buttons:
The driver class field would be filled in automatically as soon as you open the jar file.
URL format would be jdbc:
Give a name for your Vertica driver. In my humble opinion ‘Vertica’ seems like a very sensible name for this purpose.
After installation things should look like what is given below:
Now click the button in the screenshot below:
All the data that I have filled are samples. Give appropriate host, port and database name in the Database URL field. Choose the Driver that you created earlier. And name the connection anything that you like.
The most important bit after all that is your username and password. That is it. press connect or what ever button you are left with and you are good to go.
Congratulations! You have setup your DbVisualizer to connect with your Vertica database.