Archiving the Database

You can archive the purged data by setting and configuring an archive database in Configurator.

Note: Only a subset of the OMS database is archived and not the whole database. Only tables containing order related information are archived. No data from the Orchestrator database is archived during this process.
  1. Create a new user/schema similar to the one used for OMS. This can be done through Configurator or manually. For details, see Creating and Configuring Database section in the TIBCO Fulfillment Order Management Installation and Configuration guide on how to create a new user and schema specific to OMS.
  2. Configure the newly created schema through Configurator as displayed:
    Archival Configuration Sample

    Archive Default Catalog for hibernate
  3. Execute the steps mentioned in the Purging Orders Between Given Time Period and Matching Order Type section. Before you execute the shell script, in the purgeorder.properties file, set the archive value to true.