Deploy the RPD and Catalog

To deploy the RPD and Catalog:

1. Install Oracle Analytics Server 12.2.1.4.

   Note:

   The existing Oracle Analytics Server installation for Oracle Healthcare Foundation can be used. However, please remember to create a new domain for TRC RPD, instead of using the domain that might have been created for Oracle Healthcare Foundation RPD.
2. While running the configuration, create an Oracle Analytics Server domain.

   Remember that you can now deploy TRC CDM and HCD RPD on the same Oracle Analytics Server server by creating different Oracle Analytics Server domains. For details, see Oracle® Fusion Middleware Installing and Configuring Oracle Business Intelligence, "Chapter 4 - Configuring Oracle Business Intelligence".

   For details on how to create a Oracle WebLogic Server domain, see the Oracle® WebLogic Server 12c (12.2.1) Creating a Domain Guide, "Chapter 2 - Creating a WebLogic Server 12c (12.2.1) Domain", on the Oracle Help Center.

3. Go to the following location on the middle tier installation home: <TRC_MTIER_HOME>/trcmt/ohf_products/OBIEE/
4. Copy RPD.zip and OracleHealthSciencesCohortExplorer.zip to the Oracle Analytics Server server.
5. Extract them to a folder on the Oracle Analytics Server server. This yields the RPD file and the catalog folder.
6. In the Oracle Analytics Administration Tool, open the extracted Oracle Analytics repository (OracleHealthSciencesCohortExplorer.rpd) in offline mode and configure database connections.

   Note:

   A 64-bit Windows OS is required to run the Oracle Analytics Administration tool.
   1. In the Oracle Analytics Administration Tool, from the File menu, select Open, then Offline.
   2. Select OracleHealthSciencesCohortExplorer.rpd.
   3. Enter the repository password to log into the OracleHealthSciencesCohortExplorer.rpd file. The default password is cohort.

      Note:

      Change the RPD password by selecting Change Password from the File menu. Enter the old and new passwords.
   4. Click OK.
7. Modify the connection pools in the RPD:
   1. In the physical layer, expand the OracleHealthScienceCohortExplorer node and double-click Connection Pool.
   2. Change the following:

      Data source name: Enter the TNS entry name of the Oracle Healthcare Foundation database instance where Oracle Healthcare Translational Research is installed.

      User name: Provide the APP schema user name.

      Password: Provide the password of the APP schema user. Confirm the new password and click OK.

   3. From the File menu, select Save to save the RPD. When the “Do you wish to check global consistency" dialog box appears, click No.
8. Upload the RPD using the following command:

   <OBIEE_DOMAIN_HOME>/bitools/bin/datamodel.sh uploadrpd -I <Path extracted to as mentioned in step 5>\OracleHealthSciencesCohortExplorer.rpd -SI ssi -U weblogic -P <weblogic credentials>
   

   You are prompted for to add the RPD password. For this password, contact your Oracle Product Manager.

9. Copy the contents of the catalog folder to <OBIEE_DOMAIN_HOME>/bidata/service_instances/ssi [Service Instance Name]/metadata/content/catalog
10. Check whether tnsnames.ora is present in the location. If not, create it and add a TNS entry for the DB connection. To create the file:

    <OBIEE_DOMAIN_HOME>/config/fmwconfig/bienv/core/tnsnames.ora
    

    To add the TNS entry:

    trcpdb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <ohfdb_server.domain>)(PORT = <PORT_NUMBER>))) (CONNECT_DATA = (SERVICE_NAME = <OHDFDB_SERVICE_NAME>)))
    

11. Restart the Oracle Analytics Server services from the Oracle Enterprise Manager:
    1. Log into the Oracle Enterprise Manager.
    2. Expand the Target Navigation Menu and go to Business Intelligence > biinstance.
    3. Click the Availability tab.
    4. In the Processes tab, click Restart All. This restarts the Oracle Analytics Instance services.
    5. Log into Oracle Analytics Server.