Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Hbase Connector

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

4 Replies
rbecher
Not applicable

Re: Hbase Connector

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

Not applicable

Re: Hbase Connector

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
Not applicable

Re: Hbase Connector

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
Not applicable

Re: Hbase Connector

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