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 Browsers
  • 1.2.2 Source Systems
• 1.3 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.1.1 Setting Up the Data Warehouse
    • 2.1.1.2 Setting Up the Source System
  • 2.1.2 Setting Up Oracle Data Integrator
    • 2.1.2.1 Executing CDA - Complete Warehouse Load Plan
    • 2.1.2.2 Executing CDA - Inform Automerge Load Plan
  • 2.1.3 Emplacing the OHSCDA Help and Image Files
    • 2.1.3.1 Placement of Files for Oracle WebLogic Managed Server
  • 2.1.4 Preparing the OBIEE Web Catalog and Repository for OHSCDA
  • 2.1.5 Configuring Maps
  • 2.1.6 Creating Security Groups and Application Roles for OHSCDA
    • 2.1.6.1 Creating Groups
    • 2.1.6.2 Creating Application Roles
• 2.2 Adding InForm Studies to the OHSCDA Warehouse
  • 2.2.1 OHSCDA InForm Consolidation Schema
  • 2.2.2 Prerequisites
  • 2.2.3 Setting up Consolidation Schema
    • 2.2.3.1 Preparing TNSNAMES Files on Source and Target Database Servers
    • 2.2.3.2 Creating a Consolidation Management Root Directory
  • 2.2.4 Initiating Consolidation of InForm Studies
    • 2.2.4.1 Source Trial Database Configuration
    • 2.2.4.2 Destination Consolidation Database Configuration
  • 2.2.5 Creating InForm Auto Merge Tables
  • 2.2.6 Creating OCDA_INFORM_VIEWs
  • 2.2.7 Adjusting Scheduling of Consolidation Jobs
• 2.3 Source-specific Procedures
  • 2.3.1 (Optional) 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

Index