6 Replies Latest reply: Sep 14, 2016 5:39 AM by alberto ramon RSS

    Qlik and Apache Kylin

    alberto ramon

      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

        • Re: Qlik and Apache Kylin
          Rohit Kumar

          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.

          • Re: Qlik and Apache Kylin
            alberto ramon

            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 

              • Re: Qlik and Apache Kylin
                Rohit Kumar

                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

                  • Re: Qlik and Apache Kylin
                    alberto ramon

                    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