1/8

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 Checking for the Most Recent Information
• 1.2 Technology Stack and System Requirements
  • 1.2.1 Supported Web Browsers
  • 1.2.2 Source Systems
• 1.3 Installing the Prerequisite Software

2 Installing Oracle Health Sciences Clinical Development Analytics

• 2.1 Adding InForm Studies to the OHSCDA Warehouse
  • 2.1.1 OHSCDA InForm Consolidation Schema
  • 2.1.2 Prerequisites
  • 2.1.3 Setting Up Consolidation Schema
    • 2.1.3.1 Preparing TNSNAMES Files on Source Trial and Destination Consolidation Database Servers
    • 2.1.3.2 Creating a Consolidation Management Root Directory
  • 2.1.4 Initiating Consolidation of InForm Studies
    • 2.1.4.1 Source Trial Database Configuration
    • 2.1.4.2 Destination Consolidation Database Configuration
  • 2.1.5 Adjusting Scheduling of Consolidation Jobs
• 2.2 Running the OHSCDA Installer
  • 2.2.1 Setting Up the Data Warehouse
  • 2.2.2 Setting Up the Source System
• 2.3 Source-specific Procedures
  • 2.3.1 Handling Deletions of Source Records
    • 2.3.1.1 Handling Deletions in Oracle Clinical
    • 2.3.1.2 Handling Deletions in Siebel Clinical
    • 2.3.1.3 Handling Deletions in InForm
  • 2.3.2 (Optional) Handling Deletion or Deactivation of a Study
  • 2.3.3 (Optional) Fine-tuning of Oracle Clinical Settings
• 2.4 Setting Up Oracle Data Integrator
• 2.5 Configuring Data Sources for OHSCDA
• 2.6 Executing the ETL Load Plans
• 2.7 Emplacing the OHSCDA Help and Image Files
  • 2.7.1 Placement of Files for Oracle WebLogic Managed Server
• 2.8 Preparing the OBIEE Web Catalog and Repository for OHSCDA
• 2.9 Configuring Maps
• 2.10 Creating Security Groups and Application Roles for OHSCDA
  • 2.10.1 Creating Groups
  • 2.10.2 Creating Application Roles

3 Upgrading Oracle Health Sciences Clinical Development Analytics

• 3.1 Upgrading from OHSCDA 3.1.1 Standard to OHSCDA 3.2
  • 3.1.1 Prerequisites
  • 3.1.2 Running the Installer in Upgrade Mode
  • 3.1.3 Performing Next Steps
  • 3.1.4 Migrating Data from OHSCDA 3.1.1 Standard to OHSCDA 3.2
  • 3.1.5 Upgrading ODI Topology and Work Repository
  • 3.1.6 Executing the ETL Load Plan