Contents

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 HTML 5
• 2.10 Configuring Maps
• 2.11 Creating Security Groups and Application Roles for OHSCDA
  • 2.11.1 Creating Groups
  • 2.11.2 Creating Application Roles
• 2.12 Adding a Source System to an Existing OHSCDA Setup

3 Installing and Configuring Oracle GoldenGate

• 3.1 Prerequisite
• 3.2 Installing Oracle GoldenGate
• 3.3 Deploying and Configuring OHSCDA-specific Oracle GoldenGate Code
• 3.4 Encrypting Oracle GoldenGate Data
• 3.5 Executing Scripts
  • 3.5.1 Executing Scripts on Oracle Clinical Source System
  • 3.5.2 Executing Scripts on Oracle Clinical Target System
• 3.6 Executing Full Load
• 3.7 Executing an Incremental Load

4 Upgrading Oracle Health Sciences Clinical Development Analytics

• 4.1 Upgrading from OHSCDA 3.2 to OHSCDA 3.2.1
  • 4.1.1 Prerequisites
  • 4.1.2 Running the Installer in Upgrade Mode
  • 4.1.3 Performing Next Steps
  • 4.1.4 Upgrading ODI Topology and Work Repository
  • 4.1.5 Executing and Scheduling the ETL Load Plan