Adapter Structure

Oracle Life Sciences Data Hub adapters are defined objects like other defined objects in Oracle LSH.

An adapter consists of an Adapter Domain with one or more Adapter Areas, each containing a Work Area. The Adapter Area also contains two Program definitions with source code for each custom function required by the external system, and the Parameter Set required for each Program. The Work Area contains an instance of each Program. Figure 2-1 shows object ownership within an Adapter Domain.

Note:

The Work Area, like other Oracle LSH Work Areas, must be installed in the database in order to function. Adapter Work Areas are installed as part of the post-installation jobs. For more details on running the post-installation programs, see the Oracle Life Sciences Data Hub Installation Guide.

Figure 2-1 Adapter Structure: Object Ownership

Description of "Figure 2-1 Adapter Structure: Object Ownership"

Oracle LSH Release 2.4.8 includes the following Adapter Domains (the names in parentheses appear in the Oracle LSH user interface):

• Oracle Export (ORACLE EXPORT). The Oracle Export adapter is required to create Oracle Export Data Marts.
• Oracle Clinical (ORACLECLINICAL_ADAPTER). The Oracle Clinical Adapter Domain includes many different Adapter Areas, one for each type of Oracle Clinical Load Set. You can assign different user groups to each one if you want to.
• Oracle Family (ORACLEFAMILY_ADAPTER). The Oracle adapter is required to create Load Sets of type Oracle Tables and Views. This adapter is also required to create Programs of type PLSQL and Oracle Reports.
• SAS Family (SASFAMILY_ADAPTER). The SAS adapter is required to create SAS Load Sets.The SAS adapter is also required to create Programs of type SAS, SAS Macro Catalog, and SAS Format Catalog.
• SAS Export (SAS EXPORT). The SAS Export adapter is required to create SAS Data Marts.
• Text Export (TEXT EXPORT). The Text Export adapter is required to create Text Data Marts.
• Text Family (TEXTFAMILY_ADAPTER). The Text adapter is required to create a Text Load Set. It uses the defined Load Set Parameter values to create a control file for the SQL*Loader.
• OBIEE Adapter (OBIEE). The Visualization adapter is required to create Oracle Business Intelligence (OBIEE) visualizations of Oracle LSH data.
• Generic Visualization Adapter (GENERIC_VISUALIZATION). The generic visualization adapter is required to create visualizations of LSH Data in tools other than OBIEE.
• InForm (INFORMFAMILY_ADAPTER) This is required for use with Oracle Health Sciences Data Management Workbench to enable loading data and metadata from Oracle InForm into Oracle DMW.

Oracle-technology source data adapters (Oracle and Oracle Clinical) contain the Remote Location and Connection information you define for the external Oracle system. For more details, see Registering Locations and Connections.