Oracle Siebel 简易部署手册
Siebel CRM SmartScript用户指南说明书
Siebel CRM SmartScriptSiebel SmartScript is a powerful, flexible tool that provides a workflow-based, dynamic user interface that guides a user on the web or an agent in a Call Center through a guided sequence of steps. It combines setting a workflow process with a dynamically generated user interface to offer information on a “just in time” basis. It can be used for automating a wide variety of tasks including diagnostic Q&A for problem resolution, call scripting for telemarketers, or needs analysis for product recommendations systems. SmartScripts can be easily constructed using a drag-and-drop interface to build questions, text, and branches. All questions are reusable, and the same script can be deployed across HTML pages on different browsers and devices. Scripts can be continually refined without programming.S I E B E L S M A R T S C R I P TK E Y F E A T U R E S∙Dynamic agent desktop with “just in time” question-answer interface∙Dynamically generate questions based on branching logic∙Visual representation of question sequence to agents to allow easy traversing of the script ∙Group related questions using page sections ∙Flexibility to branch from any question to any other question in Smart Script Player∙Drag-and-drop flowchart UI for administering SmartScripts without programming∙Support extending scripts with Siebel VB and eScript∙Reusability of SmartScript pages and questions across multiple scripts∙Simple deployment of scripts in multiple languages without changing the script structure∙Save & Resume Capability for multi session interactions Dynamically Generated UI Ensures The Quality Of Each Customer InteractionSiebel SmartScript provides a dynamic desktop with a question-answer interface where the next question asked may be determined by answers given on prior questions. Branching logic can be easily built so that questions that prompt the agent are generated dynamically to guide the agent through the interaction. Agents can view and navigate to related questions, which are displayed and grouped as Pages. Agents easily navigate through the SmartScript sequentially, by following the question order, or through a treecontrol where they can directly jump to a particular question.Reduce Training Time and Increase ProductivitySmartScripts incorporate elements that are of tremendous use by inexperienced and experienced agents. Instead of navigating through unfamiliar and sometimes complex screens, agents will be prompted with the next question based on previous answers and a set workflow. Agents will not be required to remember what and how to ask question. They instead will be provided with the exact wording and answer options for every question. Once the business analysts design the SmartScript, it can be immediately deployed to the call center or to the Web.Integrate Sales and ServiceSiebel SmartScript can be designed to incorporate rules for cross-selling or up-selling. Based on answers provided by a customer over the phone, SmartScript can prompt the agent to inquire about other product or service options. In addition, the sales effectiveness of different approaches can be tested out and refined using SmartScript. Sales per agent can be continually improved using different word phrasings or question sequences.Deploy SmartScripts Over The WebSiebel SmartScript allows call centers to deploy across HTML on the web. With the deployment capability of “create once, deploy everywhere, the same administration and same SmartScripts can be used for both call center and Web. In order to improve the ease of using scripts on the web, all of the questions from the SmartScript that don’t require a branch will be displayed at once so it is not necessary to constantly refresh the HTML page. The next set of questions will be displayed based on how the user answers the last question.Graphically Design And Modify Call Scripts Without Technical ExpertiseSiebel SmartScript uses a graphical, simple, drag-and-drop user interface that allows visualization of the structure of a script. Users simply add new pages or questions through this interface and drag branches between them to create the sequence logic. Instead of requiring weeks or months of IT or engineering time to build a script, SmartScripts can be built at the business analyst level in a fraction of the time. Changing SmartScript structure can be done using the same flowchart UI, allowing continuous improvements to productivity.Easily Deploy Multilingual SmartScriptAny number of translations of SmartScripts can be built just by translating the question and answer strings with the Siebel Administration screen. Once the structure of the SmartScript is built, then it is not necessary to alter it for additional languages. Once a question is translated, since it is reusable across multiple scripts, the task of translating multiple scripts is considerably reduced. When agents run a script, they can choose which language they want to run it in. Alternatively, a question in the script can be used to invoke the proper language in the SmartScript.Leverage the power of Siebel Products with SmartScriptSiebel SmartScript is fully integrated into Siebel Applications. Siebel CTI can be used to capture information about a call, start a SmartScript, and use this CTI information in the SmartScript. Assignment Manager can be used to assign tasks created in a SmartScript and then return that information to SmartScript. Siebel’s knowledgebase of Decision Issues and Solutions can be effectively used to build a dynamic troubleshooting script. SmartScript can capture information about a user, which can then be passed to the Siebel Product Configurator to make product suggestions.C O N T A CFor more information about Siebel CRM, visit or call +1.800.ORACLE1 to speak to an Oraclerepresentative.C O N N E C T W I T H U S/oracle /oracle /oracle Copyright © 2014, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and。
四季沐歌 Siebel CRM项目客户端程序安装操作手册
日出东方CRM项目客户端程序安装操作文档操作手册作者:HAND创建日期:2014-9-26最后更新日期:2014-9-26版本：V1.0编写说明系统用户通过IE浏览器的方式进行系统首次登陆时需要安装Siebel HighInteractivity Framework插件，以保证系统的正常使用。
本操作文档主要针对上述插件安装的流程进行详细说明，包含以下几个部分：•信任站点设置：叙述在IE浏览器端将系统加入信任站点，以保证插件可正常下载•浏览器设置：叙述如何设置以保证系统界面可以正常使用•插件安装流程：叙述首次登陆用户如何安装插件•常见问题解决：叙述在插件安装过程中可能遇到的一些常见问题及解决办法使用对象全体用户Contents编写说明 (ii)使用对象 (ii)CRM主系统-信任站点的设置 (1)流程描述 (1)操作说明 (1)操作过程 (1)CRM主系统-针对IE8或更高版本的兼容性设置 (9)流程描述 (9)操作说明 (9)操作过程 (9)CRM主系统-选项卡设置 (11)流程描述 (11)操作说明 (11)操作过程 (11)CRM主系统-浏览器插件的下载 (14)流程描述 (14)操作说明 (14)操作过程 (14)Reip中CRM账号维护 (19)业务简述 (19)操作说明 (19)操作过程 (19)CRM主系统用户密码修改 (21)流程描述 (21)操作说明 (21)操作过程 (21)CRM门户系统用户密码修改 (23)流程描述 (23)操作说明 (23)操作过程 (23)录入用户名及密码，并点击常见问题及解决办法 (27)⏹无法登陆到系统操作页面 (27)⏹无法添加系统网址至“可信网站”列表 (28)⏹无法进入或点击Siebel系统的菜单栏选项的问题 (28)⏹无法看到系统登陆页面或其他登入、下载插件的问题 (29)CRM主系统登录-信任站点的设置流程描述1. 需使用IE8浏览器，将正式环境地址加入IE浏览器的信任站点中，并将安全等级设置为“低”操作说明操作过程1．首次访问系统登陆界面及网址记录•首次进入登陆界面•正式环境网址：/2．添加网址至可信任的站点•选择，IE浏览器菜单上的“工具——>Internet选项”•选择，IE点击“安全”选项卡，选择“受信任的站点”•点击“站点”按钮，弹出安全站点添加界面•在“将该网站添加到区域中”下的录入框中填入刚刚记录下的网址，并将下方的“对该区域中的所有站点要求服务器验证(http: ）”的选项去掉•点击“添加”，将键入的网址添加到可信站点的“网站”列表中•点击“确定”按钮，添加可信站点的操作完毕3．更改可信任站点的安全性设置•点击“自定义级别”按钮，弹出“受信任的站点区域对话框”•将“重置为”选择为“安全级–低”•检查“下载未签名的ActiveX控件”是否选为“启用”，若为“禁用”请选为“启用”•检查“文件下载自动提示”是否为“启用”，若为“禁用”请选为“启用”•点击“确定”按钮•返回登陆页面，查看右下角的状态栏，如果前述设置正确，网站状态为“可信站点”CRM主系统登录-针对IE8或更高版本的兼容性设置流程描述1. 对兼容性视图进行设置操作说明操作过程1．进入“兼容性视图设置”界面•在IE的命令栏中选择“页面”选项，在下拉菜单中选择“兼容性视图设置”，进入“兼容性视图设置”界面2．对兼容性视图进行设置•在“兼容性视图设置”界面中，勾选“在兼容性视图中显示所有网站”选项CRM主系统登录-选项卡设置流程描述1. 对选项卡进行设置操作说明操作过程1．进入“Internet选项”设置界面•打开IE浏览器。
oracle 10g RAC for aix6安装步骤
Oracle 10g RAC for AIX6.1硬件环境：2台IBM P520 服务器，2台光纤交换机，1台IBM DS4700磁盘阵列（1.2TB）软件环境： Oracle 10g R2 （需升级到10.2.0.4）， AIX6.11.IP规划:racdb1 公网：172.16.28.31VIP：172.16.28.33心跳: 192.168.100.1racdb2 公网: 172.16.28.32VIP: 172.16.28.34心跳：192.168.100.22.需要的软件包：bos.adt.libbos.adt.libmbos.perf.libperfstatbos.perf.perfstatbos.perf.proctoolsxlC.aix61.rte:9.0.0.1xlC.rte:9.0.0.1通过lslpp -l bos.adt.base 查看软件包是否已安装# lslpp -l bos.adt.baseFileset Level State Description---------------------------------------------------------------------------- Path: /usr/lib/objreposbos.adt.base 6.1.3.0 COMMITTED Base Application Development Toolkit需要的补丁:由于此次项目的系统是最新的AIX6.1，无法在网上确切查询到所需要的正确补丁，所以在安装过程中遇到很多问题，最终安装了p6613550_10203_AIX64-5L、p8705958_10204_AIX5L(CRS PSU补丁,解决升级后VIP起不来BUG)3.通过命令“# chfs -a size=30G /”调整文件系统，结果如下：# df -gFilesystem GB blocks Free %Used Iused %Iused Mounted on/dev/hd4 30.00 29.79 1% 13717 1% //dev/hd2 10.00 8.03 20% 45904 3% /usr/dev/hd9var 10.00 9.76 3% 7296 1% /var/dev/hd3 8.00 7.67 5% 608 1% /tmp/dev/fwdump 5.00 5.00 1% 4 1% /var/adm/ras/platform /dev/hd1 30.00 11.28 63% 53931 2% /home/dev/hd11admin 2.00 2.00 1% 5 1% /admin/proc - - - - - /proc/dev/hd10opt 10.00 9.54 5% 9610 1% /opt/dev/livedump 5.00 5.00 1% 4 1% /var/adm/ras/livedump /dev/lv00 0.25 0.24 4% 18 1% /var/adm/csd/dev/fslv00 0.25 0.25 1% 8 1% /audit4.在2个节点上分别建立oinstall、dba、hagsuser组，Oracle用户，并保持组ID和用户ID相同# smitty group# smitty user：Primary GROUP 为“oinstall”，Group SET 为“dba”和“hagsuser”改为“-1”（无限制）5.编辑/etc/hosts文件，添加以下内容：172.16.28.31 racdb1192.168.100.1 racdb1-priv172.16.28.33 racdb1-vip172.16.28.32 racdb2192.168.100.2 racdb2-priv172.16.28.34 racdb2-vip6.配置系统参数，配置每用户的最大进程数，调整water mark# smitty chgsys7.存储划分asm 400G hdisk4vote 2G hdisk5ocr 2G hdisk6arch 200G hdisk7# lspvhdisk0 00cbc154bde9ce42 rootvg active hdisk1 00cbc1a4cb987b44 rootvg active hdisk2 none Nonehdisk3 none Nonehdisk4 none Nonehdisk5 none Nonehdisk6 none Nonehdisk7 none None# cd /dev# chown root:oinstall hdisk6# chown oracle:oinstall hdisk4 hdisk5# chmod 664 hdisk4 hdisk5 hdisk6# chown root:oinstall rhdisk6# chown oracle:oinstall rhdisk4 rhdisk5# chmod 664 rhdisk4 rhdisk5 rhdisk68.配置.rhosts文件，用于节点间的通信认证和加密# cd /home/oracle# mkdir .rhosts# vi .rhostsracdb1 oracleracdb2 oracleracdb1-priv oracleracdb2-priv oracleracdb1-vip oracleracdb2-vip oracle9.配置NTP服务，用于2个节点的时间同步用date命令调整时间至1000秒以内，如果2个节点时间相差多于1000秒，NTP服务会失败如date 0508013030 表示 5月8日1点30分30秒racdb1# vi /etc/ntp.confbroadcastclientserver 127.127.1.0 (添加)driftfile /etc/ntp.drifttracefile /etc/ntp.trace# startsrc -s xntpdracdb2# vi/etc/ntp.confbroadcastclientserver 172.16.28.31 (添加)driftfile /etc/ntp.drifttracefile /etc/ntp.trace# startsrc -s xntpd10.配置环境变量# cd /home/oracle# vi .profileORACLE_BASE=/home/oracleexport ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/10.2.0.1/racdbexport ORACLE_HOMEORACLE_CRS_HOME=$ORACLE_BASE/product/10.2.0.1/crsexport ORACLE_CRS_HOMEORACLE_SID=rac1export ORACLE_SIDORACLE_TERM=xtermexport ORACLE_TERMNLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport NLS_LANGLD_LIBRARY_PATH=$ORACLE_CRS_HOME/lib:$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/l ibexport LD_LIBRARY_PATHPATH=$PATH:$ORACLE_HOME/bin:$ORACLE_CRS_HOME/bin:/usr/bin:/etc:/usr/sbin:/usr/uc b:$HOME/bin:/usr/bin/X11:/sbin:.export PATH11.打补丁p6718715_10203_AIX64-5L.zip，然后以root用户执行补丁6718715里面的rootpre.sh文件；再用oracle用户执行CRS安装程序./runInstaller点击Next点击Next选择CRS安装的目录/home/oracle/product/10.2.0.1/crs，点击Nextoracle进行系统参数检查无问题，点击Next添加Cluster中两个节点及相关的公网、私网、VIP网络名称，点击Next选择ocr文件的位置为/dev/hdisk6，点击Next选择voting disk的位置为/dev/hdisk5，点击Next执行安装至完成。
OracleSiebelCRM解决方案保险业
可靠性：Oracle Siebel CRM解决方案经过多年的发展和完善，具有高度的可靠性和稳 定性，能够确保保险公司的业务正常运行。
安全性：该解决方案提供了一系列的安全措施，确保保险公司的客户数据和业务数 据的安全性和完整性。
人工智能和机器学习在CRM解决方案中的应用将进一步深化 云计算技术的普及将推动CRM解决方案的云端化 数据安全和隐私保护将成为CRM解决方案的重要考虑因素 定制化和行业专属性将成为CRM解决方案的重要发展方向
未来发展方向与挑战
人工智能和机器学习在Oracle Siebel CRM解决方案中的应用将进一步增强。
YOUR LOGO
Oracle Siebel CRM解决方案保险 业
XX,a click to unlimited possibilities
汇报人：XX
时间：20XX-XX-XX
目录
01
添加标题
02
03
04
05
Oracle Siebel CRM解决方案概 述
Oracle Siebel CRM 解决方案在保险 业的应用
实施效果：提高了客户满意度和 忠诚度，优化了销售流程和管理 效率，增加了业务收入和市场份 额
某外资保险公司实施效果
实施背景：公司面临客户信息分散、数据不一致等问题，需要集中管理客户信息和销售流程。
解决方案：采用Oracle Siebel CRM解决方案，整合客户信息，统一销售流程，提高客户满意 度和销售效率。
汇报时间：20XX/01/01
实施过程：项目分阶段进行，包括需求分析、系统配置、数据迁移、员工培训等环节，确保系统 顺利上线。
Oracle Siebel 运输解决方案集 运输业运营优势说明书
Increase Order Accuracy Provide a single automated and integrated order management system allowing companies to create, validate, and manage quotes and orders across the entire order lifecycle. Eliminate incorrect orders and order fallout by making sure that products and services are correctly configured and available before the order is confirmed.
The claims management process with Siebel Transportation Solution Set for Operational Excellence supports the entire claim lifecycle from claim report through settlement and analytics. It enables customers to log and track claims on the Web. And it accelerates claimsprocessing by automating manual tasks such as customer correspondence and escalation.
Oracle Siebel Tools 15.5 学生指南 Volume I说明书
Learn more from Oracle University at/education/Siebel T ools Rel 15.5Student Guide | Volume ID70458GC20Edition 2.0 |May 2016 | D94391Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Disclaimer This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. Except where your use constitutes "fair use" under copyright law, you may not use, share, download, upload, copy, print, display, perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part without the express authorization of Oracle. The information contained in this document is subject to change without notice. If you find any problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not warranted to be error-free. Restricted Rights NoticeIf this documentation is delivered to the United States Government or anyone using the documentation on behalf of the United States Government, the following notice is applicable:U.S. GOVERNMENT RIGHTSThe U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these training materials are restricted by the terms of the applicable Oracle license agreement and/or the applicable U.S. Government contract.Trademark NoticeOracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.AuthorCustomer Experience (CX)Curriculum DevelopmentTechnical Contributorand ReviewerCustomer Experience (CX)Product DevelopmentTeamPublishersJayanthy KeshavamurthyRaghunath MContents1 Siebel Tools: Course IntroductionLesson Agenda 1-2Instructor and Class Participants 1-3Training Site Information 1-4Course Audience 1-5Course Prerequisites 1-6Course Goal 1-7Course Objectives 1-8Course Methodology 1-9Course Materials 1-10Information Sources 1-11Course Agenda 1-122 Configuring a Siebel ApplicationObjectives 2-2Siebel Customer Relationship Management (CRM) 2-3 Siebel CRM Applications 2-4Comparison of Siebel CRM Applications 2-5Configuring a Siebel Application 2-6Siebel Tools 2-7The Repository and Siebel Tools 2-8Siebel Repository File 2-9Object Definitions 2-10User Interface Layer 2-12Tailoring the Logical User Interface 2-13Business Layer 2-14Tailoring the Business Layer 2-15Data Layer 2-16Extending the Data Layer 2-17Basic Configuration Steps 2-18Create or Edit Object Definitions 2-19Compile the Edited Object Definitions 2-20Test the Modifications 2-21Lesson Highlights 2-22Practices 2-233 Using a Local Development EnvironmentObjectives 3-2Siebel Application Development 3-3Create a Separate Development Environment 3-4 Creating a Local Developer: Overview 3-5Repositories 3-6Develop on the Local Repository 3-7Projects 3-8Assigning Object Definitions to Projects 3-9Viewing Object Definitions by Project 3-10Check Out/Check In Mechanisms 3-11Copying Projects 3-12Getting Projects 3-13Checking Out a Project 3-14Check Out a Project 3-15Checking In a Project 3-16Check In a Project 3-17Canceling Check Out 3-18Project Differences 3-19Undoing a Check Out 3-20Undo Check Out 3-21Object Check Out/Check In (COCI) 3-22Checking Out an Object 3-23Using Object COCI 3-24Disabling Object COCI 3-25Creating New Projects 3-26Create a New Project 3-27Locking Projects 3-28Locking Projects Locally 3-29Do Not Lock Projects on the Server 3-30Developing a Proof of Concept 3-31Lesson Highlights 3-32Practice 3-334 Editing and Compiling Object DefinitionsObjectives 4-2Editing An Object Definition 4-3Creating a New Object Definition 4-4Symbolic Strings 4-5Using Symbolic Strings 4-6Changed Flag 4-7Validation 4-8Validating an Object Definition 4-9Compiling 4-10Compiling Projects 4-11Compiling Object Definitions 4-12Rapid Unit Testing 4-13Auto-starting the Web Client 4-14Debug Settings 4-15Basic Configuration Strategy 4-16Recommendations: Object Definitions 4-17 Recommendations: Projects 4-18Lesson Highlights 4-19Practices 4-205 Managing Object DefinitionsObjectives 5-2Archiving Object Definitions 5-3Exporting Object Definitions 5-4Importing Object Definitions 5-5Conflict Resolution 5-6Resolve Import Conflicts 5-7Importing Multiple Archive Files 5-8Source Code Control Integration 5-9Backing Up 5-10Comparing Object Definitions 5-11Compare Objects 5-12Inspect Differences 5-13Compare Two Object Definitions 5-14Inspect Differences 5-15Planning 5-16Implementing 5-17Lesson Highlights 5-18Practice 5-196 Siebel Web TemplatesObjectives 6-2Siebel Web Template Files 6-3Siebel Tags 6-4Web Template Explorer 6-5Siebel Web Template Files 6-6Siebel Open UI Web Template Files 6-7Configure Siebel Tools to use Open UI Web Templates 6-8 Cascading Style Sheets (.css files) 6-9Using Web Template Files 6-10Web Template Object Definition 6-11Types of Web Templates 6-12Form Applet Web Templates 6-13List Applet Web Templates 6-14Applet Web Templates 6-15View Web Templates 6-16Web Page Web Templates 6-17Container Page 6-18Working with Web Templates 6-19Assigning a Web Template to a View 6-20Example: Assigning a Web Template to a View 6-21Assigning Components in a View or Applet 6-22Mapping Information 6-23Example: Assigning Applets in a View 6-24View Web Template Items 6-25Summary of Object Types 6-26Lesson Highlights 6-27Practice 6-287 Configuring Form AppletsObjectives 7-2Applet 7-3Common Applet Types 7-4Applet Properties 7-5Editing Properties 7-6Controls for Form Applets 7-7Expanding and Collapsing Form Applets 7-8Control Object Definitions 7-9Web Templates for Form Applets 7-10Grid Layout Editor 7-12Grid Layout Editor: Additional Operations 7-13Web Controls Palette 7-14Creating a Form Applet 7-15Form Applet Wizard Inputs 7-16Form Applet Wizard 7-17Grid Layout Editor 7-18Show More Mode 7-19Enabling Show More 7-20Summary of Object Types 7-21Lesson Highlights 7-22Practice 7-238 Configuring List AppletsObjectives 8-2List Applets 8-3List Object Definition 8-5List Column Object Definitions 8-6Control Object Definitions 8-7List Applet Web Templates 8-8List Applet Modes 8-9Base and Edit Modes 8-10Applet Web Layout Editor 8-11Show in List Property 8-12Number of Rows Displayed 8-13Show More Button 8-14Creating a List Applet 8-15List Applet Wizard Inputs 8-16List Applet Wizard 8-17Web Layout Editor 8-18Applet Web Template 8-19List Column Definitions 8-20Summary of Object Types 8-21Lesson Highlights 8-22Practice 8-239 Configuring ViewsObjectives 9-2View 9-3View Web Templates 9-4Applets in View Web Templates 9-5Identifying the View Web Template 9-6Identifying Applets Assigned to a View 9-7 Web Layout Editor 9-8Preview Mode 9-9Creating a View 9-10Inputs for the View Wizard 9-11View Wizard 9-12Web Layout Editor 9-13Adjust the Applet Mode 9-14Additional Steps After Configuring a New View 9-15 Administering a New View in the Client 9-161. Register the View 9-172. Assign the View to a Responsibility 9-18Summary of Object Types 9-19Lesson Highlights 9-20Practice 9-2110 Configuring Applications and ScreensObjectives 10-2Application 10-3The Container Page 10-4Acknowledgement Web Page/View 10-5Additional Web Pages 10-6Application-Level Menus 10-7Toolbars 10-8Toolbars for an Application 10-9Screen Tabs 10-10Site Map Links 10-11Screens and Views 10-12Views for a Screen 10-13Screen View Types and Categories 10-14Aggregate Category 10-15Aggregate View 10-16Detail Category 10-17Detail View 10-18Assigning a View to a Screen 10-19Specifying the Default View for a Screen 10-20Summary of Object Types 10-21Lesson Highlights 10-22Practices 10-2311 Business Components and JoinsObjectives 11-2Business Components 11-3Business Component (BC) 11-4Business Component Properties 11-5Base Table 11-6SVFs That Map to a Base Table 11-7Mapping a Field to a Column in a Base Table 11-8Type Property for Fields 11-9Default Single Value Fields 11-10Joined Tables 11-11Joining Data from Related Tables 11-12Explicit Join 11-13Join Definition 11-14Outer Join Flag 11-15Outer Join Example 11-16Join Specification 11-17Fields That Map to a Joined Table 11-18Mapping a Field to a Column in a Joined Table 11-191. Determine if a Join Definition Already Exists 11-202. Create a Join 11-213. Create the Single Value Field 11-221:1 Extension Table 11-23Implicit Joins 11-25SVFs That Map to an Extension Table 11-26Creating a New Business Component 11-27Business Component Wizard Inputs 11-28Business Component Wizard 11-29Configuring a New Business Component 11-30Summary of Object Types 11-31Lesson Highlights 11-32Practice 11-3312 Party Business ComponentsObjectives 12-2Party Data 12-3Party Business Components 12-4S_PARTY 12-5Benefits of the Party Data Model 12-6Commonly Used Party Business Components 12-7S_PARTY and Its Extension Tables 12-8Person-Related Party Business Components 12-9Organization-Related Party Business Components 12-11 Party Business Components for Access Control 12-13Groupings for Access Control 12-14S_PARTY_PER 12-15Role of Joins in Party Data 12-16Mapping Fields in Party Business Components 12-17Joining Party Data Into a Business Component 12-18Explicit Join Definition 12-19Joining Party Data into a Party Business Component 12-20 Explicit Join Definition 12-21Mapping a Field to a Column in a Party Table 12-22Creating a Join to a Party Table 12-23Create the Single-Value Field 12-24Key Considerations for Party Joins 12-25Lesson Highlights 12-26Practice 12-2713 Business Components and FieldsObjectives 13-2Business Component Properties 13-3Business Component Editing Properties 13-4Applet Editing Properties 13-5Owner Delete Property 13-6Search Specification Property 13-7Search Specification Considerations 13-8Sort Specification Property 13-9Expression Builder 13-10Business Component Field Properties 13-11Required and Read Only Properties 13-12Force Case Property 13-13Validation Property 13-14Validation Message 13-15Displaying A Validation Message 13-16Predefault Value Property 13-17Post Default Value Property 13-18Calculated Field 13-19Calculated Value Property 13-20Restrictions on Calculated Fields 13-21Lesson Highlights 13-22Practice 13-2314 Business Objects and LinksObjectives 14-2Business Objects (BOs) 14-3Business Object Definition 14-5Business Object Component 14-6Link Definition 14-71:M Link Definition 14-8Cascade Delete Property 14-9M:M Link Definition 14-11Child Deletion for M:M Links 14-12Grandchild Business Components 14-13Links for Grandchild Data 14-14Summary of Object Types 14-15Lesson Highlights 14-16Practice 14-1715 Creating a New Business Component Using a Standard 1:M Extension TableObjectives 15-2Business Challenge 15-3Solution: Create New Business Components 15-4Review: 1:M Extension Table 15-5Create a New Business Component 15-7New 1:M Business Component 15-8Multiple Business Components 15-9Set Values for Type 15-10Steps to Use the New BC 15-111. Create a Link 15-122. Add BC to a Business Object 15-133. Create a List Applet 15-144. Assign the Applet to a View 15-15Lesson Highlights 15-16Practices 15-1716 Extending the Siebel DatabaseObjectives 16-2Incorporating Additional Data 16-3Adding New Fields 16-4Extending the Siebel Database 16-5Creating a Custom Extension Column 16-6Creating a Stand-Alone Table 16-7Table Wizard 16-8Creating a 1:1 Extension Table 16-9Creating a 1:M Extension Table 16-11Creating an Intersection Table 16-13Creating Foreign Keys 16-15Propagating Database Changes to Other Developers 16-161. Apply Changes to the Local Database 16-172. Propagate Changes to Server Database 16-183. Propagate Changes to Other Developers 16-19Lesson Highlights 16-20Practices 16-2117 Additional Data Layer ConfigurationObjectives 17-2Additional Considerations 17-3Custom Indexes 17-4Creating a Custom Index 17-5Enterprise Integration Manager (EIM) 17-6EIM Mappings 17-7Dock Objects 17-8Types of Dock Objects 17-9Dock Object Visibility Rules 17-10Modifying Dock Objects 17-11Extending a Table to Support Case Insensitive Queries 17-12Creating CIAI 17-13CIAI Wizard 17-14Lesson Highlights 17-15Practices 17-1618 Configuring Drilldowns and Applet TogglesObjectives 18-2Navigation Using Drilldown 18-3Static Drilldown: Same Business Component 18-4Configuring Drilldown Within the Same Business Component 18-5 Static Drilldown: Different Business Component 18-6Configuring Drilldown to a Different Business Component 18-7Dynamic Drilldown 18-8Determining the Target View 18-9Configuring Dynamic Drilldown 18-10Specifying the Conditions 18-11Thread Bar 18-12Configuring the Thread Bar 18-13Applet Toggles 18-14Configuring Applet Toggles 18-15Togglebar Tag 18-16Dynamic Applet Toggling 18-17Configuring Dynamic Applet Toggling 18-19Lesson Highlights 18-20Practice 18-2119 Configuring PicklistsObjectives 19-2Picklists 19-3Static Picklist 19-4Static PickList Values 19-5Administering Static Picklists 19-6Administering Static Picklists Using Siebel Tools 19-7 Dynamic Picklist 19-8Picklist Terms 19-9PickList Generic Business Component 19-10Object Definitions for PickLists 19-11PickList Object Definition 19-12Single Value Field and SVF Pick Map 19-13SVF Pick Maps 19-14Pick Applet 19-15Control and List Column 19-16Creating a Picklist 19-17Pick List Wizard Inputs for Static Picklists 19-18Defining the Static Picklist 19-19Pick List Wizard 19-20Pick List Wizard Inputs for Dynamic Picklists 19-21Defining the Dynamic Picklist 19-22Defining the Pick Maps 19-23Pick List Wizard 19-24Constrained Picklist 19-25Constraining a Picklist 19-26Hierarchical Picklists 19-27LOVs for Hierarchical Picklists 19-28Configuring a Hierarchical Picklist 19-29Configuring the SVF Pick Maps 19-30Summary of Object Types 19-31Lesson Highlights 19-32Practice 19-3320 Configuring Multi-Value GroupsObjectives 20-2Multi-Value Group (MVG) 20-3Shuttle Applet 20-4Multi-Value Group Display 20-5MVG Advantages 20-6MVG Concepts 20-7Multi Value Field (MVF) 20-8Multi Value Link 20-9Multi Value Fields and Multi Value Links 20-10Multi-Value Group Applet 20-11Association Applet 20-12Invoking the MVG Applet 20-13Primaries 20-14Primaries and Performance 20-15Primary Foreign Key 20-17Finding the Primary Foreign Key 20-18Enabling a Primary for a MVG 20-19The Auto Primary Property 20-20Setting the Primary Record 20-21Creating a Multi-Value Group 20-22MVG Wizard Inputs 20-23MVG Wizard 20-24Summary of Object Types 20-25Lesson Highlights 20-26Practice 20-2721 Configuring Access ControlObjectives 21-2Access Control: Review 21-3Business Components and Record-Level Access Control 21-4 Visibility Views 21-5View Modes 21-6Configuring Visibility Views 21-7BusComp View Mode Definition 21-8Personal View 21-9My View 21-10Retrieving My View Records 21-11My Team’s (Manager) View 21-12Retrieving My Team's Records 21-13All View 21-14Retrieving Records for an All View 21-15Across All Organizations View 21-16Administration View 21-17Group View 21-18Private Flag 21-19View Web Template Item Applet Visibility 21-20Visibility For Picklists 21-21Picklist Visibility 21-22Visibility for an Individual Picklist 21-23Lesson Highlights 21-24Practice 21-2522 Configuring User PropertiesObjectives 22-2User Properties 22-3Object Definitions with User Properties 22-4User Properties 22-5Editing User Properties 22-6Expression Editor 22-7Multiple Instances of a User Property 22-8Examples of Applet User Properties 22-9DefaultFocus_New 22-10NoDataHide 22-11EnableDragAndDropInList 22-12Examples of Business Component User Properties 22-14 All Mode Sort 22-15BC Read Only Field 22-16On Field Update Set 22-17Parent Read Only Field 22-18Field Read Only Field 22-19Disable Automatic Trailing Wildcard Field List 22-20Required (Field User Property) 22-21Lesson Highlights 22-22Practice 22-2323 Migrating Repository ChangesObjectives 23-2Multiple Enterprises 23-3Migrating Between Enterprises 23-4Items to Be Migrated 23-5Repository Object Definitions 23-6Name of the Repository 23-7References to the Name of the Repository 23-8Files 23-9Customized Data 23-10Overview of the Migration Process 23-11Benefits of the Process 23-12Prepare the Development Enterprise 23-13Prepare the Target Enterprise 23-14Migrate the Repository to the Target Enterprise 23-15 If Necessary, Rename the Repositories 23-16Migrate Files and Customized User Data 23-17Repository Customizations 23-18Siebel Enterprise Parameters 23-19Lesson Highlights 23-20Practice: 23-2124 TroubleshootingObjectives 24-2Common Mistakes 24-3Tools Mistakes 24-4Compilation Mistakes 24-5Administration Mistakes 24-6Testing Mistakes 24-7Common Configuration Problems 24-8User Interface Layer 24-9Business Layer 24-11Data Layer 24-13Diagnosing Problems 24-14Create a File to Capture SQL 24-15Turn on SQL Spooling 24-16Have a Fallback 24-18Do Not Configure on the Server 24-19Lesson Highlights 24-20Practice 24-21。
siebel基础开发介绍---XXX
基础开发
页面开发
界面结构
页面搭建——创建Table
表名称 Project名称 表的类型
页面搭建——创建Table
系统默认Columns，主键ROW_ID：其他字段可自行新建。(注意：新建或者扩展字段的表需要在 服务器端Tools 进行Apply)
页面搭建——创建View
推荐复制一个现有的View，修改对应的Acreen
配置页面显示属性；
权限配置
权限配置——职责(角色)
职责1
职责2
人员
职责3 职责…….
权限配置——View部署
管理-应用程序-视图；
权限配置——职责添加
管理-应用程序-职责（将View添加到对应的职责下），清除缓存；
谢谢聆听
202 0
Siebel基础开发
编写人：XXX
目 录页
01.产品介绍 02.基础开发 03.权限配置
Siebel产品介绍
Siebel产品介绍
Oracle CRM产品
eSales、eMarketing、eService、Loyalty等 开发工具
Siebel Tools\Siebel Client
页面搭建——创建BC
Project名称 BC名称 表名称
页面搭建——创建BC Field
每一个Table Column都需要有对应的 BC Field字段去定义（计算字段、UP、JOIN、MVF/MV Link）；
页面搭建——创建Applet
Applet分为List、Form类型；
页面搭建——创建Applet WebLayOut
ORACLE数据库部署手册范本
ORACLE数据库部署手册1.Oracle简介Oracle Database，又名Oracle RDBMS，或简称Oracle。
是甲骨文公司的一款关系数据库管理系统。
它是在数据库领域一直处于领先地位的产品。
可以说Oracle数据库系统是目前世界上流行的关系数据库管理系统，系统可移植性好、使用方便、功能强，适用于各类大、中、小、微机环境。
它是一种高效率、可靠性好的适应高吞吐量的数据库解决方案。
2.Oracle安装医院部署数据库要求使用Oracle 11G R2（64Bit）正版数据库，建议使用医院采购的正版oracle11g数据库软件。
本文档详细介绍Oracle11gR2的安装步骤、常用服务、日常使用等。
本文档主要介绍Oracle11gR2数据库的安装步骤，关于不同应用程序的具体数据库配置，则在对应的应用程序的产品手册中详细描述。
2.1.安装环境的要求2.2.安装步骤1)运行安装文件打开安装包后，双击setup.exe文件;稍等片刻后，出现如下所示的安装界面；如下图1所示：图 12)配置安全更新等oracle安装程序启动以后，第二步就进入了【配置安全更新】环节，这一步可将自己的电子信息填写进去点击“下一步”；如下图2所示：图 23)选择安装选项安装选项有三种选择：新部署数据库时选择“创建和配置数据库”，点击下一步；当安装完毕数据库管理软件后，系统会自动创建一个数据库实例，点击“下一步”；如下图3所示：图 34)系统类选项设置进入“系统类选项设置”，系统类选项设置分为桌面类和服务器类两种；如下图4所示：桌面类：使用桌面类系统安装。
使用WINDOWS系统则使用此类典型安装。
服务器类：适合linux服务器环境下的高级安装。
图 45)典型安装配置选择桌面类之后，默认为典型安装，填写完成后，点击“下一步”继续；如下图5所示：Oracle基目录：目录路径不要含有中文或其它的特殊字符软件位置：也即是实例存储的目录数据库文件位置：放置数据库文件的位置数据库版本：这里选择使用企业版字符集：选择默认值ZHS16GBK字符集（此处字符集一定要选择这个）全局数据库名称（即实例名称）和口令：全局数据库名（数据库名称）：orcl，管理口令（密码）：根据需要设置注：此处实例名称和口令十分重要（相当于SQL数据库的登录名和密码），请单独记录保存。
Siebel实用小工具--V1.0 Beta版--用户手册
Siebel实用工具软件用户手册汉得信息技术股份有限公司版本号：V1.0 Beta版序言Siebel实用小工具是基于基于Microsoft .NET Framework开发的一个小软件,目的在于提高日常项目实施中的工作效率,避免一些重复性的劳动.其主要功能有：对文本的各种简单处理，最常用的有，对数据进行OR连接，可以方便的实现在siebel应用的查询，对数据进行sql中in字句的连接，可以方便的将数据插入到sql的语句中。
对文本进行按照给定数据的拆分，以及替换，使用非常方便快捷。
对文本进行查重、去重、对比等各种功能。
对剪贴板进行监控，可以方便的获取数据，方便的生成ldap的ldif文件、db的sql脚本等可以按照模板发送邮件等，可以用在期初上线发送用户名以及密码给客户。
可以获取数据库中的eScript脚本第一章软件安装与初始化Siebel实用小工具是一个免安装工具，双击运行目录下的Siebel实用工具.exe即可运行。
但是前提是您的电脑中安装有Microsoft .NET Framework，否则程序无法打开启动页面，可能会报如下错误：/downloads/zh-cn/details.aspx?FamilyID=39C8B6 3B-F64B-4B68-A774-B64ED0C32AE7可通过以上地址下载安装Microsoft .NET Framework。
若可以成功打开，则能看到如下界面：第二章操作说明2.1 期初配置2.2 功能说明2.2.1 文本操作2.2.2 其它操作2.1 参数配置文件在软件的目录下面有文件夹config下面对每个参数做一个简单的讲解：●emailLAddressform：用与发送邮件的时候使用，可不填写！●emailLAddressto：用与发送邮件的时候使用，可不填写！●emailLAddresspassword：用与发送邮件的时候使用，可不填写！●emailLAddresssmtp：用与发送邮件的时候使用，可不填写！●REG_HOT_KEY：用户判断是否开启注册SHIFT+X按键的热键●DEVPODBCDCN：配置一个开发环境的odbc信息，用户获取脚本时使用，可不填写●DEVPODBCDataBase配置一个开发环境的odbc信息，用户获取脚本时使用，可不填写●DEVPODBCUID配置一个开发环境的odbc信息，用户获取脚本时使用，可不填写●DEVPODBCPWD配置一个开发环境的odbc信息，用户获取脚本时使用，可不填写2.2.1 文本功能操作如图所示，在图中上方的框中随便输入一段信息，点击【使用OR连接】,可以得到以OR连接的方便siebel查询的字符串。
Oracle的SiebelCRM解决方案
Oracle CRM：全球最好的客户关系管理系统
跨行业解决方案
商业智能
客户数据整合
商业流程整合
套装
行业解决方案
托管式
定制
交付选择
最多的成功案例 最佳的销售和最多的实施最佳的客户结果跨行业最多的客户成功
为什么 Oracle 是最佳的合作伙伴
最强功能的软件
最有力的专家意见
洞察力驱动升等销售和交叉销售
洞察力驱动的销售绩效
行业特定的线索到签单流程
GARTNER 2004 CRM
评估象限 地位
2004 IDC 营销和销售联合CMO奖
2004 Gartner 评估象限和地位
METASpectrum 2004 CRM 应用套件评估
行业荣誉
“The real battle is for the number two spot.”—Liz Roche, META
现场服务
B2B CRM
客户服务 & 支持
B2C CRM
销售
Oracle/Siebel
Oracle/Siebel
Oracle/Siebel
Oracle/Siebel
Oracle/Siebel
Oracle/Siebel
CDI
最全面的应用功能
公认产品-分析师
划算的全面CRM，可被业务用户配置
Shared service offering共享服务部署迅速内置分析和CRM最佳实践
On Premise
Private Hosted
On Premise & Hosted Combined
Shared Hosting
Oracle R Enterprise 1.4 教程说明书
Hello, and welcome to this online, self-paced lesson entitled “Introducing Oracle R Enterprise.” This session is part of an eight-lesson tutorial series on Oracle R Enterprise.My name is Brian Pottle. I will be your guide for the next 45 minutes of interactive lectures and review sessions on this lesson.“Introducing Oracle R Enterprise” is the first lesson of eight self-study sessions on Oracle R Enterprise.In this lesson, you’ll learn:•What R is, who uses it, and why they use it.•Next, we’ll examine several common user interfaces for R.•Finally, you’ll learn about Oracle’s strategy for supporting the R community. So, let’s start with the first topic: Using R: What, Who, and Why?R is a language and environment for statistical computing and graphics. This GNU Project is similar to the S language and environment, which was developed at Bell Laboratories (formerly AT&T, now Lucent Technologies) by John Chambers and colleagues. R can be considered a different implementation of S. There are some important differences, but much code written for S runs unaltered under R.R is an open-source language and environment that supports:•Statistical computing and data visualization•Data manipulations and transformations•And sophisticated graphical displaysWith over 2 million R users worldwide, R is increasingly being used as the statistical tool in the academic world. Many colleges and universities worldwide are using R today in their statistics classes. In addition, more and more corporate analysts are using R.R benefits from around 5000open-source packages, which can be thought of as a collection of related functions. This number grows continuously with new packages submissions from the R user community.Each package provides specialized functionality in such areas as bioinformatics and financial market analysis.In the slide, the list on the right shows “CRAN Task Views.” CRAN stands for the Comprehensive R Archive Network, which is a network of FTP and web servers that store identical, up-to-date versions of R code and documentation.The CRAN Task Views list areas of concentration for a set of packages. Each link contains information that is available on a wide range of topics.So, why do statisticians and data analysts use R?•As mentioned previously, R is a statistics language that is similar to SAS or SPSS.•R is a powerful and extensible environment, with a wide range of statistics and data visualization capabilities.-Powerful: Users can perform data analysis and visualization with a minimal amount of R code.-Extensible: Users can write their own R functions and packages that can be used locally, shared within their organizations, or shared with the broader R communitythrough CRAN.•It’s easy to install and use.•And it’s free and downloadable from the R Project website.Although it’s a powerful and effective statistical environment, R has limitations.First, R was conceived as a single-user tool that was not multithreaded. The client and server components are bundled together as a single executable, much like Excel.•R is limited by the memory and processing power of the machine on which it runs. •Also, R can’t automatically leverage the CPU capacity on a user’s multiprocessor laptop without special packages and programming.Second, R suffers from another scalability limitation that is associated with RAM.•R requires data that it operates on to be first loaded into memory.•In addition, R’s approach to passing data between function invocations results in data duplication. This “call by value” approach to parameter passing can use up memoryquickly.So inherently, R is really not designed for use with big data.Some users have provided packages to overcome some of the memory limitations, but the users must explicitly program with these packages.R provides a wealth of resources to help users, including:•Many R-related books that are available on the R project website•Many user groups and user conferences that are available to the R community •Online libraries of reusable code from the CRAN website•Documented R packages with sample data and codeNext, let’s examine several common user interfaces for R.First, let’s take a quick look at the interface that comes with open-source R by default, called the R Console.•This default open-source R graphical user interface (GUI) includes a command-line interface for running scripts or individual functions, as shown in the slide.•In addition, open-source R supports many third-party graphics packages.-In this example, we load a popular third-party graphics package named “ggplot2.”-Then, the graphics package is called from the R Console command line. The second qplot function call displays the graphic on the right.-Here, the qplot function is invoked on the mtchars data set, which comes with R. In the graph, we plot miles per gallon against weight, with the size of each dotindicating the number of cylinders.In addition to the default open-source R GUI, you can use a third-party integrated development environment (IDE), such as RStudio, which is shown in the slide.With RStudio:•You can use the upper-left pane to view R scripts and select portions of an R script for execution.•In the Console pane, you can execute R scripts or functions at the command line, in a similar fashion as the default R GUI.•You can execute selected portions of R scripts in the top window by clicking the Run button. With this method, selected lines are pasted into the Console pane and executed.•You can view graph results in the right pane. In this case, the Plots tab is selected.In this next view, the R script that we saw previously is displayed in the viewer window.•Here, the first portion of the script is selected. This code requests help on the gplot() function.•When the Run button is clicked, the selected code is pasted into the Console pane and then executed.•In the display pane, you can select (and switch between) different tabbed output views on the Files, Plots, Packages, and Help tabs. In this case, the Help tab is selected to display results from the R help command. In this final view, the last function in the R script is selected.•This same gplot() function was shown previously in the default R GUI.•The Run button is clicked and the code is executed. The Plots tab shows the current output. In fact, RStudio also lets you view previously generated plots.RStudio is only one of many third-party R IDEs.As shown in the table of this 2011 poll, RStudio is the second most commonly used interface, behind the built-in R console we looked at earlier. However, it’s often user preference that decides which IDE will be used.Data visualization helps convey information faster than most other means. The link shown in the slide is for the R Graph Gallery, where you can find a variety of graphic types for R.Here are a few examples of graphs in R. Of course, there are many others. Moving from left to right, and top to bottom, we show:• A box plot•Perspective graphs of mathematical surfaces•3-D scatter plots with points• A regression plane•Multivariate facet crafts•Smooth scatter plots•Venn diagrams•And even chromosome mappings from the bioconductor packageIn this final section of the lesson, you’ll learn about Oracle’s strategy for supporting the R community. This section includes the following topics:•Goals•Software term definitions•High- and mid-level architectural overviews•Software component features•R user-community definitionsScalability, performance, and production deployment are key requirements for the enterprise data analytics arena.•What may work fine on your laptop for thousands or even millions of rows, won’t scale to 100s of millions and billions of rows.•Similarly, performance may be adequate on smaller scale data, but will moving to “big data” allow you to keep up? The cost of moving data to a separate server can render an application unusable.•Finally, when you’ve finished your project in a lab environment, how easy is it to deploy that result into production?Each of these requirements are met by Oracle’s strategy for supporting the R community.Oracle’s goal for supporting open-source R is to deliver enterprise-level advanced analytics based on the R environment. The strategy is implemented through the release of the following Oracle technologies:•Oracle R Enterprise (ORE), which is part of the Oracle Advanced Analytics option for Oracle Database 12c and 11g, release 2. ORE contains a statistics engine, andprovides transparent access to database-resident data from R, as you will learn in this tutorial series.•Oracle R distribution, which supports configurations of open-source R on various platforms. In addition, Oracle contributes bug fixes and enhancements to open-source R.•ROracle, the open-source Oracle database interface for R.•Oracle R Advanced Analytics for Hadoop, or ORAAH, provides an R interface to an Oracle Hadoop cluster on the BDA ,and also to non-Oracle Hadoop clusters. It enables you to access and manipulate data in the Hadoop Distributed File System, in the Oracle Database, and on the file system.Now, let’s examine an architectural view of ORE.•The R workspace console may be the default R GUI or any of the third-party R GUIs.Users execute R scripts here.•Then, the ORE transparency layer intercepts functions that operate on database tables or views. It translates the request into SQL for execution in Oracle Database fortransformations and statistical computations. In Oracle Database, the statistics engine consists of native database functionality that leverages SQL and the various database management system (DBMS) packages, as well as enhancements that are specific to ORE.•Finally, the results can be leveraged by enterprise systems, such as Oracle Business Intelligence Enterprise Edition (OBIEE), or web services-based applications.This design results in:•No changes to the R user experience in the development environment•The ability to scale to large data sets in the production environment•And, the ability to embed results in operational systems, such as Oracle OBIEE DashboardsThis architectural view illustrates how ORE can work with Oracle R Advanced Analytics for Hadoop. ORAAH enables native R access to the Hadoop cluster for both: •MapReduce programming in R, and•Access to Hadoop Distributed File System (HDFS) data, in either the Big Data Appliance (as shown in the slide), or non-Oracle Hadoop clustersOracle Big Data Appliance has been mentioned a couple of time so far in this lesson. So, what is it? Oracle BDA:•Is an optimized solution for storing and integrating low-density data into Exadata.•Is a preintegrated configuration with 18 of Oracle's Sun servers that include InfiniBand and Ethernet connectivity to simplify implementation and management.•Has the Cloudera distribution, including Apache Hadoop to acquire and organize data, along with Oracle NoSQL Database Community Edition to acquire data.•Includes additional system software: Oracle Linux, Oracle Java Hotspot Virtual Machine, and an open-source distribution of R.Oracle Big Data Connectors is an option for BDA. It consists of:•Oracle Loader for Hadoop•Oracle Data Integrator Application Adapter for Hadoop•Oracle Direct Connector for HDFS•Oracle R Advanced Analytics for HadoopYou can use ORAAH to access data in Exadata, and perform R calculations on HDFS data by using scalable map-reduce methods.Now, let’s take a brief look at the components of Oracle R Enterprise. From a software perspective, ORE consists of R packages, database libraries, and SQL extensions.We’ll divide the features into three main groups: the Transparency Layer, the Statistics Engine, and SQL extensions.The Transparency Layer is a set of packages that map R data types to Oracle Database objects.•This feature automatically generates SQL for R expressions on mapped data types, enabling direct interaction with data in Oracle Database while using R languageconstructs.•Functionally, this mapping provides access to database tables from R as a type of data.frame: a base R data representation with rows and columns. ORE calls this an“ore.frame.”•Therefore, when you invoke an R function on an ore.frame, the R operation is sent to the database for execution as SQL.The Statistics Engine is a database library that supports a variety of statistical computations. This engine includes existing in-database advanced analytics and new features added specifically in ORE.SQL extensions enable in-database embedded R execution, which is particularly valuable for third-party R packages, or custom functions, that do not have equivalent in-databaseIf we look at ORE from the perspective of a collaborative execution model, it leverages three layers of computational engines.The first one is the client (or user) R engine, which resides on the desktop.•This R engine consists of the base R packages, the ORE packages, and any other R packages that the user may have installed.•At this level, the Transparency Layer intercepts R functions for in-database execution.•It also enables interactive display of graphical results, while flow control remains with the R environment.•From the client, users can submit entire R scripts for execution by Oracle Database, using embedded R execution.•And, although not explicitly depicted here, users can connect to a Hadoop Cluster by using Oracle R Connector for Hadoop.The second compute engine is Oracle Database.•This database allows scaling to large data sets.•R users are able to access tables, views, and external tables, as well as data that is accessible through database links.•The SQL generator through the Transparency Layer can automatically leverage database parallelism.•It can also leverage both new and existing in-database statistical and data mining capabilities.The third compute engine (or engines) are those spawned and managed by Oracle Database, and they execute on the database server machine.•These embedded R engines enable more efficient data transfer between the database and R.•Because these engines run on the database server, rather than on the client, they are likely to have greater memory capacity and compute power. Exadata is an example.•The embedded R execution enables parallel data transfer, returning rich XML or PNG image output, SQL access to R, and the ability to run parallel simulations.•The embedded R engines also enable use of 3rd party packages or custom functions that do not have in-database SQL equivalent functionality.•The engines also enable R users to write and test map-reduce scripts before rolling them out to a Hadoop cluster.•Finally, these engines enable “lights-out” execution of R scripts; that is, scheduling or triggering R script packages inside a SQL or PL/SQL query.The ORE target environment design provides a comprehensive, database-centric environment for end-to-end analytic processes in R, with immediate deployment to production environments. It provides many benefits, including:•Elimination of R client engine memory constraint•Execution of R scripts through the Oracle Database server machine for scalability and performance•Seamless integration of Oracle Database as the HPC environment for R scripts, providing data parallelism and resource management•The ability to operationalize entire R scripts in production applications•Scoring of R models in Oracle DatabaseR and ORE can receive data from many sources. In this figure, we depict the R engine running on the user’s laptop, as shown in the previous slide.Through a series of R packages, R itself is able to access data stored in both files, and in databases.In addition, ORE provides transparent access to data stored in the local Oracle Database, as we previously discussed.In addition, ORE has access to:•Data in other databases, which are accessible through database links•Data in external tables•And, of course, data in HDFS. In addition to bulk import, ORE makes it possible to access Hadoop directly, in a similar fashion to external tables, by using HDFS connect.This means that you can join Hadoop data with database data.Here are a few resources on Oracle R related technology.So, in this lesson, we covered three primary topics.•First, you learned what R is, who uses it, and why they use it.•Then, we looked at some common user interfaces for R.•Finally, we discussed Oracle’s strategy for supporting the R community, including an overview of goals, definitions of software terms, high- and mid-level architecture,software component features, and R user-community definitions.You’ve just completed “Introducing Oracle R Enterprise”. Please move on to the next lesson in the series: “Getting Started with ORE”.。
SiebelWSD配置
SiebelWSD配置⼀、功能介绍Siebel Web Survey Deamon 在线问卷调查，是Marketing 的⼀个⼦功能，主要实现在Siebel中定义问题和⽹页样式，然后通过WebService传输到Web Survey服务器,然⽤户进⾏调查问卷，WebSurvey服务器会⾃动将调查结果通过EAI XML传回Siebel服务器，其中Siebel会针对调查问题中的个别信息进⾏Map处理（如根据调查者姓名，与Contact⾃动匹配）⼆、安装WSD服务器1. eDelivery下载Marketing Integrated Server套件这边测试平台是Redhat5，Siebel是8114，因为找不到Linux下的这个安装包，所以就只好下了Windows下的。
2. 运⾏wsd.exe，安装后发现WSD安装好后其实是个tomcat 的siebel Web survey加强版，⽽这⾥⾯包含了tomcat 的linux shell程序，所以直接打包拷到服务器上，配下tomcat端⼝8080，⾄少tomcat可以跑了。
如果有Tomcat管理需要的话，在/wsd/conf/tomcat-users.xml⾥⾯添加Roles和User。
三、配置WSD 服务器1. 修改/wsd/bin/setenv.sh ⽂件，确保websurvey/config的路径正确JAVA_OPTS="-Dwebsurvey.configDir=/siebel/app/siebel/wsd/webapps/websurveys/config"2. 确保安装JDK 1.5以上，修改/wsd/tomcat-ctl.sh⽂件，添加JAVA_HOME环境变量3. 给wsd⽬录及其⼦⽂件赋权限，chmod –R 777 *4. 在Siebel数据库中创建⽤户，例：WSDUSER，分配创建对象权限5. 切换wsd/sql⽬录下，使⽤SQLPLUS执⾏对应数据库的SQL脚本，创建对象和元数据6. 修改wsd/webapps/websurveys/config/websurvey.properties⽂件db.driver = com.siebel.sem.jdbc.oracle.OracleDriver 注册驱动db.WEBSURVEY.url = jdbc:sebl:oracle://[Domain]:1521;ServiceName=siebeltest 配置TNSer = WSDUSER 数据库⽤户名db.WEBSURVEY.password = y0b/EV/J/kKCzTiMD9yeKlHEiglBD1Xq8BO5---------------------------------------------------------------------------------------------------------------这⾥的密码必须为加密密⽂，加密⽅法如下：加密程序LIB环境变量导⼊export CLASSPATH=/siebel/app/siebel/wsd/webapps/websurveys/WEB-INF/lib/occam-crypto.jar转码命令: java com.siebel.occam.security.OccamCrypto encrypt [password]输出密⽂写到db.WEBSURVEY.password----------------------------------------------------------------------------------------------------------------report.enable = trueWebSurveyQueueDirectory = /siebel/app/siebel/wsd/webapps/websurveys/QueueingSIEBEL_USERNAME=SADMINSIEBEL_PASSWORD=SADMINSIEBEL_LOCALE=chsRESPONSE_TYPE=\u5b8c\u6210\u7684\u7f51\u7edc\u8c03\u67e5---------------------------------------------------------------------------------------------------------------如果SIEBEL 中SEED LOV为中⽂，这⾥的类型必须为也写为中⽂：但是配置⽂件本⾝是ASCII编码，⽽⽣成的XML回传Siebel是UTF-8编码，所以直接写中⽂会乱码，因此这⾥需要⽤转码⼯具将中⽂“完成的⽹络调查”转换为UTF-8编码的ascii字串，这⾥直接⽤python的字符串解码命令:----------------------------------------------------------------------------------------------------------------最后修改wsd/webapps/websurveys/config/loging.properties，将⾥⾯的Log⽂件路径写对7. 修改 wsd/webapps/websurveys/WEB-INF/conf/axis2.xml ⽂件注释掉下⾯这句 <parameter name="Transfer-Encoding" locked="false">chunked</parameter>原因为：在Siebel WebServer 为 Oracle Application Server 的情况下，使⽤chunked编码进⾏SOAP数据传输，Siebel会报⼀个WS错误Error Code: 10944629 Error Message: Error: Missing body length in response to SWE request!8. 启动WSD，在wsd⽬录下执⾏tomcat-ctl.sh startWSD服务器配置基本完毕。
安装SIEBEL的TOOLS和WEBCLIENTS(完整资料).doc
此文档下载后即可编辑1. 客户机上的安装 (1)1.1. Siebel web client (1)1.2. Siebel tools (12)1.客户机上的安装1.1. Siebel web client在安装前先把IE浏览器设置的高级里的禁用脚本调试取消勾选，如下图取消勾选此目录下运行oui.exe进行安装点击下一步名称和路径用默认这里可能会出现一个警告，是正常的，手动勾选通过验证语言英文和中文都勾选上点击下一步选择安装Developerweb client选择Oracle数据库数据库别名orcl表所有者SIEBEL在这一步，我们需要指定file system的路径，依然需要手动新建一个文件夹fs目录位置新建一个文件夹fs指定fs文件夹的位置填入服务器的ip地址网关IP地址服务器名称，我们依然用SBA_81服务器ip地址这里的两项用默认值点击安装正在安装安装的过程中会弹出IE窗口，会下载一个ActiveX控件，如果IE 安全提示，要允许，要把IE的安全级别设置为中低，并且允许所有的ActionX选项，直到出现the download is complete，you may close the window这句话，表示成功，关闭IE。
安装结束后，点击退出。
弹出确定提示，点击是。
1.2. Siebel tools简单方法：按系统默认的安装到C盘根目录。
将原来的C盘目录复制到新的Siebel tools对应目录即可。
安装步骤如下：在此相对路径下运行oui.exe点击下一步选择Siebelbusinessapplication tools8.1.1.0.0开发版名称用默认，指定安装路径。
点击下一步中文和英文都勾选我们用的是Oracle数据库数据库别名orcl表所有者SIEBEL这里需要指定fs所在位置，点击浏览。
在tools目录下新建一个文件夹fs在此处指定fs路径服务器的ip地址服务器的ip地址服务器名称填写SBA_81点击安装开始安装了安装结束了，点击退出。
OracleCRM(Siebel)
Siebel 数据同步原理图
• 双向同步 • 用户可自定义同步对象和同步规则
更快的事故解决
包含在Oracle CRM Siebel 中
更快的事故解决
包含在Oracle CRM Siebel 中
审计追踪
• 保留所有信息的改变踪迹 • 方便的管理和操作
挑战/机会
• 满足不同服务渠道获取一致的客户信息，为客户提供一致的服务。 • 通过了解客户与不同渠道的交互历史，提升客户价值分析能力，从而保持
强大的客户服务能力。
PICC Health案例分享
解决方案
• 部署Siebel Health Care 7.8 / Siebel Call Center
• 实现“以客户为中心”的健康保障和健康管理服务，深度挖掘客户价值，提升服务水平， 打造统一的营销管理、销售管理、客户服务平台
eMail Integration
Siebel 公共业务逻辑与数据
Siebel使用界面简便– 基于任务的用户界面
提高流程质量
• 通过关键任务引导用户
– 提高产品易用性 – 降低培训成本 – 标准化流程
• 高效的数据管理 • 可用于移动用户或其他方式连接的用户 • 缩短学习周期，高效使用应用程序
– 每个用户都是专家 – 当出现流程的频繁更改，将影响降至最低
在一个浏览器内体验一种 Windows 应用习惯
为每个用户/渠道的优化的应用程序
防火墙内部
防火墙外部
HI Web Client
Siebel Wireless
SI Web Client
Mobile Client
Siebel Handheld
银河麒麟服务器操作系统Oracle+数据库安装与配置指南
目录第1章 配置内核参数 (1)第2章建立ORACLE用户 (3)1.1.在超级用户下创建新的组和用户 (3)1.2.建立O RACLE软件的安装目录 (3)第3章 安装ORACLE补丁与JAVA开发包 (4)3.1安装P3006854_9204_LINUX补丁 (4)3.2安装J A V A开发包 (4)3.3软件介质 (4)第4章 安装ORACLE DATABASE (5)4.1编辑 (5)4.2启动O RACLE U NIVERSAL I NSTALLER (OUI) (5)第5章 创建数据库 (11)5.1编辑 (11)5.2切换到ROOT的终端，安装 OPATCH。
(11)5.3最后切换到ORACLE终端 (11)第6章 参数配置建议 (17)第1章 配置内核参数Oracle数据库对系统的硬件配置有基本的要求，包括机器主频、磁盘空间和内存大小，但作为服务器的机器一般是满足的，这里就不赘述了。
下面的一些参数需要根据机器系统的实际情况，特别是内存的大小来进行设置，这里假定内存为2G，页面大小为4K。
为使Oracle 数据库管理系统在运行时有更好的性能，应尽量给数据库留出较多的内存。
在以下的内核生成过程中，假设内核源码位于/root/kylin2.0，并定义为环境变量KSROOT。
# cd $KSROOT/arch/i386/conf# cp GENERIC ORACLE# cat >> ORACLEoptions SEMMAP=128options SEMMNI=128options SEMMNS=32000options SEMOPM=250options SEMMSL=250options SHMMAXPGS=65536options SHMMAX=2147479552options SHMALL=524287options SHMMNI=4096options SHMSEG=4096options MAXDSIZ="(1024*1024*1024)"options MAXSSIZ="(1024*1024*1024)"options DFLDSIZ="(1024*1024*1024)"注：根据上面的假定，Kylin页大小为4k ，这样2G的内存，其SHMALL可以为524288，这里设定524287，也是考虑到实际情况，用dmesg工具就可以看到，可用的内存实际上并没有2G，比2G稍少。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
安装完成后在您的盘符下新建一个文件夹（例如 d:\f5config ） Copy lbconfig.txt 到文件夹下。 解压siebel8-bigipv9.zip文件， 把siebel-bigipv9.pl copy到文件夹 下 进入 windows 的命令行模式 进入到你的文件夹下（d:\f5config>） 执行 perl siebel8-bigipv9.pl -r （调用的 rule 名字） -v （virtual server 的 IP 地址） ： （端口，默认 2321） 例如： perl siebel8-bigipv9.pl -r seibelruletest -v 10.7.70.100:2321 生成了以下就生成了我们所需要的 bigip.cfg 文件。 文件格式内容如下：
bigpipe pool EAIObjMgr_chsRRPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool EAIObjMgr_SIRRPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool EAIObjMgr_wtRRPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool ADMBatchProcRRPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool ADMObjMgr_chsRRPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool ADMProcRRPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool 10.7.97.2ServerPool { lb method rr \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool 10.7.97.3ServerPool { lb method rr \ member 10.7.97.3:2321 \ monitor all monitor_PROD \ } bigpipe rule seibelruletest { ' when CLIENT_ACCEPTED { TCP::collect 1 } when CLIENT_DATA { if { [findstr [TCP::payload] "/siebel" 0 " "] ==
二：部署推荐拓扑如下： 在实施之前我们必须做好 LTM 标准的事实前准备工作。包括与客 户讨论好部署模式,IP 地址规划。安全性控制等等。注：这里不再对 LTM 配置进行赘述，以标准的服务器负载均衡配置方式就可以。一下 是推荐使用的 LTM 于 Siebel 的拓扑。
三：LBconfig.txt 文件 在实施部署 bigip 之前。 我们需要拿到 Siebel 的 LBconfig.txt 文 件。 我们需要使用这个文件来生成我们的配置脚本。 在 Siebe server 中 Enterprise 的权限执行一下命令： Generate lbconfig （不能带/s） 然 后 到 <Siebel Installation Root>/admin. 这 个 文 件 夹 中 导 出 lbconfig.txt 文件，文件格式如下：
#Component Rules:
/PROD/eCommunicationsObjMgr_chs=10.7.97.3:2321;10.7.97.2:232 1; /PROD/EAIObjMgr_rz=10.7.97.3:2321;10.7.97.2:2321; /PROD/EAIObjMgr_eChannel=10.7.97.3:2321;10.7.97.2:2321; /PROD/EAIObjMgr_chs=10.7.97.3:2321;10.7.97.2:2321; /PROD/EAIObjMgr_SI=10.7.97.3:2321;10.7.97.2:2321; /PROD/ADMProc=10.7.97.3:2321;10.7.97.2:2321;
Oracle Siebel 简易部署手册
Siebel 是 Oracle 的一个基于 web 应用服务系统， F5 本身有一个解 决方案可以快速的与 Siebel 配合实施。具体实施步骤如下：
一：首先要判断这套方案的实施条件. 手册上写的是 F5 bigip 必须是 9.1 以上， 推荐使用 9.4 的版 本， 值得注意的是 V10 版本在配置导入时候由于 V10 底层 TMSH 的命 令与 V9 有所区别，导致如果用脚本导入会失败。必须手工建立 Pool ,Virtual Server 等配置。同时还要手工修改 profile 中的某些设置。 第二，Siebel Server 必须是 7.7 版本以上，推荐使用 8.0 的 版本。
bigpipe shell write partition bigpipe monitor monitor_PROD { ' defaults from http interval 30 timeout 91 send "GET /PROD/scbroker HTTP/1.0" ' } bigpipe pool eCommunicationsObjMgr_chsConnPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool EAIObjMgr_rzConnPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool EAIObjMgr_eChannelConnPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool EAIObjMgr_chsConnPool { lb method rr \
值得注意的是这些文件中所有 URL 的大小写必须严格区分。 Seibel 系统中对于所有 URL 都区分大小写。导出的配置文件中可 能存在大小写与原来 Selbel 不符的情况，我们必须检查其 URL 的 准确性。
四：bigip.cfg 文件 准备好 lbconfig.txt 文件以后， 我们下一步要做的是通过这个文 件生成一个 bigip.cfg 文件。F5 通过一个 Perl 的脚本来完成。 安装 Perl /Products/ActivePerl/ 这里可以找到 perl 脚本 for windows X32 或者 X64 的脚本安装文件。 （文件名为 ActivePerl-5.12.2.1203-MSWin32-x86-294165.msi） 下载 F5 配置转换脚本 /solutions/resources/deployment-guides/files/siebel 8-bigipv9.zip.
#Section one -- Session Manager Rules: VirtualServer=1:10.7.97.2:2321;5**************** #Section two -- 3rd Party Load Balancer Rules
member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool EAIObjMgr_SIConnPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool EAIObjMgr_wtConnPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool ADMBatchProcConnPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool ADMObjMgr_chsConnPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool ADMProcConnPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool eCommunicationsObjMgr_chsRRPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool EAIObjMgr_rzRRPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ } bigpipe pool EAIObjMgr_eChannelRRPool { lb method rr \ member 10.7.97.3:2321 \ member 10.7.97.2:2321 \ monitor all monitor_PROD \ }