Web development tool for Vertica data

Terry_Marr

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?

Prasanta_Pal

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

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

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

[Deleted User]

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

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

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

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.