MSTR really could consume REST service, it worth to have a try...(but I have no experience for such way).
Best Regards! --------------------- Luke Han On Sat, Nov 12, 2016 at 8:35 AM, Ajay Chitre <[email protected]> wrote: > As a workaround one can export the query results into a CSV & import them > into MSTR - although this is not the most elegant solution. > > I believe someone mentioned that they have used MSTR XQuery reporting > feature on top of Kylin's REST service. Is that true? Any pointers on this? > > Thanks for the help. > > > On Thu, Nov 10, 2016 at 10:54 PM, Luke Han <[email protected]> wrote: > >> Hi Anton, >> That's great information, if possible, please link such jira here. >> Some of my friends are evaluating with different BI tools including >> MSTR, will keep this thread updated if there's any progress later. >> >> Thanks. >> Luke >> >> >> Best Regards! >> --------------------- >> >> Luke Han >> >> On Fri, Nov 11, 2016 at 11:44 AM, Anton Bubna-Litic < >> [email protected]> wrote: >> >>> Hi Luke, >>> >>> >>> >>> I have been testing out MSTR with Kylin and the experience has been >>> pretty poor. However, this does not seem to be a Kylin issue and more to do >>> with the way MSTR is sending requests to Kylin. I have seen tickets on the >>> MSTR jira to build a proper connector and am still waiting on it. Until >>> this happens, Kylin with MSTR appears to be unworkable. >>> >>> >>> >>> Cheers, >>> >>> Anton >>> >>> >>> >>> >>> >>> >>> *From:* Luke Han [mailto:[email protected]] >>> *Sent:* Friday, 11 November 2016 2:25 PM >>> *To:* [email protected] >>> *Subject:* Re: Microstrategy with Kylin >>> >>> >>> >>> Hi Ajay, >>> >>> That's information already out of date since there are many things >>> happen in the past. >>> >>> >>> >>> We have not tested with MSTR yet but there's one friend who have >>> tried MSTR with Kylin and could work, with a little bit limitation. >>> Unfortunately, they are not in this mailing list... >>> >>> >>> >>> Please try and report any issue or bug to Kylin JIRA, we will >>> check if it's really Kylin's issue. >>> >>> >>> >>> Thanks. >>> >>> Luke >>> >>> >>> >>> >>> Best Regards! >>> --------------------- >>> >>> Luke Han >>> >>> >>> >>> On Fri, Nov 11, 2016 at 9:07 AM, Ajay Chitre <[email protected]> >>> wrote: >>> >>> Hello, >>> >>> >>> >>> Any update on this? >>> >>> >>> "MicroStrategy is now evaluating Kylin in house and a certificate >>> connection between MicroStrategy and Kylin should come out soon in near >>> future..." >>> >>> >>> I saw the above note at: https://www.mail-archive.com/d >>> [email protected]/msg02267.html >>> >>> >>> I tried using the latest Kylin ODBC driver with Microstrategy. I can >>> connect to Kylin successfully & I can see my Cube & Dimensions under >>> 'Available tables' inside 'FreeForm', but when I run a query, I get 'SQL >>> Pass 0 failed to execute'. The same query runs successfully in Kylin UI. >>> >>> Am I doing something wrong - or - does the ODBC driver not work with >>> 'MicroStrategy >>> Analytics Enterprise with SQL Server Standard' version 9s (9.5)? I am using >>> the Microstrategy EC2 image on AWS. >>> >>> Any help in this regard will be greatly appreciated. Thanks. >>> >>> >>> >> >> >
