5 Integrate Oracle Health Sciences InForm

This section contains the following topics:

• Section 5.1, "Get a CA Certificate if You Use HTTPS"

• Section 5.2, "Use Character Semantics"

• Section 5.3, "Create Oracle Accounts for the Oracle DMW InForm Connector"

• Section 5.4, "Set Up the InForm Adapter"

5.1 Get a CA Certificate if You Use HTTPS

To support HTTPS, you need to request a certificate from a Certificate Authority (CA) vendor such as Thawte, Entrust, or Verisign. Allow some time for the certificate to be issued.

5.2 Use Character Semantics

Set the Oracle Applications profile LSH: Use Character Semantics for Workarea Installation to Yes on each computer where you install Oracle DMW is required for integration with InForm. See the Administration chapter of the Oracle Health Sciences Data Management Workbench User's Guide.

5.3 Create Oracle Accounts for the Oracle DMW InForm Connector

The InForm Connector is a component of Oracle DMW. It is required to import study data and metadata from InForm. On each InForm study database, run scripts to create a read-only user account for Oracle DMW to use to access data and metadata in InForm.

The account has Select privileges on all tables and views in study accounts referenced by the InForm Connector, including metadata views, operational data views, and RDE views. This schema also has packages that facilitate the data load process.

Use the credentials of this account when you set up a database connection (remote location) in the Oracle DMW InForm configuration for each study using the InForm database. See the Oracle Health Sciences Data Management Workbench User's Guide Administration chapter.

5.3.1 Create Directory on Each InForm Database

On each InForm database with a study for which you plan to use Oracle DMW, create one OS directory using the mkdir command to hold scripts you must copy and run.

You need one directory per database, not per study.

5.3.2 Copy Scripts

Copy the following files from the directory $CDR_TOP/patch/115/sql/ on the computer where you have installed Oracle Life Sciences Data Hub to each InForm database directory you created in Section 5.3.1:

• DMWInFormInstall.sql—the driver script

• DMWInFormUser.sql—creates new users or confirms existing users

• DMWInFAdms.pls—installs a package specification into the Oracle DMW administration account

• DMWInFAdmb.pls—installs a package body into the Oracle DMW administration account

• DMWInFormROAccessObjs.sql—installs a table into the Oracle DMW read-only access account

• DMWInFroas.pls—installs a package specification into the Oracle DMW read-only access account

• DMWInFroab.pls—installs a package body into the Oracle DMW read-only access account

5.3.3 Run the Driver Script

The driver prompts for all required input parameter values and calls the other scripts as required.

1. Log into SQL*Plus with an account with DBA privileges.

2. Go to the directory that contains the downloaded scripts.

3. Execute DMWInFormInstall.sql. The script prompts for:

   • A name to give the log file.

   • TNS name or connect string for the InForm database. If you enter the connect string, do not enter any spaces.

   • system or other DBA username and password.

   • Name of the Oracle DMW Admin account to be used or created for the purpose of giving privileges to the Oracle DMW read-only access account. The system creates the account if it does not already exist.

   • Name of the Oracle DMW read-only access account to be used or created. The system creates the account if it does not already exist.

     Note:

     Do not use spaces or special characters other than underscore (_) in the username or password.

   • Passwords for both accounts. If the accounts are new, the script prompts you to confirm each password. If the accounts already exist, you must enter a password, but the system does not change the existing password. It proceeds to create or update the packages owned by the schema.

   • If the read-only access account is new, the script also prompts for a tablespace name. It then creates a tablespace on the InForm database to be used for the integration with Oracle DMW and creates or updates all Oracle DMW objects in this tablespace.

5.4 Set Up the InForm Adapter

The InForm Adapter is an Oracle Health Sciences InForm component. Oracle DMW uses it to send discrepancies to InForm.

5.4.1 Install the InForm Adapter

Install the appropriate version of the InForm Adapter for the version of InForm you are using:

• If you are using Oracle Health Sciences InForm 5.5.1, install InForm Adapter Release 1.3.5, 1.3.6, or 1.3.7.

• If you are using Oracle Health Sciences InForm 6.0, install InForm Adapter Release 1.3.6 or 1.3.7.

Oracle Health Sciences InForm Adapter 1.3.7 Installation Guide is available at http://docs.oracle.com/cd/E59505_01/index.htm

You can install the Discrepancy Enhanced interface, Adapter Admin interface and RegisterTrialTool on a dedicated computer—the most common configuration—or on the InForm application server computer with the InForm Server Adapter (ISA).

The InForm Server Adapter (ISA) must be available on the InForm application server to invoke the "Issue" and "Update" methods in the Discrepancy Enhanced interface, and the ISA Windows service must be running.

Note:

Make sure that all clocks are synchronized on the machines on which you are installing the InForm Adapter interfaces, the InForm server, the database server, and the Oracle DMW application tier.

5.4.2 Register the InForm Server Adapter

Follow instructions in the Oracle Health Sciences InForm Adapter Installation Guide at http://docs.oracle.com/cd/E59505_01/index.htm to register the InForm Server Adapter (ISA) using the SetServer command in the Register Trial Tool.

5.4.3 Register Each Trial

Follow instructions in the Oracle Health Sciences InForm Adapter Installation Guide at http://docs.oracle.com/cd/E59505_01/index.htm to register each trial, using the SetTrial command in the Register Trial Tool.

5.4.4 Check the InForm Integration

1. Verify that the ISA URL opens correctly in the browser from your local machine.

2. To verify that it is accessible from DMW server and there are no network connectivity issues, execute the wget command:

   wget your_ISA_URL

   It should return a message ending in "...connected."

5.4.5 Create InForm Users

On each InForm database with a study you plan to use Oracle DMW:

1. Log in to UMT using an account that can create new users, such as system.

2. Create a user with a suggested username DMW_AUTH to be used for authentication purposes by the web service connection. This user does not need any privileges. Its username and password will be used within Oracle DMW when creating web service locations.

3. Create a user with the required name DMW_QUERY to be used for sending and updating discrepancies in InForm.

   • Make DMW_QUERY a sponsor user

   • Assign the DMW_QUERY user to a query group.

   It is not required to give the DMW_QUERY user access to sites or even be part of a rights group that can manipulate discrepancies. The password for this user is not used in Oracle DMW.

4. Activate both accounts.