1. Applications Administration Guide
  2. Installing Siebel Intelligent Data Archival

Installing Siebel Intelligent Data Archival

This release delivers both Siebel application updates and an external microservice deployment package to enable the archival framework.

Nature of Changes

Category Description
Binary Changes Core Siebel binaries have been enhanced to support archival orchestration via new Archival Administration views. New siebel-data-archival.zip package containing
  • siebel-data-archival.jar to setup Helidon microservices.
  • siebel-data-archival.zip also includes ArchivalDBSetup.jar to setup schema on target DB
Seed Data Changes New seed data entries are delivered to enable rule-based archival configuration and monitoring within Siebel.
Repository (NEO) Changes Repository changes under the NEO model include new metadata objects that support rule management, integration, and logging
Schema Changes Database schema changes introduced as part of post-install setup.

These changes establish the Siebel-side framework required for integration with the external Helidon based Data Archival Microservices.

Prerequisites

Before installation and configuration:

  • Verify Siebel REST API endpoints are configured and functional.

  • Install Java21 on the target machine for running the Helidon microservice.

  • Ensure secure network communication between the Siebel server and the Helidon host.

PostInstall Database Setup

After applying the latest Siebel patch:

  1. Run the Post Install DB Setup utility included in the update package.

    This step introduces the required schema objects (tables, indexes, and sequences) for archival rule management and logging.

Steps for Target DB Setup

  1. Unzip siebel-data-archival.zip from <Siebel Build>\ses\siebsrvr\BIN\siebel-data-archival.zip.
  2. ArchivalDBSetup.jar is packaged inside siebel-data-archival.zip. Make sure ArchivalDBSetup.jar is present in the same folder as siebel-data-archival.jar .
  3. ojdbc11-23.6.0.24.10.jar is packaged as part of siebel-data-archival.zip under \libs. Provide the FS path for ojdbc11-23.6.0.24.10.jar in the following command after unzipping it.
  4. Provide the Target DB details using command line arguments.
  5. It should connect to the DB and create tables and sequences by executing the following command.

Windows:

Command:

java -cp "<fs>\ArchivalDBSetup.jar;<fs>\libs\ojdbc11-23.6.0.24.10.jar" 
com.siebel.siebarchivaldbsetup.ArchivalDBSetup -h <server> -o <port> -s 
<instance> -u <tableowner> -p <tableowner_password> Example : java -cp 
"C:\siebel-data-archival\target\ArchivalDBSetup.jar;C:\siebel-data-archival\target\libs\ojdbc11-23.6.0.24.10.jar" 
com.siebel.siebarchivaldbsetup.ArchivalDBSetup -h 
phoenix248484.appsdev.fusionappsdphx1.oraclevcn.com -o 1551 -s qa484 -u ORA484130 -p ORA484130

Linux:

Command:

java -cp "<fs>/ArchivalDBSetup.jar:<fs>/libs/ojdbc11-23.6.0.24.10.jar" 
com.siebel.siebarchivaldbsetup.ArchivalDBSetup -h <server> -o <port> -s 
<instance> -u <tableowner> -p <tableowner_password> Example : java -cp 
"/scratch/home/sblqa1/DA/ArchivalDBSetup.jar:/scratch/home/sblqa1/DA/libs
/ojdbc11-23.6.0.24.10.jar" com.siebel.siebarchivaldbsetup.ArchivalDBSetup -h 
phoenix248484.appsdev.fusionappsdphx1.oraclevcn.com -o 1551 -s qa484 -u ORA484130 -p ORA484130