How do i connect DBVisualizer with the vertica driver ? I can only see JDBC connection option ? How

Soumya_Behera

[Deleted User]

Hi Soumya,

DBVisualizer supports JDBC connections only. You can obtain the Vertica JDBC .jar file from the my.vertica website in order to set up a connection to your Vertica database. 

Let me know if you have any further questions,
Mitch

Soumya_Behera

Thanks for replying Mitch .
Can you please suggest what value i should give in the Data source field ?
Here is the screenshot .

Also if you can give me some URL where i can find any info that will be great .

[Deleted User]

Hey Soumya,

The format for the Data Source string is as follows:   jdbc:vertica://<server>:5433/<database>

You can find additional information on setting up the Vertica JDBC driver in the docs here:
https://my.vertica.com/docs/6.1.x/HTML/index.htm#16718.htm

Let me know if you have any further questions,
Mitch

MylesC

Vertica.com has excellent online documents and videos on how to connect Vertica to 3rd-party tools (including DbVisualizer, Qlikview, Talend etc.) here:
http://www.vertica.com/resources-for-technology-partner-integrations/

Myles