10 What's 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 Oracle Life Sciences Data Hub (Oracle LSH).

• Section 10.1, "Set Up System Security"

• Section 10.2, "Set Up User Security"

• Section 10.3, "Set Up Oracle LSH Services"

• Section 10.4, "Assign User Group to InForm Family Adapter"

• Section 10.5, "Set Required Profile and Lookup Settings"

• Section 10.6, "Create Study and Library Categories in Oracle LSH"

• Section 10.7, "Set Up File Watcher"

• Section 10.8, "Integrate Other Applications (Optional)"

10.1 Set Up System Security

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

10.2 Set Up User Security

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.

10.3 Set Up Oracle LSH Services

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.

10.3.1 Distributed Processing Services for File Watcher

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.

10.3.2 PLSQL Service Instances for InForm Metadata and Data Loading and PL/SQL Jobs

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

10.4 Assign User Group to InForm Family Adapter

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."

10.5 Set Required Profile and Lookup Settings

Oracle DMW uses Oracle Applications profiles and lookups to determine some aspects of system behavior. See the Administration chapter of the Oracle Health Sciences Data Management Workbench User's Guide for information.

10.6 Create Study and Library Categories in Oracle LSH

After finishing the installation, create subdomains within the shipped DMW domain to organize your company's studies and libraries. See the Administration chapter of the Oracle Health Sciences Data Management Workbench User's Guide for information.

10.7 Set Up File Watcher

See the Administration chapter of the Oracle Health Sciences Data Management Workbench User's Guide.

10.8 Integrate Other Applications (Optional)

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