About Adapters

Oracle Life Sciences Data Hub is designed for integration with other systems.

You can:

• Load data into Oracle LSH from another system
• Copy Oracle LSH data into a file for export
• Transform and report Oracle LSH data using external technologies as integrated development environments (IDEs)
• Allow read-only access to specified Oracle LSH data through a visualization tool

Oracle LSH ships with adapters to other systems for each of these purposes. If you want to integrate Oracle LSH with a different system, you can create your own adapter.

There is a specialized object type in Oracle LSH for each of these purposes: Load Sets for loading data, Data Marts for exporting data, Programs for manipulating and reporting on data, and Business Areas for specifying the data available to a visualization tool. Oracle LSH developers, or Definers, define an object of the appropriate type in order to accomplish any of these tasks. When you create an adapter, you make it possible for Definers to create a new type of Load Set, Data Mart, Program, or Business Area that uses the logic required by your system.

For example, if you create a Load Set adapter, when a Definer creates a new Load Set in Oracle LSH, your adapter appears in the Load Set/Adapter Type drop-down list in the Create Load Set page. If the Definer selects your adapter type, the attributes you have defined for the adapter (if any) appear on the Load Set definition page and the Definer must provide values for them and specify the source data files or tables to complete the Load Set definition. Using the new Load Set, Definers and other users can load data into Oracle LSH from your external system. Your adapter type is also available to the public API for creating Load Sets.

Oracle LSH includes the following adapters:

• Load Set adapters. Oracle LSH ships with Load Set adapters for SAS and text files, Oracle tables and views, and Oracle Clinical.
• Data Mart adapters. Oracle LSH includes Data Mart adapters to copy Oracle LSH data to SAS data sets, SAS CPort and XPort files, text files, and Oracle Export files.
• Program adapters. Oracle LSH includes Program adapters to allow users to write data transformation and/or reporting programs in SAS, SQL Developer, SQL*Plus, Oracle Reports, and Oracle Business Intelligence Publisher.
• Business Area adapters. Oracle LSH includes Business Area adapters for Oracle Business Intelligence Enterprise Edition (OBIEE), including its Administration tool and Presentation Services.

  Note:

  Oracle LSH also includes a Generic Visualization Adapter that is available for use with other visualization tools. To use this adapter, follow instructions in Using the Generic Visualization Adapter. You do not need to follow instructions in any other chapter.