Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Visualizing HBase Data with standard BI or Portal Front-end tools

Highlighted

Visualizing HBase Data with standard BI or Portal Front-end tools

New Contributor

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.

4 REPLIES 4

Re: Visualizing HBase Data with standard BI or Portal Front-end tools

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

http://cambridge-intelligence.com/keylines/visualizing-nosql-database/

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!

Re: Visualizing HBase Data with standard BI or Portal Front-end tools

Mentor

one option is to create a hive view on top of hbase table and connect that to Tableau. https://community.hortonworks.com/content/kbentry/14806/working-with-hbase-and-hive-wip.html

Re: Visualizing HBase Data with standard BI or Portal Front-end tools

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.

Re: Visualizing HBase Data with standard BI or Portal Front-end tools

New Contributor

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 ?

Don't have an account?
Coming from Hortonworks? Activate your account here