topic Re: Qlkiview to hbase connection in QlikView

Qlkiview to hbase connection

Wed, 02 Jul 2014 08:27:15 GMT

Hi,

I'm using Qlikview 11.20 Personal edition.

Now i wanted to connect to hbase 0.94.15-cdh4.6.0 (hbase which I'm using is not a standalone hbase,it is with cloudera).

So i saw one announcement/blog in the below link:

Connecting QlikView to HBase

1)In the above link they have shown how to connect to hbase but i wanted to know whether they have used ODBC driver or JDBC driver to connect to hbase?

2) Please provide the link from where to download the driver which is campatible with my qlikview and hbase version.

3) Also provide the steps to install the drivers

Thanks,

Shree

Re: Qlkiview to hbase connection

VishalWaghole — Wed, 02 Jul 2014 09:11:59 GMT

Hi shree,

Please find links below, hope it will work for you...

How to connect Hadoop Hive

Connecting BigData to QlikView Via HBase | Bird's Eye View

-Regards,

Vishal Waghole

Re: Qlkiview to hbase connection

Wed, 02 Jul 2014 09:49:44 GMT

Hi, Is there any reply on the above post?

Re: Qlkiview to hbase connection

VishalWaghole — Wed, 02 Jul 2014 09:52:04 GMT

I have replied you but that content Web Link so it will need moderator approval.

It will be approve soon....

Re: Qlkiview to hbase connection

Wed, 02 Jul 2014 09:57:42 GMT

Hi,

In already gone thriugh the links which you have shared. But i din't find the information of drivers . If they are using jdbc or ODBC . If they are using jdbc , what are the required hbase jars . These thing are not clearly given there. Thay have just mentioned about the connection .

Re: Qlkiview to hbase connection

Fri, 04 Jul 2014 07:08:57 GMT

As suggested i came to know that pheonix SQL Layer JDBC driver is used to connect to qlikview and Hbase.

Can you please give me the link from where to download this driver and procedure to install this server.

Also is it possible to connect to hbase from qlikview without using pheonix SQL Layer JDBC driver? Is there any other drivers are available?

Here I'm not using standalone hbase.(i'm using hbase with cloudera)

Shree

Re: Qlkiview to hbase connection

rbecher — Fri, 04 Jul 2014 07:53:04 GMT

You can start here:

http://phoenix.apache.org/Phoenix-in-15-minutes-or-less.html

Phoenix: A SQL layer over HBase

You need to prepare also on the server site. For the JDBC connect it's also important to place the config file hbase-site.xml in the same folder as the phoenix-x.x.x-client.jar.

- Ralf

Re: Qlkiview to hbase connection

Mon, 07 Jul 2014 10:20:44 GMT

Hi, Phoenix driver is compatible only with apache HBASE right?

I'm using the hbase version 0.94.15-cdh4.6.0 . So Phoenix driver is compatible with this version of hbase?

Alos from the below link what i'm supposed to download to get Phoenix driver?

Thanks

Re: Qlkiview to hbase connection

rbecher — Mon, 07 Jul 2014 12:33:01 GMT

There is a lot more to do to set it up then just downloading and using a driver. I guess this doesn't fit into this forum, and it is not a QlikView related question...

Re: Qlkiview to hbase connection

Thu, 30 Jul 2015 12:23:40 GMT

Hi All,

My Question here is can i able to connect the Hadoop (HBase) database to the Qliksense. If able to connect then where i get the Drivers and could i connect it with ODBC driver.

Bosc

Re: Qlkiview to hbase connection

agigliotti — Fri, 29 Jul 2016 15:59:34 GMT

I'm asking the same question.

Anybody can help?

Re: Qlkiview to hbase connection

rbecher — Mon, 01 Aug 2016 08:53:48 GMT

There are several commercial HBase ODBC drivers around. Just google it..

Re: Qlkiview to hbase connection

agigliotti — Mon, 01 Aug 2016 09:29:18 GMT

My question is:

Why it's not included in the ODBC connector package ?

Does an open source driver exists for HBase ?

Re: Qlkiview to hbase connection

rbecher — Mon, 01 Aug 2016 09:44:54 GMT

For my opinion all databases (several thousands?) should be included in the ODBC connector package! But I guess this would ten-fold the license costs, or more..

Feel free to start an open source project for it...