topic Qlikview bigdata connectivity in QlikView

Qlikview bigdata connectivity

vijetas42 — Mon, 11 Jun 2018 09:29:43 GMT

Hi,

Is there any connector available to connect qlikview with phoenix sql layer to access hdfs (hadoop file system) data?

Re: Qlikview bigdata connectivity

petter — Mon, 11 Jun 2018 10:32:08 GMT

Apache Phoenix works as a fast SQL layer on top of HBase that runs on HDFS. Hortonworks has provided an ODBC driver that would be easy to use from QlikView to connect to Apache Phoenix:

http://public-repo-1.hortonworks.com/HDP/phoenix-odbc/1.0.0.1000/windows/HortonworksPhoenixODBC64.msi

I don't know about the licensing of this driver - you'll have to check at the Hortonworks site or with their sales representatives.

Re: Qlikview bigdata connectivity

petter — Mon, 11 Jun 2018 10:34:29 GMT

Simba Technologies (now part of Magnitude) also have a Phoenix ODBC driver that I am pretty sure has to be licensed but there is a free evaluation you can use to test with:

https://www.simba.com/drivers/phoenix-odbc-jdbc/

Re: Qlikview bigdata connectivity

vijetas42 — Mon, 11 Jun 2018 10:34:47 GMT

Thanks Petter!

is there any reference document for the same.

Regards,

Vijeta

Re: Qlikview bigdata connectivity

petter — Mon, 11 Jun 2018 10:41:11 GMT

A more implementation costly solution would be to go for using the Qlik SSE (Server Side Extension) to connect via Python and using Phoenix's Python library. The use case has to be considered and it will require quite a bit more understanding of Qlik, Python and SSE to implement. This gives full support from Load Script and from Qlik expression language in the apps for near-real-time integration towards Phoenix.

Python Driver for Phoenix | Apache Phoenix

Introducing Qlik Advanced Analytics Integration (via SSE - Server Side Extensions)

An Advanced Analytics Integration Timeline

There is a Place (subsite) on Qlik Community devoted to Advanced Analytics Integration: Advanced Analytics Integration. NB! don't let the name Advanced Analytics fool you - it is really just a good "marketing" term but the technology underpinning this is not limited to only Advanced Analytics it can be used as a generic back-end server calculation integration too with SSE.

Java could also be an option with Qlik SSE and the samples from Qlik on Github shows how to create "middelware" with Java and Qlik SSE and then the JDBC connectivity could be used: https://github.com/qlik-oss/server-side-extension

Re: Qlikview bigdata connectivity

petter — Tue, 12 Jun 2018 09:18:50 GMT

Learned today that Qlik Sense June 2018 will include an Apache Phoenix ODBC driver... maybe it will be a part of QlikView in the near future - I am quite confident that it will.

Re: Qlikview bigdata connectivity

petter — Tue, 12 Jun 2018 09:48:52 GMT

Please mark this question as answered by tagging the right answer as correct to close the thread if you find that the question indeed has been answered...