How to connect QlikView with Hadoop?

[#1]

Hi,

Within QlikView I am trying to access data within Hadoop HDFS  (table or file).

First I installed a driver from http://hortonworks.com/hdp/addons/, I downloaded and used driver 'Hortonworks Hive ODBC Driver (Win/Mac – v1.3.19)' - windows 64-bit (msi).

After installing, within QlikView I choose database 'OLE DB' and then select 'Microsoft OLE DB Provider for ODBC Drivers'. Then for  'data source name' I choose 'Sample Hortonworks Hive DSN'.

But when testing the connection I end with 'Test connection failed because of an error in initialize provider'...

Does someone have an idea how I can solve this?

[swuehl]

Here are some informations about how to connect to Hadoop:

Connecting to Hadoop

[#3]

Please find link:

How to connect Hadoop Hive

[gregortvw]

I've searched a time ago for possibilities to work with hadoop:

Here is a connector QlikView->Cloudera QlikView Connector for Cloudera | Qlik

Another one for Hortonworks: http://hortonworks.com/hadoop-tutorial/business-discovery-and-visualizing-your-data-in-hdp-using-qli...

And a tutorial:QlikView Integration with Hadoop - Hadoop Online Tutorials

Also here is a JDBC Connector (paid version) http://www.tiq-solutions.de/display/enghome/ENJDBC