Table of Contents

• Title and Copyright Information
• Preface
  • Documentation accessibility
  • Diversity and Inclusion
  • Related resources
  • Access to Oracle Support
• 1 System Requirements and Technology Stack
  • System Requirements
    • Operating Systems
      • Database Tier
      • Middle Tier
  • Technology Stack
    • Supported Browsers
• 2 Install Oracle Life Sciences Data Hub
• 3 Install Oracle WebLogic Server
  • Install Oracle Java Development Kit
  • Install Oracle WebLogic Server
    • Install Oracle WebLogic Server 12.2.1.4
    • Create Database Schemas to Use with Oracle Fusion Middleware
  • Create a WebLogic Server Domain for Oracle DMW
    • Select Templates
    • Select Development Mode
    • Advanced Configuration
    • Create a WebLogic Server "Machine"
    • Create a Managed Server and Assign it to the Machine
    • Deployment Targeting
    • Services Targeting
    • Support SSL Wildcards and SSL Web Services
    • Restart the WebLogic Server
  • Copy runtime12.jar into the Domain's lib Directory
  • Edit setDomainEnv.sh
  • Change the Default Timeout Period (Optional)
  • Restart the WebLogic Server
  • Start the Node Manager and Check Settings
  • Restart WebLogic Server and Check Settings
  • Change WebLogic Server to Production
  • Enable E-Business Suite User Authentication
    • Prepare the Oracle Applications Server to Receive Messages from Oracle DMW
      • Copy the Database Connection File
      • Download and Install the Software Development Kit for Java
      • Register the External Node and Generate the Desktop DBC File
      • Create the Required User [e-mail]
    • Configure AppDataSource on the WebLogic Server
      • Rebuild the fndext.jar file for Oracle WebLogic Server on UNIX/LINUX
      • Deploy AppsDataSource Code on the Oracle WebLogic Server
      • Configure the AppsDataSource in the Administration Console
        • Create Data Source lswdbBC4JDS
        • Create Data Source lswdbDS
        • Create Data Source lswExtSysDS
        • Create Data Source lswdbRestDS
        • Create Data Source lswdbDfdDS
        • Create Data Source lswdbExportDS
        • Run the Script to Create User CDRBC4JINTERNAL
        • Run the Script to Grant Rights to the DMWMON User
      • Enable CLOB Support
    • Prepare a Security Realm on the WebLogic Server
      • Create Users and Assign Groups in the Realm
      • Set the Default Realm
  • Configure the DMWServer Managed Server
    • Apply the JRF Template to DMWServer
    • Apply the JSF Library to the Oracle DMW Domain
    • Change the Connection Pool Maximum Capacity on DMWServer
    • Clear the Listen Address
    • Change Targets for "em" Deployment
    • Open port 47632
  • Configure the WebLogic JMS Resources
    • Configure the WebLogic JMS Resource for Data Flow Diagram
    • Configure the WebLogic JMS Resource for Discrepancies Export
  • Apply the ADF Patch
• 4 Deploy Oracle DMW on the WebLogic Server
  • Download the Oracle DMW Folder
  • Deploy Oracle DMW with Default Support for HTTPS
  • Deploy Oracle DMW and Disable HTTPS Support
  • Deploy Discrepancies Export and Data Flow Diagram Modules
  • Check for and Install Any Oracle DMW 3.4.x Patches
  • Run the Health Check Scripts
• 5 Integrate Oracle Health Sciences InForm
  • Get a CA Certificate if You Use HTTPS
  • Use Character Semantics
  • Create Oracle Accounts for the Oracle DMW InForm Connector
    • Create Directory on Each InForm Database
    • Copy Scripts
    • Run the Driver Script
  • Set Up the InForm Adapter
    • Install the Oracle InForm Adapter
    • Register the InForm Server Adapter
    • Register Each Trial
    • Check the InForm Integration
    • Create InForm Users
• 6 Configure File Watcher Support
  • Set Up the Distributed Processing Server
  • Create Directories
    • Create Watched Folders
    • Create Archive Folders (Optional)
  • Secure Files in Folders
  • Configure Server Time Zone Settings
    • Set the TZ Environment Variable Manually
    • Set the TZ Environment Variable Automatically
    • Use the tzselect Utility
    • Verify the Time Zone Setting Used by Java Virtual Machine (JVM)
  • Complete Your File Watcher Configuration
• 7 Install Oracle Thesaurus Management System (Optional)
  • Install Oracle Thesaurus Management System
  • Edit setDomainEnv.sh
  • Edit setDomainEnv.sh
  • Run Script dmetmsseeddata.sql
• 8 Upgrade to Release 3.4
  • Upgrade Oracle Life Sciences Data Hub
  • Deploy Oracle DMW to the WebLogic Server
  • Run the Populate Custom Listings Script
  • Rename the Existing "Clinical One Operational Data" Data Models
  • Upgrade Existing Business Area for Custom Listings
  • Upgrade File Watcher to Support Archiving Files (Optional)
  • Install Oracle Thesaurus Management System (Optional)
  • Migrate the Editioned Objects
• 9 What's Next
  • Set Up System Security
  • Set Up User Security
  • Set Up Oracle LSH Services
    • Distributed Processing Services for File Watcher
    • PLSQL Service Instances
  • Assign User Group to InForm Family Adapter
  • Set Up OAuth for InForm and Oracle DMW Integration
  • Enable rng-tools to Avoid Performance Issues While Sending Discrepancies
  • Set Required Profile and Lookup Settings
  • Create Study and Library Categories in Oracle LSH
  • Set Up File Watcher
  • Set Up Logging
  • Integrate Other Applications (Optional)
• 10 Revision History
• 11 Architecture
  • Client Tier
  • Application Tier
    • Oracle LSH Application Tier
    • Oracle DMW Application Tier
  • Database Tier