Kofax Analytics for Capture (KAFC) includes historical data which does not need to be preserved. Is there any method to delete a Date Range of data from all tables of the KAFC Data database?
The appropriate Execution Plan to use for specific date deletion of data from the KAFC Data database is the "Delete Data by Time"
Steps to delete data be Date:
Navigate to the Data Loader (../Insight/dataload)
- Execution Plans will be displayed
Scroll Down to 'Delete Data By Time' & select the 'LOAD' button
Date Range - From date: select the option for "Beginning of times (1/1/1900 12:00AM)
Date Range - To date: select the option for "Specific Date" and use the calendar button to select the desired date/time
LOAD Data (use this button to process the Execution Plan)
The Data Load screen will update with status to show a Task (Delete Data by Time) has been scheduled/processed with a result of 'Success'
Level of Complexity
|Kofax Analytics for Capture||All|
Add any references to other internal or external articles