topic Hbase Connector in QlikView

Hbase Connector

Tue, 23 Apr 2013 09:14:11 GMT

Hello,

I am currently looking for a Hbase connector to Qlikview.

The only one I found is it : http://branchbird.com/blog/connecting-big-data-to-qlikview-via-hbase/

However, i am not able to download it, I don't know if it is free or not.

So, is there another way to connect Hbase via QlikView?

Thanks in advance

Re: Hbase Connector

rbecher — Tue, 23 Apr 2013 21:50:13 GMT

Hi,

you should be able to connect HBase via JDBC: http://www.hbql.com/examples/jdbc.html

Therefor you could use our QlikView JDBC Connector (commercial license needed): http://www.tiq-solutions.de/display/enghome/ENJDBC

- Ralf

Re: Hbase Connector

Wed, 24 Apr 2013 08:47:08 GMT

Which .jar file should I add to JDBC connector? I added hbase and hadoop jars and when I try to connect, it displays.. "No Suitable Driver".

Thanks

Re: Hbase Connector

rbecher — Wed, 24 Apr 2013 11:07:42 GMT

I haven't tried so far. Usually you can test it before with a tool like SQuirrel to inspect all dependend Java libs. Also you have to specify the drivers class name (org.apache.hadoop.hbase.jdbc.Driver).

Maybe we can build up a test case in our labs. Please contact me by email: ralf.becher@tiq-solutions.de

Re: Hbase Connector

rbecher — Tue, 20 Aug 2013 08:12:28 GMT

Short update on this. Now we have a workable solution with the JDBC Connector using the Phoenix HBase SQL layer:

https://github.com/forcedotcom/phoenix