Adapters to External Systems

Oracle Life Sciences Data Hub (Oracle LSH) is intended for integration with other systems for a variety of purposes. Each external system integrated with Oracle LSH requires an adapter to handle whatever communication and exchange is required, depending on the purpose of the integration and the technical specifications of the external system. Oracle LSH is shipped with built-in adapters for loading data into Oracle LSH from other systems, for developing and executing programs operating on Oracle LSH data, and for exporting data out of Oracle LSH.

Figure A-1 shows the adapters that are included with Oracle LSH. Adapters to other systems may be available from third parties.

Figure A-1 Oracle LSH Adapters by Functionality

Description of "Figure A-1 Oracle LSH Adapters by Functionality"

This section contains the following topics:

• Source Data Systems
  
• Data Transformation and Reporting Tools
  
• Visualization Tools
  
• Data Export Tools
  

Source Data Systems

Oracle Life Sciences Data Hub (Oracle LSH) includes adapters to external systems that you can use to load data into Oracle LSH:

• SAS. The SAS adapter allows you to load SAS data sets into Oracle LSH.

• Text. The Text adapter allows you to load text files from any system into Oracle LSH.

• Oracle Databases. The general Oracle Databases adapter allows you to load data from any Oracle database into Oracle LSH.

• Oracle Clinical. The Oracle Clinical adapter family includes eight specialized adapters for loading the following data and metadata from Oracle Clinical:

  • Data Extract SAS Views
  • Data Extract Oracle Views
  • Global Library
  • Labs
  • Study Data
  • Study Design and Definition
  • Stable Interface Tables
  • Randomization

Data Transformation and Reporting Tools

Oracle LSH includes adapters to set up the following systems as integrated development environments (IDEs) for developing and generating programs:

• SAS
• PL/SQL
• Oracle Reports
• Oracle Business Intelligence Publisher

Visualization Tools

Oracle LSH includes adapters to allow the following systems to display visualizations of Oracle LSH data:

• Oracle Discoverer
• Oracle Business Intelligence Enterprise Edition (OBIEE) Answers
• Oracle Clinical Development Analytics—to view visualizations in OBIEE Answers of Oracle Clinical data in Oracle LSH
• Generic Visualization Adapter—to integrate other visualization tools

Data Export Tools

Oracle LSH includes adapters to allow exporting Oracle LSH data:

• Oracle Export
• SAS—Transport Files and Data Sets
• Text Files