4 Upgrading Oracle Health Sciences Clinical Development Analytics

This chapter provides procedures that explain how to upgrade OHSCDA. It includes the following section:

• Section 4.1, "Upgrading from OHSCDA 3.2 to OHSCDA 3.2.1"

4.1 Upgrading from OHSCDA 3.2 to OHSCDA 3.2.1

The Installer automates the upgrade of the warehouse. After running the Installer, to complete the upgrade from OHSCDA 3.2 to OHSCDA 3.2.1, perform the steps mentioned in Section 4.1.3, "Performing Next Steps" through Section 4.1.5, "Executing and Scheduling the ETL Load Plan".

Note:

OHSCDA 3.2 is certified on Oracle Database 12.1.0.2.0. For detailed certification information, see Finding Certification Information.

4.1.1 Prerequisites

For information, see Section 1.2, "Technology Stack and System Requirements".

4.1.2 Running the Installer in Upgrade Mode

1. Run the OHSCDA Installer as described in Section 2.2, "Running the OHSCDA Installer".

   Perform this step only for the Siebel Clinical source system. Selecting the Oracle Clinical and InForm source systems is not required.

4.1.3 Performing Next Steps

After running the installer, perform the following steps:

1. To enable multi-byte character support, execute the Database Migration Assistant for Unicode (DMU) on the CDA warehouse schema.

   For information, see Oracle Database Migration Assistant for Unicode Guide.

   Note:

   If your OHSCDA warehouse database is currently not enabled to support multi byte character and if you need the multi byte support in future, then you must perform this step.

2. Perform the steps listed in the following sections:

   • Section 2.7, "Emplacing the OHSCDA Help and Image Files"

   • Section 2.8, "Preparing the OBIEE Web Catalog and Repository for OHSCDA"

     Note:

     If you are upgrading from OHSCDA 3.2 and have modified the OBIEE repository or Web Catalog, merge these objects. For more information, refer to Oracle® Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1.

   • Section 2.10, "Configuring Maps"

   • Section 2.11, "Creating Security Groups and Application Roles for OHSCDA"

4.1.4 Upgrading ODI Topology and Work Repository

Note:

Before upgrading the ODI work repository and topology to OHSCDA 3.2.1, back up the complete topology and work repository.

For information on how to back up, see Oracle Data Integrator User's Guide.

1. Perform smart export of customizations you want to apply.

   Note:

   Before exporting the customizations, Oracle recommends that you organize all customizations into a single folder with a unique object name. For example, prefix the object name with cust_.

   For information on how to smart export, see Oracle Data Integrator User's Guide.

2. Upgrade the topology and work repository to OHSCDA 3.2.1.

   • To upgrade the work repository, perform steps 3 through 22 in Section 2.4, "Setting Up Oracle Data Integrator".

   • To upgrade the topology, perform steps 23 through 29 in Section 2.4, "Setting Up Oracle Data Integrator".

   To upgrade the work repository, perform steps 3 through 22 and to upgrade the topology perform steps 23 through 29 do so, perform steps 3 through 24 in Section 2.4, "Setting Up Oracle Data Integrator".

3. Perform smart import of the customizations which you had exported in earlier step.

4. Update the load plan with required customizations.

4.1.5 Executing and Scheduling the ETL Load Plan

For information, see Oracle Health Sciences Clinical Development Analytics Administrator's Guide.