Transcription

HYPERION DATA INTEGRATION MANAGEMENTRELEASE 11.1.1.1.0INSTALLATION GUIDE

Data Integration Management Installation Guide, 11.1.1.1.0Copyright 2007, 2008, Oracle and/or its affiliates. All rights reserved.Authors: EPM Information Development TeamThis software and related documentation are provided under a license agreement containing restrictions on use anddisclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement orallowed 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 decompilationof 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 findany errors, please report them to us in writing.If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S.Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS: Programs, software, databases, and relateddocumentation and technical data delivered to U.S. Government customers are "commercial computer software" or"commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplementalregulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions andlicense terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Governmentcontract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007).Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.This software is developed for general use in a variety of information management applications. It is not developed orintended for use in any inherently dangerous applications, including applications which may create a risk of personalinjury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe,backup, redundancy and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaimany liability for any damages caused by use of this software in dangerous applications.This software and documentation may provide access to or information on content, products and services from thirdparties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind withrespect to third party content, products and services. Oracle Corporation and its affiliates will not be responsible for anyloss, costs, or damages incurred due to your access to or use of third party content, products or services.

ContentsChapter 1. Installation Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5Data Integration Management Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5Chapter 2. Data Integration Management Workflow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7Chapter 3. Data Integration Management Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9Data Integration Management Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9Informatica PowerCenter System Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9Operating Environments for Data Integration Management Adapters . . . . . . . . . . . . . . . . 9System Requirements for Data Integration Management Adapters . . . . . . . . . . . . . . . 10Client Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10Server Operating System/Processor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11Third-Party Software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12Release Compatibility for Data Integration Management Adapters . . . . . . . . . . . . . . . . . . 12Upgrading Data Integration Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13Upgrading Data Integration Management Adapters . . . . . . . . . . . . . . . . . . . . . . . . . 13Upgrading Informatica PowerCenter (Optional) . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13Setup Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14Chapter 4. Data Integration Management Adapters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15Data Integration Management Adapter Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15Installing Data Integration Management Adapters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16Data Integration Management Adapters' Installation Files for Client and Server Plugins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16Installing Data Integration Management Adapters' Client Plug-ins . . . . . . . . . . . . . . . 17Installing Data Integration Management Adapters' Server Plug-ins . . . . . . . . . . . . . . . 18Updating the Environment Variables for DIM Adapter for Essbase . . . . . . . . . . . . . . 20Configuring Application Connections . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21Uninstalling Data Integration Management Adapters . . . . . . . . . . . . . . . . . . . . . . . . . . . 22Contentsiii

ivContents

Installation Overview1In This ChapterData Integration Management Components. 5Data Integration Management ComponentsOracle's Hyperion Data Integration Management is integrated with Informatica PowerCenterand with adapters for these products: Oracle Essbase Oracle Hyperion Financial Management, Fusion Edition Oracle's Hyperion Enterprise Oracle Hyperion Performance Scorecard, Fusion Edition Oracle Hyperion Planning, Fusion Edition Oracle's Hyperion Translation ManagerData Integration Management provides a way of uniting disparate data sources across anenterprise. For example, it can integrate data stored in multiple warehouses and data marts,relational database management systems (RDBMS), and online analytical processing (OLAP)stores.Components of Data Integration Management: PowerCenter applications: PowerCenter client PowerCenter serverData Integration Management Adapters: Oracle's Hyperion Data Integration Management Adapter for Essbase Oracle's Hyperion Data Integration Management Adapter for Financial Management Oracle's Hyperion Data Integration Management Adapter for Hyperion Enterprise Oracle's Hyperion Data Integration Management Adapter for Performance Scorecard Oracle's Hyperion Data Integration Management Adapter for Planning Oracle's Hyperion Data Integration Management Adapter for Translation ManagerData Integration Management Components5

6Installation Overview

Data Integration ManagementWorkflow2The following table lists the high-level steps required to install and configure Data IntegrationManagement. Review these steps first, before you begin the installation process. For detailedinformation, refer to the component user interface and related documentation listed at eachstep.Table 1WorkflowSTEPINSTRUCTIONPRODUCT COMPONENTDOCUMENTATION1.Install PowerCenter 8.1.1.PowerCenter InstallerInformatica PowerCenter 8.1.1Installation and Configuration GuideNote: If you have an earlierversion of PowerCenter installedon your computer, upgrade it toPowerCenter 8.1.1.2.Upgrade to PowerCenter 8.1.1SP3.PowerCenter Service PackInstallerInformatica PowerCenter 8.1.1 SP3Service Pack Installation Guide3.Configure PowerCenter.PowerCenter InstallerInformatica PowerCenter 8.1.1Installation and Configuration Guide4.Install and configure therequired Oracle Product forwhich you want to provide dataintegration managementcapability.Oracle Hyperion EnterprisePerformance ManagementSystem Installer Oracle Hyperion EnterprisePerformance ManagementSystem Installation Start Here Oracle Hyperion EnterprisePerformance ManagementSystem Installation andConfiguration Guide Oracle Hyperion EnterprisePerformance ManagementSystem Installation andConfiguration TroubleshootingGuide Oracle Hyperion EnterprisePerformance ManagementSystem Installation andConfiguration Readme Oracle Hyperion EnterprisePerformance ManagementSystem SSL Configuration Guide Oracle Hyperion EnterprisePerformance Management7

STEPINSTRUCTIONPRODUCT COMPONENTDOCUMENTATIONSystem Security AdministrationGuide5.Install the required DataIntegration ManagementAdapter. Oracle Hyperion EnterprisePerformance ManagementSystem Lifecycle ManagementGuide Oracle Hyperion EnterprisePerformance ManagementSystem Backup and RecoveryGuide Oracle Hyperion EnterprisePerformance ManagementSystem Manual DeploymentGuide Oracle Hyperion EnterprisePerformance ManagementSystem High Availability GuideData Integration Managementadapter installation files incompressed formatThis guide, Hyperion Data IntegrationManagement Installation Guide.Informatica PowerCenterAdministration ConsoleThis guide, Hyperion Data IntegrationManagement Installation Guide.Note: If present, uninstallearlier releases of DataIntegration Managementadapters installed on yourcomputer.6.8Configure Data IntegrationManagement Adapter.Data Integration Management Workflow

Data Integration ManagementRequirements3In This ChapterData Integration Management Components. 9Informatica PowerCenter System Requirements . 9Operating Environments for Data Integration Management Adapters. 9Release Compatibility for Data Integration Management Adapters .12Upgrading Data Integration Management .13Setup Options .14Data Integration Management ComponentsThe requirements for Data Integration Management components can be broadly classified asInformatica PowerCenter requirements and Data Integration Management adapterrequirements.Informatica PowerCenter System RequirementsYou must have the system requirements and supported operating systems before you installInformatica PowerCenter. For Informatica PowerCenter 8.1.1 hardware and softwarerequirements, see these documents: The Informatica PowerCenter 8.1.1 Installation and Configuration Guide—Chapter 3,“PowerCenter Prerequisites.” The Informatica PowerCenter 8.1.1 SP3 Service Pack Installation Guide—“Step 1 – VerifyingMinimum System Requirements.”Operating Environments for Data Integration ManagementAdaptersYou must have the required operating environments for the Data Integration Managementcomponents to work correctly.Data Integration Management Components9

System Requirements for Data Integration ManagementAdaptersThis section describes system requirements for Data Integration Management Adapters. Theinformation includes requirements for Data Integration Management Adapter plug-ins forclient and server.Client RequirementsData Integration Management Adapter for client components have the following systemrequirements:General requirements: “Client Operating Systems” on page 10.Third-party requirements “Other Third-Party Software” on page 11.Client Operating SystemsOperating SystemProcessorWindows:x86-32 Windows Vista (all editions except Home series) Windows XP Professional SP2 Windows Server 2003 SP1 (R2 is also supported)*OracleNotesWindows 2003 SP1 also supports x86-64.*Hyperion Financial Data Quality Management, Fusion Edition Workbench client does not support x86-64.Runtime ClientsSome Data Integration Management Adapter for clients require the runtime clients of otherData Integration Management Adapter or third-party products. Data Integration ManagementAdapter for runtime client and server versions must match.For information on Data Integration Management Adapter product inter-operability, seeChapter 1, “Installation Overview.”Runtime ClientRequired For Essbase—The Essbase runtime client is installed automatically with the Essbaseinstallation.* DIM Adapter for Essbase Financial Management—The Financial Management client is installed automatically withthe Financial Management installation. DIM Adapter for Financial Management*IfInformatica server is installed on UNIX server, then you must install Essbase runtime client and DIM Adapter for Essbase on the UNIX server.10Data Integration Management Requirements

Disk Space and RAMDisk space and RAM requirements are approximate.The recommended RAM requirement for all clients is 1 GB.Product FamilyComponentDisk Space (Minimum)*NotesOracle's Data ManagementData IntegrationManagement Adapters128 MB175 MB for DIM Adapterfor Essbase (notincluding EssbaseRuntime Client)*Diskspace does not include the common client components installed on the machine with Oracle's Hyperion Foundation Services.Other Third-Party SoftwareSupported SoftwareNotesInformatica PowerCenter clientInstallation Informatica PowerCenter 8.1.1 SP3Server Operating System/ProcessorNote:Oracle VM 2.1 for Linux and Windows is supported as a virtualized environment. Forinformation on support for Oracle’s Oracle Hyperion Enterprise Performance ManagementSystem products in third-party virtualized environments, see