Skip Headers
Oracle® Health Sciences Clinical Development Analytics Administrator's Guide for Oracle Data Integrator
Release 3.2.1
E86403-01
Contact Us
Next
PDF
·
Mobi
·
ePub
1/9
Contents
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Finding Information and Patches on My Oracle Support
Finding Documentation on Oracle Technology Network
Related Documents
Conventions
1
Maintaining the OBIEE Repository and Warehouse
1.1
Maintaining the Oracle Health Sciences Clinical Development Analytics OBIEE Repository
1.1.1
Modifying the Repository
1.1.1.1
Details for Selected Modifications
1.1.2
Merging Changes into a New Oracle-supplied Repository
1.2
Maintaining the Oracle Health Sciences Clinical Development Analytics Data Warehouse
1.2.1
Extensions
1.2.2
Substitutions
1.2.3
Modifying Data Warehouse Tables
1.3
Changing the RXI and RXI_RPD Schema Passwords
1.4
Derivations
2
Extract Transform Load Programs
2.1
ETL Architecture
2.1.1
Adding Data Source Information
2.1.2
Handling Deletions in Siebel Clinical
2.1.3
Adding a New Data Source
2.2
Executing the ETL Load Plans
2.2.1
Executing CDA - Complete Warehouse Load Plan
2.2.2
Executing CDA - Inform Automerge Load Plan
2.3
Customizing an ETL Load Plan
2.4
Creating an ETL Load Plan
2.5
Modifying an ETL Load Plan
2.6
Scheduling an ETL Load Plan
3
InForm Auto-merge Matching Rules
3.1
W_EMPLOYEE_DS
3.2
W_GEO_DS
3.3
W_HS_APPLICATION_USER_DS
3.4
W_PARTY_PER_DS
3.5
W_PRODUCT_DS
3.6
W_RXI_PROGRAM_DS
3.7
W_RXI_SITE_DS
3.8
W_RXI_THERAPEUTIC_AREA_DS
A
Troubleshooting
A.1
Sorting and Displaying Null Values in Reports
A.2
Aborting a Load Plan