Hbase Connector

[#1]

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

[rbecher]

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

[#3]

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

[rbecher]

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

[rbecher]

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