Provide report writer capabilities on top of graph database

[meas...@redhat.com]

I am looking for a way to provide a reporting tool on top of a tinker pop based graph database. Most of the reporting tools rely upon a JDBC connection for getting at the data and I see that there is some mention of Jdbc drivers in sql-gremlin but it does not seem to be there yet. Is there any other initiatives that are providing Jdbc drivers over graph databases, or even a report writer that can interact with the graph database directly. 

[Stephen Mallette]

A project like that would be very cool - I'm not really aware of any report writers for graphs. Of course, I imagine they would be sorta tricky to design/build with Gremlin compared to JDBC/SQL which has standard columnar return types, but I'm sure something useful could still be built. Unless you have some really new twist on a report writer for graphs in that regard, a JDBC driver for TinkerPop would probably be a most useful community contribution as it would open up tons of tools that currently support JDBC - from report writers to ETL to application platforms and so on. I assume that implementing a JDBC driver that takes Gremlin would put some limits on Gremlin itself - how extensive those limitations ended up being would determine usefulness. 

I think Ted's project is the only one that's doing anything in relation to TinkerPop and SQL/JDBC. It might be worth talking with him a little bit to see where he is on things.

On Mon, May 23, 2016 at 7:13 AM, <meas...@redhat.com> wrote:

I am looking for a way to provide a reporting tool on top of a tinker pop based graph database. Most of the reporting tools rely upon a JDBC connection for getting at the data and I see that there is some mention of Jdbc drivers in sql-gremlin but it does not seem to be there yet. Is there any other initiatives that are providing Jdbc drivers over graph databases, or even a report writer that can interact with the graph database directly. 

--
You received this message because you are subscribed to the Google Groups "Gremlin-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gremlin-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gremlin-users/1f564389-78b1-452b-9b8a-9e504a854a19%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Ted Wilmes]

Hi guys,

I'm still really interested in adding JDBC support to SQL-Gremlin.  It fell down the priority list but I think it'd be pretty useful and would like to get back to it.  SQL-Gremlin makes heavy use of Apache Calcite which contains a project called Avatica which provides all the necessary tools for adding JDBC.  Neo has a Cypher JDBC driver which is neat and opens up some integration options with off the shelf tools (Tableau, etc), but since machine generated SQL is the lingua franca of most reporting tools, it's still limited reporting-wise.  I'd be curious to hear what reporting tools folks are looking to use with their TinkerPop enabled DBs.  Also, would these reports be ad hoc, canned, OLAP (dimensions and measures sorts of things...), all of the above?

Thanks,

Ted