open hub, data fragmentation

[Former Member]

Hi all,

I have a question related to open hub destination. Is it possible to fragment somehow a data amount with open hub destination service?

My problem is the following:

We have a SAP BI system. We are using open hub (and it's tables) to upload the data into an another system. The problem is that the other system can handle just only 5000 record simultaneously. Is it possible to solve it somehow? e.g. load all the data into open hub tables and read from here 5000 records and after this 5000 again etc.

many thanks in advance

Peter

[Former Member]

You can fill a field called counter and pull out the records based on the count. For example, fill 10,250 records in Open Hub, run job on 2nd system to pull records 1-5000, then 2nd job to pull 5001-10,000, then a third job to pull 10,001 - 15,000.

Brian