1、OData:Best Practices for OData Integrations that Minimize Impacts to Overall System PerformanceVarthini Bhaskaran2AgendaIntroductionLearning Objectives Session Overview Business Scenario DiscussionUtilizing OData and Generic Inquiries to Retrieve/Export DataQuiz Q&A|Survey CompletionSummary and Key
2、Takeaways3Presented byVarthini BhaskaranTechnical Account Manager4CPE DisclaimerThis session is NASBA-compliant,and you may get 1 CPE credit if you fulfill the following requirements:Participate in at least one quizProvide your full name and email address when you complete a quizFailure to provide y
3、our full name and email address will result in Acumaticas inability to recognize you in our reports;thus,we will be unable to issue a CPE certificate for you.If you are not interested in getting the CPE credit,specifying your personal details is optional.Learning Objectives6Learning ObjectivesIn thi
4、s session,you will learn:What OData v3 and v4 areHow to select and filter data for optimal speedHow to use generic inquiries and ODataWhat best practices should be applied to boost performance and efficiencySession Overview8Acumatica Offerings:OData&Generic InquiryBenefits from Exposing Data through
5、 OData Multiple applications can use data exposed through the OData protocol,including Microsoft Power BI and Microsoft Excel OData vs REST API9Quick showcaseLinking EXCEL with Sales Demo dataset using ODataLinking Power BIBusiness Scenario11Use CaseAn accountant has requested access to the project
6、financial planning data available in Acumatica ERP.The accountant wants:To work in real-time mode with consolidated data from various Acumatica ERP forms through a third-party OData client,such as Microsoft Excel or Microsoft Power BITo retrieve the data efficiently without performance issues,such a