Skip Headers
Oracle® Life Sciences Data Hub System Administrator's Guide
Release 2.2.2
E55498-01
Home
Book List
Index
Contact Us
Next
PDF
·
Mobi
·
ePub
1/27
Contents
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Finding Information and Patches on My Oracle Support
Finding Oracle Documentation
Related Documents
Conventions
1
Setting Up Services
About Services
About the Distributed Processing Server
Setting Up the Distributed Processing Server
Defining Service Locations
Defining Services
Service Types
Service Types that Do Not Use the DP Server
Service Types that Use the DP Server
Service Prioritization
Service Instances
2
Setting Up Adapters to External Systems
About Adapters
Adapter Structure
Creating Your Own Adapters
Setting Up Security for Adapters
Assigning User Groups to Adapter Domains and Adapter Areas
Assigning User Groups
Viewing and Modifying User Group Assignments
Creating Roles with the Required Operations for Adapters
Clearing Oracle Applications Cache
3
Setting Profile Values
How to Log In to Oracle Applications Profile Forms
Setting Native Client Encoding
Using Character Semantics for Work Area Table Installation
Gathering Work Area Schema Statistics
Creating a New Tablespace for Work Area Schema Objects
Setting the Default Value for: Force Output Validation Status to Development
Setting the Maximum Number of Nested Domains
Adding the Direct SQL Option to SAS Libraries
Allowing User Preferences for SAS Clients
Setting Snapshot Label Freezing Restrictions
Setting Password Requirements
Setting Password Case Sensitivity (Required for BIP 10g and 11g)
Setting Password Length Requirement
Setting "Hard to Guess" Requirement
Enabling "Forgot Your Password?" Functionality
Setting a Limit on Log-In Attempts
Setting a Time Limit on Password Reuse after Resetting Password
Journaling Tables
BIP 10g Endpoint
BIP 11g Endpoint
Report Set Install Lock Wait Time
4
Adding and Modifying Lookup Values
About Lookups
Modifiable Lookups
File Types
Font Name
OTD Default Papersize
Report Type
SAS IDE Client
Service Type
Summary Output Validation Status
System Validation Steps
Tablespace Names
Technology Types
Logging In
Querying and Viewing Lookups
Adding, Modifying, or Discontinuing a Lookup Value
5
Registering Locations and Connections
About Remote Locations and Connections
Defining Remote Locations
Defining Connections
Searching for Remote Locations and Connections
6
Enabling Internal Metadata Table Auditing
About Internal Table Auditing
Audited Tables
7
Setting Up Printers
Setting Up Printers Globally
Setting Default Printers
8
Setting Up the Classification System
About Classification
Creating and Maintaining Hierarchies
Creating Hierarchies
Adding Levels to Hierarchies
Reorder Hierarchy Levels
Remove Hierarchy Levels
Activating the Hierarchy and Making it Usable or Unusable
Adding Terms to Levels
Modifying Hierarchies and Terms
Assigning Levels to Object Subtypes
9
Setting Up the Security System
About Security in the Oracle Life Sciences Data Hub
Setting Up User Accounts
About Users
Creating User Accounts
Maintaining User Accounts
Assigning Application Roles
Oracle Life Sciences Data Hub Application Roles
Setting Up Specialized Administrators
Setting Up Object Security
Creating and Maintaining Object Subtypes
Creating Object Subtypes
Modifying Object Subtypes
Creating and Maintaining Object Security Roles
Creating Object Security Roles
Modifying Object Security Roles
Assigning Subtype Operations to Roles and Modifying Assignments
Assigning Roles to Operations
Modifying Operation Assignments to Roles
Notes on Particular Object Types
Creating and Maintaining User Groups
Creating User Groups
Adding Supported Roles to User Groups
Assigning a Group Administrator to the User Group
Duplicating User Groups
Modifying User Groups
Granting Security Access to APIs
10
Creating Database Accounts
About Database Accounts
Database Accounts for Use in Definition
Database Accounts for Message-Based Submissions
Creating Database Accounts
Managing Database Account Privileges for Generic Visualization Business Areas
Setting Up TMS Security for Users
Resetting the Password
Removing a Database Account
11
Setting Up Oracle Business Intelligence Visualizations
Setting Up a Single-Computer Configuration
Setting Up a Multiple-Computer Configuration
Service Locations and Services Required in a Multiple Computer Installation
Single and Multiple Repository Files
Set Up Database Connectivity
Assign Repository Filename(s) to each Oracle BI Presentation Server Instance (10g Only)
Add an Entry to the NQSConfig File for Each Repository File
Set up the Analytics Web DSN to Use the Repository File
Copy and Edit Revised Execution Command Scripts
Set the Default Authenticator to Optional (11g Only)
Starting the WebLogic Server (11g Only)
Set Up Oracle Business Intelligence Administration Tool
Security Configuration
Data Security
Creating an OBIEE Remote Location and Connection for RPD Password Security
Create an OBIEE Remote Location
Create an OBIEE Remote Location Connection
Using Separate URLs to Control Access
12
Setting Up Security for Oracle Business Intelligence Publisher
Overview
Creating and Assigning Oracle Applications Responsibilities
Creating User-Specific Responsibilities in E-Business Suite
Assigning Application Roles in Oracle LSH
Configuring Security in Oracle BI Publisher
Setting Up the Security Model and Creating the Local Superuser Account in Oracle BI Publisher
Creating Data Sources and Assigning them User-specific Roles
Creating the SYSTEM Folder
Storing the BI Publisher Local Superuser Credentials in Oracle Life Sciences Data Hub
Creating the Oracle BI Publisher Remote Location in Oracle LSH
Creating the Oracle BI Publisher Remote Connection in Oracle LSH
The LSH: BIP Endpoint Profile
Configuring the Oracle BI Publisher Server (11g Only)
13
Setting Up Security for Informatica
Setting Up User Accounts
Informatica Administrator Account
Accounts for Each Oracle LSH Definer
Creating an Informatica Remote Location and Connection
Creating the Informatica Remote Location in Oracle LSH
Creating the Informatica Remote Connection in Oracle LSH
14
Customizing Object Validation Requirements
About Customizing Object Validation
Modifying the Custom Validation Package
15
Synchronizing an Apps Password Change
16
Monitoring Jobs
About Execution in the Oracle Life Sciences Data Hub
Querying for Jobs
Job Information
General Job Information
Job Execution Details
Submission Properties
Outputs
Subjobs
Submission Parameters
System Parameters
Source Data Currency
Log File
Job Statuses
Execution Statuses
17
Exporting and Importing Objects
About Exporting and Importing Objects
Objects Included and Excluded
Objects Included
Objects Excluded
Source Independence
Exporting Objects
Full and Partial Export
Populating the Driver Table
Roles and Privileges Required for Exporting
Creating the Directory and Running the Export Script
Export Log File Content
Importing Objects
Upgrading an Existing Domain
Roles and Privileges Required for Importing Domains
Creating the Directory and Running the Import Script
Import Log File Content
Applying Security to an Imported Domain
Installing Objects
Running the Installation Script
Preserving Customizations
18
Stopping and Starting Services and Queues
Starting, Stopping, and Checking the Distributed Processing Service
Starting the Distributed Processing Server Service
Checking the Distributed Processing Server Service
Stopping the Distributed Processing Server Service
Stopping and Starting the Oracle Warehouse Builder Service
Stopping the OWB Service
Starting the OWB Service
Stopping, Starting, and Enabling the Job Queue
Starting the Job Queue
Stopping the Job Queue
Enabling the Job Queue
Starting and Stopping Message-Triggered Submission Queues
Starting a Message-Triggered Submission Queue
Stopping a Message-Triggered Submission Queue
19
Troubleshooting
Job Execution Problems
Job Remains at Submitted or Executing
Oracle Warehouse Builder Processes Do Not Start
Job Runs But Does Not Upload Outputs
Job Log File Does Not Contain Info after a Long or Failed Execution
Job Fails to Obtain Service
Report Set Jobs Do Not Produce Any Output when using SAS 9.2
Database Core Dumps during Object Creation
Query Exceeds 200 Rows
Table Auditing (Journaling) Not Working
Enabling a Trace on a Job
A
Object Ownership
Domains
Application Areas
Work Areas
Glossary
Index