Have you connected Qlik Sense to Druid?

[isorinrusu]

I'd like to know if anyone has successfully connected to Druid using Qlik Sense and Direct Discovery. Have you?

[Ricardo_Gerhard]

Dear Sorin,

   Can you explain if this software have a specific database? Its possible to connect in thousands of solutions within a various kind of methods.

[isorinrusu]

Hi Ricardo,

I don't know much about Druid. There's some info here: Druid | About Druid.‌ Data in Druid can be queried using Apache Hive, so it probably can be done through Qlik Sense using its connector. But I must know for sure and can't get to test it myself.

Thank you.

[Ricardo_Gerhard]

I never had worked with druid, but I think that is possbile by Qlik Rest Connector.

Take a look on this article:

REST for Qlik Sense ‒ Qlik Connectors

Druid | Understanding Druid Real-time Ingestion

[Siddhartha_Chaudhary]

Hi Team,

Noticed, there is no update for this query for quite some time! 🙂

You can plan below steps:

1. Integrate DRUID with Hive, then new tables will be considered as HIVE table itself.

2. Install HIVE ODBC driver at QLIK server

3. Add required details like host etc. (Important - It can be different port like 10500 instead of default hive port 10000)

4. Create connection using this ODBC DSN or you can directly use inbuilt HIVE connector to fetch data of DRUID tables.

Regards

[morenoju]

Hi, I connected to Druid using the REST connector with a POST method like this:

{ "query" : "SELECT * FROM my_table"}

It worked without issue. Now my concern is if I will lose the real-time capabilities offered in Kafka/Druid because of the Qlik Sense script being slow.

Have any of you tried to get as close to real-time as possible? How was it?