To reduce the load on the SAP system network, the interface has a flexible configuration to reduce the load per fetch and sync. This is particularly important for the initial sync which can be too much for certain systems. The interface can be configured to fetch for a maximum time range per sync (sync period), which allows the initial sync to be split over several days. Each sync can also be split up into batches by a configured from or to date period. j5 fetches the configured date period at a time within one sync. This allows for quicker queries to SAP since the date range SAP has to process is smaller. Each of these batches will be split up into chunks, where each chunk is a set number of rows. This is necessary to limit the payload in SOAP.
See the illustration below of the sync elements:
|
Option |
Description |
Default |
|---|---|---|
|
Sync Batch Period |
Determines the length of the time periods the sync is split up into. This is more for SAP than for the actual fetch. It allows SAP to query the database with stronger restrictions and therefore allows the sync to be faster. The fetch itself is split up into chunks with a maximum number of rows per chunk. |
|
|
Sync Batch Period Type |
Determines how the value in Sync Batch Period is interpreted - Weeks, Months, or Years. |
|
|
Sync Chunk Size |
Determines how many rows should be fetched at a time within a sync batch period. This limits the data sent over the line when using SOAP (for example). There are memory implications if this value is set too high. The default is 500. The data will be processed in batches of 500 at a time even when it is set to a higher value. |
500 |
|
Sync Round Period |
Determines the maximum time frame fetched per sync. For example, it can restrict the initial syncs to one year at a time. This setting allows the initial data to be synced over a couple of days to reduce the load on the system. This is only valid if the Sync-From-Date is set. |
|
|
Sync Round Period Type |
Determines how the value in Sync Round Period is interpreted - Weeks, Months, or Years. |
|
|
Synchronize From Date (YYYY-MM-DD) |
When set, j5 only retrieves data from this date. This is particularly important when SAP has a lot of old data which does not need to be synced to j5. |
The Sync Round Period Type and Sync Batch Period Type options are Week, Month and Year. The Month option is treated as 30 days and the
Year option is treated as 365 days. For example, a Sync Round Period of 3 and a Sync
Round Period Type of Month results in a 90 days sync period.
All of the SAP PM Sync Time Split fields are optional. If they are not set, j5 fetches everything. The sync will still happen in chunks (limiting the number of rows per fetch).