Siebel Repository Extract (SRE) Tool – A Must Have For Siebel Developers

Launching

Pic - Dashboard

Pic – Dashboard

 

Development Challenge

  • Manually extracting new/modified object details from Siebel repository to prepare Technical Design Document.
  • Time-consuming process – With the increase in number of objects, time taken to extract them also increases proportionally.

 

Solution

  • Siebel Repository Extract (SRE) Tool
  • SRE Tool will automate the process of extracting Siebel object details from Siebel repository to excel sheets.
  • It will also formats the data, making it ready to be used in your Technical Design Document.

 

Process Improvement

  • Eliminates the need of manual efforts.
  • Achieves time reduction of 99.29%.

 

Features

  • Supports 31 most commonly worked upon Siebel Object Types.
  • Supports access to Server, Local or Sample databases through ODBC connections.

 

Versions Available

Trial vs Full Version

Trial vs Full Version

 

Download Presentation/User Guide

 

Download Trial Version

 

Purchase Full Version

In case of any difficulty in downloading/purchasing the tool, please leave a comment.

Siebel Interview Question – Execution Architecture

 

Question

Which executes first – An escript on WriteRecord of a BusComp or a Runtime Event on Writerecord of same BusComp?

 

Answer

Runtime Events fire before any script events.

Siebel Party Model – What is a User?

 

User is a person/contact with User ID. For example – A registered customer on your Web site browsing/ordering products online.

Parties Person - Venn Diagram

Parties Person – Venn Diagram

User records can be seen in following application view:

  • Administration – User > Users
  • Contacts > All Contacts

 

Characteristics of a User 

  • May have associated responsibility leading to application access.
  • May have any associated positions.
  • Must have a User ID leading to database login.
  • It is possible to promote a contact/person to a user.
    • Adding a User ID value for a person record in Persons view causes it to appear as a user in the Users view.
What is User - Application View

What is User – Application View

 

Database Tables

Tables representing a User record are highlighted below:

  • Base Table – S_PARTY
  • Extension Tables
    • S_CONTACT – Stores First and Last Name of user.
    • S_USER – Stores User ID.
  • Intersection table – S_PER_RESP (not shown) stores responsibilities for users.
Table Architecture - User

Table Architecture – User

 

Complete Overview of Party Data Model

To study Siebel’s Party Data Model in detail, please preview/download:

Siebel – How To Extract Attachments Using EIM

 

 

Scenario

During upgrade process, over 11,000 Opportunities were identified for migration. Also there were attachments associated with these opportunities.

 

Approaches

I short-listed following two ways to pull out the attachment files:

  1. Client-side Business Service
  2. EIM export

After initial POC, I settled down with EIM export option.

Reason – EIM job extracts the attachment files and place them at specified location. Now suppose if there are multiple files with the same name, what will happen? In this scenario, EIM job automatically appends file name with numerals (like 1, 2, 3 and so on) and further saves the file.

But with the client-side scripting, this scenario needs to be handled explicitly.

 

Solution

To download the required IFB file (enclosed in word document), click here >> ExtractOptyAttachments – IFB

Limitation: Only 1000 Row Ids can be specified at maximum in each IFB file. Therefore to extract attachment files for 11,000 opportunities, I had to prepare 11 IFB files and run each of them.