Utility Siebel Repository Extract SRE Tool Copyright2013 Cracking
Utility Siebel Repository Extract (SRE) Tool Copyright@2013 Cracking. Siebel. com
Agenda u Development Challenge u Solution u Features/Benefits u Process Improvement u User Guide v v v Introduction ODBC Connection User Id/Password Repository Changed Date System Requirements u Released Versions Copyright@2013 Cracking. Siebel. com
Development Challenge • Preparation of Technical Design Document (TDD) with Siebel Object Definitions • Developers manually copy details of new/modified objects from Siebel repository, format them and paste them onto TDD. • This manual process consumes a big share of development time. • Multiple Developers Working on Same Technical Design Document (TDD) • When multiple developers are working on the same TDD, it needs to be ensured that each developer updates it one by one. • Also changes made by other developers should not get modified by your changes. Copyright@2013 Cracking. Siebel. com
Solution Siebel Repository Extract (SRE) Tool • Extracts all new/modified objects that have been modified in Siebel Repository since a specific date. • Automatically formats extracted records and puts them onto excel sheets, ready to be copied into your Technical Design Document. • Supports 31 most commonly worked upon Siebel Object Types. • Supports connectivity with Server, Local and Sample databases through standard ODBC connections. Copyright@2013 Cracking. Siebel. com
Solution (. . . Contd) List of 31 Siebel Object Types that are supported by SRE Tool: • • • Applet • Applet – Control • Applet – List Column • Applet – User Prop Business Component • Bus. Comp – Field – Pickmap • Bus. Comp – Field – User Prop • Bus. Comp – Join – Constraint • Bus. Comp – Join – Specification • Bus. Comp – MVL • Bus. Comp – View Mode • Bus. Comp – User Prop Business Objects • Bus. Obj - Component • Integration Object • Int. Obj – Component - Field • Link • Picklist • Screen • Screen - View • Table • Table - Column • View • View – Web Template – Item • Copyright@2013 Workflow • WF Process Prop • WF Step Cracking. Siebel. com • WF Steps – I/O Argument
Features/Benefits u Automation of the process n n n All details of modified objects are extracted and formatted automatically onto excel sheet with a single click. Eliminates time-consuming manual effort. Time taken for this process is reduced by 99. 29%. u Single User Administration n n Single user can manage entire set of modified objects with ease. No further need of all team members working separately on extracting and copying data for their respective modules. u Portability n Due to <500 KB size, SRE Tool is easy to share over emails. u MS Office Platform n n No installation is required. This tool is build on MS Excel. Wide acceptance of MS Office tools enable high availability of the tool as well. Copyright@2013 Cracking. Siebel. com
Process Improvement Below is the time comparison of repository extraction process – Manual v/s SRE Tool No. of Repository Objects Time Taken - Extract and Format Data in Excel Time Reduction (in %) Manually (in min) SRE Tool (in min) 10 8. 3 0. 2 97. 59 100 83. 3 0. 25 99. 70 500 416. 7 0. 35 99. 92 1000 833. 3 0. 5 99. 94 Average % 99. 29 Comparison Criteria: 10 attributes for each modified object need to be extracted, formatted and copied over to an excel sheet. Copyright@2013 Cracking. Siebel. com
User Guide - Introduction u Provide four inputs n n u ODBC Connection User Id Password Repository Change Date (YYYY/MM/DD) Click ‘Generate Reports’ to extract objects from Siebel repository. n User can click ‘Generate Reports’ multiple times to capture further modified objects in Siebel repository Copyright@2013 Cracking. Siebel. com
User Guide – ODBC Connection Copyright@2013 Cracking. Siebel. com
User Guide – User Id/Password Copyright@2013 Cracking. Siebel. com
User Guide – Repository Change Date Copyright@2013 Cracking. Siebel. com
User Guide - System Requirement u u Windows XP or higher. MS Excel 2003 or higher. Macros should be enabled in MS Excel. Please note that Openoffice Spreadsheet is not supported. Copyright@2013 Cracking. Siebel. com
Released Versions - Trial v/s Full Copyright@2013 Cracking. Siebel. com
Thank you ! Copyright@2013 Cracking. Siebel. com
- Slides: 14