Oracle® Health Sciences Clinical Development Analytics Installation and Configuration Guide for Oracle Data Integrator Release 3.2 E74829-02 |
|
|
PDF · Mobi · ePub |
This chapter provides procedures that explain how to upgrade OHSCDA. It includes the following section:
Note:
You must upgrade OHSCDA 3.1 to OHSCDA 3.1.1 before upgrading to OHSCDA 3.2.The Installer automates the upgrade of the warehouse. After running the Installer, to complete the upgrade from OHSCDA 3.1.1 to OHSCDA 3.2, perform the steps mentioned in Section 3.1.3, "Performing Next Steps" through Section 3.1.6, "Executing 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.For information, see Section 1.2, "Technology Stack and System Requirements".
Run the OHSCDA Installer as described in Section 2.2, "Running the OHSCDA Installer".
After running the installer, perform the following steps:
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.
Perform the steps listed in Section 3.1.4, "Migrating Data from OHSCDA 3.1.1 Standard to OHSCDA 3.2".
Perform the steps listed in the following sections:
Section 2.8, "Preparing the OBIEE Web Catalog and Repository for OHSCDA"
Note:
If you are upgrading from OHSCDA 3.1.1 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, "Creating Security Groups and Application Roles for OHSCDA"
Perform the following steps to migrate data from OHSCDA 3.1.1 Standard to OHSCDA 3.2:
Log on to the OHSCDA warehouse schema.
<warehouse_user>/<warehouse_password>@<SID>
Create the following database links:
oc_dblink for Oracle Clinical source
Example (OC):
create database link <oc_dblink> connect to <oc_username> identified by <oc_password> using '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=<portno>))(CONNECT_DATA=(SID=<sidname>)))';
sc_dblink for Siebel Clinical source
Example (SC):
create database link <sc_dblink> connect to <sc_username> identified by <sc_password> using '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=<portno>))(CONNECT_DATA=(SID=<sidname>)))';
if_dblink for InForm source
Example (IF):
create database link <if_dblink> connect to ocda_if_src identified by ocda_if_src using '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=<portno>))(CONNECT_DATA=(SID=<sidname>)))';
Connect to the warehouse schema.
Execute the following driver scripts in the sequence as mentioned:
Note:
Driver scripts are available in <OCDA_HOME>\OCDA_ODI\Database\Migration_Scripts3.1.1_to_3.2.zip.drv_Migrate_CDA311_to_32_SC_Set1.sql
drv_Migrate_CDA311_to_32_SC_Set2.sql
drv_Migrate_CDA311_to_32_IF.sql
drv_Migrate_CDA311_to_32_OC.sql
drv_Migrate_CDA311_to_32_Cleanup.sql
Connect to the Siebel Clinical source schema and execute ocda_sc_del_trigger.sql located at <OCDA_HOME>\OCDA_Common\OCDA_Common_Scripts\Delete_Script.
Note:
Before upgrading the ODI work repository and topology to OHSCDA 3.2, back up the complete topology and work repository.For information on how to back up, see Oracle Data Integrator User's Guide.
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.
Upgrade the topology and work repository to OHSCDA 3.2.
To do so, perform steps 3 through 24 in Section 2.4, "Setting Up Oracle Data Integrator".
Perform smart import of the customizations which you had exported in earlier step.
Update the load plan with required customizations.
For information, see Oracle Health Sciences Clinical Development Analytics Administrator's Guide.