| Oracle® Health Sciences Data Management Workbench Installation Guide Release 2.3 E35223-01 |
|
 Previous |
 Next |
| Oracle® Health Sciences Data Management Workbench Installation Guide Release 2.3 E35223-01 |
|
Previous |
Next |
After you have finished all the installation tasks outlined in this book, you must do the following tasks before you can begin to use the Oracle Health Sciences Data Management Workbench (Oracle DMW). Most tasks are performed in in Oracle Life Sciences Data Hub (Oracle LSH).
For information on securing your system, see Oracle Health Sciences Data Management Workbench and Oracle Life Sciences Data Hub Security Guide and the Secure Configuration Guide for Oracle E-Business Suite Release 12 (My Oracle Support article 403537.1; see "Finding Information on My Oracle Support".)
Oracle DMW uses the Oracle LSH security system, which uses the user security features of the Oracle E-Business Suite. Start by reading the section on setting up security in the "Administration" chapter of the Oracle Health Sciences Data Management Workbench User's Guide.
Define Oracle LSH service locations and service instances to support Oracle DMW features as follows, following instructions in the chapter "Setting Up Services" in the Oracle Life Sciences Data Hub System Administrator's Guide.
You need the following service types to support Oracle DMW File Watcher:
Text for SQL Loader if you are loading text files from labs or elsewhere.
SAS if you are loading SAS files from labs or elsewhere.
InForm metadata and data loading use the PLSQL service. Oracle LSH installation automatically creates a service location with the database SID as its name and creates the PLSQL service under it in the Oracle LSH user interface with three (3) service instances, which allows concurrent processing of three PL/SQL jobs.
In Oracle DMW these jobs include:
loading metadata and data for an InForm study
executing a PL/SQL custom program for a transformation
executing a generated transformation
executing a validation check batch
Increase the number of PLSQL service instances to support the number of PL/SQL jobs you are likely to run concurrently. Oracle suggests a setting of 100.
Assign appropriate user group(s) to the InForm Adapter family, following instructions in the Oracle Life Sciences Data Hub System Administrator's Guide chapter on Adapters, section "Setting Up Security for Adapters."
Several profile settings are required in Oracle DMW. See theOracle Life Sciences Data Hub System Administrator's Guide chapter on "Setting Profile Values" for more information.
On each computer where you install Oracle DMW, you must set the Oracle Applications profile LSH: Use Character Semantics for Workarea Installation to Yes, as instructed in the Oracle Life Sciences Data Hub Installation Guide.
For more information see the Oracle Life Sciences Data Hub System Administrator's Guide chapter on profile values.
If you did not already do this when installing Oracle LSH, do it now:
Open your Oracle LSH URL.
Log on with the system administrator account. An E-Business Suite screen opens.
In the Main Menu pane, expand the System Administrator (not System Administration) node, then Profile, and then click System.
A new browser screen opens with several windows open and the Find System Profile Values window on top.
|
Note: If you lose the Find System Profiles window at any point, click the Search icon in the toolbar. |
In the Profile field, enter LSH: Use Character Semantics for Workarea Installation
Click Find.
In the Site column, select YES.
In the File menu, select Save and Proceed. The system displays a message that the transaction is complete.
Click OK. The transaction message pop-up disappears.
Click the X in the upper right corner of the System Profile Values window to close the window.
LSH: Domain Nesting Levels should be set to at least 6 because three levels of domains are predefined for DMW and you will need more to create categories such as Therapeutic Areas. The maximum allowed value is 9.
Follow instructions in Section 7.5.1, "Use Character Semantics" except in the Profile field, enter LSH: Domain Nesting Levels and in the Site column, enter a number between 6 and 9.
Follow instructions in the Oracle Life Sciences Data Hub System Administrator's Guide control various login and password-related requirements.
This profile determines the default setting for a check box in the Oracle DMW discrepancy creation user interface. Users can override the setting.
If you want the default behavior to be that the check box is not checked, so that by default the username is not added to the discrepancy text, you do not need to set this profile.
After finishing the installation, create subdomains within the shipped DMW domain to organize your company's studies and libraries. Instructions are included in the Oracle Health Sciences Data Management Workbench User's Guide chapter on administration.
If you plan to use Oracle or third-party applications with Oracle DMW, follow instructions in the Oracle Life Sciences Data Hub Installation Guide and Oracle Life Sciences Data Hub System Administrator's Guide to integrate them with Oracle LSH, including defining Distributed Processing Services for them. Third-party applications must be purchased and licensed separately.
Applications you may want to use include:
Informatica PowerCenter or SAS for custom transformation programs
JReview or Spotfire for data visualizations
Oracle Business Intelligence Enterprise Edition (OBIEE) for data visualizations
|
 Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|