Deploy the RPD and Catalog

Install Oracle Business Intelligence Enterprise Edition 12.2.1.4.

Note:

The existing Oracle Business Intelligence Enterprise Edition 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.

While running the configuration, create an Oracle Business Intelligence Enterprise Edition domain.

Remember that you can now deploy TRC CDM and HCD RPD on the same Oracle Business Intelligence Enterprise Edition server by creating different Oracle Business Intelligence Enterprise Edition 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.

Go to the following location on the middle tier installation home: <TRC_MTIER_HOME>/trcmt/ohf_products/OBIEE/

Copy RPD.zip and OracleHealthSciencesCohortExplorer.zip to the Oracle Business Intelligence Enterprise Edition server.

Extract them to a folder on the Oracle Business Intelligence Enterprise Edition server. This yields the RPD file and the catalog folder.

In the Oracle Business Intelligence Administration Tool, open the extracted Oracle Business Intelligence repository (OracleHealthSciencesCohortExplorer.rpd) in offline mode and configure database connections.

Note:

A 64-bit Windows OS is required to run the Oracle Business Intelligence Administration tool.

In the Oracle Business Intelligence Administration Tool, from the File menu, select Open, then Offline.
Select OracleHealthSciencesCohortExplorer.rpd.
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.
Click OK.

Modify the connection pools in the RPD:

In the physical layer, expand the OracleHealthScienceCohortExplorer node and double-click Connection Pool.
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.
From the File menu, select Save to save the RPD. When the “Do you wish to check global consistency" dialog box appears, click No.

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.

Copy the contents of the catalog folder to

<OBIEE_DOMAIN_HOME>/bidata/service_instances/ssi
                        [Service Instance Name]/metadata/content/catalog

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>)))

Restart the Oracle Business Intelligence Enterprise Edition services from the Oracle Enterprise Manager:

Log into the Oracle Enterprise Manager.
Expand the Target Navigation Menu and go to Business Intelligence > biinstance.
Click the Availability tab.
In the Processes tab, click Restart All. This restarts the Oracle Business Intelligence Instance services.
Log into Oracle Business Intelligence Enterprise Edition.