--- title: "Archive Entities" slug: "archive-entities" updated: 2025-06-11T18:33:52Z published: 2025-06-11T18:33:52Z --- > ## Documentation Index > Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt > Use this file to discover all available pages before exploring further. # Archive Entities ## Overview The primary purpose of this feature is to delete or move the old, inactive, process-completed data to a separate database or warehouse. This allows the primary database to focus on managing the essential data for current operations. At the same time, the archived data can be used for compliance, auditing, historical analysis, etc. Users with [**Administrator Permissions** and **Can Administrate Permissions**](https://documentation.decisions.com/v9/docs/setting-folder-permissions?highlight=Folder%20Permissions%20Levels) to the folders can mark entities archived using the **Archive Entity**action. Once an entity is marked as archived, it is **not** moved or deleted immediately; instead, the "**Archive Entities Settings**" allows administrators to configure the duration for which entities remain in the system before being deleted or moved to an external database. #### This document discusses the following topics: - [Configuring the Archive Entities Settings](/v9/docs/archive-entities#configuring-archive-entities-settings) - [User actions to Archive the Entities](/v9/docs/archive-entities#user-actions-to-archive-the-entities) - [Automating Archiving of Case Folder](/v9/docs/archive-entities#automating-archiving-of-case-folder) - [Generate a Report of the entities that have been archived](/v9/docs/archive-entities#generating-report-of-archived-entities) Warning: - Archiving of Entities is an irreversible process. Retrieval of data is not supported after the archival of any entities. - Decisions using PostgreSQL Database does not support the moving of entities to an external database. ## --- ### Type of Entities that can be archived Only transactional data can be archived. - [Process Folders](https://documentation.decisions.com/v9/docs/creating-a-process-folder) - [Case Folders](https://documentation.decisions.com/v9/docs/creating-a-case-entity-data-structure) ## --- ### Configuring Archive Entities Settings Navigate to **System (Gear Icon)** > **Settings** > **Archive Entities settings**. A dialog box appears to edit the archive entities settings. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749665590913.png) For all the configurations and a detailed description, please refer to the following table: #### Archive Settings | Configuration | Description | | --- | --- | | Enable | Enabling this setting will allow the manual archiving of all the entities. | | Process After Days | This allows administrators to configure a time limit (in days) for how long an entity can be marked as archived. If an entity is marked as archived, admins can unarchive it before the time limit is reached. Once the entities have surpassed the time limit, a scheduled job will automatically move or delete all the entities. | | Archiving Strategy | Currently, there are two Archiving Strategies, **Delete**- This will delete the entities from the database. **Move**- This will move the entities to a separate database. This option will be absent if Decisions is using the Postgres database. | #### Archive Strategy Settings When using an archiving strategy that involves moving data, the administrators must set up the connection to the external database. Note: - When connecting to an external database, it is recommended to create a new database. - Moving Entities to PostgreSQL is not supported. | Configuration | Description | | --- | --- | | Server Name | The DNS name or IP of the server running the Database. | | Database Name | Name of database. | | Windows Authentication | Checking this box will use the windows login to access the Database. | | User Name | Username of the SQL account used to access the Database. | | Password | The password of the SQL account access the Database. | | Use an Encrypted Connection | Enabling will encrypt the connection between the client and the server. Ensure to configure the database server to use trusted certificates. | | Trust Server Certificate | Enabling will bypass the 3rd party trusted certificate and will use the server's own trusted certificate. | | Timeout | The timeout setting sets the maximum time limit, in seconds, for the transfer of entities between databases, after which the process gets terminated. **0**=**Infinite Time** | #### Archive Settings Calendar Admins must configure the calendar information to schedule a job. This scheduled job will automatically archive all the entities which are already**marked as archived** and also surpassed the number of days configured in **Process After Days**. Refer to [Understanding Scheduled Job](https://documentation.decisions.com/v9/docs/understanding-scheduled-jobs?highlight=Daily%20Schedule) articles for a detailed description of all the calendar settings. Folder behavior when marked as archived. When the folder is marked as archived, all the child entities (comments, folder assignments, and documents) within the folder get marked as archived simultaneously. The child entities will follow the same archiving strategy configured in the Archive Entities settings. However, if a parent folder is marked as archived and a child entity is added later, the parent folder will get archived, leaving the child in the primary database. ## --- ### User actions to archive the Entities Archiving can be done manually on demand via folder actions (right-click on the entities) or through Flow Steps. 1. **Archiving through Folder actions:** 1. After configuring the settings for archiving. Navigate to the process folder that you wish to archive. 2. Right-click on the**Folder > More > Archive Folder**. A confirmatory dialog box will open. Click **OK**. 3. Hence, the folder will be marked as archived. 4. It is possible to select multiple entities at the same time and mark them as archived simultaneously by using a multi-select feature. Press "**Ctrl**" and click on the entity to enable the multi-select.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749666538193.png) 2. **Un-Archiving through Folder Actions:** Navigate to the folder that is already marked as Archived.**Right-click on the folder > More > Un-Archive Folder**. A confirmatory dialog box will open. Click **OK**. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749666502858.png) 3. **Archiving through Flow Steps:** Users can mark "archive" to the **Case folders** or the **Process folders** by using the **"Archive Folder"** step within a Flow. The **Archive Folder** step takes the **Folder ID**as input and marks the Folder as Archived, similar to the one we mark manually. Refer to the [Archive Folder](https://documentation.decisions.com/step-library/docs/archive-folder)Step article for detailed information about the step.Note:From the System settings, if Archive Entities Settings is disabled, the Step will throw a "Business Rule Exception" stating that `Not allowed to Archive {Folder Name}.` --- ## Automating Archiving of Case Folder When a case folder reaches the closed state, it will be automatically marked as archived after a specified number of days, as configured by the administrator in the case management settings. Note:Before configuring **Case Management Settings,** it is important first to configure the **Archive Entities Setting** to ensure that the case entities follow the archiving strategy used in the archive entities setting. --- ### Configuring Case Management Settings Navigate to **System (Gear Icon) > Settings > Case Management Settings**. A dialog box appears. Click on **ADD**to add the type of case. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749666680732.png) | Configuration | Description | | --- | --- | | Type Name | From the drop-down, choose the type of Case Entity you wish to enable for archiving. This will also expose the setting to archive the case entity folder manually. | | Archive After Days (on reaching closed state) | This allows administrators to configure a time limit (in days) after how long an entity can be marked as archived. Once the entities have reached the closed state and also surpassed the time limit, the scheduled job will follow the archiving strategy configured in the Archive Entities settings to move or delete it. To mark an entity as a closed state, refer to the "[Case Entities](https://documentation.decisions.com/v9/docs/en/creating-a-case-entity-data-structure?highlight=case%20entite#state-configuration)" article. | After adding the case type it will expose the calendar information to configure the scheduled job. Refer [Archive Settings Calendar](https://documentation.decisions.com/v9/docs/understanding-scheduled-jobs?highlight=Daily%20Schedule) for more information. Note:Users with [Administrator Permissions and Can Administrate Permissions](https://documentation.decisions.com/v9/docs/setting-folder-permissions?highlight=Folder%20Permissions%20Levels) to the case entity folders can mark them archived no matter what the current state of the case is. --- ## Decisions Data on External Database (Warehouse) MS SQL OnlyExternal Databases are only supported when using MS SQL Server. PostgreSQL is not supported. When connecting to an external database, it is recommended to either create a new database or use a database that was not used by any decision instance. When the data is moved to the external database (warehouse), a database schema is automatically created only for the entities being moved, and all archived data is moved to the respective tables. For example, - **Folders** will be moved to **dbo.entity_folder** - **Comments** will be moved to **dbo.comments_folder** Note:The database schema of the primary database and the external (warehouse) database will be exactly the same. --- ## Generating Report of Archived Entities Users can generate a Report of all the archived entities by integrating with the external database (warehouse) that has been used to archive the entities. ### Example 1. [Integrating with external database](https://documentation.decisions.com/v9/docs/insert-update-delete-steps-integration-database#configuration)(warehouse) - Follow steps 1 and 2 from the following [article](https://documentation.decisions.com/v9/docs/insert-update-delete-steps-integration-database#configuration) to integrate with an external database. Ensure to use the same credentials that were used to connect to the warehouse. - In this example, we have named the external database **Archivied_Entities_DB.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1749666794479.png)** 2. [Integrate with the Database Table](https://documentation.decisions.com/v9/docs/integrate-with-database-table). - Click on the newly created database connection. From the top action bar, click on **Add Table**, and a database integration dialog appears. - From the drop-down, select **dbo.entity_folder** and click on **Next-Next-Save**. 3. [Creating the Report.](https://documentation.decisions.com/v9/docs/create-reports) - Navigate to the Designer Folder and create a new Report **Archived Entities**. - Under **Data Sources > Add > Common > Archivied_Entities_DB**[name of the database]**> dbo.entity_folder**[name of the table]. - Under **Data Fields > Add > entity_name, archivied_by** etc. **Save** and close the Report. 4. Refer to the following article to [Add a Report to Page](https://documentation.decisions.com/v9/docs/report-viewer-control). Similarly, users can create multiple reports after adding multiple tables from the database. Refer to the following articles to build more [complex reports](https://documentation.decisions.com/v9/docs/reports-filtered-row-selection). [Configuring the Archive Entities Settings](/v9/docs/archive-entities#configuring-archive-entities-settings)