Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Finding Certification Information
• Finding Information and Patches on My Oracle Support
• Finding Documentation on Oracle Technology Network
• Related Documents
• Conventions

1 Before You Begin

• 1.1 Technology Stack and System Requirements
  • 1.1.1 Supported Browsers
  • 1.1.2 Source Systems
• 1.2 General Security Principles
  • 1.2.1 Keep Software Up To Date
  • 1.2.2 Keep Up To Date on Latest Security Information Critical Patch Updates
  • 1.2.3 Configure Strong Passwords on the Database
  • 1.2.4 Follow the Principle of Least Privilege
  • 1.2.5 Managing Default User Accounts
  • 1.2.6 Closing All Open Ports Not in Use
  • 1.2.7 Disabling the Telnet Service
  • 1.2.8 Disabling Other Unused Services
  • 1.2.9 Designing for Multiple Layers of Protection
  • 1.2.10 Enabling SSL
• 1.3 Security Guidelines for Oracle Business Intelligence Data Warehouse Administration Console
• 1.4 Security Guidelines for Oracle Healthcare Master Person Index
• 1.5 Security Guidelines for Oracle Business Intelligence Enterprise Edition
  • 1.5.1 Checking External Links that May Expose Account Data
• 1.6 Installing the Prerequisite Software

2 Installing Oracle Health Sciences Clinical Development Analytics Standard Configuration

• 2.1 Installing Oracle Health Sciences Clinical Development Analytics Standard Configuration
  • 2.1.1 Running the OHSCDA Installer
  • 2.1.2 Setting Up Relational Connections in the Informatica Workflow for OHSCDA
  • 2.1.3 Preparing a DAC Repository for OHSCDA
  • 2.1.4 Emplacing the OHSCDA Help and Image Files
    • 2.1.4.1 Placement of Files for Oracle WebLogic Managed Server
  • 2.1.5 Preparing the OBIEE Web Catalog and Repository for OHSCDA
  • 2.1.6 Configuring Maps
  • 2.1.7 Creating Security Groups and Application Roles for OHSCDA
    • 2.1.7.1 Creating Groups
    • 2.1.7.2 Creating Application Roles
  • 2.1.8 Setting Up OHMPI Projects (Optional)
    • 2.1.8.1 Creating JDBC Data Resources for an MPI Application Project for Oracle
    • 2.1.8.2 Creating JMS Resources for an MPI Application Project
    • 2.1.8.3 Deploying and Running Applications on Oracle WebLogic Server
    • 2.1.8.4 Setting Up the User
  • 2.1.9 Setting Up Informatica Server (Optional)
• 2.2 Managing Source System Specific Requirements
  • 2.2.1 Fine-tuning Oracle Clinical Settings
  • 2.2.2 Handling Deletions in Siebel Clinical

3 Upgrading Oracle Health Sciences Clinical Development Analytics

• 3.1 Migrating from OHSCDA 2.1 (Plus Configuration) to OHSCDA 2.2 (Standard Configuration)
• 3.2 Upgrading from OHSCDA 2.1 Standard to OHSCDA 2.2 Standard
  • 3.2.1 Upgrading Warehouse Database Version and Reconfiguring OBIEE and DAC Client
  • 3.2.2 Running the Installer in Upgrade Mode
  • 3.2.3 Next Steps
  • 3.2.4 Emplacing the OHSCDA Help and Image Files
    • 3.2.4.1 File Placement for Oracle WebLogic Managed Server
  • 3.2.5 Migrating Data from OHSCDA 2.1 to OHSCDA 2.2 (Standard Configuration)
  • 3.2.6 Setting Up the Informatica Server for Upgrade
  • 3.2.7 Redeploy following OHMPI projects into Oracle WebLogic
  • 3.2.8 Upgrading the Existing DAC Environment
    • 3.2.8.1 Back Up the Existing DAC Repository
    • 3.2.8.2 Upgrade the Current DAC Repository
  • 3.2.9 Importing the OHSCDA Warehouse Application Metadata into the DAC Repository
  • 3.2.10 Merging Changes into a New Oracle-supplied Repository

Index