Archive Service process flow
Currently, when you run the Order Purge agent, data is moved from transaction table to history table. When you run the Order History Purge agent, data is permanently deleted from Sterling Order Management System Software.
After you install and integrate Sterling Order Management System Software with Archive Service, you can seamlessly move the old history data from Sterling Order Management System Software to the Archive Service and access the data for further processing when needed.
The following diagram illustrates the Archive Service integration model:
- When the integration with Archive Service is enabled, and when an order is purged to the history table, the order is staged for archival in the Awaiting Archive table with an archival date, which indicates when this order is available for archival.
- The Order Archive transaction picks up the orders that are eligible for archival from the Awaiting Archive table.
- The Order Archive transaction reads the order and corresponding details from history tables and prepares a JSON input to move the data to Archive Service.
- The Order Archive transaction calls the Archive Order API to archive data to Archive Service.
- The response from Archive Service is received and processed by the Order Archive transaction.
- On successful archival, all orders and the corresponding details are deleted from Sterling Order Management System Software history tables.
- On successful deletion of data from Sterling Order Management System Software history tables, the staging data related to the orders are deleted from the Awaiting Archive table. In case of any failure, the corresponding Awaiting Archive data are retained in the Awaiting Archive table.
When an order is restored from the history table, the corresponding staging data is deleted from the Awaiting Archive table. When integration with Archive Service is enabled, the Order History Purge agent stops processing the confirmed history orders.