topic Re: How to connect QlikView with Hadoop? in QlikView

How to connect QlikView with Hadoop?

Mon, 26 Jan 2026 16:26:21 GMT

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?

Re: How to connect QlikView with Hadoop?

swuehl — Fri, 18 Apr 2014 13:30:57 GMT

Here are some informations about how to connect to Hadoop:

Connecting to Hadoop

Re: How to connect QlikView with Hadoop?

Tue, 16 Feb 2016 15:16:43 GMT

Please find link:

How to connect Hadoop Hive

Re: How to connect QlikView with Hadoop?

gregortvw — Tue, 16 Feb 2016 17:31:19 GMT

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-qlikview/

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