Recently I’ve had to develop a scenario with Proxy to JDBC communication to extract a lot of records (millions of records), the strategy to achieve this is get a bunches of records in packages until transfer all records from database to SAP.
I’ve developed a Service Interface with tree operations:
- Count: to get the number of records to extract
- Transfer: to get records in packages
- Delete: clear the table if the prrocess completes successfully
The execution logic is simple, first, SAP counts all record in DB to know how many of them will be extract, next an ABAP program calculate the size of packages and start to extract the records in packages, and count the transfered data per package, at last, if the transferred data is equal to initial count the source table is deleted.
The interesting point is on Message mapping, let’s review them: Seguir leyendo