Connecting to Sybase IQ - Pivotgrid

4 posts, 0 answers
  1. JAVIER
    JAVIER avatar
    2 posts
    Member since:
    Nov 2012

    Posted 24 Sep 2013 Link to this post

    Hello,

    we are trying to connect this control to sybase iq database in order to improve the performance using OLAP technology, but the control's connectión only defines an user, password an query that execute a full scan read, so the perfrmance is not so good,

    Do you know any solution to make a good connection to Sybase IQ?

    Thanking in advance,

    Regards,



  2. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 24 Sep 2013 Link to this post

    Hi Javier,

    May I ask you for more information what are the issues you have faced? Are you unable to connect RadPivotGrid or you have some other problems? When you use XmlaDataProvider on its initialization we send six requests to get the metadata for the cube (dimensions, measures, KPIs, Sets, etc.). Once the user selects the dimensions and measures for grouping and updates the provider, we send a single request to get the needed data and after that it is populated in RadPivotGrid.

    Hopefully this makes sense. I'm looking forward to hearing from you.

    Regards,
    Rosen Vladimirov
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  3. UI for WPF is Visual Studio 2017 Ready
  4. JAVIER
    JAVIER avatar
    2 posts
    Member since:
    Nov 2012

    Posted 26 Sep 2013 Link to this post

    Hi Rosen,

    I would like to know, if you have some experience or similar case with IQ sybase database,  because we could test to SQL Server, but in our case we don't find a xmladata provider in IQ
    Thanks,

    Regards,
  5. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 01 Oct 2013 Link to this post

    Hello Javier,

    Unfortunately we have not tested RadPivotGrid with every possible Cube. The idea of our pivot is that it supports the XMLA protocol, so every Cube that can give you XMLA access is suitable for using with RadPivotGrid.

    I'm not sure if the IQ Sybase supports XMLA, but if it does and you have any probles with the connection between RadPivotGrid and the Cube, we'll be glad to help you.

    Regards,
    Rosen Vladimirov
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
Back to Top