Posts Tagged ‘extract’

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

  • To purchase full version (Single User License) of SRE Tool, click SRE Tool – Full Version
  • Limited period 25% discount code – “CRACKERDISC”

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

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.