Skip to main content

Web development tool for Vertica data

  • June 28, 2013
  • 7 replies
  • 15 views

Terry_Marr
Forum|alt.badge.img+1
We have just moved our data from Oracle to Vertica and are now searching for a fairly easy web development tool to front-end it. Suggestions?

7 replies

Prasanta_Pal
Forum|alt.badge.img
  • Participating Frequently
  • June 28, 2013
Hi, Are you looking for a client tool like TOAD to query the data from Vertica? Or trying to develop web application using Vertica as a back end Database?

Terry_Marr
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • June 28, 2013
Hi, we already use Toad to develop the back-end data. Now we are looking to develop a web intranet application using Vertica as the back-end

Prasanta_Pal
Forum|alt.badge.img
  • Participating Frequently
  • June 28, 2013
ok, If you are developing web application and trying to access Vertica Database, then you can access data using ADO.NET, ODBC, JDBC etc. Refer to the documentation: https://my.vertica.com/docs/6.1.x/HTML/index.htm#12557.htm

Forum|alt.badge.img+2
  • Participating Frequently
  • June 28, 2013
If I may jump in briefly: In addition to our official drivers, you'll find that there are a number of community-maintained drivers. For example, there's one for Python (and an adapter specifically for Django); there's one for Node.js; etc. Our JDBC driver also works with, for example, Hibernate. Basically, lots of things work. What do you want to use? Others here might have specific frameworks that they like.

Terry_Marr
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • June 29, 2013
Thanks for the replies. Specifically, we are looking at Visual Studio Lightswitch. Have you tried to connect to Vertica data source using that? We need to develop a 3-tier web solution. Will ODBC work in that configuration?

thomas_1
  • New Participant
  • June 19, 2014
Is it possible  to integrate the hibernate with HP vertica? If so ,then which dialect that i have to use ? Please advice me? Sure it will be more helpfull for me.

rix
  • New Participant
  • April 23, 2015

Hi Terry, were you able to build this web application on top of Vertica ? I was looking through the forums to find some information on any such application and found your post. was wondering if you were able to build this and if you faced any challenges.