Qlik and Apache Kylin

[#1]

Good Morning

I made a small study of Qlik on Apache cubes Apache Kylin

Integration isn't full, I used "load script" then I couldn't not use all the functionality of Qlik

(Pre-view data & define associations)

If you have any experience or improving integration with Kylin, please contact me

BR, Alb

[#2]

Hi Alberto,

I have read about Apache Kylin, I am just little confuse Apache Kylin is similar to Cloudera or Apache Kylin is similar to Qlik , Can you please help me to understand what Kylin does , If it is similar to Cloudera so Qlik have connectors like HIVE where you can establish a connection between them and create visuals into Qlik. Please try to make a connection with Apache HIVE drivers and then use the same connection with Qlik.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

[#3]

Hello

Kylin is a Cube on Hadoop, Like Microsoft SSAS

With one important Difference:

The queries are written on SQL (not MDX)

This means, you write queries using Fact and Dim Tables, but It resolve

using internal precalculates of cube

What exactly you are trying to do with Qlik and Kylin ?

See tableau Example:

https://github.com/albertoRamon/Kylin/tree/master/KylinWithTableau

Create dashboard, reports, .... from data stored in Kylin, using

Measures and Dimensions

It is now more clear?

BR, Alb

2016-09-13 13:52 GMT+02:00 Rohit Kumar <qcwebmaster@qlikview.com>:

[#4]

Kylin have ther own ODBC driver

But the import didn't work
(You can find a detailed info here: small study)

In this video, with standard data load, .... fail: never finished

In this video: with "load script" work fine, BUT:

Preview data and define your own relations, don't work

BR, Alberto 

[#5]

I tested, and didn't work

[#6]

Hi Albreto,

Thanks for your great response .

First of all I want to say , I really want to know how Kylin get connected to Qlik so I am taking your concern on priority.

I went through your Videos(I believe its your own made video) and Getithub link. lets talk about each one.

Getithub page has a way to connect Kylin to tableau by creating ODBC connection. Now,Your video are showing that you are using the same host name (172.17.0.2 ) which is mentioned in the Getithub page , Confusing ?

Do you have access to Kylin Database with full permissions,If yes ,Are you using the same Host ID where you have access(I am sure you are not using this host id 172.17.0.2 while connecting because its a sample host id).

Why you didn't click on connect rather Done while create the connection with KYLIN database ?

Have your tried create a new OLEDB connection with the help of KYLIN OLEDB driver(I am not sure they are available, but it should be there) , I am saying this because in Qlik 3.0 ODBC connection has some bad reviews.

If Tableau can use I am sure Qlik to because I know how Tableau works, I was a Tableau developer .

Try to access the RDBMS of KYLIN not the cube ,because cube has aggregated data mostly.

Please go through my each step and let me know what you are missing or if you are doing all same I will lo further on it.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Rohit Kumar

[#7]

The IP 172.17.0.2, its a docker container With Kylin

there is only ODBC, or REST API, not OLEDB

With Tableau Woks fine (some warning when get metadata), but one time you have it, get data works fine and fast

is there any way of work with "load scripts" and define your own relations? Solve this issue can be enought for now

I will try with a ODBC Driver demo (I saw an example with cassandra)

Kylin its a nice and powerful soft, ... can be very interested for all community make connection possible as secure