Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Restricted Use License of Oracle Business Intelligence Enterprise Edition with Oracle Health Sciences Cohort Explorer
• Audience
• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Finding Documentation on the Oracle Technology Network
• Related Documents
• Conventions

1 Getting Started

• System Requirements
  • Operating Systems
  • Browsers
• Technology Stack
• General Security Principles
  • Keep Software Up To Date
  • Keep Up To Date on Latest Security Information Critical Patch Updates
  • Configure Strong Passwords on the Database
  • Follow the Principle of Least Privilege
• Before You Begin

2 Installing the Oracle Health Sciences Cohort Explorer Schema

• Security Guidelines for Database Objects and Database Options
  • About Oracle Health Sciences Cohort Explorer Database Objects
  • Oracle Database Options
    • Database Vault
    • Oracle Audit Vault
    • Transparent Data Encryption
• Prerequisites for Creating the Schema
• Installation Files
• Installing the Schema

3 Installing the Oracle Health Sciences Cohort Explorer ETL

• Security Guidelines for Oracle Data Integrator (ODI)
  • Security Guidelines for Oracle Health Sciences Cohort Explorer ODI ETL Objects
  • Managing Default User Accounts
  • Closing All Open Ports Not in Use
  • Disabling the Telnet Service
  • Disabling Other Unused Services
  • Designing for Multiple Layers of Protection
  • Enabling SSL
• Install an Oracle Data Integrator (ODI) Repository
  • Download Zipped Files from the Installation Package
  • Create a Database Schema
  • Create an ODI Master Repository
    • Creating a New ODI Repository Log In
    • Importing the ODI Master Repository
  • Create an ODI Work Repository
    • Creating a New ODI Work Repository
    • Import the OHSCE Work Repository
  • Configure the ODI Physical Agent
  • Configure the Physical Data Server
  • Configure the Physical Schema
  • Create a Database Link
• Revoke Unnecessary Grants on the OHSCE Schema

4 Installing Oracle Health Sciences Cohort Explorer Reports

• Security Guidelines for Oracle Business Intelligence Enterprise Edition (OBIEE)
  • Security Guidelines for Oracle Business Intelligence Enterprise Edition Report Objects
  • Managing Default User Accounts
  • Checking External Links that May Expose Account Data
  • Closing All Open Ports Not in Use
  • Disabling the Telnet Service
  • Disabling Other Unused Services
  • Designing for Multiple Layers of Protection
  • Enabling SSL
• Installing Oracle Health Sciences Cohort Explorer Reports
  • Policy Store Migration
  • Repository Installation
• Accessing Oracle Health Sciences Cohort Explorer
  • Logging In
  • Viewing a Dashboard

5 Verifying an Oracle Health Sciences Cohort Explorer Installation

• OHSCE Database Components
• ODI Repository Components
  • ODI Master Repository Components
  • ODI Work Repository Components

A Configuring Oracle Identity Management for Oracle Health Sciences Clinical Development Center

• Installing the Prerequisite Software
  • Configure Oracle Identify Management
  • Create an LDAP User
    • Creating an LDAP User Using Command Line Tools
    • Creating an LDAP User Using the Self-Service Console
• Install the Oracle Health Sciences Clinical Development Center 3.1 SP1 Client
  • Prerequisites
  • Installing the Oracle Health Sciences Clinical Development Center (CDC) Client
• Configuring Your Single Sign-On (SSO) ID with Oracle Business Intelligence Enterprise Edition
  • Install Prerequisites for SSO ID Configuration
  • Configure Your Database to Use the Directory
  • Register Your Database with the Directory
  • Create Credentials for a Oracle Health Sciences Clinical Development Center User on the LDAP Server
• Configuring Oracle Business Intelligence Enterprise Edition (OBIEE) with Oracle Internet Directory (OID)
  • Install the Prerequisite Software
  • Configure the Database
  • Run the Repository Creation Utility (RCU) to Create Oracle Business Intelligence Database Schemas
  • Install Oracle Business Intelligence Enterprise Edition (OBIEE) 11g
  • Configure OBIEE with OID for Authentication
  • Configure the User Name Attribute in the Identity Store
  • Verify OID Users and Groups in the WebLogic Console

B Oracle Healthcare Data Warehouse Foundation Tables

• Mandatory Oracle Healthcare Data Warehouse Foundation Code Types Table
• Oracle Healthcare Data Warehouse Foundation Physical Table

Index