使用 Oracle Metadata Services 构建可定制应用程序
- 格式:docx
- 大小:635.26 KB
- 文档页数:19
Infortrend磁盘阵列系统存储解决方案Infortrend存储为CERN科研服务位于瑞士的欧洲核能研究机构(CERN)是全世界最大的粒子物理研究实验室,它的大型强子对撞器产生的大量的数据需要数百TB高度可靠的存储空间。
CERN是欧洲第一个共同科学机构,目前拥有20个会员国,有超过1万位科学家在其中致力于解开宇宙组成的奥秘。
虽然CERN的研究对外人来说听起来难以理解,但这些研究与日常生活的许多层面都息息相关,范围包括癌症治疗、医疗影像以及因特网的开发。
存储挑战大型强子对撞器(Large Hardon Collider,LHC)是全世界最复杂的科学仪器,其设计是为了针对宇宙的一些基本问题找出答案,例如质量的来源。
LHC是一部粒子加速器,安装在圆周26659公尺长的隧道中。
隧道中呈现的真空环境比月球还要低10倍,质子粒子在隧道中循环,在对撞之前,每秒产生约1100万个回路。
粒子对撞后会立即产生高温,比太阳核心的温度还要高100兆倍。
在LHC上进行的六个实验观察这些对撞所产生的碎片。
这些实验每年会产生约15PB的珍贵科学数据,这对存储来说是一个极大的挑战。
为了组织并管理这些数据,CERN需要建立一个专门且复杂的基础架构,这个架构本身就需要数百TB的高度可靠的存储空间。
选择基础架构在为LHC设计与构建存储基础架构时,CERN的IT部门希望能够让研究团队拥有最好的工作系统,并且符合紧缩的预算与严苛的截止期限。
在经过详细评估后,CERN选择了Infortrend的EonStor磁盘阵列系统存储metadata,这些系统在价格、可靠性与技术功能方面提供了最佳的平衡。
Eonstor硬盘种类与系统硬盘数的多种选择使系统的构建更加灵活。
在LHC的计划中,多台EonStor系统混合使用,其中包括8、12、16、24-bay Fibre to SATA,以及Fibre to SAS/SATA系统。
Eonstor前方面板上的LCD在整体设计中看起来似乎是次要的功能,但在CERN 团队眼中这个设计能够让使用变得更加容易,尤其是在中央管理系统建置完成前。
OpenShift Container Platform 4.6Pipelines在 OpenShift Container Platform 中配置和使用 PipelinesLast Updated: 2023-02-27OpenShift Container Platform 4.6 Pipelines在 OpenShift Container Platform 中配置和使用 PipelinesEnter your first name here. Enter your surname here.Enter your organisation's name here. Enter your organisational division here. Enter your email address here.法律通告Copyright © 2022 | You need to change the HOLDER entity in the en-US/Pipelines.ent file |.The text of and illustrations in this document are licensed by Red Hat under a Creative Commons Attribution–Share Alike 3.0 Unported license ("CC-BY-SA"). An explanation of CC-BY-SA is available at/licenses/by-sa/3.0/. In accordance with CC-BY-SA, if you distribute this document or an adaptation of it, you must provide the URL for the original version.Red Hat, as the licensor of this document, waives the right to enforce, and agrees not to assert, Section 4d of CC-BY-SA to the fullest extent permitted by applicable law.Red Hat, Red Hat Enterprise Linux, the Shadowman logo, the Red Hat logo, JBoss, OpenShift, Fedora, the Infinity logo, and RHCE are trademarks of Red Hat, Inc., registered in the United States and other countries.Linux ® is the registered trademark of Linus Torvalds in the United States and other countries. Java ® is a registered trademark of Oracle and/or its affiliates.XFS ® is a trademark of Silicon Graphics International Corp. or its subsidiaries in the United States and/or other countries.MySQL ® is a registered trademark of MySQL AB in the United States, the European Union and other countries.Node.js ® is an official trademark of Joyent. Red Hat is not formally related to or endorsed by the official Joyent Node.js open source or commercial project.The OpenStack ® Word Mark and OpenStack logo are either registered trademarks/service marks or trademarks/service marks of the OpenStack Foundation, in the United States and other countries and are used with the OpenStack Foundation's permission. We are not affiliated with, endorsed or sponsored by the OpenStack Foundation, or the OpenStack community.All other trademarks are the property of their respective owners.摘要本文档提供在 OpenShift Container Platform 中配置和使用 Pipelines 的说明。
Oracle® Fusion Cloud EPM在 Oracle Enterprise Performance Management Cloud 中使用 EPM AutomateF28912-19Oracle Fusion Cloud EPM 在 Oracle Enterprise Performance Management Cloud 中使用 EPM AutomateF28912-19版权所有© 2016, 2023, Oracle 和/或其附属公司。
第一作者:EPM Information Development TeamThis software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.If this is software, software documentation, data (as defined in the Federal Acquisition Regulation), or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed, or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software," "commercial computer software documentation," or "limited rights data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed, or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.Oracle®, Java, and MySQL are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.目录文档可访问性文档反馈1 关于 EPM Automate安装 EPM Automate1-1容量和端口要求1-2支持的平台1-2Java 运行时环境和 EPM Automate1-3使用 OpenJDK1-3Windows 说明1-4Linux/UNIX/macOS X 说明1-4EPM Automate 命令的服务器端执行1-5了解 EPM Automate 加密级别1-5将 OAuth 2.0 授权协议用于 OCI(第 2 代)环境1-52 命令参考关于运行 EPM Automate 命令2-1先决条件2-1默认文件位置2-2启用传输层安全协议 1.22-3使用 EPM Automate 命令2-4为一个参数指定多个值2-4日常维护期间的行为2-4运行 EPM Automate2-5 Windows2-5Linux2-6运行 EPM Automate 的多个实例2-7命令概览2-9 EPM Automate 命令2-14iiiaddUsers2-14 addUsersToGroup2-16 addUsersToTeam2-17 addUserToGroups2-17 applicationAdminMode 2-18 applyDataGrants2-19 archiveTmTransactions2-19 assignRole2-21 autoPredict2-22 calculateModel2-23 clearCube2-25 clearDataByPointOfView2-26 clearDataByProfile2-27 clearPOV2-27 cloneEnvironment2-28 copyDataByPointOfView2-32 copyDataByProfile2-33 copyFileFromInstance2-33 copyFromObjectStorage2-34 copyOwnershipDataToNextYear2-35 copyPOV2-36 copySnapshotFromInstance2-37 copyToObjectStorage 2-38 createGroups2-39 createNRSnapshot2-40 createReconciliations2-40 deleteFile2-41 deleteGroups2-42 deletePointOfView2-43 deletePOV2-43 deployCube2-44 deployEJTemplates2-45 deployFormTemplates2-46 deployTaskManagerTemplate2-46 dismissIPMInsights2-47 downloadFile2-47 enableApp2-48 enableQueryTracking2-48 encrypt2-49 executeAggregationProcess2-50 executeBurstDefinition2-51ivexecuteReportBurstingDefinition2-51 exportAccessControl2-52 exportAppAudit 2-52 exportAppSecurity2-53 exportARApplicationProperties2-54 exportBackgroundImage 2-55 exportCellLevelSecurity 2-55 exportConsolidationJournals2-56 exportData2-56 exportDataManagement2-57 exportDimension2-57 exportDimensionMapping2-58 exportEJJournals2-59 exportEssbaseData2-60 exportJobConsole2-60 exportLibraryArtifact2-63 exportLogoImage2-64 exportMapping2-64 exportMetadata2-65 exportOwnershipData2-65 exportQueryResults2-66 exportSnapshot2-68 exportTemplate2-68 exportTaskManagerAccessControl2-69 exportValidIntersections2-70 extractDimension2-70 feedback2-71 getApplicationAdminMode 2-72 getDailyMaintenanceStartTime2-73 getEssbaseQryGovExecTime2-73 getIdleSessionTimeout2-74 getIPAllowlist2-74 getSubstVar2-75 getVirusScanOnFileUploads2-76 groupAssignmentAuditReport 2-76 help2-77 importAppAudit2-77 importAppSecurity2-78 importARApplicationProperties2-79 importBackgroundImage2-79 importBalances2-80vimportCellLevelSecurity 2-80 importConsolidationJournals2-81 importData2-82 importDataManagement2-83 importDimension2-83 importJobConsole2-84 importLibraryArtifact 2-85 importLogoImage2-86 importMapping2-86 importMetadata2-87 importOwnershipData2-88 importPreMappedBalances2-89 importPreMappedTransactions2-90 importProfiles2-90 importRates2-91 importReconciliationAttributes2-91 importSnapshot2-92 importSupplementalCollectionData2-94 importSupplementalData2-96 importTemplate2-96 importTmPremappedTransactions2-97 importValidIntersections2-98 invalidLoginReport2-99 listBackups2-100 listFiles2-101 loadData2-102 loadDimData2-103 loadViewpoint2-104 login2-104 logout2-108 maskData2-108 mergeDataSlices2-109 mergeSlices2-109 optimizeASOCube2-110 programDocumentationReport2-111 provisionReport2-111 purgeArchivedTmTransactions 2-113 purgeTmTransactions2-113 recomputeOwnershipData2-114 recreate2-115 refreshCube2-118viremoveUserFromGroups2-118 removeUsers2-119 removeUsersFromGroup2-120 removeUsersFromTeam2-121 renameSnapshot2-122 replay2-122 resetService2-123 restoreBackup2-124 restructureCube2-125 roleAssignmentAuditReport 2-126 roleAssignmentReport2-127 runAutomatch2-128 runBatch2-128 runBusinessRule2-129 runCalc2-130 runComplianceReport2-131 runDailyMaintenance2-132 runDataRule2-133 runDMReport2-135 runIntegration2-135 runMatchingReport2-139 runPlanTypeMap2-140 runRuleSet2-140 runSupplementalDataReport2-141 runTaskManagerReport2-142 sendMail2-143 setApplicationAdminMode2-144 setDailyMaintenanceStartTime2-145 setDemoDates2-145 setEJJournalStatus2-146 setEncryptionKey2-147 setEssbaseQryGovExecTime2-148 setIdleSessionTimeout2-148 setIPAllowlist2-149 setManualDataAccess2-150 setPeriodStatus2-151 setSubstVars2-151 setVirusScanOnFileUploads2-152 skipUpdate2-152 snapshotCompareReport2-154 sortMember2-155viiunassignRole2-156updateUsers2-157upgrade2-158uploadFile2-159userAuditReport2-160userGroupReport2-161validateConsolidationMetadata2-161validateModel2-162退出代码2-1633 命令执行示例方案关于复制示例脚本3-1所有服务的示例方案3-1将应用程序快照备份到计算机3-2将快照复制到 Oracle Object Storage 或从中复制快照3-4创建用户并向其分配预定义角色3-6统计许可的用户数(分配了角色的用户)3-8创建分配了角色的用户的审核报表3-10创建角色分配和撤消审核报表3-14遮蔽访问日志和活动报表以确保符合隐私法3-17自动将活动报表下载到本地计算机3-22从环境中下载访问日志3-26自动克隆环境3-29从环境中删除不必要的文件3-33从环境中查找并下载文件3-33重新创建一个旧 EPM 云环境用于审核3-34自动进行数据库访问审核与合规性调节3-45复制用户和预定义角色分配3-56将一个身份域的用户复制到另一个身份域3-57将预定义角色分配从一个环境复制到另一个环境3-63创建每季度一次的 EPM 云升级节奏3-71 Windows 脚本和说明3-71UNIX/Linux 脚本和说明3-74Groovy 脚本3-78Planning、Consolidation、Tax Reporting 和 Enterprise Profitability and Cost Management的示例方案3-82自动从聚合存储多维数据集导出大量单元格3-82将元数据导入应用程序3-92导入数据、运行计算脚本并将数据从块存储数据库复制到聚合存储数据库3-92导出和下载元数据和数据3-93viii导出和下载应用程序数据3-93自动存档应用程序审核记录3-93 Windows 脚本3-95Linux 脚本3-95将数据文件上传到环境并运行数据加载规则3-96自动执行每日数据集成3-97Account Reconciliation 示例方案3-99将预先设置格式的余额加载到期间内3-100上传和导入备份快照3-100Profitability and Cost Management 示例方案3-101将元数据导入应用程序中3-101导入数据并运行程序规则3-101Oracle Enterprise Data Management Cloud 示例方案3-102将 Oracle Enterprise Data Management Cloud 维和映射与 EPM 云应用程序同步3-103将 EPM 云维与 Oracle Enterprise Data Management Cloud 应用程序同步3-104自动执行脚本3-105监视 EPM Automate 活动3-1064 在不安装 EPM Automate 的情况下运行命令支持服务器端命令执行的环境4-1信息源4-2支持的命令4-2使用服务器端 Groovy 运行 EPM Automate 的方法4-2使用服务器端 Groovy 脚本克隆环境4-3使用服务器端 Groovy 脚本通过电子邮件发送活动报表4-45 复制 EPM 云环境设置每日复制5-1设置按需复制5-2配置辅助环境5-3A 准备运行 Replay 命令关于 Replay 命令A-1先决条件A-1创建 HAR 文件A-2创建重放文件A-5生成跟踪文件A-5ix重放示例会话A-6B 处理特殊字符C 特定于每个 EPM 云服务的命令Account Reconciliation 命令C-2 Financial Consolidation and Close 命令C-3 Narrative Reporting 命令C-4 Oracle Enterprise Data Management Cloud 命令C-5 Planning、Planning 模块、自由形式、战略性人员规划和销售规划命令C-6 Profitability and Cost Management 命令C-7 Enterprise Profitability and Cost Management 命令C-8 Tax Reporting 命令C-9x文档可访问性有关 Oracle 对可访问性的承诺,请访问 Oracle Accessibility Program 网站http:///pls/topic/lookup?ctx=acc&id=docacc。
Securing REST Clients using Oracle WebService Manager 12.1.2August 2013Step-by-Step Instruction GuideAuthor: Prakash YamunaOracle CorporationTable of Contents1 Getting Started (4)1.1 Pre-Requisites (4)1.2 Install Locations (4)1.3 Topology (4)1.4 Install & Topology Verification (4)1.4.1 Verify all Product Consoles are reachable (5)2 Usecase (5)3 Create “rest-saml-idprop” Application (7)3.1 Create “service” Project (8)3.2 Create “HelloWorldIdPropSample” POJO class (9)3.3 Add method “hello” to the POJO Class (10)3.4 Add Jersey Libraries via Project Properties (11)3.5 Create a RESTFul Service from the POJO Class (13)3.6 Using @Context and SecurityContext (16)3.7 Modify the Servlet name (17)3.8 Secure the REST service in JDeveloper (18)3.9 Create a Deployment Profile and WAR (19)3.10 Deploy the REST service “helloworld.war” to WLS using EM (22)3.11 Validate the REST service (25)4 Create REST client (28)4.1 Create a new “rest-client” Web project (28)4.2 Create “HelloWorld Servlet” (32)4.3 Create REST Client Proxy (35)4.4 Secure the REST Client Proxy (38)4.5 Modify the HelloWorldServlet to call the RESTful Client Proxy (41)4.6 Modifying the REST Client Security Policy (42)4.7 Secure the HelloWorldServlet web application (43)4.7.1 Select Authentication Mechanism (43)4.7.2 Add Security Constraints (44)4.7.3 Final “web.xml” for the HelloWorldServlet (45)4.7.4 Create weblogic.xml deployment descriptor (46)4.7.5 weblogic.xml for the HelloWorldServlet (48)4.8 Create Deployment Profile and WAR for the Client (49)5 Create users in weblogic using WLS Console (51)6 Create credentials in credential store to be used by REST Client (54)6.1 Create “oracle.wsm.security” CSF map (54)6.2 Create “weblogic-csf-key” under the oracle.wsm.security CSF map (55)6.3 Mapping newly created “testuser” in weblogic.xml (57)7 Deploy the client application to Weblogic using EM (57)8 Testing (60)1Getting Started1.1Pre-RequisitesThis How-To guide assumes that you have already downloaded and installed the followingproducts/components.∙Download and install FMW 12.1.2 – this includes Oracle WebService Manager 12.1.2.∙Download and install Database 11.2.0.3∙Download JDeveloper 12.1.2∙JDK7 is preinstalled1.2Install LocationsThis How-To does not provide installation instructions for the pre-requisite components.You can consult the following how-to for installing FMW 12.1.2:/technetwork/middleware/webservices-manager/owsm-installation-12c-1971739.pdfYou can also consult the appropriate Install guides. OWSM documentation can be found at:/middleware/1212/owsm/index.htmlThe components in this How-To are installed at the following locations:1.3TopologyThis How-To uses a single domain. The domain includes a single weblogic server. The steps provided in this How-To can vary based on Topology.∙Domain Name: base_domain∙Weblogic Server: AdminServer1.4Install & Topology VerificationStart the Admin ServerNavigate to: D:\oracle_12.1.2\user_projects\domains\base_domain\bin1.4.1Verify all Product Consoles are reachableGo to the product console URL and provide username as weblogic and password as appropriate to your installation.2UsecaseDescriptionThis How-To describes how to secure a JAX-RS REST service and client using OWSM 12.1.2.HelloWorldIdPropSample(REST service)ObjectiveThe main objective of this How-To:∙How to build a simple REST services using JAX-RS technology in JDeveloper∙How to secure a simple HelloWorld JAX-RS application using OWSM Policy in JDeveloper∙Deploy and Run the HelloWorld JAX-RS application to a Weblogic domain∙How to build a simple HelloWorld REST Client Proxy for the HelloWorld REST service using JAX-RS technology in JDeveloper∙How to secure the HelloWorld REST Client Proxy using OWSM Policy in JDeveloper∙Testing end to end.3Create “rest-saml-idprop” ApplicationThis application will contain two projects. One for the REST service and another for the REST Client.NOTE: Ignore the name of the sample (I plan to have another How To that describes identity propagation using SAML)Provide the necessary information for creating the Application as shown in the screenshot below.Click “Next”3.1Create “service” ProjectCreate a project called “service” in JDeveloper as show in the screenshot below. This project will be used to build the REST service.Click “Next”Click “Next”Click “Finish”3.2Create “HelloWorldIdPropSample” POJO class Create a POJO class under the “service” Project.Click “OK”3.3Add method “hello” to the POJO Class3.4Add Jersey Libraries via Project PropertiesWe will use APIs that require Jersey Libraries in the Project. Add these Libraries via the Project Properties. This can be achieved by right-clicking on the “service” project and clicking on the “Project Properties” menu item as shown in the screenshot below.Click on “Add Library” button in the screenshot above. This will pop up the “Add Library” dialog below.Click “OK”Click “OK”3.5Create a RESTFul Service from the POJO ClassYou can create a RESTFul Service by right clicking on the POJO Class and clicking on “Create RESTful Service” menu item as shown below.For the purposes of this How-To select the media type as text/plain by Clicking “Produces”.Click “OK”.Click “Next”Click “Finish”3.6Using @Context and SecurityContext**************************************************************************************NOTE: Modify the code to use the @Context annotation to get the authenticated user after creating a RESTful Service.Pay special attention to the import statements.import java.security.Principal;import javax.ws.rs.core.Context;import javax.ws.rs.core.SecurityContext;Also note that that the method “hello” has a Path annotation.WARNING: If you add the @Context parameter before creating the RESTful service – then you will not be able to use the “Create RESTFul Service” menu item as shown above to create a RESTful servic e. So the sequence described above is important.While you can add the @Path annotations, etc manually the “Create RESTful Service” converts the project to a Web Project and adds the web.xml deployment descriptor – which allows you to secure the RESTful Service.NOTE: There are other ways of programming this sample in JDeveloper. The sequence shown here is important only for this particular scenario.3.7Modify the Servlet nameWhen you create a RESTful service – Jdeveloper automatically modified the project to be a Web Project and adds web.xml. However the default servlet name is called “jersey”. Modify the servlet name and provide a more user friendly name as shown below.3.8Secure the REST service in JDeveloperYou can secure a REST service by right-clicking on “web.xml” and selecting the “Secure RESTful Application” menu item as shown below.You can search for a policy of a particular name in JDeveloper as shown below.Click “OK”Securing a RESTful Service will create a wsm-assembly.xml document as shown below.3.9Create a Deployment Profile and WARClick “OK”Click “OK”Click “Next”Click “Finish”3.10Deploy the REST service “helloworld.war” to WLS using EMClick “Webogic Domain->Deployments” from the RHS menu in the screenshot above.Click “Next”Click “Next”Click “Next”Click “Deploy”Click “Close”3.11Validate the REST serviceExpand the “helloworld” node in the LHS and click on the helloworld (AdminServer) instance as shown in the screenshot below. This will open up the Application Home page in EM. Select “Application Deployment->Web Services” menu item on the RHS as shown in the below screenshot.4Create REST client4.1Create a new “rest-client” Web projectCreate a new Project for the client as shown in the screenshot below.We will create “Web Project” since the client will act as a JEE Client.Click “OK”.Click “Next”Click “Next”Click “Next”Click “Next”Click “Next”Click “Finish”4.2Create “HelloWorld Servlet”Create a HTTPServlet which will act as the REST Client. You can create a Servlet by right-clicking on the project and selecting “New->HTTPServlet” from the context menu.Click “Next”Click “Next”Click “Next”Click “Finish”4.3Create REST Client ProxyYou can create a REST Client Proxy by right-clicking on the project and selecting “New->From Gallery” as shown below.Select the “Web Services” category from the “New Gallery” dialog on the Left Hand side. This will show all the options related to Web Services on the Right hand side. Select “Restful Client and Proxy” from RHS to create a REST client as shown in the screenshot below.Click “OK”Click “Next”To create a RESTful Proxy Client – you will need the WADL of the REST service.NOTE: Either you need to save the WADL of the service a priori or have the RESTful Service running in order to be able to provide the WADL url.Click “Next”By default JDeveloper generates a classname for the Proxy client. Provide a more user friendly name in this dialog as shown in the screenshot above.Click “Next”Select the OWSM policy you want to use to secure the client and click “Next”.IMPORTANT: Although JDeveloper provides you a policy selection dialog to select the OWSM policy in the REST Client Proxy creation wizard – there is a bug in JDeveloper - due to which the Policy is not added to the Client Proxy code. You will need to manually add the following lines of code show below.4.4Secure the REST Client ProxyPay special attention to the import statements in the code snippet above.import oracle.wsm.metadata.feature.AbstractPolicyFeature;import oracle.wsm.metadata.feature.PolicyReferenceFeature;import oracle.wsm.metadata.feature.PolicySetFeature;import oracle.wsm.metadata.feature.PropertyFeature;import oracle.wsm.security.util.SecurityConstants;import weblogic.jaxrs.api.client.Client;Few other things to note:∙The oracle/wss_http_token_client_policy – provides basic auth functionality and requires a username/password that needs to be sent to the client.∙For the username/password – we will store it in the credential store. The key to the entry will be called “weblogic-csf-key”under “oracle.wsm.security” CSF map.4.5Modify the HelloWorldServlet to call the RESTful Client ProxyFor purposes of brevity I have provided the code snippet for how to call the generated RESTful Proxy Client code above.4.6Modifying the REST Client Security PolicyOne can modify the OWSM client policy used to secure the client by right-clicking on the RESTful Client Proxy class and selecting “Secure RESTful Client” from the context menu as shown below.You can use the above dialog to make a different policy selection if required. In this case I did not modify the policy since I had already selected the correct policy.NOTE: Any changes you do in terms of selecting a different policy via this dialog will be effective and the corresponding code in the RESTful Proxy Client will be modified.4.7Secure the HelloWorldServlet web applicationOpen web.xml for the “rest-client” Project in JDeveloper and add an entry for the HelloWorldServlet as shown below.4.7.1Select Authentication MechanismSelect “HTTP Basic Authentication” mechanism.4.7.2Add Security Constraints4.7.3Final “web.xml” for the HelloWorldServlet4.7.4Create weblogic.xml deployment descriptor Right click on the project and select “New->From Gallery”.Click “OK”Click “Next”Click “Next”Click “Finish”4.7.5weblogic.xml for the HelloWorldServlet4.8Create Deployment Profile and WAR for the Client Click “OK”Click “OK”Click “Next”。
Oracle® CloudData Sync Getting StartedRelease 2.4DSGS-240February 2018Getting Started With Data SyncThis guide introduces Data Sync Version 2.4 and provides installation instructions.Data Sync loads and transforms data that you want to analyze into a target database,for example, Oracle Database Cloud Service or Essbase Cloud Service (Essbase).Topics:•Before You Start•Installing and Setting Up Data Sync•Connecting to Oracle Database Cloud Service Using SSH Tunneling•Connecting To Your Data Target and Data SourceBefore You StartTo install Data Sync, you must meet the requirements and prerequisites, download theapplication from Oracle Technology Network, then install and configure the software.PrerequisitesBefore installing, you must have Java V1.8.x (not V1.9.x) of Java Development Kit(JDK) and apply critical updates.Source Database SupportData Sync supports the following source database types:•Oracle•NetSuite•Microsoft SQL Server•DB2•Teradata•MySQL•Oracle TimesTen•Generic JDBC with prepackaged drivers for Greenplum, MongoDB, Salesforce, Redshift, Hive and PostgreSQL•Other sources that support JDBC•Oracle Transactional Business Intelligence:–Oracle Financials Cloud–Oracle HCM Cloud–Oracle Procurement Cloud–Oracle Project Management Cloud–Oracle Sales Cloud–Oracle Supply Chain Management Cloud•Oracle Service Cloud (RightNow)JDBC DriversData Sync is a Java application that uses Java Database Connectivity (JDBC). Data Sync is installed with Oracle JDBC Version 12.1.0.2.0. If you’re using a different database or version, then you must replace the installed Oracle JDBC version with the JDBC version that’s specific to your database. To replace the installed JDBC version, you copy the JDBC drivers from your Oracle database environment to the \lib directory on the machine where you installed Data Sync.Vendor JDBC Driver File nameOracle ojdbc7.jarMySQL Mysql-connector-java*.jarMicrosoft SQL Server sqljdbc.jarDB2db2java.zipTimesTen ttjdbc6.jar, orai18n.jar, timestenjmsxla.jar,jms.jar, javax.jms.jarTeradata terajdbc4.jar, log4j.jar, teradata.jar,tdgssjava.jar, tdgssconfig.jarSecurityOracle recommends that you only install Data Sync in protected environments because Data Sync stores connection information and passwords for your databases. Installing and Setting Up Data SyncTo install Data Sync, you download the software pack from Oracle Technology Network, install the software, then configure Data Sync.Download and Install Data Sync1.On the Data Sync Downloads site (/technetwork/middleware/bicloud/downloads/index.html), accept the OTN license agreement, and click the OAC Data Sync link to download the OACDataSync.zip file.2.Copy the OACSDataSync.zip file to an installation directory with no spaces in thefolder names (for example, c:\DataSync2_4), and extract the contents.Setting up the Java Home Environment VariableDepending on your operating system, edit the config.bat or config.sh file, and modify the line that sets the JAVA_HOME. Replace “@JAVA_HOME” with the directory where the JDK is installed. If your JDK directory name contains spaces, then put double-quotes around it.For example, on Windows:set JAVA_HOME=D:\JavaFor example, on UNIX:JAVA_HOME=usr/javaStarting Data SyncTo start Data Sync and its server, run datasync.bat (Windows) or datasync.sh (Linux/ UNIX) from the directory where you installed Data Sync. The Data Sync icon displays in your system icon tray to show that the server is running.•Select Start UI to open the Data Sync client. When you close the Data Sync client, the Data Sync server remains running.•Select Exit to stop the Data Sync server and close the Data Sync client if it is open.Alternatively, use these files:•datasyncClient.bat.sh opens the Data Sync tool (when the server is running).•stopserver.bat/sh stops the Data Sync server.Upgrading an Existing Data Sync InstallationIf your existing environment is using JDK V1.7, follow these steps to upgrade:1.Create a new Data Sync2.3 environment using JDK V1.8.2.From the old environment, export the metadata (from the Tools menu, thenExport, then and select all categories and projects).3.From the old environment,import the metadata (from the Tools menu, then Import, then and select allcategories and projects).e the new environment to upgrade to Data Sync V2.4.Running Data Sync for the First TimeThe first time you start the Data Sync client, the Configuration Setup wizard prompts you to enter the following information:•Logical Name. Specify a name for the repository to distinguish the repository in multi-repository environments. For example, you might name the instanceDevelopment Environment or Production Environment.•Password. Provide a password for accessing Data Sync. Optionally, use the Remember password option to specify whether Data Sync stores the password so that you don’t have to specify it each time you start Data Sync.Reconfiguring Data Sync With Its Default SettingsTo reset Data Sync with default settings and re-run the setup process, run datasync.bat (Windows) or datasync.sh (Linux/UNIX) in a command window with the -clean option.Uninstalling Data SyncTo uninstall Data Sync, delete the install directory.Connecting to Database As A Service Using SSH TunnelingBy default, Data Sync V2.4 communicates with Oracle Database Cloud Service using port 1521. Alternatively, you can configure Data Sync to communicate with DatabaseAs A Service using the Secure Shell (SSH) port 22 (this configuration is known as‘SSH Tunneling’).1.Close Data Sync and the Data Sync server.To stop the Data Sync server, click the Data Sync icon on the Windows tool bar and click Exit.2.Update your JDK/JRE with Java Cryptography Extension (JCE), which supportsUnlimited Strength.The default JDK doesn’t install the unlimited strength version of JCE (JavaCryptography Extension). You must install a version of JCE that's compatible with the Java version you're using for Data Sync. For example, you might download JCE V7 from /technetwork/java/javase/downloads/jce-7-download-432124.html, or JCE V8 from /technetwork/java/ javase/downloads/jce8-download-2133166.html.3.Unzip the contents of the downloaded JCE ZIP file and replace the local_policy.jarand US_export_policy.jar in $JAVA_HOME/jre/lib/security with the downloaded files.4.Start Data Sync.5.From the Views menu, click SSH Tunnels (Beta).6.Create a new entry to configure the port forwarding from the local machine to theremote host.Option What to specifyName A short descriptive name to identify this configuration inData Sync.Remote Host The IP address of the Database As A Service node.Remote SSH Port The SSH Port on the remote host, which is typically 22.User Name The user name for the remote server, which is typicallyopc.Private Key The SSH private key file that matches the public keyassociated with the deployment. When you create aDatabase As A Service instance, you create a public keyand a private key. The Public Key was used on instancecreation. The private key is used to connect to theinstance at the Operating System (OS) level. Downloadthis file and point the location of that key file.Passphrase The password that you specified when you created thedatabase deployment.Port Forward The database port on the remote host, which is typically1521.Local Port An unassigned port on the local machine that can be usedfor the tunnel. If you don’t know the port number to enter,click Find Available Port, and select a port.7.Save the details and test the connection.When you test a connection and it’s successful, Data Sync creates the SSHtunnel, and this SSH tunnel remains active as long as Data Sync is running.8.Configure the default TARGET connection or create a new database connection toyour Database As A Service instance by choosing Oracle (Thin) type connection.For the Host, use localhost, and for the Port, use the local port that you defined in Step 6.9.Create a project and load your data as normal.If for any reason the SSH tunnel closes (or is deactivated), then reported failures in the job will relate to IO Exceptions. From the Views menu, click SSH Tunnels (Beta), and correct any issues.Connecting to Your Data SourceIn Data Sync, navigate to the Connections tab and specify connection details for your target database and the data sources that you want to extract from.Connecting Data Sync to Your Data SourceOn the Connections tab, create a connection for each of your data sources. If you load data only from files, skip this task and access the Project-File Data dialog to specify the files and loading details. On the Connections tab, click New and specify the connection details of your data source.•In the User and Password fields, specify the user name and password for a user with sufficient reporting privileges for the data source.•In the URL field, specify the URL for your data source. For example, for Amazon Redshift you might enter: jdbc:redshift://bics-:1234/prod.•In the Connection Type field, select the appropriate data source type. For example, for Amazon Redshift, you select Generic JDBC.For additional information about specifying connections for JDBC, Oracle Service Cloud, or NetSuite, click Help.Connecting to a Oracle Database Cloud Service TargetIn Data Sync, navigate to the Connections tab and specify connection details for your target database and the data sources that you want to extract from.Connecting Data Sync To A Oracle Database Cloud Service Data TargetOn the Connections tab, edit the connection with the name TARGET, and specify the connection details of your database target.•In the Connection Type field, don’t change the connection type Oracle (BICS).•In the User and Password fields, specify the user name and password of a user appropriate Application Roles.The user must have BI Dataload Author to load data into a table, and DVContent Author to load data into a data set.•In the URL field, specify your Oracle Analytics Cloud URL. For example, https://. Do not use URL extensions. Connecting to an Essbase TargetIn Data Sync, navigate to the Connections tab and specify connection details for your target database and the data sources that you want to extract from.Connecting Data Sync To An Essbase TargetOn the Connections tab, edit the connection with the name TARGET, and specify the connection details of your database target.•In the Connection Type field, select Essbase.•In the User and Password fields, specify the user name and password of a user with the Application Role named BI Dataload Author.•In the URL field, specify your Essbase URL. For example, http://:9000/.Oracle® Cloud Data Sync Getting Started, Release 2.4DSGS-240Copyright © 2015, 2018, Oracle and/or its affiliates. All rights reserved.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.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 are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.This document introduces Oracle Business Intelligence Cloud Service Data Sync Version 2.2 and provides installation instructions.。
Oracle Financial Services Data Foundation Application Pack Release NotesRelease 8.1.2.2.1December 2022OFS Data Foundation Application Pack Release NotesCopyright © 2022 Oracle and/or its affiliates. All rights reserved.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable.U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are “commercial computer software” pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.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 are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.For information on third party licenses, click here.Document ControlTable of Contents1Preface (5)1.1Audience (5)1.2How this Guide is Organized (5)1.3Access to the Oracle Support (5)1.4Related Documents (6)2Introduction (7)2.1About the Oracle Financial Services Data Foundation Application Pack (7)2.2Components of the OFSDF Application Pack (7)3OFSDF Application Pack Release Notes v8.1.2.2.1 (9)3.1New Features (9)3.2Prerequisites (9)3.3Installing this One-off Patch Release (10)3.4Bugs Fixed in this Release (11)3.5Known Issues or Limitations (11)4Hardware and Software Tech Stack Details (12)5Licensing Information (12)A UDIENCE1PrefaceThis section provides supporting information for the Oracle Financial Services Data Foundation ApplicationPack Release Notes v8.1.2.2.1.Topics:•Audience•How this Guide is Organized•Access to the Oracle Support•Related Documents1.1AudienceThis document is intended for Administrators, Business Users, Strategists, and Data Analysts, who handleinstalling and maintaining the application pack components and have knowledge of the following: •OFSAA Application Components•OFSAA Architecture•UNIX Commands•Database Concepts•OFSDF Data Model1.2How this Guide is OrganizedThe OFSDF Application Pack Release Notes includes the following sections:•Introduction: This section provides information about the OFSDF Application Pack and itscomponents.•OFSDF Application Pack Release Notes v8.1.2.2.1: This section provides information about the OFSDF Application Pack Release v8.1.2.2.1 such as new features and prerequisites for the release, how toapply for this release and the list of bugs fixed and enhancements done, and the known issues orlimitations, if any.•Hardware and Software Tech Stack Details: This section provides a reference to the OFSAA Technology Stack Matrices document required for this release.•Licensing Information: This section provides a reference to the Licensing Information User Manual required for this release.1.3Access to the Oracle SupportOracle customers have access to electronic support through My Oracle Support. For more information, visit/pls/topic/lookup?ctx=acc&id=info or visit/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.R ELATED D OCUMENTS1.4Related DocumentsOracle strives to keep this and all other related documents updated regularly; visit the OHC DocumentationLibrary to download the latest version available there. The list of related documents is as follows: •For the OFSDF Application Pack Release 8.1.x.x.x product documents OHC Documentation Library.•For the OFSDF Application Pack Release 8.1.x.x.x other documents OHC Documentation Library.•My Oracle Support for the OFSDF Application Pack Release 8.1.x.x.x technical documents:▪Data Model Difference Reports▪Changelog▪SCD Metadata▪T2T Metadata▪Run Chart•Oracle Financial Services Analytical Applications (OFSAA) Technology Matrix Release 8.1.2.0.0•Oracle Financial Services Analytical Applications (OFSAA) Licensing Information User Manual Release 8.1.2.0.0A BOUT THE O RACLE F INANCIAL S ERVICES D ATA F OUNDATION A PPLICATION P ACK2IntroductionOFSAA is a suite of applications covering risk, performance, financial crime, compliance, customer insight,and Regulatory Reporting functions. These applications are built on a common technology infrastructure,which works off a singular data model that has unified structures for non-redundant acquisition, hosting,and processing of data, and renders rich information output that can be analyzed across a conformed setof perspectives. Sophisticated processing engines underlying the suite facilitates modular deployment andare controlled by comprehensive, user-configurable metadata.The OFSAA Applications are in use at several financial institutions across the globe.Oracle Financial Services Analytical Applications delivers a comprehensive, Integrated Suite of FinancialServices Analytical Applications for both Banking and Insurance domains.Topics:•About the Oracle Financial Services Data Foundation Application Pack•Components of the OFSDF Application Pack2.1About the Oracle Financial Services Data FoundationApplication PackThe Oracle Financial Services Data Foundation (OFSDF) Application Pack is an Analytical Data Warehouseplatform for the Financial Services industry. OFSDF Application Pack combines an Industry Data Model forFinancial Services along with a set of management and infrastructure tools that allows Financial ServicesInstitutions to develop, deploy, and operate analytical solutions spanning key functional areas in FinancialServices, including:•Enterprise Risk Management•Enterprise Performance Management•Customer Insight•Financial Crime and Compliance ManagementOFSDF is a comprehensive Data Management platform that helps institutions to manage the analyticaldata life cycle from Sourcing to Reporting and Business Intelligence (BI) using a unified, consistent platformand toolset.2.2Components of the OFSDF Application PackThe OFSDF Application Pack consists of the following components, which are described in additional detailin the following sections:•Financial Services Analytical Warehouse Data ModelThis is a physical data model that supports data sourcing and reporting related to key analytical usecases in the Financial Services Industry. The Warehouse Model is a physical data model, unlike theOFSDF LDM, meaning that it is readily deployable, and consists of database object definitions, andadditional supporting scripts.It is organized into two distinct sets of tables based on purpose: The Staging Model, which facilitatesdata sourcing from the bank's internal operational systems such as Lending Systems, TradingSystems, Collateral Management Systems, and Master Data Management Systems.C OMPONENTS OF THE OFSDF A PPLICATION P ACKThe Reporting model, which facilitates the storage of outputs from analytical tools, applications, and engines in a manner that is conducive to Business Intelligence Reporting. The Warehouse Model is typically deployed into production through a set of management tools known as the Oracle Financial Services Analytical Application Infrastructure (OFSAAI). OFSAAI is a separate product and is aprerequisite for OFSDF.•Supporting ScriptsAs part of the OFSDF Package, additional scripts are provided for basic operations such as internal data movement between the Staging and Reporting tables.N EW F EATURES3OFSDF Application Pack Release Notes v8.1.2.2.1 Oracle Financial Services Data Foundation Application Pack v8.1.2.2.1 One-off Patch.Patch ID 34835967: FSDF 8.1.2.2.0 ONE-OFF PATCH#1 RELEASE (8.1.2.2.1)Oracle Financial Services Data Foundation Application Pack is a separately licensed product.Topics:•New Features•Prerequisites•Installing this One-off Patch Release•Bugs Fixed in this Release•Known Issues or Limitations3.1New FeaturesThe new feature added as a part of the Oracle Financial Services Data Foundation Application Pack Releasev8.1.2.0.0 is the Data Lineage enhancements for the Data Transformation and the inclusion of DataExtraction in Json format.For detailed information about using the existing features, see the Oracle Financial Services DataFoundation Application Pack User Guide Release 8.1.2.0.0.For more information about the OFS AAI requirements, see the Oracle Financial Services AdvancedAnalytical Applications Infrastructure Installation Guide Release 8.1.2.0.0.3.2PrerequisitesThe following prerequisite software must be installed for this release:•Oracle Financial Services Data Foundation (OFSDF) Application Pack v8.1.2.2.0 Maintenance Level Release Patch ID 33984652 plus other prerequisite OFSDF Patches (download from My OracleSupport (MOS)) must be installed and configured on your machine. For more information, see thePreparing for Installation Section in the Oracle Financial Services Data Foundation Application PackInstallation and Configuration Guide Release 8.1.2.2.0.I NSTALLING THIS O NE-OFF P ATCH R ELEASE3.3Installing this One-off Patch ReleaseTo install this release, follow these steps:NOTE The OFSDF Application Pack Release 8.1.2.2.1 patch is applicable only for theRDBMS mode of installation.1. Log in to My Oracle Support (MOS) and navigate to the Patches & Updates tab.2. Search for the OFSDF Application Pack patch ID 34835967.3. Download the 34835967_GENERIC.zip archive file and copy it to your OFSAA Server in the Binarymode.4. Shut down all the OFSAAI Services.For more information, see the Stop the Infrastructure Services section in the Oracle Financial ServicesAdvanced Analytical Applications Infrastructure Installation Guide Release 8.1.2.0.0.5. Create a new directory for the patch 34835967_GENERIC.zip archive file using the followingcommand:mkdir 348359676. Copy the 34835967_GENERIC.zip archive file into the 34835967 directory.7. Extract the contents of the patch archive file using the following command:unzip -a <name of the file to be unzipped>For example, unzip -a 34835967_GENERIC.zip8. Assign the RWX or 775 permission to the 34835967 directory using the following command:chmod -R 775 348359679. Navigate to the <>/appsLibConfig/conf directory.10. In the params.conf file, update the UPLOAD_MODEL parameter value to 0 and MODEL_TYPEparameter value to 1.11. Navigate to the <>/OFS_FSDF/bin directory.12. Execute the following setup command:./setup.shOFSDF A PPLICATION P ACK R ELEASE N OTES V8.1.2.2.1B UGS F IXED IN THIS R ELEASE13. Verify the patch installation logs in the <>/OFS_FSDF/logs directory. If there are any errors,contact My Oracle Support (MOS).14. Generate the application EAR or WAR file and redeploy the application in the configured WebApplication Server.For more information, see the Creating and Deploying EAR/WAR File section in the Oracle FinancialServices Advanced Analytical Applications Infrastructure Installation Guide Release 8.1.2.0.0.15. Restart all the OFSAAI Services after successful deployment.For more information, see the Starting Infrastructure Services section in the Oracle Financial ServicesAdvanced Analytical Applications Infrastructure Installation Guide Release 8.1.2.0.0.3.4Bugs Fixed in this ReleaseThere are no modifications and bug fixes included in Oracle Financial Services Data Foundation ApplicationPack Release v8.1.2.2.1.3.5Known Issues or LimitationsThere are no Known Issues or Limitations in the Oracle Financial Services Data Foundation ApplicationPack Release v8.1.2.2.1.H ARDWARE AND S OFTWARE T ECH S TACK D ETAILSK NOWN I SSUES OR L IMITATIONS4Hardware and Software Tech Stack DetailsThe hardware and software combinations required for the OFS Data Foundation Application Pack Releasev8.1.2.0.0 are available in the Oracle Financial Services Analytical Applications (OFSAA) Technology MatrixRelease 8.1.2.0.0.5Licensing InformationFor details on the third party software tool used, see the Oracle Financial Services Analytical Applications(OFSAA) Licensing Information User Manual Release 8.1.2.0.0 available in the OHC Documentation Library.OFSAA S UPPORTOFSAA SupportRaise a Service Request (SR) in My Oracle Support (MOS) for queries related to the OFSAA Applications.S END U S Y OUR C OMMENTSSend Us Your CommentsOracle welcomes your comments and suggestions on the quality and usefulness of this publication. Yourinput is an important part of the information used for revision.•Did you find any errors?•Is the information clearly presented?•Do you need more information? If so, where?•Are the examples correct? Do you need more examples?•What features did you like most about this manual?If you find any errors or have any other suggestions for improvement, indicate the title and part numberof the documentation along with the chapter/section/page number (if available) and contact the MyOracle Support.Before sending us your comments, you might like to ensure that you have the latest version of thedocument wherein any of your concerns have already been addressed. You can access My Oracle Supportsite that has all the revised or recently released documents.。
OBIEE Metadata Repository Deployment Guide Oracle FLEXCUBE Investor ServicingRelease 14.5.2.0.0[November] [2021]Table of Contents1.OBIEE METADATA REPOSITORY DEPLOYMENT GUIDE ................................................................ 1-1 1.1I NTRODUCTION........................................................................................................................................... 1-11.1.1Layers in RPD .................................................................................................................................... 1-11.1.2FCIS OBIEE RPD .............................................................................................................................. 1-2 1.2P REREQUISITES........................................................................................................................................... 1-21.2.1Hardware / Software Required .......................................................................................................... 1-2 1.3D EPLOYMENT IN OBIEE ............................................................................................................................ 1-31.3.1Rpd Connection Changes ................................................................................................................... 1-31.3.2Deploying RPD ................................................................................................................................ 1-101. OBIEE Metadata Repository Deployment Guide 1.1 IntroductionThe Oracle Business Intelligence Server is a stand-alone process that maintains the logical data model which it provides to BI Presentation Services via ODBC. Metadata is maintained for thedata model in a local proprietary file called the repository file (rpd). On the back-end, the BIServer connects to customer data stores via data source adaptors.1.1.1 Layers in RPDThe Physical layer defines the data sources to which Oracle BI Server submits queries and therelationships between physical databases and other data sources that are used to processmultiple data source queries. The recommended way to populate the Physical layer is byimporting metadata from databases and other data sources. The data sources can be of thesame or different varieties. You can import schemas or portions of schemas from existing datasources. Additionally, you can create objects in the Physical layer manually.When you import metadata, many of the properties of the data sources are configuredautomatically based on the information gathered during the import process. After import, you can also define other attributes of the physical data sources, such as join relationships, that might not exist in the data source metadata. There can be one or more data sources in the Physical layer, including databases, spreadsheets, and XML documents. In this example, you import andconfigure tables from the sample SH schema included with the Oracle 10g database.The Business Model and Mapping layer of the Administration Tool defines the business, orlogical, model of the data and specifies the mappings between the business model and thePhysical layer schemas. This is where the physical schemas are simplified to form the basis forthe users’ v iew of the data. The Business Model and Mapping layer of the Administration Toolcan contain one or more business model objects. A business model object contains the business model definitions and the mappings from logical to physical tables for the business model.The main purpose of the business model is to capture how users think about their business using their own vocabulary. The business model simplifies the physical schema and maps the users’business vocabulary to physical sources. Most of the vocabulary translates into logical columns in the business model. Collections of logical columns form logical tables. Each logical column (and hence each logical table) can have one or more physical objects as sources.There are two main categories of logical tables: fact and dimension. Logical fact tables containthe measures by which an organization gauges its business operations and performance. Logical dimension tables contain the data used to qualify the facts.The Presentation layer is built after the Physical layer and Business Model and Mapping layerand adds a level of abstraction over the Business Model and Mapping layer. It is the view of the data seen by end users in client tools and applications, such as Oracle BI Answers. ThePresentation layer provides a means to further simplify or customize the Business Model andMapping layer for end users. For example, you can organize columns into catalogs and folders.Simplifying the view of the data for users makes it easier to craft queries based on users’business needs because you can expose only the data that is meaningful to the users, organize the data in a way that aligns with the way users think about the data, and rename data asnecessary for the set of users.You typically create Presentation layer objects by dragging objects from the Business Model and Mapping layer. Corresponding objects are automatically created in the Presentation layer.Presentation layer objects can then be renamed and reorganized.1.1.2 FCIS OBIEE RPDIn FCIS OBIEE we have a single RPD. In this document we will see how merge a RPD to FCISMetadata RPD. We will also see how to deploy sample dashboards generated using these RPDs.1.2 Prerequisites1.2.1 Hardware / Software Required1.3 Deployment in OBIEE 1.3.1 Rpd Connection Changes1. Open OBIEE Administration tool.2. Open rpd in offline mode.3. Enter Password: Weblogic123 and click ‘OK’.4. Double click on connection pool.5. Change Data source name.6. Change Data source name for the marked info given in the below format:(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <Host Address>)(PORT = <Port>)))(CONNECT_DATA = (SERVICE_NAME <Servicename>) ) )7. Enter User ID and password and click OK. Again enter the same password when it prompts.Save the Rpd changes.8. Click ‘OK’ and the follwing screen is displayed:9. Click ‘OK’ and the following screen is displayed:10. Click ‘’Yes.11. Click ‘’Close in below window.1.3.2 Deploying RPDEarlier OBIEE RPD deployment was through Enterprise manager, now a command from putty.sh data-model-cmd.sh uploadrpd -I <rpd name> -W <RPD password> -SI ssi -U <console user name> -P <console password>Eg: sh data-model-cmd.sh uploadrpd -I FCIS.rpd -W weblogic123 -SI ssi -U weblogic -Pweblogic123.OBIEE Metadata Repository Deployment Guide[November] [2021]Version 14.5.2.0.0Oracle Financial Services Software LimitedOracle ParkOff Western Express HighwayGoregaon (East)Mumbai, Maharashtra 400 063IndiaWorldwide Inquiries:Phone: +91 22 6718 3000Fax:+91 22 6718 3001/financialservices/Copyright © [2007], [2021], Oracle and/or its affiliates.Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial computer software" or "commercial computer software documentation" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate failsafe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.This software or hardware and documentation may provide access to or information on content, products and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.。
Business Integration for the 21st Century Peter BelknapORACLE PRODUCT LOGOProgram Agenda•21st Century Integration Landscape •Oracle SOA Suite and BPM Suites –Industrial SOA for Integration Everywhere –Business-Driven Process ImprovementIntegration or Extension? Oracle Fusion Middleware“Extension”Platform“Integration”PlatformMeeting the “Data Tsunami” ChallengeMuch more data, many more events need to be handledmuch more quicklyNew and existing business processes need to be integrated reliably, securely,and inexpensivelyOperators and customers expectincreased visibility and control IT must respond with a flexible, secure, scalable infrastructureAd Hoc Point to Point IntegrationStandards-based Service Oriented ArchitectureDeclarative Re-use Building a Successful Service-Oriented ArchitectureVisibility, Control, AnalyticsEnterprise SecurityOracle Identity Access, RiskMgmtOracle SOA GovernanceCanonicalServicesLoosely Coupled Layered Architecture Core Business ApplicationsOracle BPEL PM,CEP Oracle AIAOracle Service Bus ERP , Custom ApplicationsExadata Cloud Application Foundation on ExalogicSUNOracle BI, BAM WebCenterIntegration Landscape•Complete•Best-in-Class •Integrated •OpenOracle Fusion MiddlewareUser Engagement User EngagementIdentity Management & Security Identity Management & SecurityBusiness ProcessManagement Management ContentManagement Management BusinessIntelligence IntelligenceService Integration Service Integration Data Integration Data IntegrationDevelopment DevelopmentTools ToolsCloud ApplicationFoundation FoundationEnterprise EnterpriseManagement ManagementWebSocialMobileKey Usages Of SOA in Fusion AppsUsage Category Description UsageProcess Customization (for Developers) Allow developers to customize process to suitbusiness needs.•Simple sequential BPEL process steps.•Customer can modify steps.Human Workflow Support human workflow with complexapprovals including approval hierarchies •Most important usage by many fusion apps•Manual task or approval tasksIntegration Decouple external systems. Allows bringingnew systems online without changing coreProcesses •Mediator is an example•End to End Integration •Flexibility with Rules based routingProcess Composition (for Business Analysts) Make it easier for business analyst to modifyprocess at runtime.•Business Analysts arrange orchestrationflow of “pre-canned” tasks / processes•Process Composer use caseLong Running or Batch Processing Support Batch processing and other longrunning jobs as scheduled /async processes •Executed as a batch or is a long running process•Processing itself happens outside •Orchestration, fault handling and compensations are keyEvent Processing Support event processing using SOA model. •Event driven integration•Events to add flexibility and loose coupling2. Process DecompositionDecomposition of Long Running Processes• BPEL for main process and subprocesses • Rules• Mediator (dynamic routing) • Asynchronous services1. Human ApprovalsHuman Interactions within the process (most prevalent)• BPEL (or BPMN)• Human Tasks/AMX with HCM integration• Rules for dynamic routing • ADF Task flows• Customizable Worklist• Actionable email notifications3. Business EventsDecoupling using business events•Events publication from ADF •Event Delivery Network•Async invocation of process, human tasks or ESS jobs5. Enabling Edge Integration4. Batch jobs6. Synchronous MicroflowsSynchronous Processes•Synchronous processes•Dynamic processing using rules •Straight through processing with BPEL & ADF services •SDO entity variablesLong Running batch jobs•Scheduler for time basedscheduling and job incompatibility •BPEL for orchestration•Asynchronous Services/jobs •ODI integrationEdge Integration•Dynamic endpoints•Support multiple protocols •Mediator with differenttransformations based on end point8. Process CompositionFusion Micro Patterns7. Activity GuideMultistep human interactions•BPEL/BPMN processes with human tasks•Activity guide metadata •ADF task flows•AG controls in apps UIBusiness user driven process composition•BPMN based process templates •BPMN/BPEL Rules, human workflow •BPM composer for customization •Service catalogApplication Integration ArchitectureSolutions Which Deliver Sustainable Integration•Powered by Oracle Fusion MiddlewareLeverage Oracle’s best -in-class, standards-based SOA Middleware platform•Reference Process ModelsOptimize business performance leveraging Oracle’s extensive experience and best practices•Pre-Built IntegrationsAccelerate implementation of discreet business processes using AIA’s pre -built integrations across Oracle Applications•Foundation PackBuild cross-functional business processes across any of your applications utilizing a standardized approach and methodologyComplete. Open. Integrated.BPM SuiteProcess ManagementRegistry &Repository Service ManagementSOA Governance ProcessIntegration B2B IntegrationSOA Suite ODI SuiteBulk DataProcessing Data QualityFoundation PackReference ProcessModelsCommon Objects & Standard Shared ServicesSOA/BPM Framework &MethodologyDeveloper UtilitiesPre-Built IntegrationsPackaged Integration Accelerators For Specific Applications & Processes:Process Integration Packs and Direct IntegrationsArtifactsPoliciesImplementationEfficiency, Reuse & ConsolidationSecuritySystematic Enforcement of PolicyDefinitionBusiness/IT AlignmentMetadataMonitoring andManagementProduction Assurance for SLAsOracle Governance SolutionComplete solution for Application Integration ProjectsArchitects Business OwnersDesignersITOperationsRelease ManagementDevelopers &IntegratorsSecurity EngineersConsumer Provisioning& LEADING IDEs & LEADING IDEs& ENTERPRISE GATEWAY & ENTERPRISE GATEWAYEnterprise Repository for Oracle Fusion Applications https://Program Agenda•21st Century Integration Landscape •Oracle SOA Suite and BPM Suites –Industrial SOA for Integration Everywhere –Business-Driven Process ImprovementConnect & normalizeAdaptersERP MAINFRAME SERVICES PARTNERSDB •Over 200 adapters•For all technologies & applications: EBS, PSFT, Siebel, SAP , Databases, Files, FTP , JMS, MQ, B2B, etc. •Graphical introspection of target •Abstract complexity of underlying applications•Convert from proprietary formats to XMLTPS TPSmsg msg/s /s1,000’sservicesservices Virtualize, route, scaleOracle Service BusERPMAINFRAMESERVICES PARTNERSDB SERVICE BUS SERVICE BUS•Foundation for yourshared services infrastructure•Convert from one protocol and format to another, on the fly (ex: consume a Mainframe service from .NET over SOAP)•Add scalability through cachingOracleCoherence Data GridWorklistPortalMS Office MAINFRAME Online ShoppingMobile DevicesApplicationInstance 1ApplicationInstance 2Application Instance 3Proxy Services•Enforces agility by replacing direct coupling with a flexible virtual endpoint to the consumerXBusiness Services•Access service from multiple endpoints•Ensures high availability when apps go down and during maintenance ORACLE SERVICE BUSOracle Service Bus - Service Virtualization,Automated Service PoolingOracle Service BusKey Ingredients for an Enterprise Service BusUnified SecurityFTP MQ Adaptive MessagingSMTP MetadataReportingSLA AlertsContent Based RoutingTransformation Import / Export Validation Service ManagementService VirtualizationConfiguration Framework HTTP/S JCAJMSFile Change CenterMonitoringWSRM Tux EJBService ChainingREST AuthenticationAuthorization Identity Sign/EncryptJDBC AQ SAP EBS PSFT JDE SBLReduced RiskService results available even when application is downImproved PerformanceEliminate repeated application requests for static dataPredictable ScalabilityCached results maintained internally resulting in less dependence on 3rd party service provider availabilityScalability & PerformanceService Result Cache – Coherence in the boxCRM SalesERPBusiness AppsXCloud Vendor ACloud Vendor BENTERPRISE SERVICE BUSResult accessedfrom cache Result accessed from cacheERP MAINFRAME SERVICES EVENTSPARTNERS DB BPEL & BPMN BPEL & BPMN BUSINESS RULES BUSINESS RULES HUMAN WORKFLOW HUMAN WORKFLOW SERVICE BUS SERVICE BUSOrchestrateStandards-based BPEL & BPMN•Build process logic•Involve people(human workflow) as well as systems •Self-describinggraphical design-time environment•Build compensation logic for non-transactional servicesUnified Platform for Services, Events & Processes Unified Process PlatformProtocol BindingsDeclarative Composite AssemblySOA Composite Editor•Drag & Drop•Visual•Single Unit ofDeployment•Easyversioning•Based onSCA standardBuilt-In Business RulesHuman Workflow ServiceWorkspace applicationHuman Workflow ServiceWSDLTaskHuman Workflow MetadataProcess(BPMN/BPEL)ADF task flow to show work item details in workspaceTaskCompletedAssign TasksSupervisor Task Assignee Process OwnerTask Metadata including routing slip, AMX stage and list builder configurationsRules engineProcess ComposerBusiness Analyst-Driven Process ModelingSimple Drag andDrop ProcessModelingLeverage Existing Models •Import Visio and XPDL modelsBusiness IT CollaborationSingle Model From Modeling to ExecutionStudio – Comprehensive IDE for Developers Empower business analyst withcatalog of implementationartifactsSingle BPMN 2.0modelSimulate Before You ImplementKPIsRich set of ChartsQueue Buildups and What-ifsAdd security, management, governance and eventingCOMPLEXEVENT PROCESSINGBAMEM JDev WebPOLICY MANAGERERP MAINFRAME SERVICES PARTNERS DB BPEL & BPMN BPEL & BPMN BUSINESS RULES BUSINESS RULES HUMAN WORKFLOW HUMAN WORKFLOWSERVICE BUS SERVICE BUSDATA INTEGRATOR DATA INTEGRATORGOLDENGATE GOLDENGATEEVENTSClearly separates: •process logic from•security concernsCentralized policy management & visibility: versioning, rollback, auditing Global, Policy-driven SecurityAttach/detach policies at design-time…(right in JDeveloper)Or attach/detach policies at runtime, after deployment(in Enterprise Manager)•All-in-onemanagement console•End-to-end (process) instance tracking•No explicit work required fromdeveloper to enable tracing •Unified error handlingBPELHuman Workflow Routing Business RulesExternal ServiceDrill downDrill-down intocomponentsOut-of-the-box visibilityEnd-to-end instance tracking in Enterprise Manager•Unified exception handling framework (“Error hospital”):•Search•Delete•Recover failed instances(individual or batch)•Directly access corresponding log entriesRecoveryActionRecoveryscreenEdit payloadFaults &exceptionslogExceptions HandlingMonitor ExpressInstrument BPEL processesright from JDeveloperAvailable Monitor Objects:Interval / Counter / CaptureFeed into pre-builtBAM dashboards(or build your own)BI Views for BPMN processesOracle Business Activity Monitoring Meaningful, Event-driven Visibility for Business Users Monitor business processes & services in real-timeKey Performance Indicators (KPIs)Service-Level Agreements (SLAs)Analyze events as they occurCorrelate events & KPIsIdentify trends as they emergeAlert users to bottlenecks & solutionsAct on current conditionsEvent-driven alertsReal-time dashboardsBPEL processes & web services integrationReal Time Data CollectionOracle BAMJ M S B u s MS MQ IBM MQ Tibco Oracle AQSonic JMS 1.1 D a t a b a s eSQL ServerSybase Oracle JDBC File SystemWeb ServiceBPM/BPEL/OSB/B2B Oracle E-Business Real-time alertsReal-timedashboard/reportsD a t a S o u r c e sCall Web ServiceDB2 Enterprise ManagerBAM Adapter ODIOracle BAM: Architected for IntegrationInternetBAM DashboardsWebApplicationsStartPage ActiveViewer ActiveStudio Architect AdministratorReportServeriCommandOracle Database(Grid)BAM Data & Metadata External Data ObjectsWebServicesInternetEnterprise Integration FrameworkApplication ServerBIWeb ServicesJMS ConnectorBAM AdapterADFBAM DataControlADF Pages with DVTBAM ServerEventEngineActions & Escalations Notification ServicesReportCacheSnapshots & Change Lists Memory / DiskActiveDataCacheViewSets API KernelDataSets DataStorageEngineODIDatabasesOLTP & Data Warehouses Mobile DevicesData & Metadata Import & ExportBPELBPMMessage Queues CEPOESBNorwegian Shipping Insurance CompanyProject Metrics:Single developer (OSB, jQuery)Just a couple of months to productionWebcache HTTPSOAPDMZ OpenText eDocsOSBIntranetDMInternetjQueryRESTCRMCustomer dataclaim documentsUsed Oracle SOA Suite to provide single-view across internal and cloud applications•65,000 suppliers and 1,200+ retailers worldwide: Wal-Mart, Amazon, Rite-Aid, Ford, …✓Oracle Fusion Middleware reduced processing times by 10x✓Multi-tenant single instance installation provides economies of scaledocument enrichment, transformation and routing•Purchase orders (PO) •Advanced Shipping Notices (ASN) •Catalogs•Inventory inquiries •etc.retailers suppliersOracle B2BEDIEDIOracle B2BProject Metrics:•50,000 business docs/hr (peak)•600,000 BPELinstances/hr (peak)•Growing fast (over 7 million BPEL instances on Black Friday!)•Dehydration store close to 1TB a daySPS CommerceOracle SOA Suite used to build a public cloudMobile Applications built on Oracle SOA SuiteEvent Processing Use Cases Financial Services Homeland SecurityAlgorithmic trading Fraud Detection, digital marketing•Filter, correlate and aggregate events from high volume streams with consistent low latency •Handle disparate event and data sources•Facilitate time window processing•Recognize and act on complex patterns•Manage your data before it reaches your database•Protect your core business processes from the “data tsunami” Threat detection, sensor datacorrelation, emergency responseTelecommunications & ServicesMeter alarm filteringPower restoration confirmationMobile work unit tracking UtilitiesOracle Event Processing (OEP)❑ Lightweight OSGI-based container❑ SQL99-compliant Continuous Query Language (CQL)❑ Tight integration with Oracle Coherence and Oracle Spatial❑ Deploy on a high-end server in the datacenter or on a small server in remote locationsLocation Proximity Tracking Highlights “Interest” Area (ZONES)Smart Grid - UtilitiesFinancial Services - Best ExecutionOracle SOA Suite directionsOracle has the most complete stack today Oracle has the most integrated stack today → No technology disruption in 12cFocus areas:→ Industrial SOA→Developer’s productivity→Integration Everywhere (Cloud, Mobile, …)Industrial SOA“heavy duty”“Individual manual labor is often replaced by mechanized mass production and craftsmen are replaced by assembly lines.“1.More out-of-the-box productivity:1.Templating2.Zero-config dev environments3.Mapping improvements2.Performance & Scalability3.Diagnosability4.Built-in GovernanceIndustrial SOAExalogic: Extreme Performance SOA and BPM Platform •High-Performance Compute Nodes•Integrated Storage•InfiniBand Interconnect Fabric•Tuned and Optimized SOA Platform:520ms•Faster XML Processing9X •Scalability optimizations•Platform Optimizations58msOracle SOA and BPM Suites - Summary•The most complete & integrated offering •Mature, widely adopted – and growing faster than any other solution•Stable roadmap→The leading and most capable integration stack→Technical Documentation:/cd/E23943_01/soa.htm。
产品介绍Oracle Analytics Server 是一款本地部署的自助服务可视化和增强人工智能(AI) 分析平台。
它提供了全方位的功能,包括快速显示数据集的关键洞察的AI,自动推荐分析新元素的数据丰富功能,支持传统和公民数据科学家的机器学习(ML) 功能,以及令人惊叹的数据可视化,可提供具有像素完美报告功能的仪表板。
Oracle Analytics Server 建立在久经考验的现代技术基础上,支持超高的工作负载和复杂部署,同时以较低的总拥有成本为企业的每个用户提供及时的洞察。
企业现在可以通过移动、平板电脑和所有现代浏览器为需要访问分析数据的所有用户提供易于使用的界面,通过导入或混合数据,执行分析或安全地分发报告来实现分析平台的现代化。
客户可以选择自管理本地部署或私有云部署Oracle Analytics Server,可以按计划管理升级,并实施自定义选项,如自定义外观/样式、元数据、消息传送等。
Oracle Analytics Server 是现有 Oracle 商业智能企业版客户的轻松升级选项。
主要特性•自助式数据可视化功能•带有解释的增强分析•数据流中的机器学习•数据丰富能力•强大的地理空间映射和可视化•简便易用的即席查询和分析•像素完美的企业报告•通用企业信息模型Oracle Analytics Server — 功能概览∙增强分析:Oracle Analytics Server 将机器学习和 AI 嵌入了分析过程的每个方面,从而支持深度洞察,让您可以轻松完成分析工作。
该解决方案能够显著增强从智能数据准备到数据探索的整体分析体验,并通过提供基于自然语言处理的现代对话式分析来简化用户体验。
在后台,Oracle Analytics Server 运行聚类、分类和关联以发现洞察。
只需单击一下,即可将这些令人惊叹的可视化效果内置到仪表板中。
∙数据丰富:Oracle Analytics Server 数据丰富功能可自动推荐数据元素,包括时间分析所需的值(月份,星期,工作日等),用于映射的地理空间值,用于对元素进行分类数据中的模式识别,并集成机器学习,通过用于洞察的算法丰富数据集。
使用Oracle Metadata Services 构建可定制应用程序用实例介绍针对个性化和定制的Oracle ADF 服务作者:John Stegeman2010 年5 月发布下载:如今,应用程序用户希望他们经常使用的应用程序能够记住他们喜欢的工作方式,从而无需每次登录时都重新设置应用程序。
例如,用户希望他们常用的搜索和屏幕布局日复一日地保持不变,以便他们更加轻松直观地使用应用程序。
利用Oracle Metadata Services 提供的基础,Oracle Application Development Framework (ADF) 应用程序可以提供这样的持久个性化。
本文介绍如何配置您的Oracle ADF 应用程序以允许最终用户进行定制。
桌面应用程序用户习惯于能够设置并保存他们的个人应用程序首选项。
例如,Oracle JDeveloper 11 g用户可以重排应用程序窗口并设置其他首选项,并且认为当他们退出Oracle JDeveloper 11 g并在第二天返回时,他们的首选布局和其他选项不会发生变化,和退出之前一样。
通过以这种方式保存个人首选项,用户能够以所需的工作方式来定制应用程序,从而提高工作效率。
如今,许多应用程序是通过Web 浏览器提供的,将有越来越多的用户希望能够对基于Web 的应用程序进行同样的定制。
在新的应用程序中建立这样的可定制性可能需要花费大量开发时间;开发人员需要构建一个框架将个性化设置保存到一个数据存储中并在运行时对特定用户应用这些个性化设置。
对于复杂的企业应用程序(如Oracle E-Business Suite),为构建这样的框架而付出努力很可能是值得的;但对于较小的应用程序,这种努力常常是不值得的。
幸运的是,对于使用Oracle ADF 的开发人员来说,Oracle 已为个性化和定制创建了服务并且已在Oracle ADF 中集成了这些服务,这些服务称为Oracle Metadata Services (MDS)。
Oracle E-Business Suite 版本11i 和12 使用了Oracle MDS 的前身以允许用户对自己的自助服务应用程序进行个性化设置,并允许应用程序管理员针对特定用户群定制应用程序的各个方面。
在Oracle JDeveloper 11 g中,开发人员可以利用这些功能为Oracle ADF Web 应用程序提供同样的功能。
本文撰写时使用的是Oracle JDeveloper 11 g (11.1.1.2)。
如果您使用所提供的示例应用程序,您将需要更改Application Navigator 中Application Resources 面板中定义的HR 连接的连接信息。
另请注意,要运行示例应用程序,您应遵循本文所述任何所需配置步骤。
一、Metadata Services 概念Oracle MDS 将定制和个性化信息存储在一个信息库中。
该信息库可以存储在数据库中,也可以存储在基于文件的存储中;由于可伸缩性和可靠性以及其他方面的原因,我强烈建议使用数据库存储MDS 信息库(本系列的下一篇文章将介绍如何配置该信息库)。
对于开发/测试/调试周期,与Oracle JDeveloper11 g集成的Oracle WebLogic Server 提供了一个本地MDS 信息库,这样您就不需要为进行开发而单独建立一个信息库了。
这个MDS 信息库可以存储各种类型的定制数据及其他元数据,包括:∙用户在运行时更改过的Oracle ADF Faces 组件的特定属性(例如,表中各列的顺序)∙用户保存的搜索条目(用af:query组件创建的)∙在设计时针对包括Oracle ADF Faces、Oracle ADF 业务组件和Oracle ADF 控制器(页面流)在内的各种Oracle ADF 内容开发的自定义设置∙对资源包的定制∙其他Oracle 产品(如Oracle B2B)的元数据∙Oracle WebCenter应用程序的元数据本文将介绍如何配置Oracle ADF 应用程序以允许最终用户在运行时进行定制,以及如何在开发环境下运行和测试可定制应用程序。
本系列中的下一篇文章将介绍如何创建设计时定制,以及如何配置基于数据库的MDS 信息库。
二、最终用户定制需求为了让一个Oracle ADF Faces 应用程序允许最终用户在运行时定制应用程序,您须执行以下几个步骤:∙配置Oracle JDeveloper 11 g项目以允许最终用户定制。
∙配置默认的自定义类。
Oracle JDeveloper 11 g文档未明确是否需要执行此步骤;但在实际中,我发现如果省略了此步骤则更改不会持久,并且我还在日志中观察到如下错误:图1如果未指定自定义类,日志中会出现警告∙针对要启用定制的Oracle ADF Faces 组件配置Oracle ADF 应用程序描述文件。
∙为了在af:query组件中保存用户查询,要配置一个元数据命名空间(如Oracle JDeveloper 11 g版本说明中所述—如果您使用的是Oracle JDeveloper 11 g 11.1.1.3 版,则不必如此)。
∙为了进行部署,您必须创建并注册一个Oracle MDS 信息库(随后的一篇文章将描述这一步骤)。
另外,您的应用程序还必须符合以下要求:∙您的Oracle ADF Faces 页面必须以XML 格式(.jspx) 保存,并且必须为页面中的每个用户可定制组件指定一个ID。
之所以有这些要求,是因为Oracle MDS 记录用户所进行的定制时使用的方式。
∙您的应用程序必须启用安全性。
这一要求是为了让Oracle MDS 有一个身份,凭借这个身份来保存用户定制。
实际上,您首次创建Oracle ADF 应用程序时,执行所有要求的步骤是最容易的,因为Oracle JDeveloper11 g会替您配置一些设置项(如自动以XML 格式创建您的Oracle ADF Faces 页面)。
1.第 1 步:创建示例应用程序模型层为了演示如何配置和测试最终用户定制,我将使用一个简单的应用程序。
为了开发和运行该示例应用程序,您需要访问一个安装了HR 示例模式的Oracle 数据库。
(您可以从这里下载Oracle Database 快捷版(XE),这是Oracle Database 的一个免费版本。
)首先,您将创建该应用程序并创建一些默认的Oracle ADF 业务组件。
然后,在您创建任何Oracle ADF Faces 页面之前,您将配置该应用程序使其支持定制。
最后,您将创建和测试一些可定制的页面。
您可以执行下面总结的步骤来创建该应用程序,也可以下载示例应用程序。
如果您愿意亲自创建该应用程序,请执行下面的步骤(我相信您已具备Oracle JDeveloper11 g的一些基本经验,因此这里提供的是简要的步骤):1. 创建一个新的Fusion Web Application (ADF),具体做法是从Oracle JDeveloper 11 g的File菜单中选择New,然后从New Gallery中选择相应的选项:图2创建一个新的Fusion Web Application为该应用程序指定一个名称并接受所有默认设置,完成该应用程序的创建。
2. 右键单击Model 项目,然后选择New,这将启动Business Components from Tables向导。
创建一个到HR 示例模式的数据库连接并创建以下Oracle ADF 业务组件:a. EMPLOYEES 表的一个实体对象b. 一个基于EMPLOYEES 实体对象的可更新的视图对象c. 没有只读视图对象(在向导的这一步只需单击Next)d. 一个默认的应用程序模块(一旦到达向导这一步,您就可以单击Finish了)如果您愿意,可以通过右键单击该应用程序模块并选择Run来测试您创建的Oracle ADF 业务组件。
您应该能够双击EmployeesView1视图对象实例并滚动浏览数据库中的员工。
2.第 2 步:配置应用程序使其支持用户定制如本文前面所述,理想情况下,您应在开始创建任何Oracle ADF Faces 页面之前配置应用程序以使其支持最终用户定制。
要配置该应用程序,执行以下步骤:1. 在Application Navigator 中双击ViewController项目以显示项目属性。
选择ADF View节点,通过选择对应的选项在会话上启用用户定制,然后单击OK:图3在ViewController项目中启用用户定制2. 使用Application Navigator,展开Application Resources部分,双击adf-config.xml文件(该文件位于Descriptors文件夹的ADF META-INF子文件夹下):图4找到adf-config.xml 文件3. 为了让运行时更改真正地持久生效,必须至少注册一个自定义类。
单击Add图标添加一个自定义类。
在Edit Customization Class对话框中,指定erCC作为该自定义类的名称(这是Oracle ADF 提供的默认自定义类;这里不使用该UserCC自定义类的功能,但为了让个性化生效,必须指定一个自定义类),然后单击OK:图5指定自定义类4. 指定哪些Oracle ADF Faces 11 g组件应允许最终用户定制。
为此,选择adf-config.xml 编辑器的View部分,然后使用Add按钮添加特定组件。
对于我们的示例应用程序,我们将允许用户定制表中各列的顺序、大小及其他(通过对列组件启用定制来实现),并且允许用户定制是否显示特定的面板框(通过对panelBox组件启用定制来实现):图6将panelBox添加到可定制组件列表中。
当您将column 和panelBox这两个组件添加到可定制标签列表之后,该编辑器应如下所示:图7 adf-config.xml 编辑器显示column 和panelBox为可定制标签如果您愿意,还可添加其他组件并指定这些组件的哪些特定属性将持久保存。
有关默认情况下可持久保存的Oracle ADF Faces 组件及其属性,可参阅此文档。
5. 如Oracle JDeveloper 11 g版本说明中所述,为了对用户保存的查询启用持久性(针对af:query组件),您必须手动更改adf-config.xml文件的配置;如果您使用的是Oracle JDeveloper 11 g 11.1.1.3 版,则不必进行手动更改。
为了进行更改,单击adf-config.xml 编辑器的Source选项卡以显示该文件的XML 源代码。