Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Restricted Use License of Oracle Life Sciences Data Hub with Oracle Health Sciences Clinical Development Analytics
• Intended Audience
• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Finding Documentation on Oracle Technology Network
• Related Documents
• Conventions

1 Before You Begin

• 1.1 Getting the Oracle Health Sciences Clinical Development Analytics Media Pack
• 1.2 Technology Stack and System Requirements
  • 1.2.1 Supported Browsers
• 1.3 General Security Principles
  • 1.3.1 Keep Software Up To Date
  • 1.3.2 Keep Up To Date on Latest Security Information Critical Patch Updates
  • 1.3.3 Configure Strong Passwords on the Database
  • 1.3.4 Follow the Principle of Least Privilege
  • 1.3.5 Managing Default User Accounts
  • 1.3.6 Closing All Open Ports Not in Use
  • 1.3.7 Disabling the Telnet Service
  • 1.3.8 Disabling Other Unused Services
  • 1.3.9 Designing for Multiple Layers of Protection
  • 1.3.10 Enabling SSL
• 1.4 Security Guidelines for Oracle Business Intelligence Data Warehouse Administration Console
• 1.5 Security Guidelines for Oracle Healthcare Master Person Index
• 1.6 Security Guidelines for Oracle Business Intelligence Enterprise Edition
  • 1.6.1 Checking External Links that May Expose Account Data
• 1.7 Installation Types
  • 1.7.1 Fresh Installation
  • 1.7.2 Upgrade Installation
• 1.8 Installing the Prerequisite Software
• 1.9 Creating an Oracle Life Sciences Data Hub User Account and Assigning Required Roles
  • 1.9.1 Creating an Oracle Life Sciences Data Hub User Account
  • 1.9.2 Creating Oracle Life Sciences Data Hub Database Accounts
  • 1.9.3 Database Accounts for Use in Definition
  • 1.9.4 Assigning Application Roles to the Oracle Life Sciences Data Hub User Account

2 Oracle Health Sciences Clinical Development Analytics Installation

• 2.1 About Oracle Health Sciences Clinical Development Analytics Installation
• 2.2 About the Oracle Universal Installer
  • 2.2.1 Requirements for Tablespace
• 2.3 Gathering Table Statistics
• 2.4 Running the CDA Installer on Windows
• 2.5 Running the CDA Installer on Unix
  • 2.5.1 Installing CDA on the Same Server as Oracle LSH
  • 2.5.2 Installing CDA on a Stand-alone Database Server

3 Post Installation Tasks

• 3.1 Creating Informatica Error Logging and Oracle Health Sciences Clinical Development Analytics Auxiliary Tables
• 3.2 Setting Up Service Locations
• 3.3 Setting Up Remote Locations in Oracle Life Sciences Data Hub
  • 3.3.1 Configuring Remote Locations for Passthrough Views
  • 3.3.2 Configuring Connections
  • 3.3.3 Configuring Load Set Attributes
• 3.4 Setting Up the Source System
  • 3.4.1 Creating Source Configuration Schema and Tables
• 3.5 Managing Source System Specific Requirements
  • 3.5.1 Fine-tuning Oracle Clinical Settings
  • 3.5.2 Handling Deletions in Siebel Clinical
• 3.6 Loading Oracle Health Sciences Clinical Development Analytics Seed Tables
• 3.7 Executing Oracle Life Sciences Data Hub Workarea Installation Script
• 3.8 Setting Oracle Health Sciences Clinical Development Analytics Repository Password
  • 3.8.1 Creating an OBIEE Remote Location
  • 3.8.2 Creating an OBIEE Remote Location Connection
• 3.9 Creating Security Groups and Application Roles for CDA
  • 3.9.1 Creating Groups
  • 3.9.2 Creating Application Roles
• 3.10 Emplacing the CDA Help and Image Files
  • 3.10.1 File Placement for Oracle WebLogic Managed Server
• 3.11 Preparing the OBIEE Web Catalog and Repository for CDA
• 3.12 Post Installation Tasks for Deduplication
  • 3.12.1 Deploying OCDA_PLS_ETL_WORKFLOW_PROC.SQL
  • 3.12.2 Setting Up Relational Connections in the Informatica Workflow for CDA
  • 3.12.3 Preparing a DAC Repository for CDA
  • 3.12.4 Creating Security Groups and Application Roles for CDA
    • 3.12.4.1 Creating Groups
    • 3.12.4.2 Creating Application Roles
  • 3.12.5 Setting Up OHMPI Projects (Optional)
    • 3.12.5.1 Creating JDBC Data Resources for an MPI Application Project for Oracle
    • 3.12.5.2 Creating JMS Resources for an MPI Application Project
    • 3.12.5.3 Deploying and Running Applications on Oracle WebLogic Server
    • 3.12.5.4 Setting Up the User
  • 3.12.6 Setting Up Informatica Server

4 Upgrade Tasks

• 4.1 Upgrading CDA 2.0.0.3 to CDA 2.1
  • 4.1.1 Installing CDA 2.1
    • 4.1.1.1 Executing LSH Script to Fix Source Independent Release Utility Issues
    • 4.1.1.2 Deleting Informatica Pool Programs
    • 4.1.1.3 Backing Up CDA RPD and Web Catalog to Preserve Customizations
    • 4.1.1.4 Migrating CDA 2.0.0.3 Data Warehouse to CDA 2.1
    • 4.1.1.5 Post Installation Steps for CDA 2.1
  • 4.1.2 Scheduling and Executing Extract Transform Load Jobs

Index