当前位置:首页 > 报告详情

OData:将对整体系统性能的影响降至最低的 OData 集成的最佳实践.pdf

上传人: le****ng 编号:616564 2025-03-07 46页 1.85MB

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

word格式文档无特别注明外均可编辑修改,预览文件经过压缩,下载原文更清晰!
三个皮匠报告文库所有资源均是客户上传分享,仅供网友学习交流,未经上传用户书面授权,请勿作商用。
本文主要介绍了OData的最佳实践,以及如何通过OData和通用查询(Generic Inquiry)最小化对系统性能的影响。内容涵盖了OData v3和v4的特点、如何选择和过滤数据以优化速度、如何使用通用查询和OData、以及提升性能和效率的最佳实践。 主要观点包括: 1. OData v3和v4接口的使用,以及它们与REST API的比较。 2. 利用OData参数(如$expand,$select,$filter,$top和$skip)进行高效的数据检索。 3. 通过分页和选择性检索数据来提高性能。 4. 通用查询作为一种从Acumatica ERP数据库中提取数据的工具,并将其显示在自定义表单上。 5. 如何构建优化的通用查询,包括识别DACs、查找表之间的关系、优化参数和条件等。 6. OData的限制,如只能用于数据检索,不能用于数据创建和调用操作等。 7. 性能方面的最佳实践,如选择性检索必要的数据字段,避免不必要的扩展和排序等。 总之,本文强调了OData和通用查询在数据检索和性能优化方面的作用,并提供了实用的最佳实践。
"OData如何提高数据检索效率?" "如何通过OData和通用查询优化系统性能?" "OData v3和v4有哪些主要区别?"
客服
商务合作
小程序
服务号
折叠