If I have loaded all my data into HBase succesfully. What would be a recommended way of visualizing that data using standard BI or Portal tools ? So e.g. using something like Tableau, QlikView or Tibco Spotfire. Where users can just drill and click quickly through the data. How can I connect those tools to HBase to allow having a nice looking standard GUI to my HBase data ? Are there drivers available (ODBC, JDBC etc.) ? Can I connect with those tools to e.g. the standard HBase REST interface ?
any advice really appreciated.
Hi @Gerald Both many of the tools that you've mentioned don't (yet?) support HBase directly, you could always use something like Apache Phoenix, to allow sql querying of your nosql store but that still doesn't get you directly to the visualisation as the SQL semantics supported are far less than something like Hive etc.
I've seen a few people use a product called Keylines
I have no affiliation to the folks above, but I notice that there's a free trial available.
Let us know how you get on!
Hive over Hbase can be a good solution if your hbase tables has a fixed schema. But if you have a variable schema, give a look at http://www.simba.com/drivers/hbase-odbc-jdbc/.
The simba driver is commercial one and i guess a trial version is available and worth giving a try.
P.S. I am no affiliation to simba.
thank you all. Very interesting. I would hope that some of the commercial BI Front-end, Portal Providers close this gap so that we can directly visualize on-top of HBase. Or e.g. the HBase community closes that gap. There is definitely a need in my view to use standard front-end tools on the data you have in HBase.
What would be the "standard" way to visualize that data ? Write a custom front-end which connects to the HBase REST API or similar ?