There's been chatter of building an ODBC driver in Apache Calcite
channels (as PQS is built on Avatica which falls under the Calcite
umbrella) but no one has stepped up to build such a driver yet.
The driver available via Hortonworks/Simba is the only one I am
presently aware of.
Evagelos CHAIDACIS wrote:
Hi Phoenix,
In scope of a client project I'm trying to use Phoenix with a reporting tool
(Qlikview) to implement live reports on data entered by end users: users input
data in a web console that puts them in HBase via Phoenix and then they refresh
their reports running on Phoenix in Qlikview to analyse the impacts of the data
they entered. All this is running a kerberized cluster. The data are entered on
a specific grain that is restricted to a couple of axis and therefore can be
easily managed in Phoenix / Hbase.
This scenario is something I'd like to implement using an ODBC driver in Qlikview to
connect to Phoenix: this way we can leverage a Qlik feature called "direct
mode" to trigger live queries against Phoenix while browsing the reports and setting
filters. this feature works only with ODBC connections.
I've been trying to use the Hortonworks Phoenix ODBC driver but it doesn't work
due to the fact that my client doesn't use AD with Kerberos. I got a feedback
from the support that the Hortonworks ODBC driver is built on this link between
Kerberos and AD.
The Phoenix ODBC driver uses a transport of HTTP (via libcurl) as that is what PQS
requires. Libcurl (on windows) only has the support to communicate with the AD
controller. This is to be expected as this is the "standard" way to do this on
Windows – it hooks into the native Windows API calls for authentication.
This is not the configuration implemented and the AD is not used for projects
nor applications but only to manage employees, and this can't be changed.
Could you advise on any other way to achieve this?
Is there an ODBC driver currently in development or planned?
Thanks for your help and feedbacks
Evagelos
