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 Technology Stack and System Requirements
  • 1.1.1 Supported Web Browsers
  • 1.1.2 Source Systems
• 1.2 Installing the Prerequisite Software

2 Installing Oracle Health Sciences Clinical Development Analytics

• 2.1 Installing Oracle Health Sciences Clinical Development Analytics
  • 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.3.1 DAC Configurable Parameters
  • 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.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 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

3 Upgrading Oracle Health Sciences Clinical Development Analytics

• 3.1 Upgrading from OHSCDA 3.0 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.0 Standard to OHSCDA 3.2
  • 3.1.5 Importing the OHSCDA Warehouse Application Metadata into the DAC Repository
  • 3.1.6 Merging Changes into a New Oracle-supplied Repository
  • 3.1.7 Executing the ETL Load Plan