Retrieving Archived Data Records

The Siebel Intelligent Data Archival framework not only archives data securely but also allows controlled retrieval and visibility of archived records within Siebel. You may want to expose archived data and retrieve archived attachments for analysis, compliance, or reinstatement.

You can configure data retrieval at the UI level, for end users, using archive business components (BCs). You also can retrieve archived information at the data level for attachments. The method you use depends on the archival target (database or file system).

Expose Archived Data in the Siebel UI

Archived data can be displayed under its respective parent entities (such as Accounts, Service Requests, or Orders) using Child Archive Business Components. Child BCs are linked to the main parent BC to show historical archived records alongside active records.

Steps to expose archived data:

1. Determine the parent entity under that the archived data needs to be displayed under. For example, you might specify to show archived Service Requests under a parent Account.
2. Create a new BC that represents the archived data.

   Define the BC's data source as the S_ARCHIVE_DATA table.

   Apply a Search Specification on the Data Entity field to filter archived records relevant to that object.

3. Create a link between the parent BC and the child archive BC. The link should be based on the Parent Entity ID defined in the corresponding Archive Rule (for example, Account Id, SR Id).
4. Add the newly created child archive BC to the parent business object (BO). Use the link created in step 3 to establish the relationship.
5. Create a new applet based on the child archive BC to display archived records. Include relevant fields, for example, Archive Date, Archived By, Summary, and Description).
6. Add the applet to an existing or new view under the parent object (for example, Account Service Request List View). This will let users see both live and archived records in context.
7. Add a Retrieve button to the archive applet to allow users to initiate data retrieval.
   Configure the button properties as follows:

   • Control: Retrieve
   • HTML Type: MiniButtonEdit
   • Method Invoked: ShowPopup
   • Runtime: Y
   • Show Pop-up: Y
8. Add a Control User Property. Configure the control with the following user property:
   • Mode: Base
   • Popup: Data Archive Retrieve Object Popup Applet

Retrieve Attachments

Attachments associated with Siebel business entities, such as Service Requests, Quotes, or Activities, can also be archived and retrieved as part of the Siebel Intelligent Data Archival.

During archival, attachments are stored in Base64-encoded format to preserve data integrity and ensure transportability across storage mediums (database or file system).

Attachment Retrieval for Database Archive Target

For archival rules that target a database, all attachments are stored in the S_ARCH_ATT_STORE table.

Steps:

1. Identify the Target Data Entity.
2. Use the following SQL command to extract the Base64-encoded attachment data from the archive table:

   select ATT_OBJ_DATA  from 
   S_ARCH_ATT_STORE where ARCH_OBJ_ID 
   = <Object ID>

3. Use a Base64 decoder to decode the ATT_OBJ_DATA value and to obtain the attachment content.

Attachment Retrieval for File System Archive Target

For archival rules that target the file system, attachments are stored as Base64-encoded files under the defined archival destination directory.

Each archived attachment is associated with a Main Job ID, Batch ID, and Object ID that correspond to the archival job execution.

1. Identify the Target Data Entity and Object ID.
2. Identify the Main Job ID and Batch ID associated with the Object ID. These values are recorded in:
   • The archival activity log in Siebel
   • Helidon logs can be viewed in console.
3. Locate the archive file path in the configured target the file system as per the following structure: <FileSystem_Path>\Base_Service_Request_Archival\Main_Job_<MainJobID>\Batch_<BatchID>\<ObjectID>
4. Use a Base64 decoder to decode the ATT_OBJ_DATA value and to obtain the attachment content.

Restore Data

Use standard EIM approach to restore the archived data. Refer to Importing Data.