United Kingdom AX

 View Only
  • 1.  AX7 Lessons Learned - BI Performance

    Posted Sep 30, 2016 03:40 AM
    Edited by Michelle Lowry Oct 19, 2016 03:42 PM

    The BI tools rely on ODATA which places a restriction on performance.

    The restriction becomes a bottleneck on large data volumes creating long run times above 30 minutes.

    There is a way to bypass this though using an old school method that Microsoft has repackaged and called BYODB.

    ------------------------------
    Paul Stead
    RightSized Testing
    London
    ------------------------------



  • 2.  RE: AX7 Lessons Learned - BI Performance

    Posted Oct 03, 2016 05:57 PM

    Hi Paul

    I agree that although OData is a great interface for opening up back end databases, we have also seen its limitations (and many times in fact), I believe this is a limitation of the technology (it's not just AX7-specific). I'd be happy to share some of our results at ZAP, and discuss alternatives to AX7's Data entities/OData if you are interested to get a more robust BI solution that adapts well to customizations, and let you integrate many other datasources.

    Cheers

    Damien

    ------------------------------
    Damien Zwillinger
    ZAP (R&D Office)



If you've found this thread useful, dive deeper into User Group community content by role