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.3 - Legacy - Application management / Siebel 5.3 - Onboarding with AIP Console
Please see Siebel 5.3 - Release Notes for more information.
This extension provides support for Siebel.
In what situation should you install this extension?
The Siebel Analyzer has been designed mostly for its quality model inspired by customer best practices as well as Siebel review checklists. Hence it fulfils the use cases using the CAST Dashboard.
Supported Versions of Siebel
Thisprovides support for the following Siebel versions:
|15.0 (18.104.22.168/22.214.171.124 aka IP 2015)||New functionalities or syntax introduced in these versions are NOT supported, but this does not affect the results.|
|15.1 (126.96.36.199/188.8.131.52 PS1)|
|15.2 (184.108.40.206/220.127.116.11 PS2)|
|15.3 (18.104.22.168/22.214.171.124 PS3)|
|15.4 (126.96.36.199/188.8.131.52 PS4)|
|15.x (where x > 4)|
|16.x aka IP 2016|
|IP 2017, IP 2018, IP 2019||likely*|
* The Siebel repository tables "S_" are stable and have not change for quite some time. As such, the extractor will likely extract the objects and links as expected, and the rest of the analysis process will complete without issue.
New functionalities or syntax introduced in these versions are NOT supported, but this does not affect the results.
Function Point, Quality and Sizing 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
|Quality and Sizing|
AIP Core release
Supported DBMS servers
For AIP Core schemas
|CAST Storage Service/PostgreSQL|
For Siebel applications
The extension supports Siebel applications installed on the following DBMS:
|Microsoft SQL Server||(supported from v 5.2.6)|
|AIP Core||An installation of any compatible release of AIP Core (see table above). If you are using AIP Console to manage the analysis, you must use AIP Core ≥ 8.3.39.|
|AIP Console||If you would like to use AIP Console to manage the analysis, please ensure that you are using v. ≥ 1.27.|
Vanilla repository availability
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/DB2/Microsoft SQL Server repository (for Vanilla and Project)
For the list of S_*** tables, see Tables required to grant access to the Siebel repository.
On Workstation used for extraction (where the CAST Database Extractor / CAST Delivery Manager Tool is deployed)
On AIP Node used for analysis
On CAST Storage Service/PostgreSQL instance used for analysis
Disk space requirements
Disk space depends on the Siebel version implemented by the customer:
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:
Tables required to grant access to the Siebel repository
The following database tables are accessed during the Siebel extraction process: SIEBEL_TABLES.txt.
Download, installation, configuration and operating instructions
What results can you expect?
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:
|Siebel Business Objects|
|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|
|Siebel Business Component|
|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|
|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|
|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|
|Siebel Web Page|
The following structural rules are provided:
You can find a global list here: https://technologies.castsoftware.com/rules?sec=t_1520000&ref=||
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
When attempting to extract the Siebel database repositories (Vanilla or Project), when using:
- The standalone CAST Database Extractor using the Siebel-Extract-CLI.bat batch file
- The CAST Delivery Manager Tool (DMT) launched via the CAST Management Studio
The following error is logged, stopping the extraction process:
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:
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%:
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
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.
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 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.