cancel
Showing results for 
Search instead for 
Did you mean: 

"Batch" loads of data via OData

oliver_mainka
Active Participant
0 Kudos

In our product SAP Intelligent Asset Management we have OData APIs which can be used to export data to SAC. We now notice that for some of these APIs, when the customer has a lot of data, we are nearing performance bottlenecks, and the risk of our backend system timing out.

The question is whether there are mechanisms how we can automatically batch the data import. Say there are 1 million source records, can the OData import in SAC upload the first 10k records, pause, reset, and then upload the next 10k, etc. Sorry if I describe this in a naive way.

Accepted Solutions (0)

Answers (1)

Answers (1)

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

yes, in SAC, for your Import model (using the odata API connection) - you can restrict the fetch of each data load using query filters, and then append each rowsets as 'chunks' into the model . following that, you can set a recurring schedule to fetch the delta since last fetch date.

regards, H