Application Development 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
Showing results for 
Search instead for 
Did you mean: 

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

former_member601099
Discoverer
0 Kudos

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

  • SAP Managed Tags:
1 REPLY 1

former_member601099
Discoverer
0 Kudos

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

  • SAP Managed Tags: