Page tree
Skip to end of metadata
Go to start of metadata

On this page:

Target audience:

Users of the extension providing Siebel support.

Summary: This document provides basic information about the extension providing Siebel support.

Please ensure that you strictly follow all instructions exactly as described in this documentation. Failure to do so may result in a failed installation or erroneous results. For example:

  • Please do not use these instructions with previous releases of the Siebel extension, and vice-versa.
  • Please avoid creating your own User Defined Modules - please follow the User Defined Modules configuration exactly as described in Siebel 5.2 - Application management.

Extension ID

com.castsoftware.siebel

What's new?

Please see Siebel 5.2 - Release Notes for more information.

Description

This extension provides support for Siebel.

In what situation should you install this extension?

The Siebel Analyzer has been design mostly for its quality model inspired by customers best practice as well as Siebel review checklist. Hence it fullfills the use cases using the Dashboard.

Supported Versions of Siebel

This extension provides support for the following Siebel versions:

Siebel versionSupportedComments
7.5(tick)
7.7(tick)
7.8(tick)
8.0(tick)
8.1.x.x(tick)
15.0 (8.1.1.15/8.2.2.15 aka IP 2015)(tick)New functionalities or syntax introduced in these versions are NOT supported, but does not affect much the results.





15.1 (8.1.1.15/8.2.2.15 PS1)(tick)
15.2 (8.1.1.15/8.2.2.15 PS2)(tick)
15.3 (8.1.1.15/8.2.2.15 PS3)(tick)
15.4 (8.1.1.15/8.2.2.15 PS4)(tick)
15.x (where x > 4)(tick)
16.x aka IP 2016(tick)
IP 2017, IP 2018, IP 2019likely*

likely* : the Siebel repository tables S_ are very stable since years. So the extractor will likely extract the objects and links as expected, and rest of analysis will goes fine.

As soon as it is confirmed, a green tick will be added instead.

Function Point, Quality and Sizing support

This extension provides the following support:

  • Function Points (transactions): a green tick indicates that OMG Function Point counting and Transaction Risk Index are supported
  • Quality and Sizing: a green tick indicates that CAST can measure size and that a minimum set of Quality Rules exist
Function Points
(transactions)
(error)
Quality and Sizing(tick)

CAST AIP compatibility

This extension is compatible with:

CAST AIP release

Supported

8.3.x(tick)
8.2.x(tick)

Supported DBMS servers

For CAST AIP schemas

DBMSSupported
CSS(tick)

For Siebel applications

The extension supports Siebel applications installed on the following DBMS:

DBMS

Supported

Oracle Server(tick)
DB2 UDB(tick)

Prerequisites

CAST AIP(tick)An installation of any compatible release of CAST AIP (see table above)

Vanilla repository availability

(tick)

Please ensure that the Vanilla repository is online and available before starting.

Note that the Vanilla repository must have the same Siebel version as the Project repository, and same series of Siebel patches.

On Siebel server hosting the Oracle or DB2 repository (for Vanilla and Project)

(tick)
  • The server can be any OS, however Unix/Linux OS may require some .ksh script if you want to run the extractor on the server machine itself. 
  • The version of the Oracle / DB2 server must match a version supported by the JDBC driver embedded in the CAST Database Extractor (used to extract the SQL data). This is different and wider than the supported versions for a participating database. Note that versions supported by CAST AIP for a participating databases can be found in the official CAST AIP documentation (e.g. SQL - Covered technologies)
  • Make sure that the Siebel schema statistics are up-to-date (if not up-to-date, some queries in the extractor may not finish in reasonable times (especially the first one)). To update:
Oracle

Update the schema with the following SQL statement (requires some privileges : GRANT execute ON dbms_stats TO XXX):

Execute dbms_stats.gather_schema_stats(ownname => 'MY_SIEBEL_SCHEMA', estimate_percent => dbms_stats.auto_sample_size, method_opt => 'for all columns size auto', cascade => true); 
DB2 UDBCheck if the DB2 automatic runstats and DB2 real time statistics are enabled. If not, ask the DBA to run "db2 reorgchk update statistics on table all" or similar.
  • Identify the USER that will be used for extraction (in the CAST Delivery Manager Tool):
    • On Oracle, the required privileges for the USER used to perform the extraction are: GRANT SELECT on all S_**** tables
    • On DB2 UDB, the minimum roles and permissions for an extract is as follow : READ access on all S_**** tablesconnect to database permission.

On Workstation used for extraction (where the CAST Delivery Manager Tool is deployed)

(tick)
  • Windows or Linux (Unix/Linux OS may require some additional .ksh scripts). 
  • JRE 1.7 (ideally 64 bit version to allow for a JVM large heap size).
  • Minimum 1.2 GB RAM memory free, more if available.
  • DMT/extractor location:
    • Ideally, install the DMT/extractor on the RDBMS server (Oracle or DB2) itself.
    • Alternatively on a machine with:
      • very good bandwidth (1 GB/s) to the Oracle / DB2 server (some remote extractions fail due to poor VPN bandwidth)
      • connectivity to the Oracle / DB2 server (required ports open)
  • 4 GB free disk space (for temporary files before compression)
  • 250 MB free disk space (to store the two extraction archives) included in above requirement.

On Workstation used for analysis

(tick)
  • Windows (uses AIP).
  • 2 GB RAM memory free (for analysis/snapshot)
  • Connectivity to the CSS server hosting the CAST AIP schemas (port open)
  • 5-10 GB free disk space (to store the source code, once expanded by the Deploy phase ("Set as current version" action in the CAST Management Studio))
  • Disable anti-virus software. Check that no anti-virus is running on the workstation or disable real-time scan for the work folders (delivery & deploy folders + temp folders). Failure to do so will multiply the injection runtime ("Set as current version" action in the CAST Management Studio)

On CSS server used for analysis

(tick)

Disk space requirements

Disk space depends on the Siebel version implemented by the customer:

Siebel versionVanilla _LOCALProject _LOCALProject _CENTRAL_MNGTUNDO and TEMPSource CodeTotal consumedTotal required at peak time
8.x5 GB7 GB2 GB0.256 GB23 GB + 10 GB (maybe due to other analyses)5.98 GB49 GB100 GB
7.82.5 GB3 GB0.8 GB0.256 GBTBD or see above.5.21 GB30-35 GB50 GB

Disk speed requirements

Siebel analysis incurs heavy disk usage. Disk I/O throughput (not necessarily speed) is possibly the most important factor to determine the analysis time. So far we have tested three environments with the tool iometer, following this how-to. The rough results are these:

  • DELL laptop, 1 disk 7500rpm. Iometer reports around 3 MB/s. Analysis times +20 hours.
  • HP desktop, 2 disks 10000rpm. Iometer reports around 5 MB/s in one of the disks. Analysis time 10 hours (sources in one disk, oracle datafiles in another disk).
  • DELL workstation, 4 disks 10000rpm in a RAID5 configuration. Iometer reports around 150MB/s. Analysis time 4 hours (since this is a very performant disk configuration, CPU time is possibly part of the bottleneck. This means it would be hard to further reduce analysis time, unless switching to other costlier technology, like SSD drive).

Tables required to grant access to the Siebel repository

(tick)

The following database tables are accessed during the Siebel extraction process: SIEBEL_TABLES.txt.

FAQs

Please see Siebel and PeopleSoft - FAQs for more information.

Download, installation, configuration and operating instructions

What results can you expect?

Objects

The objects listed below are all the object types that a Siebel analysis will deliver in the Analysis Service. With these objects, CAST is capable of supporting a set of quality rules to provide a customer with a good overview of the current technical status of a Siebel application. It is not the intention of CAST to capture all details and syntaxes; a coupling between requirement and detection is made.

Click to enlarge or download it here.

The Siebel extension is capable of detecting a large number of objects, properties and links. All of these artifacts are mentioned in the picture above, but in essence, all Siebel objects are supported:

IconMetamodel description

Siebel Application

Siebel Screen

Siebel View

Siebel Business Objects

Applets

IconMetamodel description



Siebel Applet - Association List

Siebel Applet - Detail

Siebel Applet - MVG
Siebel Applet - NULL
Siebel Applet - Pick List
Siebel Applet - Playbar
Siebel Applet - Standard
Siebel Applet - Task

Business Component

IconMetamodel description

Siebel Business Component

Table

IconMetamodel description

Siebel Table Data (Intersection)
Siebel Table Data (Private)
Siebel Table Data (Public)
Siebel Table Dictionary
Siebel Table Extension
Siebel Table Extension (Siebel)
Siebel Table External
Siebel Table External View
Siebel Table Interface
Siebel Table Log
Siebel Table Repository
Siebel Table Virtual Table
Siebel Table Warehouse
Siebel Table Unkown Type

Web Template

IconMetamodel description

Siebel Web Template - Applet Template

Siebel Web Template - Applet Template - Chart
Siebel Web Template - Applet Template - Form
Siebel Web Template - Applet Template - Grid Layout
Siebel Web Template - Applet Template - List
Siebel Web Template - Applet Template - Specialized
Siebel Web Template - Applet Template - Tree
Siebel Web Template - View Template
Siebel Web Template - Web Page Template

Class

IconMetamodel description

Siebel Class - ActiveX Control
Siebel Class - Applet
Siebel Class - Business Component
Siebel Class - Document
Siebel Class - Java Applet
Siebel Class - Report
Siebel Class - Search
Siebel Class - Service

Misc

IconMetamodel description

Siebel Link

Siebel Picklist

Siebel Web Page

Structural rules

The following structural rules are provided:

Known issues/limitations

The following section lists all known issues/limitations in this release of the extension.

Unable to establish a connection while performing the database repository extraction

Situation

When attempting to extract the Siebel database repositories (Vanilla or Project), when using:

  • The CAST Delivery Manager Tool (DMT) launched via a JNLP file (i.e. when the DMT has been downloaded from the CAST AIC Portal)
  • The CAST Delivery Manager Tool (DMT) launched via the CAST Management Studio
  • The standalone CAST Database Extractor using the Siebel-Extract-CLI.bat batch file
Note that the exact situation in which the issue occurs is currently unknown.

Symptoms

The following error is logged, stopping the extraction process:

Unable to establish a connection to: jdbc:oracle:thin:@<ip>:1521:<instance> => The Network Adapter could not establish the connection

Workaround

The workaround to this issue involves manually adding a specific Java runtime option (-Djava.net.preferIPv4Stack=true) and then attempting to rerun the database extraction:

CAST Delivery Manager Tool (DMT) launched via a JNLP file

If you are using the CAST Delivery Manager Tool (DMT) launched via a JNLP file (i.e. when the DMT has been downloaded from the CAST AIC Portal) to perform the database extraction, then it is not possible to use this workaround. If you are confronted by this issue, please consider running the database extraction either:

  • using the DMT launched via the CAST Management Studio (and applying the workround listed below)
  • or using the standalone CAST Database Extractor with the Siebel-Extract-CLI.bat batch file (and applying the workround listed below)

CAST Delivery Manager Tool (DMT) launched via the CAST Management Studio

If you are using the CAST Delivery Manager Tool (DMT) launched via the CAST Management Studio to perform the database extraction, you must add the specific Java option to the shortcut that runs the CAST Management Studio executable on your workstation:

  • Add the option to the Target field, immediately after CAST-MS.exe" : -Djava.net.preferIPv4Stack=true

Note that you will need to close the CAST Management Studio and re-open it if it was running when you made the change to the shortcut.

Standalone CAST Database Extractor using the Siebel-Extract-CLI.bat batch file

If you are using the standalone CAST Database Extractor with the Siebel-Extract-CLI.bat batch file to perform the database extraction, you must add the specific Java option to the batch file at line 163, immediately after %JAVA_EXE%:

Error when displaying source code in the CAST dashboards

Most Siebel objects don't have associated source code as they correspond to a configuration (example: an applet). In the CAST dashboards an error will therefore be displayed when trying to display the object source code (example error message from the legacy CAST Engineering Dashboard):

No bookmarks are displayed for violations in source code in CAST dashboards

When using the CAST dashboards, no "bookmarks" will be displayed to indicate where violations occur in source code. This is a limitation of the extension.

Miscellaneous information

This section explains various miscellaneous information that is important to understand.

Running a CAST AIP upgrade or an Extension upgrade

This note is valid in the following situations:

  • Running a CAST AIP upgrade (major/minor or Service Pack)
  • Running an Extension upgrade (not limited to an upgrade of the Siebel extension)
  • Using the Component Update/Component Reinstall options in CAST Server Manager

When any of the above actions are performed, the Siebel custom tables located in the VANILLA_SCHEMA (in our example, SIEBEL5_V_LOCAL) will be recreated and all data will be overwritten and lost. In this situation, you MUST use the Run Analysis only option in the CAST Management Studio (on the Vanilla application) to re-populate the custom tables (used for the discrimination step during the Project snapshot generation) before you run the Project snapshot.

  • No labels