This documentation is for WSO2 Enterprise Integrator version 6.1.1 . View documentation for the latest release in the 6.x.x family and the latest release in the 7.x.x family.

All docs This doc

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Log in to the Management Console of the Analytics profile.
  2. In the Main tab, click Data Explorer to open the Data Explorer page.
  3. Select the required table in the Table Name field, and click Schedule Data Purging as shown below. 

    Note

    The Schedule Data Purging option is displayed only for users of whom the assigned role has the Delete permission under Record enabled.


    This opens the Schedule Data Purging dialog box.

  4. In the Schedule Data Purging dialog box, set the time and days within which you want to purge data as shown below, and click Save.

    Note

    Do not purge data that is less than 2 days old as it can result in a data loss.

    The fields of the above screen are described below.

    FieldDescription
    Enable Data PurgingWhether you want to enable data purging or not.
    Schedule Time (Either cron string or HH:MM)Enter the time on which you want to purge data via cron expression or by defining the time in the following format: HH:MM. For example, the following cron expression will configure the data purging job to run at  12:00 PM (noon) every day 0 0 12 * * ?  For more information on cron expressions, go to Oracle Documentation.
    Purge Record Older Than (Days)Define the value as to keep data of only the last 'n' no of days back in the selected table. For example, if you give 1 as the value, the system will purge all data stored before yesterday.
  5. Repeat these steps for all the required tables to schedule them to be cleared regularly.

    Note

    Change the value of the <data-retention-days> property as per your requirement. However, the following values are recommended to retain and purge data in an optimum way.

    • You do not need to enable data purging for table defined for months and years.

    • In the <data-retention-days> property of tables for days, you must specify 45 days in order to retain data analyzed based on days for an acceptable time period.

    • For other tables created for shorter time granularities (e.g., seconds, minutes, and hours), you can spoecify specify a retentionb retention period of two days.

Removing scheduled data purging operations

...