Skip to main content

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

  • October 26, 2013
  • 4 replies
  • 14 views

Soumya_Behera
Forum|alt.badge.img+1
How do i connect DBVisualizer with the vertica driver ? I can only see JDBC connection option ? How

4 replies

Forum|alt.badge.img+2
  • Participating Frequently
  • October 29, 2013
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
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • October 29, 2013
Thanks for replying Mitch .
Can you please suggest what value i should give in the Data source field ?
Here is the screenshot .
image
Also if you can give me some URL where i can find any info that will be great .

Forum|alt.badge.img+2
  • Participating Frequently
  • October 29, 2013
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
  • New Participant
  • January 31, 2015
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