Hey all, I'm new to Vertica and plan to write a process to pull data out of our MySQL database and place it into Vertica. Does documentation and/or sample code exist as a "getting started" in terms of inserting data into vertica via JDBC?
I've been all over the 'net (I think) and found the tungsten solution, but my superiors are not comfortable making the necessary changes to our source database, so I'm being asked to write a custom process to pull the data out of MySQL (via hibernate) and insert it into Vertica via Vertica SQL / JDBC..
Thanks!
Vertica / JDBC Getting Started?
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Vertica / JDBC Getting Started?
Have you taken a look at the Programmer' Guide? There's a pretty big section named "Programming JDBC Client Software" that may be of use to you!
If you have any specific issues, please feel free to ask the community for support
If you have any specific issues, please feel free to ask the community for support
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: Vertica / JDBC Getting Started?
Even I am new to Vertica and am trying to connect to it using JDBC.
Quite confused about the JDBC driver actually.
1. Is there any documentation on getting started with JDBC? Where is the "Programmers' Guide" you have mentioned?
2. Where can I get the JDBC driver from?
Quite confused about the JDBC driver actually.
1. Is there any documentation on getting started with JDBC? Where is the "Programmers' Guide" you have mentioned?
2. Where can I get the JDBC driver from?
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Vertica / JDBC Getting Started?
Hi kedar,
You can find the answers to both of your questions on the http://my.vertica.com web site.1. Is there any documentation on getting started with JDBC? Where is the "Programmers' Guide" you have mentioned?
2. Where can I get the JDBC driver from?
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.