Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to configure SAP By design and Odata to extract data ?

former_member601099
Discoverer

‎2018 Oct 29 1:13 PM

0 Kudos
378
  • SAP Managed Tags:
  • OData

Hello,

Sorry for my English.

I'm using SAP by design and I'm trying to export the data with ODATA.

I go through https://my999999.sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/NameReportQueryRe... to retrieve the PROPOBB data source.

With the Talend software, I count the number of recordings ("/$count") .

This request is executed between 36 and 38 seconds

Afterwards, I make a loop using the "$top" and "$skip" options until the end of my 37,000 records.

For 50 records, the SAP executes the query in 25 seconds, it would take me about 5 hours to recover my data.

Moreover, from time to time, I have timeout on the ODATA request.

How to configure SAP By design and Odata to extract approximately 37,000 records in less than 15 minutes ?

Best regards, Cédric

1 REPLY 1

former_member601099
Discoverer

‎2018 Oct 30 4:38 PM

0 Kudos
187
  • SAP Managed Tags:
  • OData

Hello,

I tried with the option "top" configured to 5000 records and I went to 5 minutes of treatment.

What must be configured in the "top" option: 5000, 10000, 20000 records?

What is SAP recommending in the configuration of the "top" option?

Best regards, Cédric