Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Here are some informations about how to connect to Hadoop:
Please find link:
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