Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• Finding Information and Patches on My Oracle Support
• Finding Oracle Documentation
• Related Documents
• Conventions

1 About Adapters

• About Adapters
• Adapter Components
• Components and the User Interface

2 Designing an Adapter

• Preparation
• Requirements for Load Set, Data Mart, Program, and Business Area Adapters
  • Load Set Adapter Requirements
    • Definition
    • Installation
    • Execution
  • Data Mart Adapter Requirements
    • Definition
    • Installation
    • Execution
  • Program Adapter Requirements
    • Definition
    • Installation
    • Execution
  • Business Area Adapter Requirements
    • Definition
    • Installation
    • Launching the Visualization Tool
• Planning Adapter Areas
• Planning Technology Types
• Planning Services
• Planning PL/SQL Functions and Procedures
  • Object Definition Functions and Procedures
    • Column_Upload_Function
    • Auto_Add_Tab_Desc_Function
    • Auto_Add_Tab_Desc_LOV
    • Define_Time_Function
    • Status_Recalc_Function
  • Object Installation Functions
    • Pre_Install_Function
    • Install_Function
    • Post_Install_Function
  • Object Execution Functions and Procedures
    • Build_IDE_Cfg_Function
    • Build_Exe_Cfg_Function
    • Pre_Execution_Function
    • Execution_Function
    • Post_Execution_Function
    • Currency_Function
    • Security_Recalc_Function
• Planning Parameters and Parameter Sets
  • General Define-Time Parameters
  • Table Descriptor Define-Time Parameters
  • Runtime Parameters
• Adding Lookup Values
• Planning Planned Outputs
• Planning Data Structures
• Planning for Object Execution
  • Execution Process
  • Execution Command
• Planning Security
• Planning Integrated Development Environment Adapters
  • IDE Launch Process from Within Oracle Life Sciences Data Hub
  • Synchronizing Security with Integrated Environments
    • Enforcing Security on Corresponding External Entities
    • Establishing Context
    • Tracking and Removing Object Access
  • Adding Source Code Types
  • Planning Navigation in the External System to Business Areas
  • Editing cdrconfig.xml
  • Creating Subdirectories on IDE Computers

3 Developing an Adapter

• Adapter Development Process
• Planning Programs and Packages
• Using the Security API Package During Development

4 Using APIs to Create Required Metadata Objects

• Retrieving IDs
  • Getting Your Company ID
  • Getting an Object's Prref_Id and Prref_Ver
• Creating a Technology Type
  • Call the Create Technology Type API
  • Sample Technology Type Settings
• Modifying a Technology Type
• Creating an Adapter Domain
  • Call the Create Adapter Domain API
  • Save the Adapter Domain ID for Future Use
• Modifying an Adapter Domain
• Creating an Adapter Area
  • Call the Create Adapter Area API
  • Save the Adapter Area ID for Future Use
  • Sample Adapter Settings
• Modifying an Adapter Area
• Assigning a User Group to the Adapter Area
  • User Interface Method
  • API Method
• Creating a Work Area
  • Call the Create Work Area API
  • Save the Work Area ID for Future Use
• Creating a Program Definition and Instance
  • Query for the Tech Type ID
  • Call the Create Program API
  • Save the Program Definition and Instance IDs for Future Use
• Creating a Source Code Definition and Instance
  • Call the Create Source Code API
• Creating a Variable
  • Call the Create Variable API
  • Save the Variable ID for Future Use
  • Check in the Variable
• Creating a Parameter
  • Call the Create Parameter API
  • Save the Parameter ID for Future Use
  • Check in the Parameter
• Creating a Parameter Set
  • Call the Create Parameter Set API
  • Save the Parameter Set ID for Future Use
• Creating a Parameter Instance in a Parameter Set
  • Call the Create Parameter API
• Creating a Table Definition
  • Call the Create Table API
  • Call the Create Column API
• Installing the Work Area

5 Using the Generic Visualization Adapter

• Generic Visualization Adapter APIs
  • Initializing the Business Area Instance
  • Resetting a Generic Visualization Business Area
  • Getting Possible Blinding Types of a Business Area Instance
  • Getting Snapshot Labels Common to All Tables in a BA Instance for a Given Blinding Access Type
• Generic Visualization Adapter Views
  • Display User's Business Area Instances
  • Retrieve Table Instance Details
• Generic Visualization Business Area Instance Attributes
  • Schema Name
  • Default Currency
  • Default Blinding Access Type
• Generic Visualization Adapter Security
  • Database and User Accounts
  • Object Security
  • Data Blinding and Currency
  • Auditing
• Generic Visualization Adapter Definitional Components

6 Checking In Objects and Setting Their Validation Status

• Running the Validation API
• Explicitly Checking In an Object

7 Setting Up an Adapter

• Defining a Service Location, Service, and Service Instance
• Defining Remote Locations and Connections
• Assigning User Groups to the Adapter Area
• Installing and Starting the Distributed Processing Server
• Edit cdrconfig.xml

8 Shipping an Adapter