Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Finding Documentation on Oracle Technology Network
• Related Documents
• Conventions

1 Installation Overview

• 1.1 Supported Platforms
  • 1.1.1 Database Tier
  • 1.1.2 Middle Tier
  • 1.1.3 Client Tier
• 1.2 Supported Browser
• 1.3 Technology Stack
• 1.4 Before You Begin
• 1.5 Known Issues

2 Installing the Database Tier

• 2.1 Prerequisites
• 2.2 Database Physical Layout Considerations
• 2.3 Installing the Database Tier
  • 2.3.1 Installing the Oracle Health Sciences Translational Research Center Database Framework
• 2.4 Upgrade Considerations
  • 2.4.1 Overview
• 2.5 Post-Installation Database Tier Steps
• 2.6 Creating Synonyms for TRC Objects (Optional)
• 2.7 Recommended Patches for Known RDBMS Issues
  • 2.7.1 Other Known RDBMS Issues
• 2.8 Login Query Performance Fix

3 Installing the Oracle Health Sciences Cohort Explorer ETL

• 3.1 Prerequisites
• 3.2 Configuring or Updating HDWF and CDM Schemas
  • 3.2.1 Installing the ODI or Informatica Script in HDWF Schema
• 3.3 Installing Oracle Data Integrator ETLs for Oracle Health Sciences Translational Research Center 3.1
  • 3.3.1 Installing an Oracle Data Integrator Repository
    • 3.3.1.1 Downloading Zipped Files from the Installation Package
    • 3.3.1.2 Installing Cohort ETLs for ODI
    • 3.3.1.3 Creating an Oracle Data Integrator Work Repository
    • 3.3.1.4 Configuring the Physical Data Server
    • 3.3.1.5 Configuring the Physical Schema
    • 3.3.1.6 Creating a Database Link
    • 3.3.1.7 Configuring the Oracle Data Integrator Physical Agent
    • 3.3.1.8 Configuring a Standalone Agent
    • 3.3.1.9 Security Guidelines for Oracle Health Sciences Cohort Explorer Oracle Data Integrator ETL Objects
  • 3.3.2 Installing Cohort ETLs for Informatica
    • 3.3.2.1 Installing Informatica ETLs
• 3.4 Installing ETLs for an Upgrade
  • 3.4.1 Upgrading the Oracle Data Integrator Repository
  • 3.4.2 Upgrading Informatica ETLs to 3.1

4 Installing and Configuring the Middle Tier

• 4.1 Installing the Middle Tier for a New Installation
  • 4.1.1 Configuring AppDB JDBC Data Source
    • 4.1.1.1 Frequently Asked Questions
  • 4.1.2 Uploading and Configuring TRC.properties File
  • 4.1.3 Installing MDS Repository Using Repository Creation Utility
  • 4.1.4 Setting Up the MDS Database Connection on WebLogic Instance
  • 4.1.5 Setting Up OBIEE
    • 4.1.5.1 Role Set Up
    • 4.1.5.2 Installing rpd and webcat
    • 4.1.5.3 Creating a BIImpersonateUser User and Granting Privileges
  • 4.1.6 Setting Up OBIEE-ADF Integration
  • 4.1.7 Deploying TrcApp.ear
  • 4.1.8 Setting OBIEE Connection and Credential Information for TrcApp
  • 4.1.9 Setting Up Oracle Health Sciences Cohort Explorer Roles in WebLogic
  • 4.1.10 Setting Up Logging for Oracle Health Sciences Translational Research Center in WebLogic
• 4.2 Updating the Middle Tier for an Existing TRC Installation
  • 4.2.1 Installing Cohort Explorer
  • 4.2.2 Upgrading OBIEE
    • 4.2.2.1 Setting Up OBIEE-ADF Integration
    • 4.2.2.2 Replacing rpd and webcat
• 4.3 Enabling iframe Support for OBIEE Reports

5 Installing the Oracle Health Sciences Omics Data Bank Loaders

• 5.1 Prerequisite for Installing Oracle Health Sciences Omics Data Bank Loaders
• 5.2 Installing the Oracle Health Sciences Omics Data Bank Loaders

6 Configuring Network Data Encryption and Integrity for Oracle Servers and Clients

A Parallelization

• A.1 Degree of Parallelization

B Statistics

• B.1 Options Used
• B.2 Script to Find Tables for Statistics

Index