Looking for simple query software for business users
Im looking for simple query software for a Vertica database, so that business users can create their own queries. The output needed is not a graph. The output needed is just tabular data.
DbVisualizer Free for Vertica is fine for me as I am in IT, but not good enough for the business users since it does tell them what tables are available, what columns are available, and how to join tables, etc.
Most of the offerings out there like Tableau seem like overkill and are too expensive. Besides we dont need any graphs, just tabular text data.
Any ideas?
0
Comments
David, have you tried the vsql client? If all you need is access to the Vertica cluster to issue SQL statements, and get returned values, this is the simplest method. And, it is free!
Additionally, you can also create an ODBC connection and use MS Excel to issue queries, and retrieve the data back in a spreadsheet. This is a little more complicated, and of course you need Excel.
-Chris
Try http://squirrel-sql.sourceforge.net/
or
http://dbeaver.jkiss.org/
Eugenia