Go to primary content
Oracle® Health Sciences WebSDM and Empirica Study Installation Instructions
Release 3.1.2.1 for Windows 2003/2008 Server
E40537-03
  Go To Table Of Contents
Contents

Previous
Previous
 
 

E Configure WebSDM to Access an Oracle Health Sciences InForm Instance

This section applies only to customers who will load SDTM-formatted study data from an Oracle Health Sciences InForm instance.

To perform these steps you must know the Oracle DBA account/password and the Oracle master account name/password for WebSDM. In addition you must have the following information pertaining to an existing InForm database instance:

Finally, you need access to files extracted from database-3_1_2_1_xxx.zip, as described in section 1.2.3, or access to the WebSDM installation media.

E.1 Add Net Service Name for InForm Database

On the WebSDM database server, add an entry for the InForm database service name to the tnsnames.ora file.

<InForm_service_name>=
(DESCRIPTION=
   (ADDRESS=
       (PROTOCOL=TCP)
       (HOST=<InForm_host>)
       (PORT=<InForm_port>)
   ) (CONNECT_DATA=(SID=<InForm_SID>))
)

Note:

The WebSDM application does not require this entry. Use it to access the InForm database and execute the SQL commands listed below.

If modifying tnsnames.ora is not desired, you can substitute the value of <InForm_service_name> directly in the SQL commands in steps C.2 and C.3. Replace <InForm_service_name> with:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<InForm_host>)
(PORT=<InForm _port>)) (CONNECT_DATA=(SID=< InForm_SID>)))

E.2 Create a Database Link

  1. Connect to WebSDM DB as <ora_dba_acct>.

    1. Type this command:

      C:> sqlplus <ora_dba_acct>@<ora_net_service>

    2. When prompted for the password, enter <ora_dba_pass>.

  2. Grant Create DB Link privilege to the websdm master account by typing:

    SQL>GRANT CREATE DATABASE LINK TO <websdm_master_acct>;

  3. Exit SQL*Plus.

  4. Connect to WebSDM DB as <websdm_master_acct>.

    1. Type this command:

      C:> sqlplus <websdm_master_acct>@<ora_net_service>

    2. When prompted for the password, enter <websdm_master_pass>.

  5. Run the following command, with values substituted as appropriate. The <DB_link_name> is a new name that you provide.

    SQL>CREATE DATABASE LINK <DB_link_name> CONNECT TO <InForm_acct> 
    IDENTIFIED BY <InForm_pass> USING '<InForm_service_name>';
    
  6. Exit SQL*Plus.

  7. Repeat step 1 to connect to WebSDM DB again as <ora_dba_acct>.

  8. Revoke Create DB Link privilege from the websdm master account by typing:

    SQL>REVOKE CREATE DATABASE LINK FROM <websdm_master_acct>;

E.3 Set Site Option to Allow InForm Import

  1. Log into WebSDM using the default administrative account.

  2. Click the Settings link at the top right corner of the page.

  3. Click Set Site Options.

  4. Select the Allow data import from Oracle Health Sciences InForm option, if it is not already selected.

  5. Click Save.

  6. Click Continue.

  7. Log out.